// Executes an Add, Delete or Update SQL statement.
private static function SQLExecute(LJCDataManager $manager)
{
$nameValue = "NameValue";
$updateValue = "Updated";
$methodName = "SQLExecute()";
$data = new LJCDbColumns();
$data->Add("Name", value: $nameValue);
$affectedCount = $manager->Add($data);
// Update with SQLExecute().
// See constructor for how to create $manager.
$keys = new LJCDbColumns();
$keys->Add("Name", value: $nameValue);
$data = new LJCDbColumns();
$data->Add("Name", value: $updateValue);
$sql = $manager->UpdateSQL($keys, $data);
$affectedCount = $manager->SQLExecute($sql);
$result = strval($affectedCount);
// result:
// 1
// $sql =
// update TableName set
// Name = 'Updated'
//
// where TableName.Name = 'NameValue'
$keys = new LJCDbColumns();
$keys->Add("Name", value: $updateValue);
$affectedCount = $manager->Delete($keys);
}
|