<?php 

  //連接參數

  $host="localhost";

  $user="root";

  $pwd="111111";

  $db="test";

  

  $linkID =mysql_connect($host,$user,$pwd); //創建一個mysql連接

  

  if(!$linkID){

  	echo "<font color='red'>unable to connect!</font>";

  }

  

  mysql_select_db($db)or die("unable to select database"); //選擇一個數據庫

  

  $SQL_SELECT_SYMBOLS="select * from symbols"; 

  

  $result=mysql_query($SQL_SELECT_SYMBOLS)or die("error in query :$query. ".mysql_errno()); //執行SQL語句

  

  if(mysql_num_rows($result)>0){

  	echo '<table cellpadding="10" border="1">';

  	echo '<tr><th>id</th><th>country</th><th>animal</th><th>cname</th></tr>';

  	 while($row=mysql_fetch_assoc($result)){

  	 	echo "<tr>";

  	 	echo "<td>".$row['id']."</td>";

  	 	echo "<td>".$row['country']."</td>";

  	    echo "<td>".$row['animal']."</td>";

  	    echo "<td>".$row['cname']."</td>";

  	 	echo "</tr>";

  	 }

  	 echo "</table>";

  }

  else{

  	echo "記錄未找到!";

  }

  

  mysql_free_result($result); //釋放記錄集所占用的內存

  

  mysql_close($linkID); //關閉數據庫連接

?>