Re: DB_Object->insert() not returning ID
| From: | Justin Patrin | Date: | Mon, 15 Nov 2004 18:46:12 +0000 |
| Subject: | Re: DB_Object->insert() not returning ID | ||
| References: | 1 2 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-15528@lists.php.net to get a copy of this message | ||
On Sun, 14 Nov 2004 21:23:06 -0800, Ken Restivo <ken@restivo.org> wrote:
> On Sun, Nov 14, 2004 at 07:36:41PM -0800, Ken Restivo wrote:
> > One more: inserts succeed but always return 1 as an ID.
> >
> > I supposed I can hack around this with a raw query for last_insert_id(), but the docs say
> > insert() should return this.
> >
>
> OK well I did this, but I'm still kind of suspicious about why I had to:
>
> function lastInsertID($obj)
> {
> $db =& $obj->getDatabaseConnection();
>
> $data =& $db->getOne('select last_insert_id()');
> if (DB::isError($data)) {
> die($data->getMessage());
> }
> return $data;
> }
>
Looking at the DB_DataObject code, insert() says it returns true,
false, or 0. Looks like the online docs are wrong. Look at the online
API docs.
--
Justin Patrin