xtreme_paranoid 0 Report post Posted April 19, 2012 Salam semua..sorry kalau soalan macam budak2 Dah google abes, still stuck. Harap ade yang kat sini boleh bantu. Aku ade buat satu sistem, data sume blh masuk database Tapi masalahnye bile nak delete.. Aku nak die blh show sume data tu, then ade checkbox yg kita boleh tanda Then tekan butang delete, data tu hilang Maknanya boleh delete beberapa row/data dalam satu masa.. Nih gambar die: http://www.diigo.com/item/image/1aptd/xe8p Coding yang aku pakai plak: [CODE] <?php $host="localhost"; // Host name $username="skem"; // Mysql username $password="skem"; // Mysql password $db_name="skem"; // Database name $tbl_name="admin"; // 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"> </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['P_Id']; ?>"></td> <td bgcolor="#FFFFFF"><? echo $rows['P_Id']; ?></td> <td bgcolor="#FFFFFF"><? echo $rows['username']; ?></td> <td bgcolor="#FFFFFF"><? echo $rows['password']; ?></td> <td bgcolor="#FFFFFF"><? echo $rows['usertype']; ?></td> </tr> <?php } ?> <tr> <td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td> </tr> <? // 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=aduseradd.php\">"; } } mysql_close(); ?> </table> </form> </td> </tr> </table> [/CODE] Coding nih based ape yang aku jumpe kat http://www.phpeasystep.com/mysql/8.html Harap ade sape2 yang expert tuh, bantu la ea. Thanks in advance Quote Share this post Link to post Share on other sites
akubudakbaik 0 Report post Posted May 8, 2012 [php] if(isset($_POST['delete'])) { $checkbox = $_POST['checkbox']; for($i=0;$i<count($checkbox);$i++) { $del_id = $checkbox[$i]; $sql = "DELETE FROM $tbl_name WHERE id='$del_id'"; $result = mysql_query($sql); } [/php] Quote Share this post Link to post Share on other sites
sinta7 0 Report post Posted May 22, 2012 Hope Working... Code not test yet.. [CODE] if(isset($_POST['delete'])) { $id_array= $_POST['checkbox']; $id = implode(" ",$id_array); $sql = "DELETE FROM $tbl_name WHERE id IN(".$id.")"; $result = mysql_query($sql); } [/CODE] Quote Share this post Link to post Share on other sites