Oracle中图片的存贮与显示例程

haidong

<br>                   //store.php <BR>&lt;HTML&gt; <BR>&lt;HEAD&gt;&lt;TITLE&gt;Store binary data into Oracle Database&lt;/TITLE&gt;&lt;/HEAD&gt; <BR>&lt;BODY&gt; <BR><BR>&lt;?php <BR>// 如果提交了表单，代码将被执行:  <BR>dl("php_oci8.dll"); <BR>$conn = OCILogon("scott","tiger"); <BR>if ($submit) { <BR><BR>echo "File name: &lt;b&gt;$userfile_name&lt;/b&gt;&lt;br&gt; "; <BR>echo "File size: &lt;b&gt;$userfile_size&lt;/b&gt;&lt;br&gt; "; <BR><BR>$hwsize = GetImageSize($userfile ); <BR>$w = $hwsize[0]; <BR>$h = $hwsize[1]; <BR>echo "Image width: &lt;b&gt;$w&lt;/b&gt;&lt;br&gt; "; <BR>echo "Image height: &lt;b&gt;$h&lt;/b&gt;&lt;br&gt; "; <BR><BR>$ImgType = strtolower(substr( strrchr_( $userfile_name, "." ), 1 ) ); <BR>if ($ImgType == "jpg") <BR>  $ImgType = "jpeg"; <BR>echo "Image type: &lt;b&gt;$ImgType&lt;/b&gt;&lt;br&gt; "; <BR><BR>echo "Created date; &lt;b&gt;".date('Y-m-d')."&lt;/b&gt;&lt;br&gt; "; <BR><BR><BR>$sql = "insert into <BR>icture (PicId, UserName, Width, Height, ImgSize, ImgType, Created, Image, FileName, Description) <BR>values(PicturePicId.nextval, '$username', $w, $h, '$userfile_size', '$ImgType', TO_DATE('".date('Y-m-d')."','YYYY-MM-DD'), EMPTY_BLOB(), '$userfile_name', '$description') <BR>returning Image into :Image"; <BR><BR>echo "&lt;pre&gt;$sql&lt;/pre&gt;"; <BR>$stmt = OCIParse($conn, $sql ); <BR><BR>$Image = OCINewDescriptor($conn );  <BR><BR>OCIBindByName($stmt, ":Image", $Image, -1, SQLT_BLOB ); <BR><BR>if (!OCIExecute($stmt, OCI_DEFAULT)) { <BR>  echo "Execution failed"; <BR>  exit(1); <BR>} <BR><BR>$fp = fopen($userfile, "r" ); <BR>$Image-&gt;save(fread($fp, filesize($userfile ) ) ); <BR>fclose($fp ); <BR>OCICommit($conn ); <BR><BR>OCIFreeStatement($stmt ); <BR><BR>} else { <BR>?&gt; <BR>    &lt;form method="post" action=" &lt;?php echo $PHP_SELF; ?&gt;" enctype="multipart/form-data"&gt; <BR>    File Description:&lt;br&gt; <BR>    &lt;input type="text" name="description"  size="40"&gt; <BR>    &lt;INPUT TYPE="hidden" name="MAX_FILE_SIZE" value="1000000"&gt; <BR>    &lt;br&gt;File to upload/store in database:&lt;br&gt; <BR>    &lt;input type="file" name="userfile"  size="40"&gt; <BR>    &lt;p&gt;&lt;input type="submit" name="submit" value="submit"&gt; <BR>    &lt;/form&gt; <BR><BR>&lt;?php <BR>} <BR>?&gt; <BR>&lt;/BODY&gt; <BR>&lt;/HTML&gt;  <BR>//display.php <BR>&lt;?php <BR>/* <BR>  Purpose: <BR>    Display an image from 'Picture' table <BR>*/ <BR>dl("php_oci8.dll"); <BR>$conn = OCILogon("scott","tiger"); <BR>$stmt = OCIParse($conn, "select Image, ImgType from Picture where picid=23" ); <BR>OCIExecute($stmt); <BR><BR>@OCIFetchInto($stmt, &amp;$result, OCI_ASSOC); <BR>Header("Content-type: image/".$result['IMGTYPE']); <BR>echo $result['IMAGE']-&gt;load(); <BR><BR>OCILogoff($conn ); <BR>?&gt;                   <br><br>