[程式編輯]如何操作MySQL - 中央論壇 - CENTER BBS

<?php
  $Host = "127.0.0.1";
  $User = "Dana";
  $Pass = "123456";
  $Database = "TEST_DB";

  $SQL = "SELECT ACCOUNT, NAME FROM tabUserInfo";
  if(!($DBLinkID = mysql_connect($Host, $User, $Pass))) {
echo "無法MySQL連接資料庫！";
exit();
  }

  mysql_select_db($Database, $DBLinkID);
  $ResultID = mysql_query($SQL, $DBLinkID);
  if (!$ResultID) {
echo "SQL語法有誤！";
mysql_close($DBLinkID);
exit();
  }

  // 使用物件(object) 方式
  while ($TableRow = mysql_fetch_object($ResultID)) {
echo $TableRow->ACCOUNT;
echo " ";
echo $TableRow->NAME;
echo "<br>";
  }

  /* 或
  // 使用陣列(array) 方式
  while ($TableRow = mysql_fetch_array($ResultID)) {
echo $TableRow[0];
echo " ";
echo $TableRow[1];
echo "<br>";
  }
  */

  mysql_free_result($ResultID));
  mysql_close($DBLinkID);
?>