PHP Create new array per row of MYSQL Info, and store the arrays in a array

Question

Don't ask me why I need it, I've tried to find it on the web and have failed. I need it to find rows of info on my database and per row it creates a array with one row and stores that array in an array and carries on with the rest of the rows.

I will then generate a new word doc per array found in the array of arrays( I can do this myself.) I'm sorry I don't make much sense, I don't really know how to explain this...

I looks pretty straightforward unless I am missing something. What specifically is a problem for you? — JRL
– JRL, Commented Oct 9, 2011 at 15:07
That's common practice I'd say. Have a look at the documentation for a start: php.net/manual/en/function.mysql-fetch-array.php — Felix Kling
– Felix Kling, Commented Oct 9, 2011 at 15:08

Clive · Accepted Answer · 2011-10-09 15:07:55Z

1

Do you mean:

$sql = "SELECT * FROM tbl";
$query = mysql_query($query, $connection);

$rows = array(); 
while ($row = mysql_fetch_array($query)) {
  $rows[] = $row;
}

// You now have an array of your DB rows in $rows

foreach ($rows as $row) {
  createWordDoc($row);
}

If you don't actually need to cache the rows you could do this directly in your first loop of course:

$rows = array(); 
while ($row = mysql_fetch_array($query)) {
  createWordDoc($row);
}

answered Oct 9, 2011 at 15:07

Clive

36.9k8 gold badges89 silver badges113 bronze badges

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

Collectives™ on Stack Overflow

PHP Create new array per row of MYSQL Info, and store the arrays in a array

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