## MySQLi - 面向對象 ### 查詢數據 ```php $sql = "SELECT id, firstname, lastname FROM MyGuests"; $result = $conn->query($sql); if ($result->num_rows > 0) { // 輸出每行數據 while($row = $result->fetch_assoc()) { echo "<br> id: ". $row["id"]. " - Name: ". $row["firstname"]. " " . $row["lastname"]; } } else { echo "0 results"; } ``` ### 條件查詢 ```php $result = mysqli_query($con,"SELECT * FROM Persons WHERE FirstName='Peter'"); while($row = mysqli_fetch_array($result)) { echo $row['FirstName'] . " " . $row['LastName']; echo "<br>"; } ``` ## PDO ```php try { $stmt = $conn->prepare("SELECT * FROM MyGuests"); $stmt->execute(); // 設置結果集為關聯數組 $result = $stmt->setFetchMode(PDO::FETCH_ASSOC); } catch(PDOException $e) { echo "Error: " . $e->getMessage(); } ```