php+mysql关于图片的存储问题~~~~

Question

图片用BASE64编码以后应该就能作为字符串存了……没试过

Answer 1

提交页：<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向数据库添加信息

Answer 2

图片显示：
<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];
}                                                                                 
?>