php上传文件并存储到mysql数据库的简单示例

前端之家收集整理的这篇文章主要介绍了php上传文件并存储到mysql数据库的简单示例前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
PHP上传文件并存储到MysqL数据库感兴趣的小伙伴,下面一起跟随编程之家 jb51.cc的小编两巴掌来看看吧!
下面的代码分别用于创建MysqL表和上传文件保存到MysqL数据库

创建MysqL

/**
 * PHP上传文件并存储到MysqL数据库
 *
 * @param 
 * @arrange 512-笔记网: jb51.cc
 **/
<?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); 
?>
/***   来自编程之家 jb51.cc(jb51.cc)   ***/
上传文件并保存到MysqL中,通过insert语句插入

/**
 * PHP上传文件并存储到MysqL数据库
 *
 * @param 
 * @arrange 512-笔记网: jb51.cc
 **/
<?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);
?>
/***   来自编程之家 jb51.cc(jb51.cc)   ***/

猜你在找的PHP相关文章