//$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
$mysqli = new mysqli("Manas9", "Manas9", "Manas9237", "test");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
$query = "SELECT CURRENT_USER();";
$query .= "SELECT fname, lname FROM emp1 ORDER BY fname";
/* execute multi query */
if ($mysqli->multi_query($query)) {
do{
/* store first result set */
if ($result = $mysqli->use_result()) {
while ($row = $result->fetch_row()) {
echo("<br/>". $row[0]." ". $row[1]);
}
$result->close();
}
} while ($mysqli->next_result());
}
/* close connection */
$mysqli->close();
?>
