/ LJCPHPCodeDoc / LJCDataManagerLib / LJCDataManager / SQLExecute


Parameters
$sql - The SQL statement.

Returns

The count of affected records.

Syntax

PHP
public function SQLExecute(string $sql): int

Executes an Add, Delete or Update SQL statement.

Example

PHP
 // 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);
 }

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