Free PHP / MySQL Newsletter!
Discuss in my Forum

Storing User Submitted Data and Files in MySQL

See More About:

4 of 7

Adding File Uploads to MySQL

Next we need to actually create upload.php, which will take our users file and store it in our database. Below is sample coding for upload.php.

<?php
mysql_connect("your.server.com","username","password");
mysql_select_db("database_name");
$data = addslashes(fread(fopen($form_data, "r"), filesize($form_data)));
$result=MYSQL_QUERY("INSERT INTO uploads (description, data,filename,filesize,filetype) ". "VALUES ('$form_description','$data','$form_data_name','$form_data_size','$form_data_type')");
$id= mysql_insert_id();
print "File ID: $id ";
print "File Name: $form_data_name ";
print "File Size: $form_data_size ";
print "File Type: $form_data_type";
print "To upload another file <a href=http://www.yoursite.com/yourpage.html> Click Here</a>";
?>

Learn more about what this actually does on the next page.