Пример #1
0
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);