mysql 二进制数据_MySQL中的二进制数据

对于这样的表：

CREATE TABLE binary_data (

id INT(4) NOT NULL AUTO_INCREMENT PRIMARY KEY,

description CHAR(50),

bin_data LONGBLOB,

filename CHAR(50),

filesize CHAR(50),

filetype CHAR(50)

);

这是一个PHP示例：

// store.php3 - by Florian Dittmer

// Example php script to demonstrate the storing of binary files into

// an sql database. More information can be found at http://www.phpbuilder.com/

?>

Store binary data into SQL Database

// Code that will be executed if the form has been submitted:

if ($submit) {

// Connect to the database (you may have to adjust

// the hostname, username or password).

mysql_connect("localhost", "root", "password");

mysql_select_db("binary_data");

$data = mysql_real_escape_string(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 "

This file has the following Database ID: $id";

mysql_close();

} else {

// else show the form to submit new data:

?>

File Description:

File to upload/store in database:

}

?>