This article illustrates the way PHP imports MSSQL data into MySQL. Share to everyone for your reference. The specific analysis is as follows:
Recently need to convert a previous ASP site to PHP, but PHP is with MySQL and my ASP and MSSQL, the result will need to import MSSQL data into the MySQL database, I wrote an example of the following I also copied an example is good.
Instance one, the code is as follows:
Copy Code code as follows:
<?php
PNR code connection in China
$hostname = "127.0.0.1"; The IP address of the MSSQL server or the name of the server
$dbuser = "sa"; The account number of the MSSQL server
$DBPASSWD = "sa"; The password for the MSSQL server
$dbname = "AA"; Name of the database
$conn = Mssql_connect ($hostname, $dbuser, $DBPASSWD); Connecting MSSQL
mssql_select_db ($dbname); /* Connection to access the database can also be written here $db =mssql_select_db ($dbname, $conn); */
$sql = "SELECT * from sheet1$"; SQL statement
$data = Mssql_query ($sql); Set the value of the query in the variable $data
while ($ARR = Mssql_fetch_object ($data))//loop initial set $arr
{
$Airport = $Arr->airport;
$citycode = $Arr->citycode;
$Chinesecityname = $Arr->chinesecityname;
$CHINESECITYJP = $Arr->chinesecityjp;
$english = $Arr->english;
$countrycode = $Arr->countrycode;
$countryfullname = $Arr->countryfullname;
$Chauname = $Arr->chauname;
Echo $code;
$conn =mysql_connect ("localhost", "root", "123456");//Connect the database's account number and port number
mysql_query ("SET NAMES ' GBK '", $conn);
mysql_select_db ("taojipiao2009", $conn);//Loading database
$sql = "Update internationcode set jp= ' $aa ' where code= ' $Code '";
$sql = "INSERT into Internationcode (Airport,citycode,chinesecityname,chinesecityjp,english,countrycode, Countryfullname,chauname) VALUES (' $Airport ', ' $citycode ', ' $Chinesecityname ', ' $Chinesecityjp ', ' $english ', ' $ CountryCode ', ' $countryfullname ', ' $Chauname ');
echo $sql. " <br> ";
$result =mysql_query ($sql);
}
Mssql_close ($conn); Close Database
?>
Reference code Two, the code is as follows:
Copy Code code as follows:
<?php
$mssql _link = Mssql_connect ($db _host, $db _msuser, $db _mspass) or Die ("MSSQL database connection failed");
mssql_select_db ($db _msname, $mssql _link);
$mysql _link = mysql_connect ($db _myhost, $db _myuser, $db _mypass) or Die ("MySQL database connection failed". Mysql_error ());
mysql_select_db ($db _myname, $mysql _link);
$msquery = Mssql_query ("SELECT top 1 * buyok_produc", $mssql _link);
$vars = ';
$vals = ';
$cols = ';
while ($row = Mssql_fetch_array ($msquery, $mssql _link)) {
$vals = ';
foreach ($row as $key => $values) {
$cols. = ($cols = = $key: ', '. $key);
$vals. = ($vals = = ""? '. $values. ', ', ', '. $values.
Echo $vals;
}
$vars. = ($vars = = ""? ' ('. $vals. ') ': ', ('. $vals. ');
}
$sql = "INSERT INTO ' buyok_produc ' ($cols) values $vars";
Echo $sql;
$aa =mysql_query ($sql, $mysql _link);
if ($AA) {
echo "successfully";
}else{
echo "Failed";
}
?>
I hope this article will help you with your PHP program design.