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…
productivity through technology
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…