bulk insert in zend framework [duplicate]

Question

Possible Duplicate:
How do I add more than one row with Zend_Db?

everyone,

I need to have a bulk insert in zend framework. For normal sql I have the below query, I want to do the same in zend framework.

INSERT INTO `dbname`.'tablename` (`id`, `user_id`, `screen_name`, `screen_name_server`) VALUES (NULL, '15', 'test', 'test'), (NULL, '15', 'test', 'test');

Thanks.

Answer 1

There's no way to do this, as Marcin states.

If you'd like to do some messing around with the Zend Framework you'd could try to alter the insert.

You could try to make it so that the insert method can take an array of arrays for the data. Then you could use the arrays of data to build the bulk insert.

For example,

$data1 = array( ); //data for first insert

$data2 = array( ); //data for 2nd insert

//a zend_db_table object

$dbTable->insert( array( $data1, $data, ) );

You would have to edit the insert method a bit to detect multiple data inserts and then build the insert accordingly. Unfortunately I haven't looked into how the code is built or I would just put it up here for you to use.

Answer 2

There is no insert method in zend_db that would insert multiple rows. What you can do though, is to use query method of Zend_Db_Adapter and put there your own insert sql.