当前位置:Gxlcms > PHP教程 > 一个连接两个不同MYSQL数据库的PHP程序

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

时间:2021-07-01 10:21:17 帮助过:31人阅读

 
  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"; 
  } 
?> 
 

人气教程排行