PHP While Loop Question

Question

How can I turn the code below into a single array when its in the while loop? An example would help.

Here is my PHP code.

while($row = mysqli_fetch_array($dbc)){ 
    $category = $row['category'];
    $url = $row['url'];
}

user113292 · Accepted Answer · 2010-08-19 06:34:52Z

4

Building off mawg's solution and your new requirement:

$data = array();

while ($row = mysqli_fetch_array($dbc)) {
  $data[$row['category']] = $row['url'];
}

This would create an associative array with the category name as the key.

Or you could do:

$data = array();

while ($row = mysqli_fetch_array($dbc)) {
  $data[] = array(
    'row' => $row['url'],
    'category' => $row['category'],
  );
}

Which would create an array of associative arrays that would contain the URL and category for each row.

answered Aug 19, 2010 at 6:34

user113292

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

Comments

Mawg · Accepted Answer · 2010-08-19 06:25:16Z

1

Do you mean something like

$urls = array();
$Categories = Array();
while($row = mysqli_fetch_array($dbc)){ 
    $Categories[] = $row['category'];
    $urls[] = $row['url'];
}

answered Aug 19, 2010 at 6:25

Mawg

40.5k110 gold badges334 silver badges582 bronze badges

I want to put them all together if possible array()

Zsolti · Accepted Answer · 2010-08-19 06:34:46Z

1

Try this:

$allRows = array(); 
while($row = mysqli_fetch_array($dbc))
{  
    $allRows[] = $row;    
}

answered Aug 19, 2010 at 6:34

Zsolti

1,6271 gold badge13 silver badges22 bronze badges