??能否在php中从mysql的一个表中读出数据,然后再插入到sqlserver的一个表中?(在一个php文件中)
急需!!!代码如下:
<?
//dl("php_mssql70.dll");
include "set.php";
$ConnM = mysql_connect("$My_host","$My_user","$My_password");
mysql_select_db("$My_db",$ConnM);
$Query = "select Title,Author,Up_date,Content,FilePath,FileName,hits from Articles";
$Result = mysql_query($Query,$ConnM) or die("Can not open the table");
$i=0;
while($Rows = mysql_fetch_array($Result))
{
$i=$i + 1;
echo $i;
echo "\n";
//往sqlserver中添数据
$Query = "insert into td_Articles (Title,Author,CreatedDate,Content,Url,Clicks) values('";
$Query = $Query.$Rows["Title"]."','";
$Query = $Query.$Rows["Author"]."','";
$Query = $Query.$Rows["Up_date"]."','";
$Query = $Query.$Rows["Content"]."','";
$Query = $Query.$Rows["FilePath"].$Rows["FileName"]."','";
$Query = $Query.$Rows["hits"]."')";
//
$ConnS = mssql_connect("localhost","sa","00000");
mssql_select_db("DotNetNuke",$ConnS);
$Result1 = mssql_query($Query,$ConnS) or die("Can not open the table");
if($Result1)
{
echo "OKKKKKKKK!";
}
else
{
echo "Failllllll!";
}
}
mssql_close($ConnS);
mysql_close($ConnM);
?>