Re: Re: cvs: php4 /pear DB.php /pear/DB common.phpmysql.php
| From: | Chuck Hagenbuch | Date: | Mon, 04 Dec 2000 20:13:02 +0000 |
| Subject: | Re: Re: cvs: php4 /pear DB.php /pear/DB common.phpmysql.php | ||
| References: | 1 2 3 4 5 | Groups: | php.pear |
| Request: | Send a blank email to php-pear+get-512@lists.php.net to get a copy of this message | ||
Quoting Sebastian Bergmann <sb@sebastian-bergmann.de>:
> Tell me how and I'll do it.
For MySQl, mysql_list_tables (http://www.php.net/manual/function.mysql-list-
tables.php) will let you check for the sequence table; if it's not there, then
run a CREATE TABLE ... query with the correct syntax.
Because this is going to be DB-specific, the nextid() function in DB_common
should probably be a stub returning a DB_NOT_SUPPORTED error object, with
implementations (and thus table syntax) stored in the individual drivers.
We should probably also add some meta-data functions to the API, to call
functions like mysql_list_tables (assuming that they're remotely portable -
odbc has an odbc_tables() function, so I'm guessing that it's relatively common
denominator).
-chuck
--
Charles Hagenbuch, <chuck@horde.org>
"If you can't stand the heat, get out of the chicken!" - Baby Blues