PHP把MSSQL数据导入到MYSQL实例
最近需要把一个以前的asp网站转换成php的,但php是与mysql而我的asp与mssql的,结果就需要把mssql数据导入到mysql数据库了,下面我自己写了一个实例还抄了一个实例都不错.
实例一,代码如下:
<?php //国内的PNR码连接 $hostname = "127.0.0.1" ; //MSSQL服务器的IP地址 或 服务器的名字 $dbuser = "sa" ; //MSSQL服务器的帐号 $dbpasswd = "sa" ; //MSSQL服务器的密码 $dbname = "aa" ; //数据库的名字 $conn = mssql_connect( $hostname , $dbuser , $dbpasswd ); //连接MSSQL mssql_select_db( $dbname ); /*连接要访问的数据库 这里也可以写做 $db=mssql_select_db($dbname,$conn); */ $sql = "select * from Sheet1$" ; //sql语句 $data = mssql_query( $sql ); //把查询的值集合在变量$data while ( $Arr = mssql_fetch_object( $data )) //循环初始的集合$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" ); //连接数据库的帐号和端口号 mysql_query( "SET NAMES ‘GBK’" , $conn ); mysql_select_db( "taojipiao2009" , $conn ); // 加载数据库 //$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 ); //开源代码phpfensi测试数据 } //mssql_close($conn); //关闭数据库 ?>参考代码二,代码如下:
<?php $mssql_link = mssql_connect( $db_host , $db_msuser , $db_mspass ) or die ( "mssql数据库连接失败" ); mssql_select_db( $db_msname , $mssql_link ); $mysql_link = mysql_connect( $db_myhost , $db_myuser , $db_mypass ) or die ( "mysql数据库连接失败" .mysql_error()); mysql_select_db( $db_myname , $mysql_link ); $msquery = mssql_query( "select top 1 * from 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" ; } ?>查看更多关于PHP把MSSQL数据导入到MYSQL实例 - php高级应用的详细内容...
声明：本文来自网络，不代表【好得很程序员自学网】立场，转载请注明出处：http://www.haodehen.cn/did30504