Getting started with MDB2

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

Re: 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_Drive r_Common.html#methodescape

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Getting started with MDB2

Here are some other options for escaping:

http://pear.php.net/manual/en/package.database.mdb2.intro-qu ote.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 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: Getting started with MDB2

Interesting. I'm following the documentation at
http://pear.php.net/manual/en/package.database.mdb2.intro-se quences.php

Here's my code:

$sql =3D new SQL();
$sql->connect(DSN_METNET3_MY_EDIT);
$qry =3D "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"
To: "YVES SUCAET" 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/LiveUse=
r_Admin_Storage_MDB2.html#methodgetAfterId

> * mysql_real_escape_string()

escape()

http://pear.php.net/package/MDB2/docs/latest/MDB2/MDB2_Drive r_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: 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 wrote:
> Interesting. I'm following the documentation at
> http://pear.php.net/manual/en/package.database.mdb2.intro-se quences.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"
> To: "YVES SUCAET" 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_Drive r_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