/ LJCPHPCodeDoc / LJCDataManagerLib / LJCDataManager / Update


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

Returns

The count of affected records.

Syntax

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

Updates the records for the provided values.

Remarks

The Update() method updates records in the database using the values from the $dataColumns collection parameter.

The $keyColumns collection parameter contains the data for the where clause.

The $keyColumns parameter is required and must have collection elements or the Update will not be executed.

Example

PHP
 // Updates the records for the provided values.
 private static function Update(LJCDataManager $manager)
 {
   $nameValue = "NameValue";
   $updateValue = "Updated";
   $methodName = "Update()";
 
   $data = new LJCDbColumns();
   $data->Add("Name", value: $nameValue);
   $affectedCount = $manager->Add($data);
 
   // Update the test data.
   // See constructor for how to create $manager.
   $keys = new LJCDbColumns();
   $keys->Add("Name", value: $nameValue);
   $data = new LJCDbColumns();
   $data->Add("Name", value: $updateValue);
   $affectedCount = $manager->Update($keys, $data);
   $result = strval($affectedCount);
 
   // result:
   // 1
 
   // $manager->SQL =
   // 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.