php 資料庫 提取 匯出 圖片 blob__資料庫

<?php $SYSSET[testkeyframePath]= "////192.168.1.56//F$//MAMLib//keyframePath//"; $SYSSET[defaultPicStep] = 100; $mysql_server_name ="localhost"; //資料庫伺服器名稱 $mysql_username ="paramam"; //串連資料庫使用者名稱 $mysql_password ="paramam123456"; //串連資料庫密碼 $mysql_database ="mz_sm_02"; //資料庫的名字 function generateKeyFrame($frameData,$FILE_NAME) { global $SYSSET; //幀資料 $keyframeFilename = iconv("utf-8","gb18030",$SYSSET[testkeyframePath].$FILE_NAME); if (!file_exists($keyframeFilename)) { $fp = fopen($keyframeFilename,"a"); fwrite($fp,$frameData); fclose($fp); } else { $fp = fopen($keyframeFilename,"r+"); fwrite($fp,$frameData); fclose($fp); } } //串連到資料庫 $conn=mysql_connect($mysql_server_name, $mysql_username, $mysql_password); //GBK的資料庫消除亂碼 mysql_query("SET NAMES 'GBK'"); //從表中提取資訊的sql語句 $actsql="select id, subject,cover,txtmemo from tb_act_info"; //執行sql查詢 $result=mysql_db_query($mysql_database, $actsql, $conn); // 定位到第一條記錄 mysql_data_seek($result, 0); // 迴圈取出記錄 while ($row=mysql_fetch_assoc($result)) { if($row["id"]<550){ continue; } $tmpforlder = $row["id"]."//"; //確定臨時目錄名、建立臨時目錄 if(!file_exists($SYSSET[testkeyframePath]."testKeyFrameOutPut//".$tmpforlder)) { @mkdir($SYSSET[testkeyframePath]."testKeyFrameOutPut//".$tmpforlder); } //產生說明資訊 $txtFilename = iconv("utf-8","gb18030",$SYSSET[testkeyframePath]."testKeyFrameOutPut//".$tmpforlder."說明.txt"); $fp = fopen($txtFilename,"a+"); $tmpStr = $row["txtmemo"]; fwrite($fp,$tmpStr); fclose($fp); //產生圖片 $keyframesql=" select rk.frame_time keyframename,rkp.pic pic from tb_res_keyframe rk,tb_res_keyframe_pic rkp where rk.keyframe_id = rkp.id and rk.resource_id = ".$row["id"]." order by rk.resource_id "; $keyframeresult=mysql_db_query($mysql_database, $keyframesql, $conn); mysql_data_seek($keyframeresult, 0); while ($keyframerow=mysql_fetch_assoc($keyframeresult)) { $tmpKeyFramePath = "testKeyFrameOutPut//".$tmpforlder.($keyframerow["keyframename"]."_".".jpg"); generateKeyFrame($keyframerow["pic"],$tmpKeyFramePath); } //釋放資源 mysql_free_result($keyframeresult); } //釋放資源 mysql_free_result($result); //關閉串連 mysql_close();