php 数据库提取导出图片 blob

心已赠人 2022-07-12 14:12 249阅读 0赞

<?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();