Re: [PHP-DB] Getting started with MDB2 - got it!
My problem was that my SQL class is a wrapper around MDB2. Obviously the SQL
class didn't have a lastInsertID() method of its own (but now it does!):
public function InsertID() {
return $this->db->lastInsertID();
}
Thanks for all the help,
Yves
-- Original Message --
Received: Mon, 08 Sep 2008 02:02:44 PM CDT
From: "Evert Lammerts" <[EMAIL PROTECTED]>
To: "YVES SUCAET" <[EMAIL PROTECTED]>Cc: php-db@lists.php.net,
[EMAIL PROTECTED]
Subject: Re: [PHP-DB] Getting started with MDB2
Have a look at this:
http://wiki.pooteeweet.org/index.php?area=MDB2&page=ExampleS&view=diff&to=2006-05-25%2010:27:49&from=2006-03-22%2011:08:24
It loads the Extended module
On Mon, Sep 8, 2008 at 8:55 PM, YVES SUCAET <[EMAIL PROTECTED]> wrote:
> Interesting. I'm following the documentation at
> http://pear.php.net/manual/en/package.database.mdb2.intro-sequences.php
>
> Here's my code:
>
>$sql = new SQL();
>$sql->connect(DSN_METNET3_MY_EDIT);
>$qry = "insert into List(lstName, lstNotes, UserName) values ($name,
> $notes, $user)";
>$sql->query($qry);
>return $sql->lastInsertID("List");
>
> I'm now getting the following error message: Call to undefined method
> SQL::lastInsertID()
>
> Any further clues?
>
> Yves
>
> -- Original Message ------
> Received: Mon, 08 Sep 2008 01:29:42 PM CDT
> From: "Evert Lammerts" <[EMAIL PROTECTED]>
> To: "YVES SUCAET" <[EMAIL PROTECTED]>Cc: php-db@lists.php.net
> Subject: Re: [PHP-DB] Getting started with MDB2
>
>> * mysql_last_insert_id()
>
> getAfterId()
>
>
http://pear.php.net/reference/LiveUser_Admin-0.3.3/LiveUser_Admin/LiveUser_Admin_Storage_MDB2.html#methodgetAfterId
>
>> * mysql_real_escape_string()
>
> escape()
>
>
http://pear.php.net/package/MDB2/docs/latest/MDB2/MDB2_Driver_Common.html#methodescape
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Getting started with MDB2
Have a look at this:
http://wiki.pooteeweet.org/index.php?area=MDB2&page=ExampleS&view=diff&to=2006-05-25%2010:27:49&from=2006-03-22%2011:08:24
It loads the Extended module
On Mon, Sep 8, 2008 at 8:55 PM, YVES SUCAET <[EMAIL PROTECTED]> wrote:
> Interesting. I'm following the documentation at
> http://pear.php.net/manual/en/package.database.mdb2.intro-sequences.php
>
> Here's my code:
>
>$sql = new SQL();
>$sql->connect(DSN_METNET3_MY_EDIT);
>$qry = "insert into List(lstName, lstNotes, UserName) values ($name,
> $notes, $user)";
>$sql->query($qry);
>return $sql->lastInsertID("List");
>
> I'm now getting the following error message: Call to undefined method
> SQL::lastInsertID()
>
> Any further clues?
>
> Yves
>
> -- Original Message --
> Received: Mon, 08 Sep 2008 01:29:42 PM CDT
> From: "Evert Lammerts" <[EMAIL PROTECTED]>
> To: "YVES SUCAET" <[EMAIL PROTECTED]>Cc: php-db@lists.php.net
> Subject: Re: [PHP-DB] Getting started with MDB2
>
>> * mysql_last_insert_id()
>
> getAfterId()
>
> http://pear.php.net/reference/LiveUser_Admin-0.3.3/LiveUser_Admin/LiveUser_Admin_Storage_MDB2.html#methodgetAfterId
>
>> * mysql_real_escape_string()
>
> escape()
>
> http://pear.php.net/package/MDB2/docs/latest/MDB2/MDB2_Driver_Common.html#methodescape
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Getting started with MDB2
Interesting. I'm following the documentation at
http://pear.php.net/manual/en/package.database.mdb2.intro-sequences.php
Here's my code:
$sql = new SQL();
$sql->connect(DSN_METNET3_MY_EDIT);
$qry = "insert into List(lstName, lstNotes, UserName) values ($name,
$notes, $user)";
$sql->query($qry);
return $sql->lastInsertID("List");
I'm now getting the following error message: Call to undefined method
SQL::lastInsertID()
Any further clues?
Yves
-- Original Message --
Received: Mon, 08 Sep 2008 01:29:42 PM CDT
From: "Evert Lammerts" <[EMAIL PROTECTED]>
To: "YVES SUCAET" <[EMAIL PROTECTED]>Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Getting started with MDB2
> * mysql_last_insert_id()
getAfterId()
http://pear.php.net/reference/LiveUser_Admin-0.3.3/LiveUser_Admin/LiveUser_Admin_Storage_MDB2.html#methodgetAfterId
> * mysql_real_escape_string()
escape()
http://pear.php.net/package/MDB2/docs/latest/MDB2/MDB2_Driver_Common.html#methodescape
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Getting started with MDB2
Here are some other options for escaping: http://pear.php.net/manual/en/package.database.mdb2.intro-quote.php I think getAfterId will not work - seems to be part of LiveUser Admin. Interesting stuff, definitely worth a look. On Mon, Sep 8, 2008 at 7:14 PM, YVES SUCAET <[EMAIL PROTECTED]> wrote: > Hi List, > > What are the equivalent MDB2 methods for: > > * mysql_last_insert_id() > * mysql_real_escape_string() > > Much obliged, > > Yves > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Getting started with MDB2
> * mysql_last_insert_id() getAfterId() http://pear.php.net/reference/LiveUser_Admin-0.3.3/LiveUser_Admin/LiveUser_Admin_Storage_MDB2.html#methodgetAfterId > * mysql_real_escape_string() escape() http://pear.php.net/package/MDB2/docs/latest/MDB2/MDB2_Driver_Common.html#methodescape -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
