上传图片存入mysql的程序.
表new里的photo存图片,filetype存类型,id是编号<?php
//打开数据库
if ($new_ok){
if ($photo_size!=0){
$data = addslashes(fread(fopen($photo, "r"), filesize($photo)));
$sql="insert into new (photo,filetype) values ('$data','$photo_type')";
} mysql_query($sql);
$err=mysql_error();
if ($err){
printf("出错");
}else{
printf("成功");
}
}else{
?>
<form name="form1" method="post" enctype="multipart/form-data">
<input type="hidden" name="MAX_FILE_SIZE" value="10000000">
<input type="file" name="photo" size="40">
<input type="submit" name="new_ok" value="开 始 录 入"> </form>
<?php
}
?>显示图片的办法:
<?php
if($id) {
@MYSQL_CONNECT( "localhost", "帐号", "密码");
@mysql_select_db( "数据库名");
$query = "select photo,filetype from new 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;
};
?>
表new里的photo存图片,filetype存类型,id是编号<?php
//打开数据库
if ($new_ok){
if ($photo_size!=0){
$data = addslashes(fread(fopen($photo, "r"), filesize($photo)));
$sql="insert into new (photo,filetype) values ('$data','$photo_type')";
} mysql_query($sql);
$err=mysql_error();
if ($err){
printf("出错");
}else{
printf("成功");
}
}else{
?>
<form name="form1" method="post" enctype="multipart/form-data">
<input type="hidden" name="MAX_FILE_SIZE" value="10000000">
<input type="file" name="photo" size="40">
<input type="submit" name="new_ok" value="开 始 录 入"> </form>
<?php
}
?>显示图片的办法:
<?php
if($id) {
@MYSQL_CONNECT( "localhost", "帐号", "密码");
@mysql_select_db( "数据库名");
$query = "select photo,filetype from new 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分钟通话, 中国电信官方发货