show data from mySQL result array returned by a function

Question

I want to pass a mySQL result from a function and print the data. How to do so ?

<?php
function showLatestItems()
 {
  $result = $this->query("SELECT aid,name,description,img,amount,strtdate,enddate FROM item WHERE enddate>now()");
  return $result;
/*      while($row=mysql_fetch_array($result))
   echo $row[0].' '.$row[3].' '.$row[1].' '.$row[2].$row[4].$row[5].$row[6].'<br>';
*/
 }
?>

Michael Berkowski · Accepted Answer · 2012-03-03 16:29:50Z

1

Just trap the result resource and then fetch rows from it. Based on the commented out code, we assume you have wrapped mysql_query() with a class method called query().

$result = $yourclass->showLatestItems();
if ($result) {
  $rowset = array();
  while ($row = mysql_fetch_assoc($result)) {
    $rowset[]  = $row;
  }
}

var_dump($rowset);

answered Mar 3, 2012 at 16:29

Michael Berkowski

271k47 gold badges450 silver badges395 bronze badges

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

4 Comments

Sourav Over a year ago

I hate var_dump, plz be nice :P

Michael Berkowski Over a year ago

@Sourav var_dump() is only there to prove $rowset is an array.

Sourav Over a year ago

Warning: Invalid argument supplied for foreach()

Michael Berkowski Over a year ago

@Sourav What foreach? There is none in your code or in mine.

Collectives™ on Stack Overflow

show data from mySQL result array returned by a function

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related