PHP Mysql select to array format

Question

I am reading data from a Mysql database like this:

$result = mysqli_query($con,"SELECT * FROM myTable");

while($row = mysqli_fetch_array($result))
  {

  echo $row['field1'] . " " . $row['field2'];

  }

Instead of outputting the records like this:

 echo $row['field1'] . " " . $row['field2'];

I need to get them into the format below:

$list = array(

        array('field1'=>'something here', 'field2'=>'something else')

  );

How do I do this?

us2.php.net/manual/en/mysqli-result.fetch-array.php, there's an example of how to do exactly what you want, in the documentation for what you're using. — SubjectCurio
– SubjectCurio, Commented Apr 8, 2014 at 12:19
Don't even know what to say. What's wrong with $result[] = array('field1'=>$row['field1'], 'field2'=>$row['field2']) ? — Alma Do
– Alma Do, Commented Apr 8, 2014 at 12:20

ajtrichards · Accepted Answer · 2014-04-08 12:26:31Z

2

$result = mysqli_query($con,"SELECT * FROM myTable");

while($row = mysqli_fetch_array($result)){

  $list[] = $row;

}

edited Apr 8, 2014 at 12:26

answered Apr 8, 2014 at 12:19

ajtrichards

30.7k13 gold badges99 silver badges102 bronze badges

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

Collectives™ on Stack Overflow

PHP Mysql select to array format

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related