看头晕:我给你个例子,我在windows,linux上都试通过了.数据库(images):表:CREATE TABLE `images` (
`id` int(10) NOT NULL auto_increment,
`photo` longblob,
`filetype` varchar(50) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;上传图片并存入mysql的页面: up.php<?php
$db=MySQL_connect("localhost", "root","");
MySQL_select_db("images");if ("确定"==$_REQUEST['submit']){ if ($_FILES['photo']['size']!=0){
$data = addslashes(fread(fopen($_FILES['photo']['tmp_name'], "r"), filesize($_FILES['photo']['tmp_name'])));
$sql="insert into images set photo='$data',filetype=\"".$_FILES['photo']['type']."\"";
}
mysql_query($sql);
$err=mysql_error();
if ($err){
printf("出错");
}else{
printf("成功,<a href=show.php?id=".mysql_insert_id().">显示</a>");
}
}else{
?>
<form name="form1" method="post" enctype="multipart/form-data">
<input type="hidden" name="MAX_FILE_SIZE" value="100000000">
<input type="file" name="photo" size="40">
<input type="submit" name="submit" value="确定">
</form>
<?php
}
?>显示mysql中的图片:show.php
<?php
$db=@MySQL_connect("localhost", "root","lin1976");
@MySQL_select_db("images");$id=$_GET['id'];
if($id){
@MYSQL_CONNECT( "localhost", "root", "");
@mysql_select_db( "images");
$query = "select photo,filetype from images where id=$id";
$result = @MYSQL_QUERY($query);
$data = @MYSQL_RESULT($result,0, "photo");
$type = @MYSQL_RESULT($result,0, "filetype");
Header("Content-type: $type");
echo $data;
}
?>
`id` int(10) NOT NULL auto_increment,
`photo` longblob,
`filetype` varchar(50) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;上传图片并存入mysql的页面: up.php<?php
$db=MySQL_connect("localhost", "root","");
MySQL_select_db("images");if ("确定"==$_REQUEST['submit']){ if ($_FILES['photo']['size']!=0){
$data = addslashes(fread(fopen($_FILES['photo']['tmp_name'], "r"), filesize($_FILES['photo']['tmp_name'])));
$sql="insert into images set photo='$data',filetype=\"".$_FILES['photo']['type']."\"";
}
mysql_query($sql);
$err=mysql_error();
if ($err){
printf("出错");
}else{
printf("成功,<a href=show.php?id=".mysql_insert_id().">显示</a>");
}
}else{
?>
<form name="form1" method="post" enctype="multipart/form-data">
<input type="hidden" name="MAX_FILE_SIZE" value="100000000">
<input type="file" name="photo" size="40">
<input type="submit" name="submit" value="确定">
</form>
<?php
}
?>显示mysql中的图片:show.php
<?php
$db=@MySQL_connect("localhost", "root","lin1976");
@MySQL_select_db("images");$id=$_GET['id'];
if($id){
@MYSQL_CONNECT( "localhost", "root", "");
@mysql_select_db( "images");
$query = "select photo,filetype from images where id=$id";
$result = @MYSQL_QUERY($query);
$data = @MYSQL_RESULT($result,0, "photo");
$type = @MYSQL_RESULT($result,0, "filetype");
Header("Content-type: $type");
echo $data;
}
?>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货