Re: DB stuff
| From: | Rouvas Stathis | Date: | Tue, 07 Nov 2000 18:36:35 +0000 |
| Subject: | Re: DB stuff | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-24152@lists.php.net to get a copy of this message | ||
Excuse me, where is the documentation for the DB abstraction layer?
I can't seem to find any in the <http://www.php.net/manual>.
Thank you for your time,
-Stathis.
Rasmus Lerdorf wrote:
>
> PHP 4 comes with a database abstraction layer. You would use it like
> this:
>
> <?
> require_once 'DB';
> $db = DB::connect('odbc://rasmus:pw@host/my_db');
> $stmt = $db->prepare('select * from my_table');
> $result = $db->execute($stmt);
> while($row = $db->fetchrow($result)) {
> while(list($key, $value) = each($row)) {
> echo "$field: $value<br>\n";
> }
> }
> $db->disconnect();
> ?>
>
> To change to a different database type the only thing you need to do is
> change the 'odbc' work in the DB::connect() call.
>
> You can of course read that database connection identifier string from
> anywhere you like and thereby configure your database access with a
> one-liner in any file you like.
>
> -Rasmus
>
> On Tue, 7 Nov 2000, Voitenko, Denis wrote:
> > I am wondering why wouldn't PHP support database connectivity like most
> > application servers do, e.g. something like a data source in JRun or
> > WebLogic where database connectivity is made DB server independent and all
> > the DB connectivity is configured in the guts of PHP?
> >
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net