在繼續學習的過程中，我現在正在根據上面學到的內容編寫不同的語句，但它沒有給出任何結果。Workbench 顯示查詢語句良好，結果顯示為“2”<?php$servername = "localhost";$username = "xxx";$password = "xxx";$dbname = "xxx";// Create connection$conn = new mysqli($servername, $username, $password, $dbname);// Check connectionif ($conn->connect_error) { die("Connection failed: " . $conn->connect_error);} $sql = "SELECT SUM(`mattiscool`),booking_date FROM `wp_cbxrbooking_log_manager` WHERE `booking_date` = CURDATE() -1";$result = mysqli_query($sql);while ($row = mysqli_fetch_assoc($result)){ echo $row['total'];}mysqli_close($con);?>我試圖通過 php 調用 MySQL 語句并輸出值。以下是我嘗試過的。有人可以幫助我了解我做錯了什么嗎？<?php$sql = "SELECT DAYNAME(wp_cbxrbooking_log_manager.`booking_date`) as \'weekday\', \n" . " wp_cbxrbooking_log_manager.`party_size` as \'Party Size\',\n" . " wp_cbxrbooking_log_manager.`booking_time` as \'Time\',\n" . " wp_cbxrbooking_log_manager.`mattiscool` as \'# of Reservations\'\n" . "FROM wp_cbxrbooking_log_manager\n" . "\n" . "WHERE `booking_date` >= DATE(NOW()) - INTERVAL 7 DAY \n" . "ORDER BY `Time` ASC";?>
2 回答
達令說
TA貢獻1821條經驗 獲得超6個贊
您需要執行查詢并獲取結果，如下所示：
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
? die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT DAYNAME(wp_cbxrbooking_log_manager.`booking_date`) as \'weekday\',? \n"
? ? . "? ? ? ? ? ? ? wp_cbxrbooking_log_manager.`party_size` as \'Party Size\',\n"
? ? . "? ? ? ? ? ? ? wp_cbxrbooking_log_manager.`booking_time` as \'Time\',\n"
? ? . "? ? ? ? ? ? ? wp_cbxrbooking_log_manager.`mattiscool` as \'# of Reservations\'\n"
? ? . "FROM wp_cbxrbooking_log_manager\n"
? ? . "\n"
? ? . "WHERE `booking_date` >= DATE(NOW()) - INTERVAL 7 DAY? \n"
? ? . "ORDER BY `Time`? ASC";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
? // output data of each row
? while($row = $result->fetch_assoc()) {
? ? echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
? }
} else {
? echo "0 results";
}
$conn->close();
?>
- 2 回答
- 0 關注
- 134 瀏覽
添加回答
舉報
0/150
提交
取消