connect_error) {
die("連線失敗: " . $connect->connect_error);
}
echo "連線成功
";
//設定連線編碼,防止中文字亂碼
$connect->query("SET NAMES 'utf8'");
//選擇資料表ian,條件是欄位id = 1的
$selectSql = "SELECT * FROM aa WHERE ID > 0";
//呼叫query方法(SQL語法)
$memberData = $connect->query($selectSql);
//有資料筆數大於0時才執行
if ($memberData->num_rows > 0) {
//讀取剛才取回的資料
while ($row = $memberData->fetch_assoc()) {
print_r($row);
echo '
';
}
} else {
echo '0筆資料';
}
//結果:Array ( [ID] => 1 [temperature] => 22 [humidity] => 83 [PM25] => 22 )