Oracle中图片的存贮与显示例程
<br>作者/来源:star2002
<br>
<br>Oracle中图片的存贮与显示例程
<br>//store.php
<br><HTML>
<br><HEAD><TITLE>Store binary data into Oracle Database</TITLE></HEAD>
<br><BODY>
<br>
<br><?php
<br>// 如果提交了表单,代码将被执行:
<br>dl("php_oci8.dll");
<br>$conn = OCILogon("scott","tiger");
<br>if ($submit) {
<br>
<br>echo "File name: <b>$userfile_name</b><br> ";
<br>echo "File size: <b>$userfile_size</b><br> ";
<br>
<br>$hwsize = GetImageSize($userfile );
<br>$w = $hwsize[0];
<br>$h = $hwsize[1];
<br>echo "Image width: <b>$w</b><br> ";
<br>echo "Image height: <b>$h</b><br> ";
<br>
<br>$ImgType = strtolower(substr( strrchr( $userfile_name, "." ), 1 ) );
<br>if ($ImgType == "jpg")
<br> $ImgType = "jpeg";
<br>echo "Image type: <b>$ImgType</b><br> ";
<br>
<br>echo "Created date; <b>".date(’Y-m-d’)."</b><br> ";
<br>
<br>
<br>$sql = "insert into
<br>Picture (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 "<pre>$sql</pre>";
<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->save(fread($fp, filesize($userfile ) ) );
<br>fclose($fp );
<br>OCICommit($conn );
<br>
<br>OCIFreeStatement($stmt );
<br>
<br>} else {
<br>?>
<br> <form method="post" action=" <?php echo $PHP_SELF; ?>" enctype="multipart/form-data">
<br> File Description:<br>
<br> <input type="text" name="description" size="40">
<br> <INPUT TYPE="hidden" name="MAX_FILE_SIZE" value="1000000">
<br> <br>File to upload/store in database:<br>
<br> <input type="file" name="userfile" size="40">
<br> <p><input type="submit" name="submit" value="submit">
<br> </form>
<br>
<br><?php
<br>}
<br>?>
<br></BODY>
<br></HTML>
<br>//display.php
<br><?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, &$result, OCI_ASSOC);
<br>Header("Content-type: image/".$result[’IMGTYPE’]);
<br>echo $result[’IMAGE’]->load();
<br>
<br>OCILogoff($conn );
<br>?>
<br>
<br>
<br>
<br>
|
kehui
|
|
智慧家居
智慧家居颠覆传统智能家居
智慧云谷让智能家居变成有智慧的
智慧云谷引领智慧家居新生活
科技改变生活 智慧云谷智慧家居系
智慧家居领航者,智慧云谷助你玩
智能家居如何赢得市场美誉度?
智慧云谷智慧家居:创业者有无限
WiFi智能家居你还在用?这样的智
互联网+助推智能家居产业
智慧云谷为您打造真正的智能家居
智能家居产业需要的不是单品,而
新家如何选择开关?智慧云谷iWis
智能传感器-世界首款“智”为你的
智慧云谷开关智能安防智能空气质
智能开关品牌,如何选择智能开关
秋季干燥,智慧家居温湿度传感器
传感器助力智慧家居 感知爱家
iWiscloud智能触摸开关缔造家居装
※室内空气污染的危害及 [sensor]
※超声波风速传感器在生 [sensor]
※这么冷清 [gabc111]
※手机APP操作有问题 [ssy11407]
※智慧云谷智慧家居将在 [cici]
※上传下载 [cici]
※下载智慧家居 [apple2008]
※秋季干燥,智慧家居温 [apple2008]
※智慧家居紧扣热点 安全 [apple2008]
※办公大楼如何智慧化管 [apple2008]
※智慧云谷工业自控的优 [apple2008]
※传感器助力智慧家居 感 [apple2008]
※智能开关品牌,如何选 [apple2008]
※智慧云谷开关智能安防 [apple2008]
※没有专业人员,如何安 [apple2008]
※烟台智慧云谷董事长任 [apple2008]
※互联网+助推智能家居产 [apple2008]
※WiFi智能家居你还在用 [apple2008]
※智慧云谷智慧家居:创 [apple2008]
※智能家居如何赢得市场 [apple2008]
|