Check out this article at SitePoint. It teaches the theory, and develops a PHP Class that does the job nicely. I've used it effectively several times.
Good luck.
If you like Access as a front end, you can use it to manage a MySQL database.
Check out how here: h*tp://www.itc.virginia.edu/desktop/web/mysql/msaccess.html