FAQ有:当然可以,用BLOB类型
存放:
<?php
// 如果提交了表单,代码将被执行: if ($submit) { // 连接到数据库
// (你可能需要调整主机名,用户名和密码) MYSQL_CONNECT( "localhost", "root", "password");
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 "<p>This file has the following Database ID: <b>$id</b>"; MYSQL_CLOSE(); } else { // 否则显示储存新数据的表单
?> <form method="post" action=" <?php echo $PHP_SELF; ?>" enctype="multipart/form-data">
File Description:<br>
<input type="text" name="form_description" size="40">
<INPUT TYPE="hidden" name="MAX_FILE_SIZE" value="1000000">
<br>File to upload/store in database:<br>
<input type="file" name="form_data" size="40">
<p><input type="submit" name="submit" value="submit">
</form> <?php } ?> </BODY>
</HTML>
读取:
<?php // getdata.php3 - by Florian Dittmer <[email protected]>
// 调用方法: getdata.php3?id=<id> if($id) { // 你可能需要调整主机名,用户名和密码:
@MYSQL_CONNECT( "localhost", "root", "password"); @mysql_select_db( "binary_data"); $query = "select bin_data,filetype from binary_data where id=$id";
$result = @MYSQL_QUERY($query); $data = @MYSQL_RESULT($result,0, "bin_data");
$type = @MYSQL_RESULT($result,0, "filetype"); Header( "Content-type: $type");
echo $data; };
?> --------------------------------------------------------------- 可以这样建表
create table images(image_id int not null primary key,
image_data blob
);
--------------------------------------------------------------- 注意:blob类型最大可存储64k的图象,超过时可用longblob类型
存放:
<?php
// 如果提交了表单,代码将被执行: if ($submit) { // 连接到数据库
// (你可能需要调整主机名,用户名和密码) MYSQL_CONNECT( "localhost", "root", "password");
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 "<p>This file has the following Database ID: <b>$id</b>"; MYSQL_CLOSE(); } else { // 否则显示储存新数据的表单
?> <form method="post" action=" <?php echo $PHP_SELF; ?>" enctype="multipart/form-data">
File Description:<br>
<input type="text" name="form_description" size="40">
<INPUT TYPE="hidden" name="MAX_FILE_SIZE" value="1000000">
<br>File to upload/store in database:<br>
<input type="file" name="form_data" size="40">
<p><input type="submit" name="submit" value="submit">
</form> <?php } ?> </BODY>
</HTML>
读取:
<?php // getdata.php3 - by Florian Dittmer <[email protected]>
// 调用方法: getdata.php3?id=<id> if($id) { // 你可能需要调整主机名,用户名和密码:
@MYSQL_CONNECT( "localhost", "root", "password"); @mysql_select_db( "binary_data"); $query = "select bin_data,filetype from binary_data where id=$id";
$result = @MYSQL_QUERY($query); $data = @MYSQL_RESULT($result,0, "bin_data");
$type = @MYSQL_RESULT($result,0, "filetype"); Header( "Content-type: $type");
echo $data; };
?> --------------------------------------------------------------- 可以这样建表
create table images(image_id int not null primary key,
image_data blob
);
--------------------------------------------------------------- 注意:blob类型最大可存储64k的图象,超过时可用longblob类型
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货