RE: [PHP] Deleting multiple items from database using checkboxes
| From: | John W. Holmes | Date: | Tue, 08 Oct 2002 00:02:12 +0000 |
| Subject: | RE: [PHP] Deleting multiple items from database using checkboxes | ||
| References: | 1 | Groups: | php.general php.windows |
| Request: | Send a blank email to php-general+get-119167@lists.php.net to get a copy of this message | ||
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:raul@mtz.jovenclub.cu]
> 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; $i<count($dele); $i++)
> $sql .= " or (entryID='$dele[$i]')";
> $res = mysql_query($sql, $connection);
> }
>
> Raul
>
> ----- Original Message -----
> From: "Davy Obdam" <info@davyobdam.com>
> To: "Php Mailinglist" <php-general@lists.php.net>; "Php-Windows
Mailing"
> <php-windows@lists.php.net>
> 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:info@davyobdam.com
> >
> >
> >
> > --
> > 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