MySQL column aliases
In the process of refactoring some MySQL queries in some PHP code, I came across some interesting syntax for field aliases in the existing code and poked around a bit…
PHP and MongoDB “Hello World!”
I have no experience with NoSQL databases and was curious to learn a bit more, with the goal of using MongoDB on a Heroku project. Here is a brief outline…
Website contact form
A standard addition to any website is some kind of ability to contact the website owners. Whilst many have opted for the implementation of “chat” functionality, the tried-and-tested Contact form…
Backing up a MySQL database using PHP’s system() & MySQL’s mysqldump
The PHP system() function is used to execute an external program. Because MySQL already has a built-in tool for creating MySQL database backups, mysqldump, let’s use it from our PHP…
How to use PHP To Backup & Restore a MySQL Database Table
This is how to backup and restore a MySQL table using a PHP script. Please note: this is an old post and the scripts include deprecated PHP functions. Execute a…
Read a Word doc using COM
So I managed to write a script to read a Microsoft Word document using PHP CLI and the COM object pretty easily, but then battled to get it working in…
PHP Dynamic year selector
Another post from the archives. After 2009 rolled in and all our sites failed to follow suit because “someone” hard-coded the years — but only up to 2008 — I…
PHP CLI “Hello World”
I have only recently begun working with PHP CLI scripts. Executing PHP scripts from the command line is fairly easy and you require no extra knowledge to create a basic…
PHP short tags
Another post from the archives: I am running a WAMP development environment at home and at work. I am always looking for new ways to fine-tune my set-up. Here is…
PHP / MySQL: storing database credentials in an .ini file
It is recommended that for security reasons you do not include database connection details in your scripts, so where exactly do you store them? Luckily, PHP has the handy function…