php+mysql关于图片的存储问题~~~~ 图片用BASE64编码以后应该就能作为字符串存了……没试过 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 提交页:<td width="100"><div align="center"> 上传近期彩照<br> <input type="hidden" name="MAX_FILE_SIZE" value="3000000"> <input name="photo" type="file" size="2"> </div></td>处理页: 数据连接我用的是ADO的,你用MYSQL的就行,这个不是主要的//BEGIN读取相片 $picdata = ""; $sfile=$_FILES['photo']['tmp_name']; if ($sfile <> ""){ $fp=fopen($Simage,"r"); $picdata = addslashes(fread($fp,filesize($sfile))); } //END读取相片 //BEGIN向数据库添加信息 $sql = "insert into personinfo values (null,'$Name','$picdata','$Regtime')"; //echo $sql; if ($db->Execute($sql)){ $sql = "select PId from personinfo where Name = '$Name' and Regtime='$Regtime' "; $rs = $db->Execute ($sql); echo "<SCRIPT LANGUAGE=JavaScript> alert ('".$Name."资料已添加到数据库');"; echo "javascript:location.href='person.php?pid=".$rs->fields[0]."';"; echo "</SCRIPT>"; } //END向数据库添加信息 图片显示:<IMG align=absMiddle border=0 src='displayimg.php?pid=1' />displayimg.php+++++++++++++++++++++++++++++++++++++++++++++++++++++++++<?php $pid = $_REQUEST['pid']; $sql = "select photo from personinfo where PId='$pid'"; $rs = $db->Execute ($sql); if (!$rs->EOF){ header("Content-type:image/jpeg"); echo $rs->fields[0]; } ?> 图片上传类,上传多个不同图片后,好几张显示相同的图片: php+mysql 发现一个奇怪的问题,各位帮忙看看。 AJAX调用编码为gb2312的页面乱码的问题 数据库设计要没有重复字段是什么意思? 关于设置SESSION过期的问题 下载了一个源码测试出现很多undefined 参数啊怎办? 急~~ 请帮看看这个sql语句有什么错误啊?? 从.net想到php(欢迎大家讨论) PHP系统公告-发送通知给每个人 入门学习php版本问题? 一直以来没有确却的说法的问题!? 请问一个很初级的问题,.php3和.php有什么区别?
上传近期彩照<br>
<input type="hidden" name="MAX_FILE_SIZE" value="3000000">
<input name="photo" type="file" size="2">
</div></td>
处理页: 数据连接我用的是ADO的,你用MYSQL的就行,这个不是主要的
//BEGIN读取相片
$picdata = "";
$sfile=$_FILES['photo']['tmp_name'];
if ($sfile <> ""){
$fp=fopen($Simage,"r");
$picdata = addslashes(fread($fp,filesize($sfile)));
}
//END读取相片
//BEGIN向数据库添加信息
$sql = "insert into personinfo values (null,'$Name','$picdata','$Regtime')";
//echo $sql;
if ($db->Execute($sql)){
$sql = "select PId from personinfo where Name = '$Name' and Regtime='$Regtime' ";
$rs = $db->Execute ($sql);
echo "<SCRIPT LANGUAGE=JavaScript> alert ('".$Name."资料已添加到数据库');";
echo "javascript:location.href='person.php?pid=".$rs->fields[0]."';";
echo "</SCRIPT>";
}
//END向数据库添加信息
<IMG align=absMiddle border=0 src='displayimg.php?pid=1' />
displayimg.php
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
<?php
$pid = $_REQUEST['pid'];
$sql = "select photo from personinfo where PId='$pid'";
$rs = $db->Execute ($sql);
if (!$rs->EOF){
header("Content-type:image/jpeg");
echo $rs->fields[0];
}
?>