mysql 导出blob图片_php 数据库 提取 导出 图片 blob | 学步园

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