[ale] PHP SQL parser (was: DB abstraction for PHP)

J.M. Taylor jtaylor at onlinea.com
Mon Dec 30 08:49:29 EST 2002


John,

I've been looking for about a year and have yet to find what you're
talking about...you want true abstraction.  PEAR doesn't do much IMHO.

So far what I've done is write a wrapper script that handles the db
connection based on a paramter, and returns your result in an array of
assoc arrays.  In *theory* it works great (and it sure does make calling
the DB easier) but in practice I've never tried it on vastly different DBs
and frankly have no knowledge of how cross-db my SQL statements would
really be. :(

What you (and I) really want is a PHP SQL parser.  It's on my list of
things to write but it's so far away that I'm afraid I can't be of any
more help than to offer the wrapper script.

Anyone know of any other resourses for this?

Jenn


John Wells said:
> Can anyone suggest a very mature db abstraction solution for PHP?  I'd
> like to support at the very least Oracle, MySql, and optionally
> Postgres.  SqlServer would be nice as well, but not a requirement.
>
> Thanks!
>
> John
>
>
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale



_______________________________________________
Ale mailing list
Ale at ale.org
http://www.ale.org/mailman/listinfo/ale






More information about the Ale mailing list