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");
?>
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
List of companies ..
1. Google USA edit delete
2. Apple USA edit delete
3. Microsoft USA edit delete
4. Oracle USA edit delete