PHP implements uploading files and storing them in mysql database

This article mainly introduces the method of uploading files in php and storing them in mysql database. It analyzes in detail the techniques of php operating file uploading and database storage in the form of a complete example. It has certain reference value and friends in need can refer to it. Next

This article mainly introduces how to upload files in php and store them in mysql database. Interested friends can refer to it. I hope it will be helpful to everyone.

The following codes are used to create mysql tables and upload files and save them to mysql database respectively

Create mysql tables:

<?php
 $con = mysql_connect("localhost", "", "");
 mysql_select_db("w3m");
 $sql = "CREATE TABLE updfiles ("
   . " id INTEGER NOT NULL AUTO_INCREMENT"
   . ", name VARCHAR(80) NOT NULL"
   . ", type VARCHAR(80) NOT NULL"
   . ", size INTEGER NOT NULL"
   . ", content BLOB"
   . ", PRIMARY KEY (id)"
   . ")";
 mysql_query($sql, $con);
 mysql_close($con);
?>

Upload files and save them to mysql through the insert statement Insert

<?php
 $con = mysql_connect("localhost", "", "");
 mysql_select_db("w3m");
 $error = $_FILES[&#39;w3img&#39;][&#39;error&#39;];
 $tmp_name = $_FILES[&#39;w3img&#39;][&#39;tmp_name&#39;];
 $size = $_FILES[&#39;w3img&#39;][&#39;size&#39;];
 $name = $_FILES[&#39;w3img&#39;][&#39;name&#39;];
 $type = $_FILES[&#39;w3img&#39;][&#39;type&#39;];
 print("\n");
 if ($error == UPLOAD_ERR_OK && $size > 0) {
  $fp = fopen($tmp_name, &#39;r&#39;);
  $content = fread($fp, $size);
  fclose($fp);  
  $content = addslashes($content);
  $sql = "INSERT INTO fyi_files (name, type, size, content)"
   . " VALUES (&#39;$name&#39;, &#39;$type&#39;, $size, &#39;$content&#39;)";
  mysql_query($sql, $con);
  print("File stored.\n");
 } else {
  print("Database Save for upload failed.\n");
 }
 print("\n");
 mysql_close($con);
?>

Summary: The above is the entire content of this article, I hope it will be helpful to everyone's study.

Related recommendations:

PHP uses phpmailer to send emails

##How to generate a reference implementation tree in PHP

Brief description of PHP date function and method of obtaining set time

The above is the detailed content of PHP implements uploading files and storing them in mysql database. For more information, please follow other related articles on the PHP Chinese website!