当前位置：IDC资讯中心 > 网站运营 > 正文

一个连接两个不同mysql数据库的php程序_php技巧

2007-08-23 分类：网站运营阅读(613) 评论(0)

建站超值云服务器，限时71元/月

<HTML><BODY BGCOLOR=FFFFFF>
<?php
    echo "Connecting as mysql<BR>\n";
    $connection1 = mysql_connect(localhost, mysql, ) or die($php_errormsg);
    echo "connection1 is $connection1<BR>\n";
    echo "Selecting test for mysql user<BR>\n";
    mysql_select_db(test, $connection1) or @die("Error " . $php_errormsg . mysql_error());
    echo "Connection as joyce<BR>\n";
    $connection2 = mysql_connect(localhost, joyce, ) or die($php_errormsg);
    echo "connection2 is $connection2<BR>\n";
    echo "Selecting books for joyce user<BR>\n";
    $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>\n";
    $users = mysql_query($query1, $connection1) or die(mysql_error());
    echo "Querying books<BR>\n";
    $books = mysql_query($query2, $connection2) or die(mysql_error());
    echo "Foos from test<BR>\n";
    while (list($foo) = mysql_fetch_row($users)){
        echo $foo, "<BR>\n";
    }
    echo "Books in techbizbookguide<BR>\n";
    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>\n";
    }
?>
</BODY></HTML>

赞(0)

版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com 特别注意：本站所有转载文章言论不代表本站观点！本站所提供的图片等素材，版权归原作者所有，如需使用，请与原作者联系。未经允许不得转载：IDC资讯中心 » 一个连接两个不同mysql数据库的php程序_php技巧

相关推荐