How to update and delete data in php?

Delete Data From a MySQL Table Using MySQLi and PDO

The DELETE statement is used to delete records from a table:

DELETE FROM table_name
WHERE some_column = some_value

Notice the WHERE clause in the DELETE syntax: The WHERE clause specifies which record or records that should be deleted. If you omit the WHERE clause, all records will be deleted!

To learn more about SQL, please visit our SQL tutorial.

Let's look at the "MyGuests" table:

The following examples delete the record with id=3 in the "MyGuests" table:

Example (MySQLi Object-oriented)

$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}

// sql to delete a record
$sql = "DELETE FROM MyGuests WHERE id=3";

if ($conn->query($sql) === TRUE) {
  echo "Record deleted successfully";
} else {
  echo "Error deleting record: " . $conn->error;
}

$conn->close();
?>

Example (MySQLi Procedural)

$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
  die("Connection failed: " . mysqli_connect_error());
}

// sql to delete a record
$sql = "DELETE FROM MyGuests WHERE id=3";

if (mysqli_query($conn, $sql)) {
  echo "Record deleted successfully";
} else {
  echo "Error deleting record: " . mysqli_error($conn);
}

mysqli_close($conn);
?>

Example (PDO)

$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDBPDO";

try {
  $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
  // set the PDO error mode to exception
  $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

  // sql to delete a record
  $sql = "DELETE FROM MyGuests WHERE id=3";

  // use exec() because no results are returned
  $conn->exec($sql);
  echo "Record deleted successfully";
} catch(PDOException $e) {
  echo $sql . "
" . $e->getMessage();
}

$conn = null;
?>

After the record is deleted, the table will look like this:

How to insert update delete record using php and mysql. In this tutorial we will show you step by step how to insert update delete record using php and mysql.

As well as you can use this insert update delete in php with source code to personally and professinally.

Use the following steps to select insert update delete record using PHP and MySQL:

• DB.PHP – Connecting Database
• Insert.PHP – Insert Records Into MySQL DB
• Select.php – Select Record From MySQL DB
• Update.php – Update Record Into MySQL DB
• Delete.php – Delete Record From MySQL DB

In this example post will use the following SQL query to Select, insert, update, and delete records from MySQL Database Table in PHP.

• In starting, we will create MySQL database connection file in PHP.
  • Will use mysqli_connect() function to connecting database with PHP.
• Then will use “SELECT FROM” SQL query to select a record from the MySQL database.
• Then “INSERT INTO” SQL query to insert record into the MySQL database.
• After that, “Update” SQL query to update the record into the MySQL database.
• Finally, “DELETE From” SQL query to delete record into MySQL database.
• As well as will use mysqli_query() function for run sql queries.

1 – DB.PHP – Connecting Database

First of all, Create db.php file to connecting mysql database with PHP:

2 – Insert.PHP – Insert Records Into MySQL DB

Then, Create a new file named insert.php and add the following code into insert.php:

Note that, The SQL INSERT statement will insert record in MySQL database using PHP function.

3 – Select.php – Select Record From MySQL DB

Then, create a new file named Select.php and add the following code into selete.php:

";
    echo "Firstname = ".$data['firstname']."
";
    echo "Lastname = ".$data['lastname']."
";
    echo "Mobile = ".$data['mobile']."
";
}
?>

Note that, The SQL SELECT statement will SELECT record FROM MySQL database using PHP function.

If you want to select limited records from MySQL database, you can use LIMIT clause with SQL query like following:

$sql = "SELECT * FROM users Limit 10";

Or, if you want to fetch record with ascending or descending order. So, you can use ASC OR DESC with SQL query.

4 – Update.php – Update Record Into MySQL DB

Now, you can modify database table records using SQL “UPDATE “ statement query. 

So, Create a new file named Update.php and add the following code into update.php:

5 – Delete.php – Delete Record From MySQL DB

If you want to delete some records or all records from database, you can use DELETE SQL statement with PHP.

So, Create a new file named Delete.php and add the following code into delete.php:

Recommended PHP Posts

How edit and delete data from database in PHP?

How delete all data from database in PHP?

How do I edit a form in PHP?

How do I update phpmyadmin data?