First PHP/MySQL Project Day 2: Inserting Data into MySQL

This six-minute video shows how I created a table and then inserted data from an HTML form into MySQL.

Click To Play

Links for Inserting Data Into MySQL

Reference pages from the MySQL manual on creating a table:

• Creating a Table
• Chapter 11: Data Types
• The Char and Varchar Types

Previous videos on PHP with HTML forms:

• Using PHP with HTML Forms
• Security Issues with Superglobals and register_globals
• Functions for Form Input Security - This also includes info about magic quotes.

Inserting data into MySQL:

• mysql_real_escape_string - Lots of info about this function from the PHP manual.
• PHP MySQL Insert Into - Info on the INSERT INTO statement from the W3Schools site.

I did some research on MySQL security issues, and man, did that give me a headache! I’ll have to get back to that one day — but hopefully not for a very long time.