쿼리 데이터를 두 개의 다른 배열에 넣은 다음 두 테이블에 에코하는 방법은 무엇입니까?

검색어는 다음 위치에 있어야합니다 UNION.

Select men.Name, men.age, men.city, men.country, 'Male' as 'gender' FROM men_table as men UNION ALL Select women.Name, women.age, women.city, women.country, 'Female' as 'gender FROM women_table as women;

따라서 쿼리 출력을 얻을 수 있습니다.

|Name   |age    |city   |country|gender|
----------------------------------------
|male1  |21     |NY     |USA    |Male  |
|male2  |23     |CLV    |USA    |Male  |
|female1|25     |GS     |USA    |Female|
|female2|27     |CHG    |USA    |Female|

그 후에 결과를 반복 할 수 있습니다.

<?php 

$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

/* check connection */
if ($mysqli->connect_errno) {
    printf("Connect failed: %s\n", $mysqli->connect_error);
    exit();
}
    $query = "Select men.Name, men.age, men.city, men.country, 'Male' as 'gender' FROM men_table as men UNION ALL Select women.Name, women.age, women.city, women.country, 'Female' as 'gender FROM women_table as women";

    $men = array();
    $women = array;

    if ($result = $mysqli->query($query)) {

        /* fetch associative array */
        while ($row = $result->fetch_assoc()) {
            if($row["gender"] == 'Male') {
                $men[] = $row[];
            }
            else {
                $women[] = $row[];
            }
        }

        print_r($men);
        print_r($women);

        /* free result set */
        $result->free();
    }

/* close connection */
$mysqli->close();
?>

출력은 다음과 같습니다.

//$men array
    array(
        [0] => array(
                'Name' => 'male1', 
                'age' => '21', 
                'city' => 'NY', 
                'country' => 'USA', 
                'gender' => 'Male'
        ),
        [1] => array(
                'Name' => 'male2', 
                'age' => '23', 
                'city' => 'CLV', 
                'country' => 'USA', 
                'gender' => 'Male'
        )
    );

//$women array
    array(
        [0] => array(
                'Name' => 'female1', 
                'age' => '25', 
                'city' => 'GS', 
                'country' => 'USA', 
                'gender' => 'Female'
        ),
        [1] => array(
                'Name' => 'female2', 
                'age' => '27', 
                'city' => 'CHG', 
                'country' => 'USA', 
                'gender' => 'Female'
        )
    );