/ LJCPHPCodeDoc / LJCDBAccessLib / LJCDbAccess / Execute


Parameters
$sql - The SQL statement.

Returns

The count of affected records.

Syntax

PHP
public function Execute(string $sql) : int

Executes a non-query sql statement.

Example

PHP
 // Executes a non-query sql statement.
 public function Execute(LJCConnectionValues $connectionValues): int
 {
   // See constructor for how to create $connectionValues.
   $dbAccess = new LJCDbAccess($connectionValues);
 
   $tableName = "TableName";
 
   // Insert test record.
   $name = "Test";
   $sql = "insert into {$tableName}\r\n ";
   $sql .= "(Name)\r\n ";
   $sql .= "values('{$name}');";
   $affectedCount = $dbAccess->Execute($sql);
   if (0 == $affectedCount)
   {
     echo("\r\nExecute() No record inserted.");
   }
 
   // Retrieve assigned ID.
   $sql = "select\r\n ";
   $sql .= "ID, Name\r\n ";
   $sql .= "from {$tableName}\r\n ";
   $sql .= "where Name = '{$name}';";
   $row = $dbAccess->Retrieve($sql);
   if ($row == null)
   {
     echo("\r\nExecute() select row not found");
   }
   $id = LJCDbAccess::GetValue($row, "ID");
   if ($id == null)
   {
     echo("\r\nExecute() ID not found");
   }
 
   // Delete test record.
   if ($id != null)
   {
     $sql = "delete from {$tableName}\r\n ";
     $sql .= "where ID = {$id};";
     $affectedCount = $dbAccess->Execute($sql);
     if (0 == $affectedCount)
     {
       echo("\r\nExecute() No record found to delete.");
     }
   }
 }

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