database鏈接檢測 ``` <?php $dbhost = 'localhost'; // mysql服務器主機地址 $dbuser = 'root'; // mysql用戶名 $dbpass = '123456'; // mysql用戶名密碼 $conn = mysqli_connect($dbhost, $dbuser, $dbpass); if(! $conn ) { die('Could not connect: ' . mysqli_error()); } echo '數據庫連接成功！'; mysqli_close($conn); ``` SQL查詢 ``` <?php $dbhost = 'localhost:3306'; // mysql服務器主機地址 $dbuser = 'root'; // mysql用戶名 $dbpass = '123456'; // mysql用戶名密碼 $conn = mysqli_connect($dbhost, $dbuser, $dbpass); if(! $conn ) { die('連接失敗: ' . mysqli_error($conn)); } // 設置編碼，防止中文亂碼 mysqli_query($conn , "set names utf8"); echo '數據庫連接成功！'; $sql = 'SELECT username, email FROM users'; mysqli_select_db( $conn, 'test' ); $retval = mysqli_query( $conn, $sql ); if(! $retval ) { die('無法讀取數據: ' . mysqli_error($conn)); } echo '<h2>mysqli_fetch_array demo<h2>'; echo '<table border="1"><tr><td>Username</td><td>email</td></tr>'; while($row = mysqli_fetch_array($retval, MYSQLI_ASSOC)) { echo "<tr><td> {$row['username']}</td> ". "<td>{$row['email']} </td> ". "</tr>"; } echo '</table>'; mysqli_close($conn); ```