PHP implementation SQL Server data import MySQL database (example)

Connecting to a SQL Server database $conn =mssql_connect ("localhost", "sa", "" "); Server name, user name, password mssql_select_db ("Db_database06", $conn); Connecting the Table_book Database Connect to MySQL Database $id =mysql_connect ("localhost", "root", "123456"); Local server localhost, user name root, password root mysql_select_db ("Db_database06", $id); mysql_query ("Set names gb2312"); Connecting the Shop_book Database Querying all the contents of a data table book from a SQL Server database ?> SQL Server data import to MySQL database _bbs.it-home.org $ms _query=mssql_query ("select * from $db _database", $conn); while ($msrow =mssql_fetch_array ($ms _query)) { $name = $msrow [name]; Set a variable for the content of the output $author = $msrow [author]; $bookconcern = $msrow [Bookconcern]; ?> Exporting the contents of a SQL Server data table Name Author Bookconcern if ($Submit 2==true) { $query =mysql_query ("INSERT into Tb_book (Name,author,bookconcern) VALUES (' $name ', ' $author ', ' $bookconcern ') ", $id); } if ($query ==true) { echo "Import succeeded!!"; }else{echo "Import failed!";} ?> $query =mysql_query ("SELECT * from Tb_book"); if ($query ==true) { while ($myrow =mysql_fetch_array ($query)) { ?> Data that was successfully imported Name Author Bookconcern Copy Code

