Create a php array with keys and values from mysql query

Question

I'm trying to store my mysql query in an array like this :

$arr = array ( "field1"=>"value" , "field2"=>"value" , "field3"=>"value" , ... );

I've tried this but don't work like I need :

$row_selectProduct = array();
$sResult = $db->query( 'SELECT * FROM tbl' )    

while ( $aRow = $sResult->fetch_assoc() )
{
        $sInfo = $sResult->fetch_field();
        // General output
        $row_selectProduct[ $sInfo->name ] = $aRow;
}

$sResult->close();

Thx for help

EDIT : Sorry for misunderstanding... I'd like to name keys by the field name in database. I try to reproduce this :

$result = array();

while ($row_selectProduct = mysql_fetch_assoc($selectProduct));
{

    $row_array= array();

$row_array['field_name1_In_DB'] = $row_selectProduct['field_name1_In_DB'];
$row_array['field_name2_In_DB'] = $row_selectProduct['field_name2_In_DB'];
$row_array['field_name3_In_DB'] = $row_selectProduct['field_name3_In_DB'];
$row_array['field_name4_In_DB'] = $row_selectProduct['field_name4_In_DB'];
$row_array['field_name5_In_DB'] = $row_selectProduct['field_name5_In_DB'];
...

array_push($result,$row_array);

};

don't work like i need doesn't tell much. What's the current result? — Ofir Baruch
– Ofir Baruch, Commented May 23, 2013 at 16:12
Is that example supposed to be one row or several rows? Isn't $aRow already in the format you want? — deceze
– deceze ♦, Commented May 23, 2013 at 16:16
@deceze SELECT * FROM tbl will definitly result in several rows — steven
– steven, Commented May 23, 2013 at 16:20
@MrSo If it's the current result - you've got what you want. What's the problem? — Ofir Baruch
– Ofir Baruch, Commented May 23, 2013 at 16:20
@steven Not if there's only one row. ;-P $arr Seems to be only one row though, so if that's the desired output the question makes no sense. Well, it doesn't either way. — deceze
– deceze ♦, Commented May 23, 2013 at 16:21

Zamphatta · Accepted Answer · 2013-05-28 01:29:46Z

1

Using PDO connection functions, it's quite simple --

foreach($db->query('SELECT field_name1,field_name2 FROM table') as $row) {
    echo $row['field_name1'].' '.$row['field_name2']; //etc...
}

Here's a good tutorial for PDO in PHP if you want more.

answered May 28, 2013 at 1:29

Zamphatta

4,7548 gold badges32 silver badges34 bronze badges

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

Comments

steven · Accepted Answer · 2013-05-23 16:31:02Z

0

while ( $aRow = $sResult->fetch_assoc() )
{
        foreach($aRow as $fieldname => $fieldvalue) {
             $row_selectProduct[$fieldname] = $fieldvalue;   
        }

}

but you will overwrite your $row_selectedProduct with every record and the var at the end will only have stored the last record

if you would like to have all results in one array you should:

$results = array();
while ( $aRow = $sResult->fetch_assoc() )
{
        $results[] = $aRow;

}

if you know that there will be only one result you need only:

$result = $sResult->fetch_assoc();

edited May 23, 2013 at 16:31

answered May 23, 2013 at 16:16

steven

4,8952 gold badges31 silver badges61 bronze badges

3 Comments

deceze Over a year ago

The inner loop is completely superfluous.

Marc B Over a year ago

$rowSelectProduct[] = $aRow;.. no need to waste a bunch of cpu cycles looping over the result row array when you can simply assign the entire array.

steven Over a year ago

yes I know but i want to make it clear what would be the right syntax.

Collectives™ on Stack Overflow

Create a php array with keys and values from mysql query

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related