Storing User Submitted Data and Files in MySQL

By Angela Bradley, About.com Guide

Sometimes it is useful to collect data from your website users and store this information in a MySQL database. We have already seen you can populate a database using PHP, now we will add the practicality of allowing the data to be added through a user friendly web form.

The first thing we will do is create a page with a form. For our demonstration we will make a very simple one:

 <form action="process.php" method="post"> 
 Your Name: <input type="text" name="name"><br> 
 E-mail: <input type="text" name = "email"><br> 
 Location: <input type="text" name = "location"><br> 
 <input type="submit" value="Submit"> 
 </form> 

Previous

• Creating a Form
• Insert Into - Adding Data from a Form
• Add File Uploads
• Adding File Uploads to MySQL
• Adding Uploads Explained
• Retrieving Files
• Removing Files

Next