Video Series: My First PHP/MySQL Project
After learning the basics of PHP, the next step was obvious: MySQL. It seems like you really can’t do much without a database these days. So, to learn how to use PHP with MySQL, I made a simple to-do list program.
For each day I worked on the project, I made a video to share what I learned. The project turned out to be huge success! I didn’t finish my to-do list program, but I learned the basics of MySQL and picked up some new PHP knowledge along the way. Here are the six videos in this series:
- First PHP/MySQL Project Day 1: Connecting to MySQL
- This seven-minute video shows how I used PHP to connect to a MySQL database — well, after reading about some functions and getting familiar with phpMyAdmin.
- First PHP/MySQL Project Day 2: Inserting Data into MySQL
- Six minutes on how I created a table and then inserted data from an HTML form into MySQL.
- First PHP/MySQL Project Day 3: Displaying Data
- A three-minute video on how to select and display data from MySQL.
- First PHP/MySQL Project Day 4: Checkboxes and Deleting Rows
- Eight-and-a-half-minute video on how to delete rows from a table in MySQL using an HTML form with dynamically generated checkboxes.
- First PHP/MySQL Project Day 5: Date Functions, Updating Data, and More
- This nine-minute video covers a lot. To add deadlines and recurring tasks to my to-do list, I had to learn about MySQL’s date functions, operators, null values, the
UPDATEstatement, and theCASEcontrol flow function. - First PHP/MySQL Project Day 6: Joining Tables Together
- Five and a half minutes on how to join two tables together with cross joins, inner joins, and outer joins.
Now that I have a working knowledge of MySQL, I’m that much closer to making a website or web application that’s actually useful. 
Stay tuned for tutorials on more advanced topics!
June 18th, 2007
nice “read”
im starting in php, (im still at the php basics video) and im finding this useful (altho i downloaded tons of video tutorials from p2p)
kisses from portugal
love ya B)
June 21st, 2007
These are great tutorials for beginning php. I have gone through all of them and learned quite a bit. The only problem is I can not get a blank -tagged out of my list. Any ideas?
June 22nd, 2007
Thanks so much!
Ian - Yeah, I had that problem, too. I just deleted the blank item from my list like any other item and that worked fine. You could also try deleting the row through phpMyAdmin — let me know if you need any help with that.
Later I’ll have to fix my form so it doesn’t insert any empty fields into the database. I’m glad you’ve found my tutorials helpful so far, and I just wish everything would work perfectly! But since I’m just learning, expect to find plenty of bugs and mistakes.
December 28th, 2007
I like this videos, i am php teacher, my class watch all videos .. hehehe.
Sorry my english, Big hug.