$data = fread(fopen($pic1,"r"),filesize($pic1));
$picname = "pic1.jpg";
$fwh = fopen($nbnet_picture . $picname, "w");
fwrite ($fwh, $data);
$db->query("update information set img_01='$picname' where id='$id'");
$picname = "pic1.jpg";
$fwh = fopen($nbnet_picture . $picname, "w");
fwrite ($fwh, $data);
$db->query("update information set img_01='$picname' where id='$id'");
http://www.gdjd.org/imgtemp/img.php
//echo $userfile_name."-在用户机器上该文件的原始名称<br>";
//echo $userfile_size."-上传文件的实际字节数<br>";
//echo $userfile_type."-如果用户的浏览器提供了这个信息的话,它表示mime的类型。例如image/gif<br>";
//开始插入到数据库中
$connect=mysql_connect($server,$user,$passwd) or die("Unable to connect to MySQL server");
@mysql_select_db($database) or die("Unable to select database");
if ($userfile!="none")
{
//$psize=filesize($userfile);
//echo $psize."文件的大小<br>";
//$userfile_name=substr($userfile_name,0,20);
//echo "userfile_name=".$userfile_name."<br>";
$mysqlPicture=addslashes(fread(fopen($userfile,"r"),$userfile_size));
//addslashes()函数 将文件中特殊字符前加上跳脱字符号“\”,以便使这些字符被当做文字字符。
//打开存放在临时目录的文件,转换成字符串,并加上反斜杠
//echo "mysqlPicture=".$mysqlPicture."<br>";
$Insertstring="Insert into pic_tb (driver_pic,pic_type,pic_oname) VALUES ('$mysqlPicture','$userfile_type','$userfile_name')";
$query=mysql_query($Insertstring) or die("Can't Perform Query");
if ($query)
{
//echo "图片添加成功";
$lastid=mysql_insert_id(); //获取上次insert的纪录的id号
}上传的表单我就不写了
写一个上传文件的表单,<form enctype="multipart/form-data" action="upload.php" method="post">
请选择附件:<input name="userfile" type="file"> <input type="submit" value="发布">
<input type=reset value="重设">
</form>
然后建立一个名为upload.php的文件,代码就是前面写的。
就会有$userfile
$userfile_name这些变量了
<img srv='photo.php'>
其中的photo.php文件中输出你从数据库中提到的存储图片的字段
$connect=mysql_connect($server,$user,$passwd) or die("Unable to connect to SQL server");
@mysql_select_db($database) or die("Unable to select database");
$querystring="select driver_pic,pic_type from pic_tb where pic_id=$PicNum";
//echo $querystring;
$result=mysql_query($querystring) or die("Can't perform Query");
$row=mysql_fetch_array($result);
Header( "Content-type: $row[type] ");
echo $row[pic];
数据库:
CREATE TABLE ccs_image (
id int(4) unsigned NOT NULL auto_increment,
description varchar(250) default NULL,
bin_data longblob,
filename varchar(50) default NULL,
filesize varchar(50) default NULL,
filetype varchar(50) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
store.php3:
<HTML>
<HEAD><TITLE>Store binary data into SQL Database</TITLE></HEAD>
<BODY> <?php
// 如果提交了表單,代碼將被執行: if ($submit) { // 連接到資料庫
// (你可能需要調整主機名,用戶名和密碼) MYSQL_CONNECT( "localhost", "ccpn", "zsstudio");
mysql_select_db( "ccpn"); $data = addslashes(fread(fopen($form_data, "r"), filesize($form_data))); $result=MYSQL_QUERY( "INSERT INTO ccs_image (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: <a href='getdate.php3?id=$id'><b>$id</b></a>";
MYSQL_CLOSE(); } else { // 否則顯示儲存新資料的表單
?>
<center>
<form method="post" action=" <?php echo $PHP_SELF; ?>" enctype="multipart/form-data">
File Description:
<input type="text" name="form_description" size="40">
<INPUT TYPE="hidden" name="MAX_FILE_SIZE" value="1000000"> <br>
File to upload/store in database:
<input type="file" name="form_data" size="40">
<p><input type="submit" name="submit" value="submit">
</form>
</center><?php } ?> </BODY>
</HTML> getdata.php3:
<?php // getdata.php3 - by Florian Dittmer <[email protected]>
// 調用方法: getdata.php3?id=<id> if($id) { // 你可能需要調整主機名,用戶名和密碼:
@MYSQL_CONNECT( "localhost", "ccpn", "zsstudio"); @mysql_select_db( "ccpn"); $query = "select bin_data,filetype from ccs_image 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; };
?> <a href="getdate.php3?id=$id"><? print($filename); ?></a>