亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

為了賬號安全,請及時綁定郵箱和手機立即綁定
已解決430363個問題,去搜搜看,總會有你想問的

我如何將 mysqli_expects 參數 1 修復為給定的 mysqli_result 字符串

我如何將 mysqli_expects 參數 1 修復為給定的 mysqli_result 字符串

PHP
蕭十郎 2023-07-21 18:25:38
當我嘗試執行查詢并獲取行數時,會生成錯誤。我已經嘗試解決這個問題好幾天了,而且我是 php 新手,所以它可能甚至不是語法問題。  <?php  // error_reporting(0);  $flying_from = "";  $flying_to = "";  $departure_date = "";  $return_date = "";  $number_of_adults = "";  $number_of_children = "";  $flight_class = "";  // Connect to database  $conn = mysqli_connect('localhost', 'presh', '1234', 'saffron');  if (isset($_GET['submit'])) {    $flying_from = $_GET['flying_from'];    $flying_to = $_GET['flying_to'];    $departure_date = $_GET['departure_date'];    $return_date = $_GET['return_date'];    $number_of_adults = $_GET['number_of_adults'];    $number_of_children = $_GET['number_of_children'];    $flight_class = $_GET['flight_class'];    $query = "SELECT * FROM flights WHERE flying_from LIKE $flying_from AND flying_to LIKE $flying_to AND departure_date LIKE $departure_date AND return_date LIKE $return_date AND    number_of_adults LIKE $number_of_adults AND number_of_children LIKE $number_of_children AND flight_class LIKE $flight_class";    $result = mysqli_query($conn,$query);    $count = mysqli_num_rows($result);    if($count > 0){        $output = 'There was no search results';    }else{      while ($row = mysqli_fetch_array($query)) {        $fFrom = $row['flying_from'];        $fTo = $row['flying_to'];        $dDate = $row['departure_date'];        $rDate = $row['return_date'];        $nAdults = $row['number_of_adults'];        $nChildren = $row['number_of_children'];        $fClass = $row['flight_class'];        $output .= '<div>'.$fFrom.' '.$fTo. ' '.$dDate.' '.$rDate.' '.$nAdults.' '.$nChildren.' '.$fClass.'</div>';    }  }}?>
查看完整描述

1 回答

?
寶慕林4294392

TA貢獻2021條經驗 獲得超8個贊

您需要傳遞的$result變量$query不在mysqli_fetch_array()

while ($row = mysqli_fetch_array($result)) {

}


查看完整回答
反對 回復 2023-07-21
  • 1 回答
  • 0 關注
  • 172 瀏覽

添加回答

舉報

0/150
提交
取消
微信客服

購課補貼
聯系客服咨詢優惠詳情

幫助反饋 APP下載

慕課網APP
您的移動學習伙伴

公眾號

掃描二維碼
關注慕課網微信公眾號