class?

[jwilson122]

Hey, I was wondering if anyone could give me an example script or show me how to make a class like such:

$do->Query("SELECT * FROM users")->Where("id = 1")->extra("LIMIT 1");

See, I know how to make a class and functions inside of the class to make:

$do->Query("SELECT * FROM users");
$do->Where(""id = 1");
$do->extra("LIMIT 1");

But I would rather have the single line link..

$do->Query("SELECT * FROM users")->Where("id = 1")->extra("LIMIT 1");

 

Is this considered OOP (object oriented programming) ? I've searched and searched for this, tried many things.. nothings working :/ any help? Thanks!

[joel24]

for the query function in the class I would have the input to be

function Query($query, $where, $extra)
{
//rarrararara
$sql = "$query $where $extra";
//execute and return results
}

 

then to call it

$do->Query("SELECT * FROM users", "WHERE id=1", "LIMIT 1");

[jwilson122]

for the query function in the class I would have the input to be

function Query($query, $where, $extra)
{
//rarrararara
$sql = "$query $where $extra";
//execute and return results
}

 

then to call it

$do->Query("SELECT * FROM users", "WHERE id=1", "LIMIT 1");

 

I didn't even think of doing it that way haha! Not bad idea

[trq]

To use method chaining as in your example you simply need to ensure that each method returns $this.

[jwilson122]

To use method chaining as in your example you simply need to ensure that each method returns $this.

 

when you said method, that means function right?

[trq]

when you said method, that means function right?

 

Yes. Functions within a class are referred to as methods of that class.

[jwilson122]

Would you guys recommend just doing like..

$_db->query("SELECT * FROM bla bla");

?? Or making a class chain?

[trq]

The chain method is a fair bit more complex within the class itself.