//Connect to database $servername = "localhost"; $username = "username"; $password = "password"; $dbname = "database_name"; $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } //Delete record from user table $sql = "DELETE FROM users WHERE id=1"; if ($conn->query($sql) === TRUE) { echo "Record deleted successfully"; } else { echo "Error deleting record: " . $conn->error; } //Close connection $conn->close();
//Connect to database $servername = "localhost"; $username = "username"; $password = "password"; $dbname = "database_name"; $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } //Delete records from user table based on condition $sql = "DELETE FROM users WHERE age < 18"; if ($conn->query($sql) === TRUE) { echo "Records deleted successfully"; } else { echo "Error deleting records: " . $conn->error; } //Close connection $conn->close();The PHP Controller Delete feature is commonly used in conjunction with database libraries such as MySQLi or PDO, which provide a wide range of database management functions.