图数据库 mysql_图片与mysql数据库的交互

进入MySql控制器

。输入命令"create database binary_data;"

。输入命令"use binary_data;"

。输入命令

"CREATE TABLE binary_data ( id INT(4) NOTNULL AUTO_INCREMENT PRIMARY KEY,description CHAR(50), bin_data LONGBLOB,filename CHAR(50), filesize CHAR(50), filetype CHAR(50));"

然后是在php中的代码，在php中设计个网页，然后插入图片。

Store binarydata into SQL Database

// 如果提交了表单，代码将被执行:

if($submit) {

MYSQL_CONNECT( "localhost","root","vertrigo");

mysql_select_db( "binary_data");

$data =addslashes(fread(fopen($form_data,  "r"),filesize($form_data)));

$result=MYSQL_QUERY( "INSERT INTO binary_data(description,bin_data,filename,filesize,filetype)

VALUES ('$form_description','$data','$form_data_name','$form_data_size','$form_data_type')");

$id= mysql_insert_id();

print"

Thisfile has the following Database ID: $id";

MYSQL_CLOSE();

} else{

?>

File Description:

File toupload/store in database:

}

?>

至于怎么再把图片从数据库中取出并打开，我暂时还没有办到。。待续...