creating functions

[ShaolinF]

Hi Guys,

 

How would I create a function that interacts with a database? Would I need to create different functions for different statements (SELECT, UPDATE, INSERT etc) or would one function suffice ?

[awpti]

Take a look at one of the many DB Abstraction libraries that exist. No need to reinvent the wheel.

 

Other than that, yes, you would (logically) create a function per type.

 

for example:

 

$this->db->update(...)

$this->db->insert(...)

$this->db->getwhere(...)

 

you know, unless you like creating one function with a bucketload of switch cases. That would be real perdy.

[ShaolinF]

Take a look at one of the many DB Abstraction libraries that exist. No need to reinvent the wheel.

 

Other than that, yes, you would (logically) create a function per type.

 

for example:

 

$this->db->update(...)

$this->db->insert(...)

$this->db->getwhere(...)

 

you know, unless you like creating one function with a bucketload of switch cases. That would be real perdy.

Thanks.

 

So is 'this->' referring to the db class ? In other words get the data between the parenthisis, process it in the update function found in the db class. Yes ?

[trq]

Yes, $this refers to the class that $this is within.

[ShaolinF]

Thanks, can you recommend me any libraries I could use ?

[toplay]

 

ADODB:

http://adodb.sourceforge.net/  manual/tutorial at: http://phplens.com/lens/adodb/docs-adodb.htm

 

ADODBLite:

http://adodblite.sourceforge.net/index.php

 

 

DB PEAR package:

http://pear.php.net/package/DB