Author Archives | Alvin Poh

Alvin Poh - who has written 320 posts on Alvin Poh’s Blog.

Alvin Poh lives in Singapore, and is interested in marketing, techy stuff, and likes to just figure out how the two can work with each other. He can also be found on Google+.

Contact the author

How To Set Up Your Own VPN

Sunday, September 21, 2014

0 Comments

Tweet VPNs (Virtual Private Networks) are beautiful things that allow you to get past firewalls, protect your data when you’re using WiFi networks of a suspicious nature (Free Airport Wifi?), and even get access to country-specific websites and services. You can get VPN service from VPN providers — or you can have your very own […]

Continue reading...

How To Import Excel Dates Into MySQL Using PHPMyAdmin

Friday, August 22, 2014

0 Comments

Tweet I tried importing a CSV into PHPMyAdmin, and everything got imported successfully except the date. The date used in Excel is different from MySQL, and number formatting won’t work in this case. The only solution that I found was to create a new column, and apply this formula to it (assuming column A has […]

Continue reading...

How To Enable Gzip Compression

Tuesday, April 8, 2014

0 Comments

Tweet Whenever someone visits your website, your website’s server will deliver all the required files (text, CSS, HTML, etc) to the visitor’s computer. Logically, the bigger the files, the longer it takes for your website to load on your visitor’s computer. The main reason why gzip is important is because it speeds up file transfer […]

Continue reading...

How To Output The Current Date in Javascript

Wednesday, April 2, 2014

0 Comments

Tweet Sometimes you want to display a date that’s based on your visitor’s computer’s time, and that’s when Javascript comes in handy because it’s client-side. Here’s code that will display today’s date in this format: Thursday, April 3 2014 No tag for this post.

Continue reading...

How To Use AWeber Personalization Code And Variables

Sunday, March 30, 2014

0 Comments

Tweet Personalization fields allow you to tailor your emails so that it appears like like a personal email to every one of your subscribers. With AWeber, you’re able to do this easily. Using personalisation fields in your AWeber emails is a simple 2-step process: Step 1: Craft your email message as you would normally, but […]

Continue reading...

How To Randomly Select From A Record Based On Weight (PHP, MySQL)

Saturday, March 29, 2014

0 Comments

Tweet I got this code from a brilliant comment here, and it’s a simple formula that allows you to randomly select from a database. The difference is, each record is weighted and the random sampling also takes that into account. For example, this will be very useful if you have several people in your database, […]

Continue reading...

How To Install and Enable PDO For cPanel, WHM

Saturday, March 15, 2014

0 Comments

Tweet PHP Data Objects ( PDO ) is a PHP extension that provides a consistent way of interacting with databases. To use PDO, you’ll need PHP 5, and PDO has to be installed and enabled, or you’ll get an error like this: “Fatal error: Class ‘PDO’ not found in…” To check whether PDO is even […]

Continue reading...