try {
$operations->insert("value", "'{$escape}'");
} catch (MysqltcsException $e) {
print "Error on insert caught<br/>\n";
print $e->getMessage() . "<br/>\n";
}
print "<h3>insert with escape of `{$escape}`</h3>\n";
$operations->insert("value", "'" . $operations->getEscapedString($escape) . "'");
$results = $operations->getList("id, value, value2", "1");
// or $results = $operations->getList("*", "1");
print "id-value-value2<br/>\n";
foreach ($results as $value) {
print $value['id'] . "-" . $value['value'] . "-" . $value['value2'] . "<br/>\n";
}
print "<h2>Remove</h2>\n";
print "<h3>Remove {$id}</h3>\n";
$operations->deleteRows("id = {$id}");
$results = $operations->getList("id, value, value2", "1");
// or $results = $operations->getList("*", "1");
print "id-value-value2<br/>\n";
foreach ($results as $value) {
print $value['id'] . "-" . $value['value'] . "-" . $value['value2'] . "<br/>\n";
}
print "<h3>Remove all rows</h3>\n";
$operations->deleteRows("1");
$results = $operations->getList("id, value, value2", "1");
// or $results = $operations->getList("*", "1");
print "id-value-value2<br/>\n";
foreach ($results as $value) {
print $value['id'] . "-" . $value['value'] . "-" . $value['value2'] . "<br/>\n";
}
