Delete / Remove Records In Database Table: PHP & MySQL

Video tutorial demonstrates deleting / removing of data / records from the database table.

First look at these short videos:
Connect to the database
Simple / basic insertion operation
Insertion of Records into Database using Forms: PHP & MySQL (important)
SELECT / LIST Records From Database Table: PHP & MySQL
UPDATE / EDIT Records In Database Table: PHP & MySQL

SELECTING and Displaying Data
index.php

< ?php
 include_once('db.php');

 if(isset($_POST['name']))
 {
   $name = $_POST['name'];

   if(mysql_query("INSERT INTO apple VALUES('','$name')"))
  echo "Successful Insertion!";
   else
  echo "Please try again";
 }


 $res = mysql_query("SELECT * FROM apple");


?>







List of companies ..

    < ?php while( $row = mysql_fetch_array($res) ) echo "
  • $row[id].
  • $row[name]
  • edit
  • delete

  • "; ?>

Some CSS styling for simple / basic presentation: CSS Hover Over Effect

We have added delete link beside each record.

Deleting Records From Database Table

< ?php
 include_once('db.php');

 if( isset($_GET['del']) )
 {
  $id = $_GET['del'];
  $sql= "DELETE FROM apple WHERE id='$id'";
  $res= mysql_query($sql) or die("Failed".mysql_error());
  echo "";
 }
?>

Here we receive the value of id, passed from index.php and assign it to a local variable called $id.
Then using simple DELETE query, we delete the records associated with the id.

Video Tutorial: Delete / Remove Records In Database Table: PHP & MySQL



YouTube Link: https://www.youtube.com/watch?v=ByaECx2mj9M [Watch the Video In Full Screen.]



List of companies ..
1. Google USA edit delete
2. Apple USA edit delete
3. Microsoft USA edit delete
4. Oracle USA edit delete