一個連接兩個不同MYSQL數(shù)據(jù)庫的PHP程序
更新時間：2006年10月09日 00:00:00 作者：
<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>
<?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>
相關(guān)文章
今天小編就為大家分享一篇關(guān)于PHP addslashes()函數(shù)講解，小編覺得內(nèi)容挺不錯的，現(xiàn)在分享給大家，具有很好的參考價值，需要的朋友一起跟隨小編來看看吧2019-02-02
動態(tài)網(wǎng)站web開發(fā) PHP、ASP還是ASP.NET
動態(tài)網(wǎng)站web開發(fā) PHP、ASP還是ASP.NET...2006-10-10
生成縮略圖...2006-10-10
php in_array 函數(shù)使用說明與in_array需要注意的地方說明
in_array函數(shù)用功能就是檢查是否存在一個值的數(shù)組 ，就是判斷當(dāng)前數(shù)組中是否存在一個指定的值哦。2010-04-04
一周讓你學(xué)會PHP 不錯的學(xué)習(xí)資料
強(qiáng)烈推薦臺灣中原大學(xué)的php教程。 詼諧幽默，那絕對是大陸的教程沒法比的。2009-02-02
十天學(xué)會php之第三天...2006-10-10
本函數(shù)用來將查詢結(jié)果 result 拆到數(shù)組變量中。若 result 沒有資料，則返回 false 值。而本函數(shù)可以說是 sybase_fetch_row() 的加強(qiáng)函數(shù)，除可以將返回列及數(shù)字索引放入數(shù)組之外，還可以將文字索引放入數(shù)組中2014-04-04
基于文本的搜索...2006-10-10
php利用adodb分頁實(shí)現(xiàn)代碼2009-03-03
模擬xcopy的函數(shù)...2006-10-10