php範例程式碼之使用mysqli對象

標籤：

1234567891011121314151617181920212223242526272829303132333435363738394041

<?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(); //關閉資料庫連接?>

php範例程式碼之使用mysqli對象