troubleshooting Question

Is this an example of a fluent interface?

Avatar of Bruce Gust
Bruce GustFlag for United States of America asked on
PHP
5 Comments3 Solutions148 ViewsLast Modified:
I have a Class that has within it two methods. The first method grabs an ID that's arriving from a form and, via a select statement, retrieves the name of the table that corresponds to that ID.

The next method's job is to retrieve the column names of the table the previous method has ascertained.

It looks like this:

class TableData {

	public $table_name;

	function TableName()
	{
		global $mysqli;

		$sql="select table_name from tools where id='$_POST[table_id]'";
			if(!$query=$mysqli->query($sql))
			{
				$err=$mysqli->errno.': '.$mysqli->error;
				trigger_error($err, E_USER_WARNING);
			}
		$row=$query->fetch_object();
		$the_name=$row->tool_name;
		
		$this->table_name=$the_name;
	}

	function TableInfo()
	{
		global $mysqli;
		
		$sql = "show columns from $table_name";
		$query = $mysqli->query($sql);
		
		if(!$query)
		{
		$error = $mysqli->errno.': '.$mysqli->error;
		trigger_error($error, E_USER_WARNING);
		}
		
		$data_count=mysqli_num_rows($query);
		
		if($data_count==0)
		{
		trigger_error("you don't have any column names", E_USER_WARNING);
		}
		//return $data_count;
		
		while($show_columns=$query->fetch_object())
		{
		$the_columns[]=$show_columns->Field;
		}
		return $the_columns;
	}
}

I imagine you could retrieve the name of the table and then pass it on as a variable into a subsequent function, but I'm thinking there's a more elegant way to do this. As I was looking for some answers I stumbled upon the term "fluent interface" and I'm not sure if that's what I'm looking for, but there it is.

Can I set in motion a "daisy chain" of methods by instantiating one Class? If so, how. If not, what are my options in terms of sound programming?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 3 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros