/ LJCPHPCodeDoc / LJCDataManagerLib / LJCDataManager / UpdateSQL


Parameters
$keyColumns - The where clause key columns.
$dataColumns - The data columns.

Returns

The Update SQL statement.

Syntax

PHP
public function UpdateSQL(LJCDbColumns $keyColumns
, LJCDbColumns $dataColumns)

Creates the Update SQL.

Example

PHP
 // Creates the Update SQL.
 private static function UpdateSQL(LJCDataManager $manager)
 {
   $nameValue = "NameValue";
   $updateValue = "Updated";
   $methodName = "UpdateSQL()";
 
   $data = new LJCDbColumns();
   $data->Add("Name", value: $nameValue);
   $affectedCount = $manager->Add($data);
 
   // Get the Update SQL statement.
   // See constructor for how to create $manager.
   $keys = new LJCDbColumns();
   $keys->Add("Name", value: $nameValue);
   $data = new LJCDbColumns();
   $data->Add("Name", value: $updateValue);
   $result = $manager->UpdateSQL($keys, $data);
 
   // result:
   // update TableName set
   //   Name = 'Updated'
   //
   // where TableName.Name = 'NameValue'
 
   $keys = new LJCDbColumns();
   $keys->Add("Name", value: $updateValue);
   $affectedCount = $manager->Delete($keys)
 }

Copyright © Lester J. Clark and Contributors.
Licensed under the MIT License.