<?php 

  //連接參數

  $host="localhost";

  $user="root";

  $pwd="111111";

  $db="test";

  

  $mysqli =new mysqli($host,$user,$pwd,$db); //實例化一個mysqli對象,并打開一個連接

  

  if(mysqli_connect_errno()){ //檢查是否可以正確打開數據庫

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

  }

  

  $SQL_SELECT_SYMBOLS="select * from symbols"; 

  

  if($result=$mysqli->query($SQL_SELECT_SYMBOLS)){

  	 if($result->num_rows>0){

  	 	

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

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

  	    while($arr=$result->fetch_array()){

	  	 	echo "<tr>";

	  	 	echo "<td>".$arr[0]."</td>";

	  	 	echo "<td>".$arr[1]."</td>";

	  	    echo "<td>".$arr[2]."</td>";

	  	    echo "<td>".$arr[3]."</td>";

	  	 	echo "</tr>";

  	    }

  	     echo "</table>";	

    }

   else{

  	echo "記錄未找到!";

   }

  

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

  }

  else{

  	echo "error in query:$query.".$mysqli->error;

  }

  $mysqli->close(); //關閉數據庫連接

?>