Exemple #1
0
<?php

header('content-type:text/html;charset=utf-8');
$mysqli = new mysqli('localhost', 'root', 'root', 'test');
if ($mysqli->error) {
    die('Connect Error : ' . $mysqli->error);
}
$mysqli->set_charset('UTF8');
$sql = "select id,username,age from user;";
$sql .= "select * from mysql.user;";
if ($mysqli->multi_query($sql)) {
    do {
        if ($res = $mysqli->store_results()) {
            $row[] = $res->fetch_all(MYSQLI_ASSOC);
        }
    } while ($mysqli->more_results() && $mysqli->next_result());
} else {
    echo $mysqli->error;
}
$mysqli->close();