How to upload files in php and store them in mysql database, _PHP tutorial

How to upload files in php and store them in mysql database,

The example in this article describes how to upload files in php and store them in mysql database. Share it with everyone for your reference. The specific analysis is as follows:

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

Create mysql table:

<&#63;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);
&#63;>

Upload the file and save it to mysql, insert it through the insert statement

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

I hope this article will be helpful to everyone’s PHP programming design.

http://www.bkjia.com/PHPjc/968258.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/968258.htmlTechArticleHow to upload files in php and store them in mysql database. This article describes how to upload files in php and store them in mysql database. method. Share it with everyone for your reference. The specific analysis is as follows:...