文章詳情頁(yè)

一個(gè)連接兩個(gè)不同MYSQL數(shù)據(jù)庫(kù)的PHP程序

瀏覽：6日期：2024-01-20 10:18:08

<HTML><BODY BGCOLOR=FFFFFF>;;<?php;;;;;;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";;;;;;;};;?>;;</BODY></HTML>;;

PHP

上一條：PHP中動(dòng)態(tài)HTML的輸出技術(shù)下一條：用PHP+java實(shí)現(xiàn)自動(dòng)新聞滾動(dòng)窗口

排行榜

					
					python中scrapy處理項(xiàng)目數(shù)據(jù)的實(shí)例分析
Hybris在idea中debug配置方法詳解
在idea中為注釋標(biāo)記作者日期操作
PHP安全-數(shù)據(jù)的暴露
PHP實(shí)現(xiàn)基本留言板功能原理與步驟詳解
Python趣味挑戰(zhàn)之用pygame實(shí)現(xiàn)簡(jiǎn)單的金幣旋轉(zhuǎn)效果
如何在JavaScript中等分?jǐn)?shù)組的實(shí)現(xiàn)
Sun 公司完整發(fā)布Java API文檔中文版
python實(shí)現(xiàn)與redis交互操作詳解
ASP.Net Core對(duì)USB攝像頭進(jìn)行截圖
JAVA 內(nèi)存溢出案例匯總
				