MySQL

List of PHP and MySQL Code Generators

PHP & MySQL Code GeneratorsIt’s both a dream and nightmare (if you make a living writing code) to have a tool that can turn a database into a fully functional application with little or no manual coding. Depending on your dream some of these tools may be just what you are are looking for, but none are likely to put traditional programmers out of business.

Some of these tools can rapidly build a fully functional application, but there’s more to most useful applications than simply displaying a list of fields for users to fill out and viewing the results from an admin only accessible area.

Read the rest of this entry »

MySQL, PHP

How to format Date & Time input from a php form into MySQL UNIX datetime format

If you’re building any type of app that requires dates and times you’ll need to know how to convert user entered data into the MySQL datetime format.

The datetime format is: yyyy/mm/dd hh:mm:ss

Note that the time portion is 24hr time and not 12 hour time.

Read the rest of this entry »

MySQL, PHP

Backing Up and Restoring MySQL Databases on your PC

MySQLRecently it became obvious that I really didn’t understand how MySQL stores databases on my PC and although I backup frequently, the files I thought were the databases were only the table structures. Not only that but restoring them was not a matter of simply copying the files back to my hard drive.

I was able to restore the databases, but discovered there are some pro’s & con’s to relying on a typical pc backup.

Here’s what I discovered:

Read the rest of this entry »

MySQL