Free reverse phone lookup google: PHP Cara Menghapus Multiple Rows dari Mysql Menggunakan Checkbox

Wednesday, August 9, 2017

PHP Cara Menghapus Multiple Rows dari Mysql Menggunakan Checkbox

Berikut adalah contoh cara menghapus beberapa baris table sehingga mempermudah user untuk melakukan pendeletetan data sesui data yang ingin dihapus.

Step 1

Kita buat table dengan nama "test_mysql" kemudian database kita kasi nama "test" (table test_mysql buat di dalam database tes).
Kemudian kita buat file dengan nama "delete_multiple.php"

Kita buat 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);

----

PHP: Cara Menghapus Multiple Rows dari Mysql Menggunakan Checkbox

Output

Kemudian kita lanjut lagi membuat file "delete_multiple.php":
----

<?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);
?>

<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
 <td>
 <form name="form1" method="post" action="">
 <table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
 
<tr>
 <td bgcolor="#FFFFFF">&nbsp;</td>
 <td colspan="4" bgcolor="#FFFFFF"><strong>Delete multiple rows in mysql</strong> </td>
</tr>
<tr>
 <td align="center" bgcolor="#FFFFFF">#</td>
 <td align="center" bgcolor="#FFFFFF"><strong>Id</strong></td>
 <td align="center" bgcolor="#FFFFFF"><strong>Name</strong></td>
 <td align="center" bgcolor="#FFFFFF"><strong>Lastname</strong></td>
 <td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td>
</tr>

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

<tr>
 <td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows[id]; ?>"></td>
 <td bgcolor="#FFFFFF"><? echo $rows[id]; ?></td>
 <td bgcolor="#FFFFFF"><? echo $rows[name]; ?></td>
 <td bgcolor="#FFFFFF"><? echo $rows[lastname]; ?></td>
 <td bgcolor="#FFFFFF"><? echo $rows[email]; ?></td>
</tr>

<?php
}
?>

<tr>
 <td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>

<?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 "<meta http-equiv="refresh" content="0;URL=delete_multiple.php">";
}
}
mysql_close();
?>
</table>

----

Output

Selamat mencoba, saya disini juga baru mencoba jadi tidak ada salahnya kalian juga mencobanya untuk menmbah wawasan pemograman PHP kamu, goodluck. :)

Refrensi: http://www.phpeasystep.com/mysql/8.html

download file now