【www.bbyears.com--Mssql】
$link = mssql_connect("127.0.0.1", "sa", "sa") or die("Can"t connect sql server");
mssql_select_db("cheng", $link) or die("Select database failure");
mysql教程_connect("localhost","root","root") or die("数据库教程服务器不能连接");
mysql_select_db("loupan") or die( "error" );
mysql_query("set Names "gb2312"");
$ms_sql ="Select * from sony_z2800";
$ms_query = mssql_query( $ms_sql ) or die("55555");
$typeid =23;
$write ="";
$sj ="";
$sjzt ="";
while( $ms_rs = mssql_fetch_array( $ms_query ) )
{
$filetype = $ms_rs[8];
$language = $ms_rs[6];
$os = $ms_rs[10];
$softsize = $ms_rs[7];
$softlinks = mysql_escape_string("{dede:link islocal="1" text="迅雷下载"}".$ms_rs[11]."{/dede:link}");
$title = mysql_escape_string(mb_convert_encoding($ms_rs[3],"gbk","gb2312"));
$click = $ms_rs[9];
if( !is_numeric($click))
{
$click = mt_rand(100,1000);
}
$litpic = mysql_escape_string(str_replace("" />","",str_replace("
$desciption ="";
$introduce="";
//die($desciption);
$addsoft = "Insert into 3g_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","","202.103.69.94","")";
mysql_query( $addsoft ) or die("addsoft".$addsoft.mysql_error());
$newid = mysql_insert_id();
$temp_title = $title."-".$sj."-".$language;
$seo =$os.$sj.$sjzt;
keywords= $os.",".$sj.",".$sjzt.",".$title.",".$language
$archives = "Insert into 3g_archives
(id,typeid,typeid2,sortrank,flag,ismake,channel,arcrank,click,money,title,litpic,writer,source,pubdate,senddate,mid,dutyadmin
,description,keywords)";
$archives.=" values
("$newid","$typeid","0","1255070897","p","1","3","0","$click","0","$temp_title","$litpic","$write","未
知","1255070897","1255070970",1,1,"$desciption","$keywords")";
mysql_query($archives) or die("archives ".$temp_title."|".$archives.mysql_error());
$arctiny = "Insert into 3g_arctiny(id,typeid,typeid2,arcrank,channel,senddate,sortrank,mid) values
($newid,$typeid,0,0,3,"1255070897","1255070970",1)";
mysql_query( $arctiny) or die( "arctiny".$arctiny.mysql_error());
}
echo "success";
本站原创转载注明来源.net教程">www.111cn.net