php 資料庫 提取 匯出 圖片 blob

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