Delete multiple rows from mysql with checkbox.

Delete multiple rows from mysql with checkbox.

Syntax

“DELETE FROM table_name WHERE column_name = ‘value’ “;

Overview

In this tutorial create 1 file
1. delete_multiple.php

Step
1. Create table”test_mysql” in database “test”.
2. Create file delete_multiple.php.

Create table “test_mysql”

CREATE TABLE `test_mysql` (
`id` int(4) NOT NULL auto_increment,
`name` varchar(65) NOT NULL default ”,
`lastname` varchar(65) NOT NULL default ”,
`email` varchar(65) NOT NULL default ”,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;

— Dumping data for table `test_mysql`
INSERT INTO `test_mysql` VALUES (1, ‘Billly’, ‘Blueton’, ‘bb5@phpeasystep.com’);
INSERT INTO `test_mysql` VALUES (2, ‘Jame’, ‘Campbell’, ‘jame@somewhere.com’);
INSERT INTO `test_mysql` VALUES (3, ‘Mark’, ‘Jackson’, ‘mark@phpeasystep.com’);
INSERT INTO `test_mysql` VALUES (4, ‘Linda’, ‘Travor’, ‘lin65@phpeasystep.com’);
INSERT INTO `test_mysql` VALUES (5, ‘Joey’, ‘Ford’, ‘fordloi@somewhere.com’);
INSERT INTO `test_mysql` VALUES (6, ‘Sidney’, ‘Gibson’, ‘gibson@phpeasystep.com’);

Create file delete_multiple.php

View in browser

############### Code
<?php
$host=”localhost”; // Host name
$username=””; // Mysql username
$password=””; // Mysql password
$db_name=”test”; // Database name
$tbl_name=”test_mysql”; // Table name

// Connect to server and select databse.
mysql_connect(“$host”, “$username”, “$password”)or die(“cannot connect”);
mysql_select_db(“$db_name”)or die(“cannot select DB”);

$sql=”SELECT * FROM $tbl_name”;
$result=mysql_query($sql);

$count=mysql_num_rows($result);

?>

<?php
while($rows=mysql_fetch_array($result)){
?>

<?php
}
?>

<?php

// Check if delete button active, start this
if($delete){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = “DELETE FROM $tbl_name WHERE id=’$del_id'”;
$result = mysql_query($sql);
}

// if successful redirect to delete_multiple.php
if($result){
echo “”;
}
}
mysql_close();
?>

  Delete multiple rows in mysql
# Id Name Lastname Email
<input name="checkbox[]" type="checkbox" id="checkbox[]" value="“>

Iklan

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout /  Ubah )

Foto Google+

You are commenting using your Google+ account. Logout /  Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout /  Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout /  Ubah )

w

Connecting to %s