【www.gdgbn.com--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.net/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.net/javascript/".$softurl.$filetype;
$view ="
效果预览地址
target=_blank>".$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.111cn.net