PHP implements SQL Server data import into Mysql database (example)

< ;td align="center">author

$ms_query=mssql_query("select * from $db_database",$conn);

while($msrow=mssql_fetch_array($ms_query)){

$name=$msrow[name]; //for output Set a variable for the content

$author=$msrow[author];

$bookconcern=$msrow[bookconcern];

?>

//Connect to SQL server database $conn=mssql_connect("localhost","sa",""); //Server name, username, password mssql_select_db("db_database06", $conn); //Connect to table_book database //Connect to mysql database $id=mysql_connect("localhost","root","123456"); //Local server localhost, username root, password root mysql_select_db(" db_database06",$id); mysql_query("set names gb2312"); //Connect to the shop_book database //Query all the contents of the data table book from the SQL server database ?> SQL Server data is imported into the MySQL database_bbs.it-home.org Please select the data table < table width="450" ​​border="1" cellpadding="0" cellspacing="0" bgcolor="#B4EEF1">
Export the contents of the SQLserver data table
name	bookconcern
;		< ;/td>

if($Submit2==true ){

$query=mysql_query("insert into tb_book(name,author,bookconcern)

values('$name','$author','$bookconcern')",$id);

}

if($query ==true){

echo "Import successful!!";

}else{echo "Import failed!!";}

?>

$query=mysql_query("select * from tb_book");

if($query==true){

while($myrow=mysql_fetch_array($query)){

?>

成功导入的数据
name	author	bookconcern

复制代码