Jump to content
#StayAtHome ×


This topic is now archived and is closed to further replies.


[SOLVED] PHP OO Loop Through Mysql Results

Recommended Posts



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%'";
	$query = $db->query($sql);
	while ($row = $query->fetch()) {
    		$result[] = $row;

	return $result;



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



Share this post

Link to post
Share on other sites

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);

//You can use a loop instead of printing everything out in a oner.


I think thats your question solved;

Share this post

Link to post
Share on other sites

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.