$mysqli = new mysqli("localhost", "username", "password", "database"); if($mysqli->connect_error) { die("Connection Failed: " . $mysqli->connect_error); } $sql = "DELETE FROM users WHERE id=1"; if($mysqli->query($sql) === TRUE) { echo "Record deleted successfully."; } else { echo "Error deleting record: " . $mysqli->error; } $mysqli->close();
$dsn = "mysql:host=localhost;dbname=database"; $username = "username"; $password = "password"; try { $pdo = new PDO($dsn, $username, $password); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { echo "Connection failed: " . $e->getMessage(); } $sql = "DELETE FROM users WHERE id=1"; if($pdo->exec($sql) === TRUE) { echo "Record deleted successfully."; } else { echo "Error deleting record: " . $pdo->errorInfo()[2]; } $pdo = null;In the above examples, we are connecting to a MySQL database and deleting a record from a table named "users" where the id is 1. Both examples use PHP's built-in methods for connecting to a database and executing a SQL query to delete records from a table. They also handle any errors that may occur during the process. The package library used in the above examples is the MySQLi extension for PHP (for the first example) and PDO (for the second example).