<?php
/*
* Created on Dec 20, 2010
*
* To change the template for this generated file go to
* Window - Preferences - PHPeclipse - PHP - Code Templates
*/
//phpinfo();
$user = 'root';
$password = '';
$conn = mysql_connect('localhost', $user, $password) or die('Could not con' . mysql_errno());
echo '<br><b>第一步成功連接</b><br>';
$db = 'test';
mysql_select_db($db) or die('Could not select database (' . $db . ' ) because of ' . mysql_error());
echo '<b>第二步: </b>成功連接到(' . $db . ')';
$query = 'SELECT * FROM `haha` WHERE 1 LIMIT 0, 30 ';
$result = mysql_query($query) or die('Query failed' . mysql_error());
echo '<br><br><b>正在獲取數據...</b><br>';
echo '<table border = "1" width = "500">\n';
$count = 0;
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { //數據轉換成array位置索引成對的出現。
echo '\t<tr>\n';
foreach ($line as $key => $value) {
echo '\t\t<td>' .$value.'</td>\n';
}
echo '\t</tr>\n';
$count++;
}
echo "</table>\n";
if ($count < 1) {
echo '<br><br>數據庫暫時沒有數據<br><br>';
} else {
echo '<br><br>表格中有' . $count . '記錄<br><br>';
}
mysql_free_result($result);
mysql_close($conn); //php引擎會幫你做可以不寫。
?>