Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
<?php
$stmt_ch = $mysqli->prepare("SELECT * FROM sakila.actor limit 10");
$stmt_ch->execute();
$result_ch = $stmt_ch->get_result();
$stmt_ch2 = $mysqli->prepare("SELECT * FROM sakila.actor limit 10,10");
$stmt_ch2->execute();
$result_ch2 = $stmt_ch2->get_result();
$result_ch_com = array_merge(
mysqli_fetch_all($result_ch, MYSQLI_NUM),
mysqli_fetch_all($result_ch2, MYSQLI_NUM)
);
print_r($result_ch_com);