php教程 将火车头采集db3数据导入到dedecms完整代码
$path =d:pdospiderresult.db3;
 $conn = new pdo(sqlite:$path);
 $array=array('','',''); 
 if( $conn )
 {
  //echo ('connection pdo success');
 }
 else
 {
  echo ('cnnection pdo fail ,plase check database server!');
 }
 $count=0;
 $sp = new splitword();
 foreach ($conn->query('select * from content limit 160,80') as $row)
 {
// baise info
$softtitle = mysql教程_escape_string(mb_convert_encoding($row[3],'gbk','auto')).'-js相册';//title
//file title
$softcontent =  str_replace('image/','http://g.111cn.cn/javascript教程/image/',mb_convert_encoding($row
[4],'gbk','auto'));
//file size of size
$softsize = '未知';
// file downurl
$softurl = str_replace('.zip','',$row['address']);
  $filetype='.rar';
  $softpath='http://g.111cn.cn/javascript/'.$softurl.$filetype;
  $view ='
效果预览地址'.$softtitle.'
';//效果预览地址
      preg_match_all(/(src|src)=[|'| ]{0,}((.*).(gif|jpg|jpeg|png|bmp))/isu,$softcontent,$img_array);
  $thum = str_replace(','',str_replace('','',$img_array[2][0]));
  $softlinks = mysql_escape_string({dede:link islocal='1' text='$localhost'}.$softpath.{/dede:link});
  $a = strip_tags($softcontent);
  $b = $sp->splitrmm($softtitle);
  $keywords = str_replace(' ',',',$b);
$desciption = '';//desc + split word
  $introduce =$softcontent.$desciption.$view;
  $os ='win2003,winxp,win2000,win9x';
  //call out link  descript
$addsoft = insert into d_addonsoft(typeid,filetype,language,softtype,accredit,
os,softrank,officialurl,officialdemo,softsize,softlinks,introduce,templet,userip,redirecturl);
   $addsoft .= values
('$typeid','$filetype','$language','','','$os','3','','','$softsize','.$softlinks.','$introduce','','222.103.69.94','');
   mysql_query( $addsoft ) or die('addsoft'.$addsoft.mysql_error());//.$addsoft
   $newid = mysql_insert_id();
// read insert new id
$sortrank = time();
//read the minutes and seconds when the system is currently
$click = mt_rand(1000,10000);
// random clicks 1000 , 10000 btween
$archives = insert into d_archives
(id,typeid,typeid2,sortrank,flag,ismake,channel,arcrank,click,money,title,litpic,writer,source,pubdate,senddate,mid,descripti
on,keywords);  
   $archives.= values
('$newid','$typeid','0','$sortrank','p','1','3','0','$click','0','$softtitle','$thum','$write','unkown','$sortrank','$sortran
k',1,'$desciption','$keywords');
mysql_query($archives) or die('archives '.$archives.'|'.mysql_error()); //$archives.
   $arctiny = insert into d_arctiny(id,typeid,typeid2,arcrank,channel,senddate,sortrank,mid) values
($newid,$typeid,0,0,3,'$sortrank','$sortrank',1);
mysql_query( $arctiny) or die( 'arctiny'.$arctiny.mysql_error());//$arctiny.
}
 echo '总共有多条',$count,不存地的;
本站原创转载注明来源.net教程>www.bkjia.com
http://www.bkjia.com/phpjc/444966.htmlwww.bkjia.comtruehttp://www.bkjia.com/phpjc/444966.htmltecharticlephp教程 将火车头采集db3数据导入到dedecms完整代码 $path =d:pdospiderresult.db3; $conn = new pdo(sqlite:$path); $array=array('','',''); if( $conn ) { //echo ('connec...