Re: [PHP] Deleting multiple items from database using checkboxes

2002-10-07 Thread Marco Tabini 

Try WHERE EntryID IN ( . implode ($dele, ',') . )

However:

1) Anybody could fake a form post or query url to delete any data in
your database
2) It would also be possible to create a more dangerous post that could
give the attacker control over your entire database

Thus, I assume that you will want to put a *lot* of checking around that
code!


Marco

On Mon, 2002-10-07 at 16:05, Davy Obdam wrote:
 Hi people,.
 
 I have a guestbook admin page were i would like to delete one item or
 more items from the database if necessary. I have modified my normal
 guestbookpage so that it has checkboxes in front of every entry. This is
 my code:
 
 input type=\checkbox\ name=\dele[]\ value=\.$sql['entryID'].\
 
 Now i can select multiple items. But i have tried to delete em, but it
 only deletes one item from the database, my query looks like this :
 DELETE  FROM gastenboek WHERE entryID=$dele . Can anyone help me. Thanks
 for your time.
 
 
 Best regards,
  
 Davy Obdam,
 mailto:[EMAIL PROTECTED]
 
 
 
 -- 
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Deleting multiple items from database using checkboxes

2002-10-07 Thread Ing. Raúl González Rodríguez 

You can use the following code to delete multiple items:

  if(isset($dele)  (count($dele)  0)) {
 $sql = delete from gastenboek where (entryID='$dele[0]');
 for($i=1; $icount($dele); $i++)
  $sql .=  or (entryID='$dele[$i]');
 $res = mysql_query($sql, $connection);
  }

Raul

- Original Message -
From: Davy Obdam [EMAIL PROTECTED]
To: Php Mailinglist [EMAIL PROTECTED]; Php-Windows Mailing
[EMAIL PROTECTED]
Sent: Monday, October 07, 2002 4:05 PM
Subject: [PHP] Deleting multiple items from database using checkboxes


 Hi people,.

 I have a guestbook admin page were i would like to delete one item or
 more items from the database if necessary. I have modified my normal
 guestbookpage so that it has checkboxes in front of every entry. This is
 my code:

 input type=\checkbox\ name=\dele[]\ value=\.$sql['entryID'].\

 Now i can select multiple items. But i have tried to delete em, but it
 only deletes one item from the database, my query looks like this :
 DELETE  FROM gastenboek WHERE entryID=$dele . Can anyone help me. Thanks
 for your time.


 Best regards,

 Davy Obdam,
 mailto:[EMAIL PROTECTED]



 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php





-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Deleting multiple items from database using checkboxes

2002-10-07 Thread John W. Holmes 

I think someone already mentioned this, but you can also do this:

if(isset($dele)  count($dele)  0)
{
  $ids = ' . implode(',',$dele) . ';
  $sql = delete from gastenboek where entryID IN ($ids);
  $result = mysql_query($sql);
}

might want to add in a is_array() somewhere in there...

---John Holmes...

 -Original Message-
 From: Ing. Raúl González Rodríguez [mailto:[EMAIL PROTECTED]]
 Sent: Monday, October 07, 2002 4:48 PM
 To: Php Mailinglist; Php-Windows Mailing
 Subject: Re: [PHP] Deleting multiple items from database using
checkboxes
 
 You can use the following code to delete multiple items:
 
   if(isset($dele)  (count($dele)  0)) {
  $sql = delete from gastenboek where (entryID='$dele[0]');
  for($i=1; $icount($dele); $i++)
   $sql .=  or (entryID='$dele[$i]');
  $res = mysql_query($sql, $connection);
   }
 
 Raul
 
 - Original Message -
 From: Davy Obdam [EMAIL PROTECTED]
 To: Php Mailinglist [EMAIL PROTECTED]; Php-Windows
Mailing
 [EMAIL PROTECTED]
 Sent: Monday, October 07, 2002 4:05 PM
 Subject: [PHP] Deleting multiple items from database using checkboxes
 
 
  Hi people,.
 
  I have a guestbook admin page were i would like to delete one item
or
  more items from the database if necessary. I have modified my normal
  guestbookpage so that it has checkboxes in front of every entry.
This is
  my code:
 
  input type=\checkbox\ name=\dele[]\
value=\.$sql['entryID'].\
 
  Now i can select multiple items. But i have tried to delete em, but
it
  only deletes one item from the database, my query looks like this :
  DELETE  FROM gastenboek WHERE entryID=$dele . Can anyone help me.
Thanks
  for your time.
 
 
  Best regards,
 
  Davy Obdam,
  mailto:[EMAIL PROTECTED]
 
 
 
  --
  PHP General Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net/unsub.php
 
 
 
 
 
 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php




--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php