RE: [SPAM] Delete the Multiple Check Box using php+mysql

["Carlo Post \(prive\)" <C.Post10@xxxxxxxxxxxx>]

Hello Gopi,

The key value of your database record should be in the field name of your checkbox (<INPUT NAME='delkey[keyVal]' TYPE='checkbox' ...>.)

When submitting, an array $_POST['delkey'] will be existent if any checkboxes are selected or no array if no checkboxes are selected

In the check on submit, following thing should be done

$delKeys    =    $_POST['delkey']
if (isset($delKeys) && is_array($delKeys) && count($delKeys) > 0) {
    foreach ($delKeys as $keyId => $keyVal) {
      /* Delete clausule*/
   }
}

Best Rgds

Carlo Post
Burg. van Tuyllkade 98
NL 3553 AM  Utrecht - Netherlands
tel. +31(0)30-2441339
mailto:C.Post10@xxxxxxxxxxxx 

  -----Original Message-----
  From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx]On Behalf Of gopi nath
  Sent: zaterdag 2 augustus 2008 15:49
  To: php-objects@xxxxxxxxxxxxxxx
  Subject: [SPAM] Delete the Multiple Check Box using php+mysql


  HI Friends,

   i have a doubt in my script. my error is: cannot delete the multiple rows.
  <?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>

  <?

  // 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>

  </form>

  </td>

  </tr>
  </body>
  </html>

  Add more friends to your messenger and enjoy! Go to http://in.messenger.yahoo.com/invite/

  [Non-text portions of this message have been removed]



   

[Non-text portions of this message have been removed]