How to change the array key in while loop for the table on php

Question

Suppose that I have a table like this:

id     name    age   birthplace
------------------------------
1      John    28   NY
2      Marry   23   LD
3      Mohamad 34   Malaysia
...

I do while loop like this:

$query = "SELECT name, age, birthplace FROM tableName";
$result = mysqli_query($dbc, $query);
$tableRows = array();
while($rows = mysqli_fetch_array($result, MYSQLI_ASSOC)){
   $tableRows[] = $rows; 
}

echo '<pre>';
print_r($tableRows);//Print the table rows from array
echo '</pre>';

I've got:

Array
(
[0] => Array
    (
        [name] => John
        [age] => 28
        [birthplace] =>  NY

    )

[1] => Array
    (
        [name] => Marry
        [age] => 23
        [birthplace] =>  Prozent Rabatt
    )

[2] => Array
    (
        [name] => 45521
        [age] => Bekleidung
        [birthplace] =>  LD
    )

[3] => Array
    (
        [name] => Mohamad
        [age] => 34
        [birthplace] =>  Malaysia 
    )
)

I would like to change the keys name, age, birthplace to 0, 1, 2 respectively.

I have read this link: In PHP, how do you change the key of an array element? But it seems that I do not need it as the function because it looks so advanced to me.

I also read this link: PHP rename array keys in multidimensional array But it just meant to change one key in one array only as I tested for my case.

Your help is appreciated. Thanks,

sachin kumara liyanage · Accepted Answer · 2020-05-26T04:29:54.140

1

using MYSQLI_ASSOC its return associative array if you replace it with MYSQLI_NUM in mysqli_fetch_array() it will return a result as you ask

$query = "SELECT name, age, birthplace FROM tableName";
$result = mysqli_query($dbc, $query);
$tableRows = array();
while($rows = mysqli_fetch_array($result,MYSQLI_NUM)){
   $tableRows[] = $rows; 
}

echo '<pre>';
print_r($tableRows);//Print the table rows from array
echo '</pre>';

edited May 26 '20 at 04:29

answered May 26 '20 at 04:14

sachin kumara liyanage

514
5
11

Oh, it returns `Array ( [0] => Array ( [0] => John [name] => John [1] => 28 [age] => 28 ) ... )`. That means each key is printed twice within its array. Any suggestion? – Phuong Ng May 26 '20 at 04:21
check it with MYSQLI_NUM. I also fix it in my answer – sachin kumara liyanage May 26 '20 at 04:30
It throws an error like this `Undefined index: name`. – Phuong Ng May 26 '20 at 04:38
It works for me. is this your full code. if this is your full code try SQL query with SQL server because query can't find collum as a name it throws error like this – sachin kumara liyanage May 26 '20 at 04:50
1

ref: https://stackoverflow.com/questions/1684993/what-does-mysqli-num-mean-and-do – sachin kumara liyanage May 26 '20 at 05:30

How to change the array key in while loop for the table on php

1 Answers1