下面的代码分别用于创建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) ***/