[SOLVED] PHP OO Loop Through Mysql Results

[s_ainley87]

Hello,

 

I have this sql code that pulls out member details from a table

 

public function getMemberAndLocationByName($name)
{
	$db = Zend_Registry::get('db');
	$name = $db->quote($name);
	$name = $name;
	$new_name = preg_replace("/[^a-zA-Z0-9s]/", "", $name);		
	$sql = "SELECT $this->_name.*, locations.name as location from $this->_name LEFT JOIN locations on $this->_name.restaurant_id = locations.id where $this->_name.name LIKE '%$new_name%'";
	//die($sql);
	$query = $db->query($sql);
	while ($row = $query->fetch()) {
    		$result[] = $row;
	}

	//die(print_r($result));
	return $result;


}

 

how do i then using oo and PHP5 print all the results on screen?

 

Thanks

[lewis987]

I dont totally understand you, BUT, you can try this:

 

$DB = new DB; #Change DB to the class that the function is contained in;

$name = "blah";

$result = $DB->getMemberAndLocationByName($name);

print_r($result);
//You can use a loop instead of printing everything out in a oner.

 

I think thats your question solved;