• <tfoot id='Y3Wz2'></tfoot>
  • <i id='Y3Wz2'><tr id='Y3Wz2'><dt id='Y3Wz2'><q id='Y3Wz2'><span id='Y3Wz2'><b id='Y3Wz2'><form id='Y3Wz2'><ins id='Y3Wz2'></ins><ul id='Y3Wz2'></ul><sub id='Y3Wz2'></sub></form><legend id='Y3Wz2'></legend><bdo id='Y3Wz2'><pre id='Y3Wz2'><center id='Y3Wz2'></center></pre></bdo></b><th id='Y3Wz2'></th></span></q></dt></tr></i><div id='Y3Wz2'><tfoot id='Y3Wz2'></tfoot><dl id='Y3Wz2'><fieldset id='Y3Wz2'></fieldset></dl></div>

        <small id='Y3Wz2'></small><noframes id='Y3Wz2'>

        • <bdo id='Y3Wz2'></bdo><ul id='Y3Wz2'></ul>
      1. <legend id='Y3Wz2'><style id='Y3Wz2'><dir id='Y3Wz2'><q id='Y3Wz2'></q></dir></style></legend>

        PHP 错误 ->警告:mysqli_stmt::execute(): 无法获取 m

        时间:2023-07-29

            <i id='jckdu'><tr id='jckdu'><dt id='jckdu'><q id='jckdu'><span id='jckdu'><b id='jckdu'><form id='jckdu'><ins id='jckdu'></ins><ul id='jckdu'></ul><sub id='jckdu'></sub></form><legend id='jckdu'></legend><bdo id='jckdu'><pre id='jckdu'><center id='jckdu'></center></pre></bdo></b><th id='jckdu'></th></span></q></dt></tr></i><div id='jckdu'><tfoot id='jckdu'></tfoot><dl id='jckdu'><fieldset id='jckdu'></fieldset></dl></div>
            <legend id='jckdu'><style id='jckdu'><dir id='jckdu'><q id='jckdu'></q></dir></style></legend>

              <tbody id='jckdu'></tbody>

              <small id='jckdu'></small><noframes id='jckdu'>

                <bdo id='jckdu'></bdo><ul id='jckdu'></ul>
                <tfoot id='jckdu'></tfoot>

                  本文介绍了PHP 错误 ->警告:mysqli_stmt::execute(): 无法获取 mysqli_stmt |警告:mysqli_stmt::close()的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

                  问题描述

                  我在尝试修改某些表时不断收到此错误.这是我的代码:

                  I keep getting this error while trying to modify some tables. Here's my code:

                  /**  <- line 320
                   *
                   * @param array $guests_array
                   * @param array $tickets_array
                   * @param integer $seat_count
                   * @param integer $order_count
                   * @param integer $guest_count
                   */
                  private function book_guests($guests_array, $tickets_array, &$seat_count, 
                          &$order_count, &$guest_count){
                  /* @var $guests_array ArrayObject */
                      $sucess = false;
                      if(sizeof($guests_array) >= 1){
                          //$this->mysqli->autocommit(FALSE);
                          //insert the guests into guest, person, order, seat
                          $menu_stmt = $this->mysqli->prepare("SELECT id FROM menu WHERE
                                      name=?");
                          $menu_stmt->bind_param('s',$menu);
                          //$menu_stmt->bind_result($menu_id);
                  
                          $table_stmt = $this->mysqli->prepare("SELECT id FROM tables WHERE
                                      name=?");
                          $table_stmt->bind_param('s',$table);
                          //$table_stmt->bind_result($table_id);
                  
                          $seat_stmt = $this->mysqli->prepare("SELECT id FROM seat WHERE
                                      name=? AND table_id=?");
                          $seat_stmt->bind_param('ss',$seat, $table_id);
                          //$seat_stmt->bind_result($seat_id);
                          for($i=0;$i<sizeof($guests_array);$i++){
                  
                              $menu = $guests_array[$i]['menu'];
                              $table = $guests_array[$i]['table'];
                              $seat = $guests_array[$i]['seat'];
                  
                              //get menu id
                              if($menu_stmt->execute()){
                                  $menu_stmt->bind_result($menu_id);
                                  while($menu_stmt->fetch())
                                          ;
                              }
                              $menu_stmt->close();
                  
                              //get table id
                              if($table_stmt->execute()){
                                  $table_stmt->bind_result($table_id);
                                  while($table_stmt->fetch())
                                          ;
                              }
                              $table_stmt->close();
                  
                              //get seat id
                              if($seat_stmt->execute()){
                                  $seat_stmt->bind_result($seat_id);
                                  while($seat_stmt->fetch())
                                          ;
                              }
                              $seat_stmt->close();
                  
                              $dob = $this->create_date($guests_array[$i]['dob_day'],
                                      $guests_array[$i]['dob_month'],
                                      $guests_array[$i]['dob_year']);
                              $id = $this->add_person($guests_array[$i]['first_name'],
                                      $guests_array[$i]['surname'], $dob,
                                      $guests_array[$i]['sex']);
                  
                              if(is_string($id)){
                                  $seat = $this->add_seat($table_id, $seat_id, $id);
                                  /* @var $tickets_array ArrayObject */
                                  $guest = $this->add_guest($id,$tickets_array[$i+1],$menu_id,
                                          $this->volunteer_id);
                                  /* @var $order integer */
                                  $order = $this->add_order($this->volunteer_id, $table_id,
                                          $seat_id, $id);
                  
                                  if($guest == 1 && $seat == 1 && $order == 1){
                                      $seat_count += $seat;
                                      $guest_count += $guest;
                                      $order_count += $order;
                  
                                      $success = true;
                                  }
                              }
                          }
                      }
                      return $success;
                  } <- line 406
                  

                  以下是警告:

                  The person PRSN10500000LZPH has been added to the guest tablePRSN10500000LZPH added to table (1), seat (1)The order for person(PRSN10500000LZPH) is registered with volunteer (PRSN10500000LZPH) at table (1) and seat (1)PRSN10600000LZPH added to table (1), seat (13)The person PRSN10600000LZPH has been added to the guest tableThe order for person(PRSN10600000LZPH) is registered with volunteer (PRSN10500000LZPH) at table (1) and seat (13) Warning: mysqli_stmt::execute(): Couldn't fetch mysqli_stmt in /Users/olatunjigbadamosi/Sites/ST_Ambulance/FormDB.php on line 358 Warning: mysqli_stmt::close(): Couldn't fetch mysqli_stmt in /Users/olatunjigbadamosi/Sites/ST_Ambulance/FormDB.php on line 363 Warning: mysqli_stmt::execute(): Couldn't fetch mysqli_stmt in /Users/olatunjigbadamosi/Sites/ST_Ambulance/FormDB.php on line 366 Warning: mysqli_stmt::close(): Couldn't fetch mysqli_stmt in /Users/olatunjigbadamosi/Sites/ST_Ambulance/FormDB.php on line 371 Warning: mysqli_stmt::execute(): Couldn't fetch mysqli_stmt in /Users/olatunjigbadamosi/Sites/ST_Ambulance/FormDB.php on line 374 Warning: mysqli_stmt::close(): Couldn't fetch mysqli_stmt in /Users/olatunjigbadamosi/Sites/ST_Ambulance/FormDB.php on line 379 PRSN10700000LZPH added to table (1), seat (13)The person PRSN10700000LZPH has been added to the guest tableThe order for person(PRSN10700000LZPH) is registered with volunteer (PRSN10500000LZPH) at table (1) and seat (13) Warning: mysqli_stmt::execute(): Couldn't fetch mysqli_stmt in /Users/olatunjigbadamosi/Sites/ST_Ambulance/FormDB.php on line 358 Warning: mysqli_stmt::close(): Couldn't fetch mysqli_stmt in /Users/olatunjigbadamosi/Sites/ST_Ambulance/FormDB.php on line 363 Warning: mysqli_stmt::execute(): Couldn't fetch mysqli_stmt in /Users/olatunjigbadamosi/Sites/ST_Ambulance/FormDB.php on line 366 Warning: mysqli_stmt::close(): Couldn't fetch mysqli_stmt in /Users/olatunjigbadamosi/Sites/ST_Ambulance/FormDB.php on line 371 Warning: mysqli_stmt::execute(): Couldn't fetch mysqli_stmt in /Users/olatunjigbadamosi/Sites/ST_Ambulance/FormDB.php on line 374 Warning: mysqli_stmt::close(): Couldn't fetch mysqli_stmt in /Users/olatunjigbadamosi/Sites/ST_Ambulance/FormDB.php on line 379 PRSN10800000LZPH added to table (1), seat (13)The person PRSN10800000LZPH has been added to the guest tableThe order for person(PRSN10800000LZPH) is registered with volunteer (PRSN10500000LZPH) at table (1) and seat (13)
                  

                  推荐答案

                  我不认为这样会起作用.当您关闭语句(例如 $menu_stmt->close();)时,您也会释放语句句柄.因此,第二次循环时,您将无法再使用准备好的语句.

                  I don't think it will work this way. When you close the statement (e.g. $menu_stmt->close();) you also deallocate the statement handle. So the second time through the loop you don't have the prepared statements available to work with anymore.

                  在循环执行完毕后尝试关闭语句.

                  Try closing the statements after the loop has finished executing.

                  这篇关于PHP 错误 ->警告:mysqli_stmt::execute(): 无法获取 mysqli_stmt |警告:mysqli_stmt::close()的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持html5模板网!

                  上一篇:CodeIgniter 从 mysql 切换驱动程序 -->mysqli 下一篇:mysqli_insert_id:如果有人在我调用它之前插入另一行

                  相关文章

                  最新文章

                1. <small id='Z8hTS'></small><noframes id='Z8hTS'>

                  <tfoot id='Z8hTS'></tfoot>

                      <legend id='Z8hTS'><style id='Z8hTS'><dir id='Z8hTS'><q id='Z8hTS'></q></dir></style></legend>
                        <bdo id='Z8hTS'></bdo><ul id='Z8hTS'></ul>
                    1. <i id='Z8hTS'><tr id='Z8hTS'><dt id='Z8hTS'><q id='Z8hTS'><span id='Z8hTS'><b id='Z8hTS'><form id='Z8hTS'><ins id='Z8hTS'></ins><ul id='Z8hTS'></ul><sub id='Z8hTS'></sub></form><legend id='Z8hTS'></legend><bdo id='Z8hTS'><pre id='Z8hTS'><center id='Z8hTS'></center></pre></bdo></b><th id='Z8hTS'></th></span></q></dt></tr></i><div id='Z8hTS'><tfoot id='Z8hTS'></tfoot><dl id='Z8hTS'><fieldset id='Z8hTS'></fieldset></dl></div>