[PHP/MySQL] Function to return ALL selected rows

maZtah · 11-09-2007, 12:38 AM

Hi, I can't figure this out myself so maybe you've got an answer to my issue.

I want to create a function which returns (as the title says) all selected rows in an array. The next thing I want to do is loop through it and display all rows.

Something like this should do probably:

PHP Code:


			
public function query($szQuery) {

    $pResult = mysql_query($szQuery);

    while ($aRow = mysql_fetch_array($pResult)) {

        $aResult[] .= $aRow;

    }

    return $aResult;

}

To enter the query..

PHP Code:


			
$aResult = $pDatabase->query('SELECT * FROM Members');

Now my problem, how to loop through all the rows and displaying them?

Salathe · 11-09-2007, 12:48 AM

You can just use the regular loop structures (foreach, for, while, and so on) since $aResult is just a normal array.

PHP Code:


			
foreach ($aResult as $aRow)
{
    // Do something for each row, perhaps
    echo $aRow['username'], ' smells!';
}

maZtah · 11-09-2007, 01:18 AM

No, $aResult exists out of Arrays.

PHP Code:


			
print_r($aResult);

will echo

Code:

Array ( [0] => Array [1] => Array [2] => Array )

bluesaga · 11-09-2007, 01:33 AM

I may be wrong but i think:
$aResult[] .= $aRow;

Is your problem, it should be:
$aResult[] = $aRow;

But im not sure how much of an effect that will have, Salathe is correct in how he recommends it, but why would you want to add them all to an array and then loop through them AGAIN to access them? Seems a little odd to me, unless you have a certain situation.

maZtah · 11-09-2007, 01:43 AM

That will return only the last row, bluesaga.

The point is that I want to output all the results found, without a mysql_fetch part outside the Database class.

bluesaga · 11-13-2007, 09:03 AM

Erm, no it won't.

Using array[] means it will create a row in the index incrementing the previous array index.

ie first time its ran:
array[0];

second time:
array[1];

However you can use something like this instead:

PHP Code:


			
class database
{

  function query($szQuery)
  {
     return mysql_query($szQuery);
  }

  function result($pQuery)
  {
    return mysql_fetch_array($pQuery);
  }
}

$db     = new database;
$query = $db->query("SELECT * FROM table");

while($result = $db->result($query))
{
   print_r($result);
}