创建MysqL表
<?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);
?>
上传文件并保存到MysqL中,通过insert语句插入
<?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);
?>