lime icon

Phosphorus and Lime

A Developer's Broadsheet

This blog has been deprecated. Please visit my new blog at klenwell.com/press.
PHP: batch queries with ADODB
I had rolled my own function using PHP's mysql functions to handle batch queries. But now I'm using the ADODB_Lite library. This example is pretty much self-explanatory:

$_DATA_BIND = array
(
array('', 'Ahmed', 20),
array('', 'Barbara', 33),
array('', 'Cecilia', 41),
);

$ok = $ADO->Execute('insert into table (uid, name, age) values (?,?,?)', $_DATA_BIND);


source: ADODB Manual

keywords: php, ado, adodb, mysql, batch