一个连接两个不同MYSQL数据库的PHP程序

来源：百度文库编辑：神马文学网时间：2024/04/28 14:30:26

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

一个连接两个不同MYSQL数据库的PHP程序用php连接oracle数据库【2】MySQL数据库的安装和配置和ASP连接MySQL的代码参考如何在ASP中连接MySQL数据库如何开一个10M的MYSQL数据库给用户？查看mysql数据库的版本 Mysql死连接的问题配置最新的PHP加MYSQL服务器缩略图生成的php程序图解MySQL数据库的安装和操作 MySQL与其他数据库的对比详解MySQL数据库的启动与终止让 MySQL 数据库自动恢复的具体操作每天备份 mysql 数据库的脚本 MySql数据库、表名大小写的问题图解MySQL数据库的安装和操作最简便的MySql数据库备份办法每天备份 mysql 数据库的脚本 unix 下mysql的连接方式用php和MySql来与ODBC数据连接 - 织梦内容管理系统 MYSQL到ORACLE程序迁移的注意事项 PHP MySQL 函数 IIS+mysql+php学习 php&mysql完整教程