PHP and SQL Server - Deleting Data

The SQL 'delete' statement can be used for removing a record or records, which looks as follows.

DELETE FROM table_name
​WHERE where_condition

The following example deletes a record from the 'person' table, as previously used in the examples for selecting, inserting and updating data, based on the 'id' being equal to '2'.

<?php

   // Connect to the database.
   require_once('database-connect.php');
   
   // Query parameter.
   $id = 2;
 
   try
   {
      
      // Prepare the query.
      $results = $connect->prepare("DELETE FROM person
                                    WHERE id = ?");
                                    
      // Bind the parameter.
      $results->bindParam(1, $id);
      
      // Execute the query.
      $results->execute();
      
   } catch(Exception $e) {
      
      // If query fails, display an error and exit.
      echo "Error deleting person information.";
      exit;
      
   }

   // Display a message saying person deleted successfully.
   echo "Person deleted successfully.";

?>

The contents of the 'person' table now looks like this.