Zurück Zum Programmierung / Coding Forum

Löschen mehrerer Kontrollkästchen Kodierung

  • kkK
  • Born
  • Born
  • No Avatar
  • Registriert: Nov 08, 2009
  • Beiträge: 1
  • Status: Offline

Beitrag November 8th, 2009, 10:40 pm

Code: [ Download ] [ Select ]
[
<?php
$host="localhost"; // Host name
$username="root"; // 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
 
  $delete = $_REQUEST['delete'];
 
  if( $delete != '' ){
 
   
 
   foreach( $checkbox as $del_id ){
 
     $sql = "DELETE FROM $tbl_name WHERE id='$del_id'";
 
     $result = mysql_query($sql);
 
   
 
   }
 
 
 
   // if successful redirect to delete_multiple.php
 
   if($result){
 
     echo "<html><head><meta HTTP-EQUIV=\"Refresh\" CONTENT=\"1; URL=delete_multiple.php\"></html>";
 
   }
 
  }
 
?>
</table>
</form>
</td>
</tr>
</table>
  1. [
  2. <?php
  3. $host="localhost"; // Host name
  4. $username="root"; // Mysql username
  5. $password=""; // Mysql password
  6. $db_name="test"; // Database name
  7. $tbl_name="test_mysql"; // Table name
  8. // Connect to server and select databse.
  9. mysql_connect("$host", "$username", "$password")or die("cannot connect");
  10. mysql_select_db("$db_name")or die("cannot select DB");
  11. $sql="SELECT * FROM $tbl_name";
  12. $result=mysql_query($sql);
  13. $count=mysql_num_rows($result);
  14. ?>
  15. <table width="400" border="0" cellspacing="1" cellpadding="0">
  16. <tr>
  17. <td><form name="form1" method="post" action="">
  18. <table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
  19. <tr>
  20. <td bgcolor="#FFFFFF">&nbsp;</td>
  21. <td colspan="4" bgcolor="#FFFFFF"><strong>Delete multiple rows in mysql</strong> </td>
  22. </tr>
  23. <tr>
  24. <td align="center" bgcolor="#FFFFFF">#</td>
  25. <td align="center" bgcolor="#FFFFFF"><strong>Id</strong></td>
  26. <td align="center" bgcolor="#FFFFFF"><strong>Name</strong></td>
  27. <td align="center" bgcolor="#FFFFFF"><strong>Lastname</strong></td>
  28. <td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td>
  29. </tr>
  30. <?php
  31. while($rows=mysql_fetch_array($result)){
  32. ?>
  33. <tr>
  34. <td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
  35. <td bgcolor="#FFFFFF"><? echo $rows['id']; ?></td>
  36. <td bgcolor="#FFFFFF"><? echo $rows['name']; ?></td>
  37. <td bgcolor="#FFFFFF"><? echo $rows['lastname']; ?></td>
  38. <td bgcolor="#FFFFFF"><? echo $rows['email']; ?></td>
  39. </tr>
  40. <?php
  41. }
  42. ?>
  43. <tr>
  44. <td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
  45. </tr>
  47. <?php
  48.  
  49.   // Check if delete button active, start this
  50.  
  51.   $delete = $_REQUEST['delete'];
  52.  
  53.   if( $delete != '' ){
  54.  
  55.    
  56.  
  57.    foreach( $checkbox as $del_id ){
  58.  
  59.      $sql = "DELETE FROM $tbl_name WHERE id='$del_id'";
  60.  
  61.      $result = mysql_query($sql);
  62.  
  63.    
  64.  
  65.    }
  66.  
  67.  
  68.  
  69.    // if successful redirect to delete_multiple.php
  70.  
  71.    if($result){
  72.  
  73.      echo "<html><head><meta HTTP-EQUIV=\"Refresh\" CONTENT=\"1; URL=delete_multiple.php\"></html>";
  74.  
  75.    }
  76.  
  77.   }
  78.  
  79. ?>
  80. </table>
  81. </form>
  82. </td>
  83. </tr>
  84. </table>


i need help....
  • Anonymous
  • Bot
  • No Avatar
  • Registriert: 25 Feb 2008
  • Beiträge: ?
  • Loc: Ozzuland
  • Status: Online

Beitrag November 8th, 2009, 10:40 pm

Beitrag November 10th, 2009, 12:49 am

Was brauchen Sie Hilfe? Bitte etwas konkreter.
RewriteEngine On

RewriteRule ^(awesome|excellent|extraordinary)$ RT

Seite 1 von 1

Buchung Informationen

  • Beiträge in diesem Thema: 2 Beiträge
  • Mitglieder in diesem Forum: 0 Mitglieder und 104 Gäste
  • Du darfst keine neuen Themen in diesem Forum erstellen.
  • Du darfst keine Antworten zu Themen in diesem Forum erstellen.
  • Du darfst deine Beiträge in diesem Forum nicht ändern.
  • Du darfst deine Beiträge in diesem Forum nicht löschen.
  • Du darfst keine Dateianhänge in diesem Forum erstellen.
 
 

© 2010 Unmelted, LLC. Angetrieben durch phpBB © 2010 phpBB Group.