1. 一、getimgarrfrommysql
    3. <?php
    5. echo ' select mysql get picurl to array start<br>';
    7. $link = mysql_connect('localhost','root',''); //('hostname','dbuser','dbpassword')
    8. if (!$link) {
    9. die('Could not connect to MySQL: ' . mysql_error());
    10. }
    12. echo 'Connection OK<br>';
    14. mysql_select_db("test", $link);
    15. $result = mysql_query("SELECT * FROM to8to_goodcasepic");
    17. $caseArr = array();
    18. $i = 0;
    20. while($row = mysql_fetch_array($result))
    21. {
    22. echo $i . " --> " . $row['picpath'];
    23. echo "<br />";
    24. $caseArr[$i] = $row['picpath'];
    25. $i ++;
    26. }
    28. echo '<br> close mysql <br>';
    29. mysql_close($link);
    31. echo '<br> mysql the end <br>';
    32. echo '<br> writeFile start <br>';
    33. $imgDataArr = '<?php
    34. $picdata =';
    35. $imgDataArr .= var_export($caseArr,true).'; ';
    36. //###测试临时注释
    37. //file_put_contents('ab3.php',$textdata2);
    39. $fileName = "./caseimgarrdata.php";
    40. writeFile($fileName,$imgDataArr,'a');
    42. echo '<br> writeFile the end <br>';
    43. echo '<br> all the end <br>';
    45. /*
    46. **
    47. * 写文件
    48. * @param string $file 文件路径
    49. * @param string $str 写入内容
    50. * @param char $mode 写入模式
    51. */
    52. function writeFile($file,$str,$mode='w'){
    53. $oldmask = @umask(0);
    54. $fp = @fopen($file,$mode);
    55. @flock($fp, 3);
    56. if(!$fp){
    57. Return false;
    59. } else {
    60. @fwrite($fp,$str);
    61. @fclose($fp);
    62. @umask($oldmask);
    63. Return true;
    64. }
    65. }
    67. ///the end ///
    69. 二、getimgarrfromdb
    71. <?php
    72. /**
    73. * 从数据库批量获取图库（效果图）地址，按规则生成webp 图片
    74. *
    75. * @author bfire.lai
    76. * @version 1.0
    77. * @copyright bfire.lai, 2015-01-16
    78. * @package default
    79. */
    81. //实时刷新浏览器缓存
    82. ob_end_clean();
    83. ob_implicit_flush(true);
    85. //网站根目录
    86. if (!defined('ROOT')) {
    87. define('ROOT', dirname(dirname(__FILE__)));
    88. }
    90. //定义图片路径
    91. define('PIC_DOMAIN','http://pic.to8to.com/');
    93. //导入基本配置文件
    94. require_once("../include/start_init.inc.php");
    96. $debug2 = (int)$_GET['_debug'];
    97. if ($debug2) {
    98. ini_set('display_errors',true);
    99. error_reporting(E_ALL);
    100. $db->SetPrintSql(true);
    101. }
    103. //设置响应时间不限制
    104. @set_time_limit(0);
    105. //设置最大缓存块是512M
    106. @ini_set('memory_limit','512M');
    108. echo '<br> all start <br>'.date("Y-m-d H:i:s");
    110. if(1){
    111. //效果图 获取数据写入文件数组
    113. $tables = 'xiaoguotu';
    115. //数遍表
    116. $tablesArr = array(
    117. 0 => 'xiaoguotu', //效果图(图库) filename
    118. 1 => 'owner', //业主头像 id
    119. 2 => 'fcom', //装修公司头像 id
    120. 3 => 'art', //装修公司设计方案 filename
    121. 4 => 'company_zhengshu', //装修公司证书 filename
    122. 5 => 'gongdi_pic', //远程工地 filename
    123. 6 => 'xiaoguotu_topic', //专题 img_for_mobile/img1/img2/img3/img4/img5
    124. //7 => 'knowzxcs', //知识 content
    125. //8 => 'company_zhengshu', //装修公司证书 filename
    126. //9 => 'c'
    127. );
    128. foreach ($tablesArr as $kk => $vv) {
    129. //switch($tables){
    130. $tables = $vv;
    131. switch($tables){
    132. case 'xiaoguotu':
    133. $filename = 'filename as filename';
    134. $where = 'visible=1';
    135. $orderby = 'edittime desc';
    136. $in_rule = 'smallcase';
    137. imgDbToImgWebp($tables, $filename, $where, $orderby, $in_rule);
    138. break;
    139. case 'owner':
    140. $filename = 'id as filename';
    141. $in_rule = 'user';
    142. imgDbToImgWebp($tables, $filename, '', '', $in_rule);
    143. break;
    144. case 'fcom':
    145. $filename = 'id as filename';
    146. $in_rule = 'user';
    147. imgDbToImgWebp($tables, $filename, '', '', $in_rule);
    148. break;
    149. case 'art':
    150. $filename = 'filename as filename';
    151. $orderby = 'edittime desc';
    152. $in_rule = 'case';
    153. imgDbToImgWebp($tables, $filename, '', $orderby, $in_rule);
    154. break;
    155. case 'company_zhengshu':
    156. $filename = 'filename as filename';
    157. $orderby = 'puttime desc';
    158. $in_rule = 'c_zhengshu';
    159. imgDbToImgWebp($tables, $filename, '', $orderby, $in_rule);
    160. break;
    161. case 'gongdi_pic':
    162. $filename = 'filename as filename';
    163. $orderby = 'add_time desc';
    164. $in_rule = 'gongdi_pic';
    165. imgDbToImgWebp($tables, $filename, '', $orderby, $in_rule);
    166. break;
    167. case 'xiaoguotu_topic':
    168. $filename = 'img_for_mobile as filename';
    169. $orderby = 'puttime desc';
    170. $in_rule = 'xiaoguotu_topic';
    171. imgDbToImgWebp($tables, $filename, '', $orderby, $in_rule);
    172. break;
    173. /*
    174. case 'xiaoguotu7':break;
    175. case 'xiaoguotu8':break;
    176. case 'xiaoguotu9':break;
    177. case 'xiaoguotu10':break;
    178. case 'xiaoguotu11':break;
    179. case 'xiaoguotu12':break;
    180. */
    181. default :echo '脚本执行完毕...';break;
    182. }
    183. }
    184. }
    186. echo '<br> all end time <br>'.date("Y-m-d H:i:s");
    188. /**
    189. * @功能：先查数据库 转换成数组 再 转换成 WEBP 格式
    190. * @参数：$tables => 数据表, $filename => 要查的字段, $where=> 条件, $orderby => 排序
    191. * @返回：若转换成功返回true,否则返回false或直接跳出
    192. */
    193. function imgDbToImgWebp($tables, $filename='', $where='', $orderby='',$in_rule=''){
    195. global $db;
    196. if($tables == ''){
    197. return false;
    198. }
    200. $page = 1;
    201. if(!@$perpage) $perpage=3;
    202. while(true){
    204. $limit=($page-1)*$perpage;
    205. $limit="$limit,$perpage";
    207. echo '<br> select xiaoguotu start time : <br>'.date("Y-m-d H:i:s");
    208. //$tables = 'xiaoguotu';
    209. $result=$db->GetRow($tables,$filename,$where,'',$orderby,$limit);
    210. echo '<br> select xiaoguotu end time : <br>'.date("Y-m-d H:i:s");
    211. echo '<br> foreach result start time : <br>'.date("Y-m-d H:i:s");
    212. echo '<pre>';
    213. //print_r($result);exit;
    214. if($result){
    215. //可以操作条件
    216. //echo '<pre>';
    217. //临时图片
    218. $imgDataArr = array();
    219. foreach ($result as $k => $v) {
    220. //echo $k . " --> " . $v['filename'];
    221. //echo "<br />";
    222. switch($in_rule){
    223. case 'case':
    224. $imgDataArr[$k] = $in_rule.'/'.$v['filename'];
    225. break;
    226. case 'smallcase':
    227. $imgDataArr[$k] = $in_rule.'/'.$v['filename'];
    228. break;
    229. case 'user':
    230. //$file='/pic/user/'.($uid%100)."/headphoto_$uid$FLAG.jpg";
    231. $uid = intval($v['filename']);
    232. $imgDataArr[$k] = $in_rule.'/'.($uid%100)."/headphoto_$uid.jpg";
    233. break;
    234. case 'c_zhengshu':
    235. $imgDataArr[$k] = $in_rule.'/'.$v['filename'];
    236. break;
    237. case 'gongdi_pic':
    238. $imgDataArr[$k] = $in_rule.'/'.$v['filename'];
    239. break;
    240. case 'xiaoguotu_topic':
    241. $imgDataArr[$k] = $in_rule.'/'.$v['filename'];
    242. break;
    243. /*
    244. case 'xiaoguotu5':break;
    245. case 'xiaoguotu6':break;
    246. case 'xiaoguotu7':break;
    247. case 'xiaoguotu8':break;
    248. case 'xiaoguotu9':break;
    249. */
    250. default :
    251. $imgDataArr[$k] = $in_rule.'/'.$v['filename'];
    252. break;
    253. }
    255. }
    256. //图片转换
    257. echo '<br> imgDataArrToWebp start time <br>'.date("Y-m-d H:i:s");
    258. imgDataArrToWebp($imgDataArr);
    259. echo '<br> imgDataArrToWebp end time <br>'.date("Y-m-d H:i:s");
    261. }else{
    262. //结束条件
    263. echo '<br> 没有结果呢... <br>'.date("Y-m-d H:i:s");
    264. break;
    265. }
    267. if($page == 3){
    268. //结束条件
    269. echo '<br> 有数据哟 不过已经结束了... <br>'.date("Y-m-d H:i:s");
    270. break;
    271. }
    272. $page ++;
    273. }
    274. echo '<br> foreach result time <br>'.date("Y-m-d H:i:s");
    276. return true;
    278. }
    280. /**
    281. * @功能：数组中的图片按规则转换成 WEBP 格式
    282. * @参数：$picdata => 源图片数组,
    283. * @返回：若转换成功返回true,否则返回false或直接跳出
    284. */
    285. function imgDataArrToWebp($picdata){
    287. //图片规则
    288. $images_rule = array(
    289. 'smallcase'=>array('r','s','t',254,508,284,480),
    290. 'case'=>array('s','c','831',480,'592x344M','140x140M'),
    291. 'home'=>array('s','r','280x280M'),
    292. 'huodong'=>array('c',730),
    293. 'attch'=>array('s','r','140x140M','80x80M','600',480,'180x180M','560x315M','640x360M','640x580M','600x338M'),
    294. 'user'=>array(120,130,60),
    295. 'renmai'=>array(600,440,80,'p'),
    296. 'vr'=>array(223),
    297. 'gongdi_pic'=>array(80,160,240,'230x230M'),
    298. 'ask'=>array('s'),
    299. 'mall'=>array('m',280,180,80,50,480),
    300. 'photo'=>array('s'),
    301. 'news_center'=>array('s'),
    302. 'xiaoguotu_topic'=>array(480,284,588),
    303. 'live'=>array('600',480,'180x180M','560x315M','640x360M','140x140M','80x80M','640x580M','600x338M'),
    304. 'c_zhengshu'=>array(180),
    305. );
    307. echo '<pre>';
    308. //print_r($picdata);exit;
    310. if(!is_array($picdata)){
    311. return false;
    312. }
    314. $imgiconnum = $imgiconsum = 0;
    315. $t = 0;
    316. echo '<br> foreach picdata start <br>'.date("Y-m-d H:i:s");
    318. foreach ($picdata as $k2 => $v2) {
    319. //echo $k2;
    320. //echo '<br>';
    322. $imgiconsum ++;
    324. $to_path = pathinfo($v2);
    325. $in_rule = explode('/',$to_path['dirname']);
    326. /*
    327. [dirname] => case/1501/15
    328. [basename] => 20150115_84991cead0e29c29a14dr5a7kn6bu7qn.jpg
    329. [extension] => jpg
    330. [filename] => 20150115_84991cead0e29c29a14dr5a7kn6bu7qn
    331. */
    332. //print_r($to_path);
    334. if($images_rule[$in_rule[0]]){
    335. echo '<br> 正在图片转换.... <br>'.date("Y-m-d H:i:s");
    337. //原图转换
    338. $srcurl = PIC_DOMAIN.$to_path['dirname'].'/'.$to_path['basename'].'.webp';
    339. askimgtohtml($srcurl);
    341. //缩略图转换
    342. foreach ($images_rule[$in_rule[0]] as $k3 => $v3) {
    343. // echo '<br>';
    344. $url = PIC_DOMAIN.$to_path['dirname'].'/'.$to_path['filename'].'_'.$v3.'.'.$to_path['extension'].'.webp';
    345. // echo $url;
    346. askimgtohtml($url);
    347. // echo '<br>';
    348. }
    349. }else{
    350. echo '<br> 不做图片转换工作 <br>'.date("Y-m-d H:i:s");
    351. }
    353. echo '<br> the '.($k2+1).' end <br>'.date("Y-m-d H:i:s");
    355. }
    356. echo '<br> foreach picdata end <br>';
    357. echo '<br>---sur- result : $imgiconnum '.$imgiconnum.'+++++ $imgiconsum '.$imgiconsum.'-----<br>';
    359. return true;
    361. }
    363. /*
    364. **
    365. * 访问URL 生成WEBP
    366. * @param string $url 图片URL
    367. */
    368. function askimgtohtml($url){
    370. $cmd=$retext=$args=$str = '';
    372. //判断所在系统
    373. $isSystem = stripos(PHP_OS,"WIN")>-1;
    374. if ($isSystem) {
    375. $cmd = "wget -O c:/null $url ";
    376. }else{
    377. $cmd = "wget -O /dev/null $url";
    379. //$retext = implode(",",$return);
    380. //$linenum = __LINE__;
    381. //操作日志
    382. //rewritetolog('#html+'.$linenum.'#', $cmd, $retext, $args);
    383. }
    384. //$str = exec($cmd,$return,$args);
    385. //echo '<br> 输出 cmd '.date("Y-m-d H:i:s").'--->';
    386. echo $cmd;
    388. //控制访问时间
    389. sleep(0.2);
    390. }
    392. /*
    393. **
    394. * 写文件
    395. * @param string $file 文件路径
    396. * @param string $str 写入内容
    397. * @param char $mode 写入模式
    398. */
    399. function writeFile($file,$str,$mode='w'){
    400. $oldmask = @umask(0);
    401. $fp = @fopen($file,$mode);
    402. @flock($fp, 3);
    403. if(!$fp){
    404. Return false;
    406. } else {
    407. @fwrite($fp,$str);
    408. @fclose($fp);
    409. @umask($oldmask);
    410. Return true;
    411. }
    412. }
    414. /**
    415. * @功能：日志记录
    416. * @参数：$intype => 要记录日志的类型,
    417. * $cmd => 执行的LINUX命令,
    418. * $return => 返回结果集,
    419. * $args => 返回结果状态，0表示成功，非0表示失败
    420. * $logger => 是否要记录日志
    421. * @返回：若转换成功返回true,否则返回false或直接跳出
    422. * 显示行号 __LINE__
    423. */
    424. function rewritetolog($intype='', $cmd='', $return='', $args='', $logger =true) {
    426. if($logger){
    427. $log = '#Suc#';
    428. if($args){
    429. $log = '#Err#';
    430. }
    431. $log = $log.$intype.':'.date("Y-m-d H:i:s").":#cmd#".$cmd."#return#".$return."#args#".$args."<br>\n";
    432. $fileName = "../syslog/imglogs/".date('Y-m-d').".log";
    433. writeFile($fileName,$log,'a');
    435. }
    437. }
    439. 三、getimgdatafromhtml
    441. <?php
    443. echo '<br> getimgdatafromhtml start <br>';
    444. echo date('h:i:s') . "<br />";
    446. //暂停 10 秒
    447. sleep(2);
    448. //重新开始
    449. echo date('h:i:s');
    450. echo '<pre>';
    451. echo '<br> require imgfile start <br>';
    452. //#读出的方法
    453. require("caseimgarrdata.php");
    454. //print_r($picdata);
    456. echo '<br> require imgfile end <br>';
    458. $imgiconnum = $imgiconsum = 0;
    459. $t = 0;
    461. echo '<br> foreach picdata start <br>';
    463. foreach ($picdata as $k2 => $v2) {
    464. echo $k2;
    465. $imgiconsum ++;
    466. $to_path = pathinfo($v2);
    467. //print_r($to_path);
    468. //makeDir( $to_path['dirname'] );
    469. $url = 'http://pic.to8to.com/'.$v2;
    470. //$url = 'http://img.to8to.com/'.$v2;
    471. //echo $url;
    472. //echo '<br>';
    473. sleep(2);
    474. $res = getImage($url,$to_path['dirname'],$to_path['basename']);
    476. //print_r($res);
    477. if($res['error']=='0'){
    478. $imgiconnum ++;
    479. }
    481. }
    482. echo '<br> foreach picdata end <br>';
    483. echo '<br>---sur- result : $imgiconnum '.$imgiconnum.'+++++ $imgiconsum '.$imgiconsum.'-----<br>';
    484. echo '<br> all end <br>';
    485. exit;
    487. /**
    488. * @功能：创建目录
    489. * @参数：$path => 要创建的目录, $mod => 指定权限
    490. * @返回：若创建成功返回true,否则返回false或直接跳出
    491. */
    492. function makeDir($path, $mod = 0777) {
    494. if (stripos(PHP_OS, 'win') === false) {
    495. $cmd = 'mkdir -p '.$path;
    496. } else {
    497. $path = str_replace('/', '\\', $path);
    498. $cmd = 'mkdir '.$path;
    499. }
    500. exec($cmd);
    501. return true;
    502. }
    504. /*
    505. 02
    506. *功能：php完美实现下载远程图片保存到本地
    507. 03
    508. *参数：文件url,保存文件目录,保存文件名称，使用的下载方式
    509. 04
    510. *当保存文件名称为空时则使用远程文件原来的名称
    511. 05
    512. */
    514. function getImage($url,$save_dir='',$filename='',$type=0){
    516. if(trim($url)==''){
    518. return array('file_name'=>'','save_path'=>'','error'=>1);
    520. }
    522. if(trim($save_dir)==''){
    524. $save_dir='./';
    526. }
    528. if(trim($filename)==''){//保存文件名
    530. $ext=strrchr($url,'.');
    532. if($ext!='.gif'&&$ext!='.jpg'&&$ext!='.png'){
    534. return array('file_name'=>'','save_path'=>'','error'=>3);
    536. }
    538. $filename=time().$ext;
    540. }
    542. if(0!==strrpos($save_dir,'/')){
    544. $save_dir.='/';
    546. }
    548. //创建保存目录
    550. if(!file_exists($save_dir)&&!mkdir($save_dir,0777,true)){
    552. return array('file_name'=>'','save_path'=>'','error'=>5);
    554. }
    556. //获取远程文件所采用的方法
    558. if($type){
    560. $ch=curl_init();
    562. $timeout=5;
    564. curl_setopt($ch,CURLOPT_URL,$url);
    566. curl_setopt($ch,CURLOPT_RETURNTRANSFER,1);
    568. curl_setopt($ch,CURLOPT_CONNECTTIMEOUT,$timeout);
    570. $img=curl_exec($ch);
    572. curl_close($ch);
    574. }else{
    576. ob_start();
    578. readfile($url);
    580. $img=ob_get_contents();
    582. ob_end_clean();
    584. }
    586. //$size=strlen($img);
    588. //文件大小
    590. $fp2=@fopen($save_dir.$filename,'a');
    592. fwrite($fp2,$img);
    594. fclose($fp2);
    596. unset($img,$url);
    598. return array('file_name'=>$filename,'save_path'=>$save_dir.$filename,'error'=>0);
    600. }