php操作mysql前処理(未完了続行)

     PHP     ,          

$host = 'localhost';

$user = 'root';

$password = '';

$dbname = 'cmstop';

$mysqli = new mysqli($host, $user, $password, $dbname) or exit('     mysql:'.$mysqli->connect_error);



 $sql  = "SELECT CURRENT_USER(); SELECT * FROM `db_setting` LIMIT 5;";



if ($mysqli->multi_query($sql)){//    

    do{

        if($result = $mysqli->store_result()){//        ,           

            while($row = $result->fetch_row()){//     

                echo $row[0];

            }

            $result->free();//          ,  

        }

        if($mysqli->more_results()){//         ,      

            echo "<hr />";

        }

    }while($mysqli->next_result());

} 





//   

$sql = "SELECT `app`,`var` FROM `db_setting` WHERE `app`=? LIMIT 5";

$app = 'article';

$stmt = $mysqli->stmt_init();

if($stmt->prepare($sql)) {

    $stmt->bind_param("s", $app);

    $stmt->execute();//    

    

    $stmt->bind_result($field1, $field2); //          

    while ($stmt->fetch()) {

        echo '<br/>', $field1,' => ', $field2;

    }

    echo'<hr/>';

    

    $app = 'guestbook';

    $stmt->execute();//    

    $result = $stmt->get_result(); //          

    while ($row = $result->fetch_array(MYSQLI_NUM)){

        echo $row[0],' => ',$row[1];

    }

    

    $stmt->close();

}

$mysqli->close();