Generating a php array from mysql and want to use ID from db as array keys

Question

The current output is..

Array
(
    [0] => Array
        (
            [ID] => 20
            [name] => Peter
            [datetime] => Tuesday 26th Oct 21 3:50am
        )

    [1] => Array
        (
            [ID] => 21
            [name] => Paul
            [datetime] => Tuesday 26th Oct 21 4:44am
        )
)

I would like the array output to be..

Array
(
    [20] => Array
        (
            [ID] => 20
            [name] => Peter
            [datetime] => Tuesday 26th Oct 21 3:50am
        )

    [21] => Array
        (
            [ID] => 21
            [name] => Paul
            [datetime] => Tuesday 26th Oct 21 4:44am
        )
)

The code I am currently using to generate the array is..

$sql=mysqli_query($conn,"SELECT * FROM `live`");
    /*every time it fetches the row, adds it to array...*/
    while($liveuserdata[]=mysqli_fetch_array($sql, MYSQLI_ASSOC));

I can't show you what i've tried as I don't know where to begin dispite several rephrased searches :-/

You can also look into using PDO with the fetch mode PDO::FETCH_UNIQUE. The benefit with PDO is not only that it's an abstraction layer (you can swap database engines by changing the connection), it also have a clearer and easier API and it has all kinds of nifty fetch modes — M. Eriksson
– M. Eriksson, Commented Oct 28, 2021 at 14:48

u_mulder · Accepted Answer · 2021-10-28 14:44:46Z

5

It is as simple as:

$sql = mysqli_query($conn,"SELECT * FROM `live`");
$liveuserdata = [];
while ($row = mysqli_fetch_array($sql, MYSQLI_ASSOC)) {
    $liveuserdata[$row['ID']] = $row;
}

answered Oct 28, 2021 at 14:44

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

Generating a php array from mysql and want to use ID from db as array keys

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related