What is the correct syntax for deleting MySQL data in PHP?

To delete MySQL data in PHP, you can use the DELETE statement in a SQL query. Make sure to connect to your MySQL database using mysqli or PDO, and then execute the DELETE query to remove the desired data from the table. Remember to include a WHERE clause to specify the condition for which rows to delete. 

<?php
// Connect to MySQL database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Delete data from table
$sql = "DELETE FROM table_name WHERE condition";
if ($conn->query($sql) === TRUE) {
    echo "Record deleted successfully";
} else {
    echo "Error deleting record: " . $conn->error;
}

$conn->close();
?>

Keywords

PHP MySQL delete syntax data

Related Questions