Deleting Existing Rows in PHP

Q

How To Delete Existing Rows in a Table in PHP?

✍: FYIcenter.com

A

If you want to remove a row from a table, you can use the DELETE statement with a WHERE clause to identify the row. The following sample script deletes one row:

<?php
  include "mysql_connection.php";

  $sql = "DELETE FROM fyi_links WHERE id = 1102";
  if (mysql_query($sql, $con)) {
    print(mysql_affected_rows() . " rows deleted.\n");
  } else {
    print("SQL statement failed.\n");
  }

  mysql_close($con); 
?>

If you run this script, you will get something like this:

1 rows deleted.

 

Working with MySQL Database in PHP

⇒⇒PHP Tutorials

2016-10-19, 244👍, 0💬