Edit Report a Bug

    mysqli::next_result

    mysqli_next_result

    (PHP 5, PHP 7, PHP 8)

    mysqli::next_result -- mysqli_next_result — Bereitet das nächste Ergebnis von multi_query vor

    Beschreibung

    Objektorientierter Stil

    public mysqli::next_result(): bool

    Prozeduraler Stil

    mysqli_next_result(mysqli $mysql): bool

    Bereitet die nächste Ergebnismenge aus einem vorherigen Aufruf von mysqli_multi_query() vor, die dann durch die Funktionen mysqli_store_result() oder mysqli_use_result() abgerufen werden kann.

    Parameter-Liste

    mysql

    Nur bei prozeduralem Aufruf: ein von mysqli_connect() oder mysqli_init() zurückgegebenes mysqli-Objekt.

    Rückgabewerte

    Gibt bei Erfolg true zurück. Bei einem Fehler wird false zurückgegeben. Gibt im Gegensatz zu mysqli_more_results() auch false zurück, wenn die nächste Anweisung zu einem Fehler führte.

    Fehler/Exceptions

    If mysqli error reporting is enabled (MYSQLI_REPORT_ERROR) and the requested operation fails, a warning is generated. If, in addition, the mode is set to MYSQLI_REPORT_STRICT, a mysqli_sql_exception is thrown instead.

    Beispiele

    Siehe mysqli_multi_query().

    Siehe auch

    add a note add a note

    User Contributed Notes 2 notes

    up
    3
    admin at travian-utils dot com
    15 years ago
    Stored procedures few rowset example:

    some_file.php
    <?php
    function proc() {
      global     $global;
          $db_connect_list = array('site');
          SQLinit($db_connect_list);
      if(isset(    $global['error'])){return;}
          SQL('CALL `procedure`();');
      while(    $row=mysqli_fetch_assoc($global['result'])){
            // do some
          }
          SQLnext();
      while(    $row=mysqli_fetch_assoc($global['result'])){
            // do some
          }
          SQLnext();
      while(    $row=mysqli_fetch_assoc($global['result'])){
            // do some
          }
          SQLclose($db_connect_list);
    }
    ?>

    config.php
    <?php
      $global    ['sys']['db']['site'] = array('host'=>'localhost', 'user'=>'site', 'pass'=>'');
    ?>

    engine.php
    <?php
    function SQLinit($array_list){
      global     $global;
      foreach(    $array_list as $set){
        if(!    $global['sys']['db'][$set]['connect'] = mysqli_connect(
                $global['sys']['db'][$set]['host'],
                $global['sys']['db'][$set]['user'],
                $global['sys']['db'][$set]['pass'])){
              $global['error']['code'] = 500;
              $global['error']['text'] = 'Database not avaliable';
              $w=fopen('error.log','a+');
              fwrite($w,'time: '.date('Y M d H:i:s')."\r\n");
              fwrite($w,'errno: '.mysqli_connect_errno()."\r\n");
              fwrite($w,'error: '.mysqli_connect_error()."\r\n");
              fclose($w);
          return;
        }
        if(!isset(    $global['sys']['default_connect']))
              $global['sys']['default_connect'] = $global['sys']['db'][$set]['connect'];
            SQL('SET NAMES \'utf8\' COLLATE \'utf8_unicode_ci\';', $global['sys']['db'][$set]['connect']);
            SQL('SET CHARACTER SET \'utf8\';', $global['sys']['db'][$set]['connect']);
            SQL('SET character_set_connection = \'utf8\';', $global['sys']['db'][$set]['connect']);
      }
    }
    function     mTime(){
      list(    $usec, $sec) = explode(" ", microtime());
      return ((float)    $usec+(float)$sec);
    }
    function     SQL($sql, $connect = -1){
      global     $global;
      if(    $connect === -1)$connect = $global['sys']['default_connect'];
      if(isset(    $global['error']['sql']))return;
      while (    $connect->next_result()) $connect->store_result();
          $begin=mTime();
          $global['result']=mysqli_query($connect, $sql);
          $end=mTime();
          $global['sys']['time_sql']+=$end-$begin;
          $error=mysqli_error($connect);
      if(    $error!=''){
            $global['error']['code'] = 502;
            $global['error']['text'] = 'SQL error';
            $global['error']['sql'] = true;
            $w=fopen('error.log','a+');
            fwrite($w,'time: '.date('Y M d H:i:s')."\r\n");
            fwrite($w,'errno: '.mysqli_errno($connect)."\r\n");
            fwrite($w,'error: '.$error."\r\n");
            fwrite($w,'sql: '.$sql."\r\n");
            fclose($w);
      }else{
            $w=fopen('sql.log','a+');
            fwrite($w,'time: '.date('Y M d H:i:s')."\r\n");
            fwrite($w,'sql: '.$sql."\r\n");
            fclose($w);
      }
    }

    function     SQLnext($connect = -1){
      global     $global;
      if(    $connect === -1)$connect = $global['sys']['default_connect'];
      if(isset(    $global['error']['sql']))return;
          $connect->next_result();
          $global['result'] = $connect->store_result();
    }

    function     SQLclose($array_list){
      global     $global;
      foreach(    $array_list as $set){
            mysqli_close($global['sys']['db'][$set]['connect']);
      }
    }
    ?>
    up
    0
    pawel dot barcik at gmail dot com
    16 years ago
    this function returns FALSE when you have an error in your syntax in one of your queries, so be carefull with this type of construction when tracking errors:

    <?php

    //error in the second sub query 
    $result = $db->multi_query("select * from news; seleeeeeeect id from news; update news set title='new title' where id= 12 ");

    //code inside object class
    $this->_db = new Mysqli($host, $user, $password, $database, $port, $socket);
           
    do {
            $result = $this->_db->store_result();
            $this->_resultMulti[] = $result;
            $this->_errnoMulti[] = $this->_db->errno;

        if(    is_object($result)) {
                $result->free_result();
        }
                   
    } while(    $this->_db->next_result());

    ?>

    in this construction all you have in the $this->_errnoMulti is :

    array(1) {
      [0]=>
      int(0)
    }

    which means that there are no errors if you are not checking how many queries are executed!
    add a note add a note
    To Top