method insert documentation in bbn\Db\Languages\Sql

Inserts row(s) in a table.

$db->insert("table_users", [ ["name" => "Ted"], ["surname" => "McLow"] ]);

$db->insert("table_users", [ ["name" => "July"], ["surname" => "O'neill"] ], [ ["name" => "Peter"], ["surname" => "Griffin"] ], [ ["name" => "Marge"], ["surname" => "Simpson"] ]);

function($table, array $values = NULL, bool $ignore = false) { if (empty($table)) { throw new \Exception(X::_('Table name is not specified')); } if (\is_array($table) && isset($table['values'])) { $values = $table['values']; } // Array of arrays if (\is_array($values) && count($values) && !X::isAssoc($values) && \is_array($values[0]) ) { $res = 0; foreach ($values as $v){ $res += $this->insert( is_array($table) ? ($table['tables'][0] ?? '') : $table, $v, is_array($table) ? ($table['ignore'] ?? $ignore) : $ignore ); } return $res; } $cfg = \is_array($table) ? $table : [ 'tables' => [$table], 'fields' => $values, 'ignore' => $ignore ]; $cfg['kind'] = 'INSERT'; return $this->_exec($cfg); }

Inserts row(s) in a table. BBN is a suite of PHP and JS libraries and VueJS components - all open-source! bbn.io, build applications, the quick way

This website uses cookies to ensure you get the best experience on our website.