php sql Мультизапрос
function get_sql() {
$sql = new mysqli(
'localhost',
'',
'',
''
);
if ($sql->connect_errno) {
print_r([$sql->connect_errno, $sql->connect_error]);
exit();
}
$sql->set_charset('utf8');
return $sql;
}
function query_sql_select($request) {
$result = [];
$sql = get_sql();
if ($query = $sql->multi_query($request)) {
do {
if ($res = $sql->store_result()) {
while ($array = $res->fetch_array(MYSQLI_ASSOC)) {
$result[] = $array;
}
$res->free();
}
} while ($sql->more_results() && $sql->next_result());
} else {
// Обработка ошибки SQL
print_r([$sql->errno, $sql->error]);
}
$sql->close();
return $result;
}