zf2 insert using $db->insert($table, $data); style

Question

Hello is there any way to insert data in a db table using the zf1 style on zf2?

$db->insert('tablename', $data);

where $data is an associative array contains (columns, values)

thanks

What is the issue you are getting?

Shaolin
– Shaolin

2013-03-07 05:49:54 +00:00
Commented Mar 7, 2013 at 5:49 — Shaolin
– Shaolin, Commented Mar 7, 2013 at 5:49

Luis · Accepted Answer · 2013-03-07 19:35:49Z

12

To make an insert in zf2:

    use Zend\Db\Sql\Sql;

    $sql = new Sql($this->dbAdapter);
    $insert = $sql->insert('table');
    $newData = array(
    'col1'=> 'val1',
    'col2'=> 'val2',
    'col3'=> 'val3'
    );
    $insert->values($newData);
    $selectString = $sql->getSqlStringForSqlObject($insert);
    $results = $this->dbAdapter->query($selectString, Adapter::QUERY_MODE_EXECUTE);

answered Mar 7, 2013 at 19:35

Luis

1,0901 gold badge15 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Kristen Waite Over a year ago

getSqlStringForSqlObject() is deprecated in 2.4

Kristen Waite Over a year ago

buildSqlString() should handle the same in this case.

user285594 Over a year ago

How to get the insert ID?

Kasikn77 · Accepted Answer · 2014-11-07 00:10:27Z

4

My proposition using TableGateway:

    $adapter = $this->tableGateway->getAdapter();
    $otherTable = new Zend\Db\TableGateway\TableGateway('table_name', $adapter);
    $otherTable->insert($data));

answered Nov 7, 2014 at 0:10

Kasikn77

3092 silver badges8 bronze badges

2 Comments

lony Over a year ago

Fatal error: Interface 'Zend\EventManager\EventsCapableInterface' not found .. seems this require another module?

Ankit Vishwakarma Over a year ago

I have this way only, but I am surprised it is making two entries why so ? $otherTable = new Zend\Db\TableGateway\TableGateway('demo', \Config\Config::getAdapter()); $otherTable->insert(['name' => 500]);

Collectives™ on Stack Overflow

zf2 insert using $db->insert($table, $data); style

2 Answers 2

3 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related