PEAR DB/MySQL Prepared Statement with LIKE

[jmark]

I need some assistance on how to create a select statement using PEAR
DB or MySQL with the LIKE function.
That is I am looking of how I can get statement like this work.
SELECT * FROM customer WHERE name LIKE '%?'

[petersprc]

On Jun 21, 3:00 pm, [e-mail] wrote:

I need some assistance on how to create a select statement using PEAR
DB or MySQL with the LIKE function.
That is I am looking of how I can get statement like this work.
SELECT * FROM customer WHERE name LIKE '%?'

require_once('MDB2.php');

$mdb2 = MDB2::singleton('mysql://user:password@host/db');
$mdb2->loadModule('Extended');

$rows = $mdb2->extended->getAll(
'select * from customer where name like ?',
null, array('%bob%'));

[jmark]

On Jun 21, 2:42 pm, petersprc <[e-mail]:

On Jun 21, 3:00 pm, [e-mail] wrote:

I need some assistance on how to create a select statement using PEAR
DB or MySQL with the LIKE function.
That is I am looking of how I can get statement like this work.
SELECT * FROM customer WHERE name LIKE '%?'

require_once('MDB2.php');

$mdb2 = MDB2::singleton('mysql://user:password@host/db');
$mdb2->loadModule('Extended');

$rows = $mdb2->extended->getAll(
'select * from customer where name like ?',
null, array('%bob%'));

Thanks for the info. But currently I am running on PEAR DB. Is there a
way this can be done in PEAR DB or plain MySQL?

[Jerry Stuckle]

jm***@fastermail.com wrote:

On Jun 21, 2:42 pm, petersprc <[e-mail]:

>On Jun 21, 3:00 pm, [e-mail] wrote:

>>I need some assistance on how to create a select statement using PEAR
DB or MySQL with the LIKE function.
That is I am looking of how I can get statement like this work.
SELECT * FROM customer WHERE name LIKE '%?'

require_once('MDB2.php');

$mdb2 = MDB2::singleton('mysql://user:password@host/db');
$mdb2->loadModule('Extended');

$rows = $mdb2->extended->getAll(
'select * from customer where name like ?',
null, array('%bob%'));

Thanks for the info. But currently I am running on PEAR DB. Is there a
way this can be done in PEAR DB or plain MySQL?

The point being that Pear DB is obsolete. See
<http://pear.php.net/package/DB>.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[jmark]

On Jun 22, 6:56 am, Jerry Stuckle <[e-mail]:

[e-mail] wrote:

On Jun 21, 2:42 pm, petersprc <[e-mail]:

On Jun 21, 3:00 pm, [e-mail] wrote:

>I need some assistance on how to create a select statement using PEAR
DB or MySQL with the LIKE function.
That is I am looking of how I can get statement like this work.
SELECT * FROM customer WHERE name LIKE '%?'
require_once('MDB2.php');

$mdb2 = MDB2::singleton('mysql://user:password@host/db');
$mdb2->loadModule('Extended');

$rows = $mdb2->extended->getAll(
'select * from customer where name like ?',
null, array('%bob%'));

Thanks for the info. But currently I am running on PEAR DB. Is there a
way this can be done in PEAR DB or plain MySQL?

The point being that Pear DB is obsolete. See
<http://pear.php.net/package/DB>.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================- Hide quoted text -

- Show quoted text -

Thanks to you two, I will migrate to mdb2

[Michael Fesser]

..oO(jm***@fastermail.com)

>Thanks to you two, I will migrate to mdb2

What about PDO?

Micha