首页 / 网页编程 / PHP / 一个连接两个不同MYSQL数据库的PHP程序

<HTML><BODY BGCOLOR=FFFFFF>
<？php
    echo "Connecting as mysql<BR> ";
    $connection1 = mysql_connect（"localhost", "mysql", ""） or die（$php_errormsg）;
    echo "connection1 is $connection1<BR> ";
    echo "Selecting test for mysql user<BR> ";
    mysql_select_db（"test", $connection1） or @die（"Error " . $php_errormsg . mysql_error（））;
    echo "Connection as joyce<BR> ";
    $connection2 = mysql_connect（"localhost", "joyce", ""） or die（$php_errormsg）;
    echo "connection2 is $connection2<BR> ";
    echo "Selecting books for joyce user<BR> ";
    $db2 = mysql_select_db（"techbizbookguide", $connection2） or die（mysql_error（））;
    $query1 = "select foo from test";
    $query2 = "select title, authorFirst, authorLast from bookinfo";
    echo "Querying test<BR> ";
    $users = mysql_query（$query1, $connection1） or die（mysql_error（））;
    echo "Querying books<BR> ";
    $books = mysql_query（$query2, $connection2） or die（mysql_error（））;
    echo "Foos from test<BR> ";
    while （list（$foo） = mysql_fetch_row（$users））{
        echo $foo, "<BR> ";
    }
    echo "Books in techbizbookguide<BR> ";
    while （list（$title, $authorFirst, $authorLast） = mysql_fetch_row（$books））{
        //Use trim in case we have a book by "Madonna" or "Prince" or...
        echo $title, " by ", trim（$authorFirst . " " . $authorLast）, "<BR> ";
    }
？>
</BODY></HTML>

版权所有©石家庄振强科技有限公司2024 冀ICP备08103738号-5 网站地图