how to build multiple insert query in zend framework

Question

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

i would like to build this query

INSERT INTO ad-page (ad_name, page_name) VALUES ('value1', 'value2'), ('value3', 'value4') , ....

i tried this which did not work

        $adpagemodel = new Admin_Model_AdPage();

        if(count($adpage)> 0)
            foreach($adpage as $page)
            {
                $newdatap[]['page_name'] = $page;
                $newdata[]['ad_name'] = $adname;            
            }
        $adpagemodel->insert($newdata);

and please also check this

score 21 · Accepted Answer · answered Mar 17 '11 at 12:47

There is simple option. Create the query by hand ;)

like this:

$query = 'INSERT INTO ' . $db->quoteIdentifier('table') . ' (`col1`, `col2`) VALUES ';
$queryVals = array();
foreach ($data as $row) {
    foreach($row as &$col) {
        $col = $db->quote($col);
    }
    $queryVals[] = '(' . implode(',', $row) . ')';
}
$stmt = $db->query($query . implode(',', $queryVals));

score 2 · Answer 2 · answered Jan 26 '11 at 09:00

2

Not all databases support this. So, there is no universal answer. But if you would tell what's you DB, we might suggest some trick... :-)

answered Jan 26 '11 at 09:00

BarsMonster

6,483
2
34
47

mysql supports this, but the problem is i don't know how to create this statement through dbmodel, instead i have to iterate through loop and insert multiple values – S L Jan 26 '11 at 09:07

how to build multiple insert query in zend framework

2 Answers2