Create an multidimensional array from the returned datas from a SQL query

Question

I've a query to fetch datas from a database:

$query = $pdo->prepare('SELECT AVA_Id, AVA_RoomId, AVA_Date, AVA_Status FROM ___Table');
$query->execute();

I'm using this to put all the datas into an array:

while ($fetch = $query->fetch(PDO::FETCH_ASSOC)) {
    $array[] = [
        'AVA_Id' => $fetch['AVA_Id'],
        'AVA_RoomId' => $fetch['AVA_RoomId'],
        'AVA_Date' => $fetch['AVA_Date'],
        'AVA_Status' => $fetch['AVA_Status']
    ];
}

Witch give me the following array:

Array
(
    [0] => Array
        (
            [AVA_Id] => 1
            [AVA_RoomId] => 47
            [AVA_Date] => 2019-02-24
            [AVA_Status] => Open
        )
    [1] => Array
        (
            [AVA_Id] => 2
            [AVA_RoomId] => 48
            [AVA_Date] => 2019-02-26
            [AVA_Status] => Open
        )
)

But how can I return result into a more complex array like this:

Array
(
    [47] => Array
        (
            [2019-02-24] => Array
                (
                    [AVA_Id] => 1
                    [AVA_Status] => Open
                )
        )
    [48] => Array
        (
            [2019-02-26] => Array
                (
                    [AVA_Id] => 2
                    [AVA_Status] => Open
                )

        )
)

trincot · Accepted Answer · 2019-02-24 21:50:50Z

1

You could do that as follows:

while ($fetch = $query->fetch(PDO::FETCH_ASSOC)) {
    $array[$fetch['AVA_RoomId']][$fetch['AVA_Date']][] = [
        'AVA_Id' => $fetch['AVA_Id'],
        'AVA_Status' => $fetch['AVA_Status']
    ];
}

answered Feb 24, 2019 at 21:50

trincot

357k38 gold badges282 silver badges338 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rohit Mittal · Accepted Answer · 2019-02-24 21:51:49Z

0

Use below code:

while ($fetch = $query->fetch(PDO::FETCH_ASSOC)) {
    $array[$fetch['AVA_RoomId']] = [
        $fetch['AVA_Date'] => [
            'AVA_Id' => $fetch['AVA_Id'],
            'AVA_Status' => $fetch['AVA_Status']
        ]
    ];
}

Hope it helps you.

answered Feb 24, 2019 at 21:51

Rohit Mittal

2,1142 gold badges12 silver badges21 bronze badges

Collectives™ on Stack Overflow

Create an multidimensional array from the returned datas from a SQL query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related