<?php//連接代碼如下$servername = "localhost";$username = "root";$password = "pwdpdd!";$dbname = "color";$conn = null;try {$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);//echo "連接成功";// 設置 PDO 錯誤模式為異常$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);$conn->exec("SET NAMES utf8");$conn->exec("SET character_set_server=utf8");}catch(PDOException $e){//echo $e->getMessage();}?><?php //以下為讀取代碼$stmt = null;try {$sql = "SELECT COUNT(*) AS total FROM colours";$stmt = $conn->prepare($sql);$stmt->execute();$stmt->setFetchMode(PDO::FETCH_ASSOC);while ($row = $stmt->fetch()) //如果表里沒有記錄，這句會報錯{……}}catch(PDOException $e){//echo $e->getMessage();}?>