Re: Re: db_* => pg_*/my_*/ifx_* ?
| From: | Ashley Sheridan | Date: | Mon, 06 Oct 2008 21:58:49 +0000 |
| Subject: | Re: Re: db_* => pg_*/my_*/ifx_* ? | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-281509@lists.php.net to get a copy of this message | ||
On Wed, 2008-10-01 at 17:44 +0200, Michelle Konzack wrote:
> Am 2008-09-30 19:58:03, schrieb Ashley Sheridan:
> > Hi Michelle, I'm not sure exactly what it is you're after. Are you
> > looking for software that will allow you to develop applications that
> > are database agnostic?
>
> What is "agnostic"?
>
> If you mean "database independant", the answer is yes.
>
> Most Applications do not need complex database specific queries and
> generaly I need only
>
> db_connect($server, $port, $db, $user, $pass)
> 1) using pconnect if possibel
> 2) there are already significant differences
> between pgsql and mysql
> db_error()
> 1) Works different between pgsql and mysql and ifx
>
> db_close($handle)
> 1) Works afaik with all databases the same way
>
> db_getarray() -> return array from SELECT
> 1) Hell of SELECT FROM WHERE...
>
> db_insert($handle, $table, $what, $where)
> db_update($handle, $table, $what, $where)
> db_delete($handle, $table, $what, $where)
> 1) Sometimes heavy differences for ALL databases...
>
>
> Thanks, Greetings and nice Day/Evening
> Michelle Konzack
> Systemadministrator
> 24V Electronic Engineer
> Tamay Dogan Network
> Debian GNU/Linux Consultant
>
>
I think you may need to write these wrappers yourself if you need them.
I don't know of any library that will provide these, and most PHP
systems I've used have their own like this as well.
Ash
www.ashleysheridan.co.uk