phpeveryday.com

The best tutorial of php, php framework, php strategies, object oriented oriented,


PHP MySQL: Deleting data

Tag: mysql, database, data, delete   Category: PHP Database
post: 03 Mar 2008 read: 1,392


php mysql basic step by step tutorial - part 14:In deleting the data, use the sintaks as follow:

DELETE FROM name_table WHERE condition1,condition2,...
As for example, we will add menu to delete the data in table edit data such as: 

echo ("<td><a href=\"delete.php?id=$row[employees_number]\">Delete</a></td></tr>")
php mysql delete link

Delete menu will bring the program into delete.php file where it is used to delete the data which have been selected in the above form. Delete.php file as follow:


<?
//delete.php
include "db.inc.php";
$order = "DELETE FROM data_employees 
          WHERE employees_number='$id'";
mysql_query($order);
header("location:edit.php");
?>


Series this article:
PHP MySQL: Connecting to Database Use mysql_connect()
PHP MySQL: Making Database Use mysql_create_db()
PHP MySQL: Making Table
PHP MySQL: The Data Type of Field
PHP MySQL: Char and Varchar Data Type
PHP MySQL: Data Type of Date
PHP MySQL: MySQL Syntax Orders
PHP MySQL: Inserting Data
PHP MySQL: Creating Form Insert Data
PHP MySQL: Display Data
PHP MySQL: mysql_fetch_row() Function
PHP MySQL: mysql_fetch_array() Function
PHP MySQL: Editing data
PHP MySQL: Deleting data
PHP MySQL: Adding Field Table
PHP MySQL: Editing Field Table
PHP MySQL: Deleting Field Table

| Give Your Opinion | Recommend
Share and Bookmark to: These icons link to social bookmarking sites where readers can share and discover new web pages.
digg del.icio.us technorati Ma.gnolia BlinkList

Recommended articles by other readers:
Web Services: How PHP Kiss VB.NET? (Part 1)
Chart: How to Build Cool Animation Real Time Chart
Joomla: Fast Road to Understand Component Programming
Email: Send Attachement Mail
mod_rewrite - Part 1: create your "fantasy" URL

What do You Think?
Your Name *:
Email *:
(Will not be published)
Website/URL:
Your Comment *:
* Required


615
posting