$result = $conn->query("SELECT * FROM head, body");
while ($row = $result->fetch_assoc()) {
$arr['head'][] = $row['head'];
$arr['body'][] = $row['body'];
}$result = $conn->query('
(
select id, name, "head" as table_name
from head
) union (
select id, name, "body" as table_name
from body
)
');
while ($row = $result->fetch_assoc()) {
$tableName = $row['table_name'];
unset($row['table_name']);
$arr[$tableName][] = $row;
}
$result->free();$result = $conn->query("SELECT t1.id as id1, t1.name as name1, t2.id as id2, t2.name as name2
FROM head t1, body t2");
while ($row = $result->fetch_assoc()) {
$arr['head'][] = $row['id1'] . $row[name1'] ;
$arr['body'][] = $row['id2'] . $row[name2'] ;
}
Простой
Средний
Простой
Простой