Automating DB Backup with CRON (PHP/MySQL)

As you work on multiple projects that involve relational databases, you run into the challenge of ensuring that period backup of your systems are done from time to time and copies saved to a location on your server. more

---

Populate a select box with the contents of a table (PHP/MySQL)

Try populating a select box with the names of all the countries in the world. You will end up with more than 2000 entries and a very large HTML file, especially if you require this select box for several fields in a single form. Here is a simple solution to populating a select box with values from a MySQL database: more

---

Creating new records, finding the last index in a table (MySQL, PHP)

Sometimes when using MySQL tables of the InnoDB engine variant, the auto increment property of the primary key does not lock properly and therefore creates holes in the system when INSERT instructions are run. more

---