Did you know?

if you register at Hamid School you can save up to 45% on hosting packages offered by Surreyhost.com .

Don't miss out, every minute counts!

Register now!

Are you Confused? Click here to learn how to use hamid school

PHP MySQL Delete From

The DELETE FROM statement is used to delete rows from a database table.

Delete Data In a Database

The DELETE FROM statement is used to delete records from a database table.

Syntax

DELETE FROM table_name
WHERE column_name = some_value

To get PHP to execute the statement above we must use the mysql_query() function. This function is used to send a query or command to a MySQL connection.

Example

Earlier in the tutorial we created a table named "Person". Here is how it looks:

The following example deletes all the records in the "Person" table where LastName='Griffin':

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

mysql_query("DELETE FROM Person WHERE LastName='Griffin'");

mysql_close($con);
?>

After the deletion, the table will look like this:

• Introduction to PHP
• PHP Installation
• PHP Syntax
• PHP Variables
• PHP String
• PHP Operators
• PHP If...Else Statements
• PHP Switch Statement
• PHP Arrays
• PHP Looping
• PHP Functions
• PHP Forms and User Input
• PHP $_GET
• PHP $_POST
• PHP Date
• PHP Include File
• PHP File Handling
• PHP File Upload
• PHP Cookies
• PHP Sessions
• PHP Sending E-mails
• PHP Secure E-mails
• PHP Error Handling
• PHP Exception Handling
• PHP Filter
• PHP MySQL Introduction
• PHP MySQL Connect to a Database
• PHP MySQL Create Database and Tables
• PHP MySQL Insert Into
• PHP MySQL Select
• PHP MySQL The Where Clause
• PHP MySQL Order By Keyword
• PHP MySQL Update
• PHP Database ODBC

Did you know?

if you register at Hamid School you can learn web programming and designing for free and also you can save up to 45% on hosting packages offered by Surreyhost.com .

Don't miss out, every minute counts!

Register now!