hard question for programmers

abnfire

i wanted to know how can i use one script with letting different clients useing different database.

like i use to mysql_connect function for mysql database and for oracle i use ora_connect and for odbc i use odbc-connect. so if client ask for postgreSql database i have to change the whole script in order to for fill my client option, how can i make it easy way???

Please if you know something! then post it.

sarahk

and this is hard because?

use classes to manage your database calls, the sql queries tend to be the same, or even just have classes with function that can interpret your basic commands and then ask the right questions.

So your user logs in
you look at who they are
set the database flag to mysql, oracle, ...
then each time you need to hit the database call your database handler with the info you need and the database type and let it do the work.

a bit of coding to setup but once it's done it should be reusable.

last thing you want is the database logic in every script though.

abnfire

please can you write an example script, so i can get more clear view.

Thank you for helping me!

edwardsbc

Don't the PEAR object (usually distributed with PHP now) already do all of this abstraction for you?

abnfire

Please anyone can explane or write a example for a newbie, because helping each other can make this community biger and friendly.Thank you

bobthedog

True, but last time I looked we weren't here to provide complete solutions for people either (and most of us probably don't have the time).

Surely the fun in programming is getting some suggestions and learning for yourself?

Go read up on www.php.net about classes, PEAR stuff (never done much with this), and try poking around some of the examples on this site.

Then maybe you can come back and write an article for this site saying how you resolved the issue 🙂

Weedpacket

Didn't I see an article or two on database abstraction on this site?