Phosphorus and Lime
A Developer's Broadsheet
This blog has been deprecated. Please visit my new blog at klenwell.com/press.
profile
Name: klenwell
Home: San Diego, California, United States
About Me: designer, programmer, wordsmith
Thursday, September 07, 2006
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:
source: ADODB Manual
keywords: php, ado, adodb, mysql, batch
$_DATA_BIND = array
(
array('', 'Ahmed', 20),
array('', 'Barbara', 33),
array('', 'Cecilia', 41),
);
$ok = $ADO->Execute('insert into table (uid, name, age) values (?,?,?)', $_DATA_BIND);
(
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
some rights reserved, © 2006