文章詳情頁

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

瀏覽：5日期：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中動態(tài)HTML的輸出技術(shù)下一條：用PHP+java實(shí)現(xiàn)自動新聞滾動窗口

排行榜

					
					IntelliJ IDEA導(dǎo)入jar包的方法
Python requests庫參數(shù)提交的注意事項(xiàng)總結(jié)
javascript實(shí)現(xiàn)雪花飄落效果
Gitlab CI-CD自動化部署SpringBoot項(xiàng)目的方法步驟
SpringBoot參數(shù)校驗(yàn)與國際化使用教程
詳談ajax返回?cái)?shù)據(jù)成功 卻進(jìn)入error的方法
PHP對文本數(shù)據(jù)庫的基本操作方法
JavaScript中l(wèi)ayim之整合右鍵菜單的示例代碼
使用Python和百度語音識別生成視頻字幕的實(shí)現(xiàn)
python ansible自動化運(yùn)維工具執(zhí)行流程
ASP基礎(chǔ)知識VBScript基本元素講解
				