echo '<h3>insertMany</h3>'; echo '<h4>with ID response</h4>'; $data = [['id' => null, 'dump' => '{"message":"Hello"}'], ['id' => null, 'dump' => '{"message":"Foo"}'], ['id' => null, 'dump' => '{"message":"Bar"}']]; $results = $dbh->insertMany('import_dump', $data); var_dump($results); echo '<h4>with NO-ID response</h4>'; $data = [['dump' => '{"message":"Hello"}'], ['dump' => '{"message":"Foo"}'], ['dump' => '{"message":"Bar"}']]; $results = $dbh->insertMany('import_dump_no_id', $data); var_dump($results); // ############################################ echo '<h3>update</h3>'; $conds = ['id' => 1]; $data = ['dump' => '{"message":"Hello Dad"}']; $results = $dbh->update('import_dump', $conds, $data); var_dump($results); // ############################################ echo '<h3>replace</h3>'; $data = ['id' => 1, 'dump' => '{"message":"#Two"}']; $results = $dbh->replace('import_dump', $data); var_dump($results); // ############################################ echo '<h3>replaceMany</h3>'; $data = [['id' => 2, 'dump' => '{"message":"Hello Mum"}'], ['id' => 3, 'dump' => '{"message":"Booooh!"}']]; $results = $dbh->replaceMany('import_dump', $data); var_dump($results); // ############################################ echo '<h3>delete</h3>'; $conds = ['id' => 3]; $condsQuery = 'id = :id'; $results = $dbh->delete('import_dump', $conds, $condsQuery); var_dump($results);