What are the best practices for updating database entries when removing individuals from rooms in a PHP script?

When removing individuals from rooms in a PHP script, it is important to update the database entries to reflect the changes accurately. This can be achieved by first querying the database to retrieve the current room occupancy, then updating the room occupancy by removing the individuals, and finally updating the database with the new occupancy information. 

// Assume $roomId and $individualId are the variables representing the room and individual being removed

// Query the database to retrieve current room occupancy
$occupancy = $pdo->query("SELECT occupancy FROM rooms WHERE id = $roomId")->fetchColumn();

// Update room occupancy by removing the individual
$occupancy = $occupancy - 1;

// Update the database with the new occupancy information
$pdo->exec("UPDATE rooms SET occupancy = $occupancy WHERE id = $roomId");

Keywords

SQL database UPDATE PHP script removal

Related Questions