WEB开发网
开发学院WEB开发PHP 一个连接两个不同MYSQL数据库的PHP程序 阅读

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

 2001-02-13 11:42:56 来源:WEB开发网   
核心提示:<HTML><BODY BGCOLOR=FFFFFF><?phpecho "Connecting as MySQL<BR>\n";$connection1 = mysql_connect('localhost', 'mysql'
<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> 

Tags:一个 连接 两个

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接