Re: [PHP-DB] Checkboxes to gather rows to delete
- Original Message -
From: "Lewis Watson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 24, 2003 9:35 AM
Subject: [PHP-DB] Checkboxes to gather rows to delete
> I have a mysql database with a table using one column as a primary key.
> (rowID). On a php page I use a query to list all of the rows of the
table
> and have a checkbox beside each row that should be used to check if you
> would like to delete this row. Can someone give me an example using post
> to pull the boxes that need to be deleted.
> Thanks!
> Lewis
I appreciate everyones help. Below what I ended up with to actually delete
the checked boxes.
Lewis
// Deletes specified rows by teacherID.
if(isset($delete_teacher) && isset($deleteID)) {
while (list($key, $num)= each($_POST[deleteID])){
$delete_query = mysql_query("delete from
teacher where teacherID = $num");
print $delete_query;
print "";
}
}
//Checkbox and Submit lines...
print "";
print "";
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Checkboxes to gather rows to delete
> I think the problem is that I need to put the array into a comma delimited
> group
> Lewis
U... that's what IMPLODE does. It will take the array and turn it into a
comma separated list. Your having a problem because you're not passing an
array when you think you are.
---John Holmes...
> - Original Message -
> From: "John W. Holmes" <[EMAIL PROTECTED]>
> To: "'Lewis Watson'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Monday, February 24, 2003 11:09 AM
> Subject: RE: [PHP-DB] Checkboxes to gather rows to delete
>
>
> > > Hi there,
> > > I have double checked the column namesIts giving me a Warning: Bad
> > > arguments to implode() error
> > > Thanks.
> > > Lewis
> >
> > What's the code you're using? Are you sure $deleteID is an array at the
> > point you call implode()? Are you sure it's available in the current
> > scope at the point you call implode()?
> >
> > ---John W. Holmes...
> >
> > PHP Architect - A monthly magazine for PHP Professionals. Get your copy
> > today. http://www.phparch.com/
> >
> > >
> > > - Original Message -----
> > > From: "1LT John W. Holmes" <[EMAIL PROTECTED]>
> > > To: "Lewis Watson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > > Sent: Monday, February 24, 2003 10:36 AM
> > > Subject: Re: [PHP-DB] Checkboxes to gather rows to delete
> > >
> > >
> > > > > Thanks. The below code returns each ID in an array like so...
> > > > > Array ( [0] =>101 [1] => 201 ). Thanks for the help!
> > > > > Lewis
> > > > >
> > > > > $teacherID = $_POST[teacherID];
> > > > > $deleteID = $_POST[deleteID];
> > > > >
> > > > > if(isset($delete_teacher)) {
> > > > > This is where I should loop through checking for the chosen
> > ones
> > > to
> > > > > delete.
> > > >
> > > > $query = "DELETE FROM table WHERE teacherID IN (" .
> > > implode(',',$deleteID) .
> > > > ")";
> > > > mysql_query($query);
> > > >
> > > > > }
> > > > >
> > > > >
> > > > > print " > > > > value=\"$row[teacherID]\">";
> > > > > print " > value=\"Delete
> > > the
> > > > > Checked Teachers\">";
> > > >
> > > > Make sure the column names are correct, but that's it.
> > > >
> > > > ---John Holmes...
> > > >
> > > >
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Checkboxes to gather rows to delete
I think the problem is that I need to put the array into a comma delimited
group
Lewis
- Original Message -
From: "John W. Holmes" <[EMAIL PROTECTED]>
To: "'Lewis Watson'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, February 24, 2003 11:09 AM
Subject: RE: [PHP-DB] Checkboxes to gather rows to delete
> > Hi there,
> > I have double checked the column namesIts giving me a Warning: Bad
> > arguments to implode() error
> > Thanks.
> > Lewis
>
> What's the code you're using? Are you sure $deleteID is an array at the
> point you call implode()? Are you sure it's available in the current
> scope at the point you call implode()?
>
> ---John W. Holmes...
>
> PHP Architect - A monthly magazine for PHP Professionals. Get your copy
> today. http://www.phparch.com/
>
> >
> > - Original Message -
> > From: "1LT John W. Holmes" <[EMAIL PROTECTED]>
> > To: "Lewis Watson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > Sent: Monday, February 24, 2003 10:36 AM
> > Subject: Re: [PHP-DB] Checkboxes to gather rows to delete
> >
> >
> > > > Thanks. The below code returns each ID in an array like so...
> > > > Array ( [0] =>101 [1] => 201 ). Thanks for the help!
> > > > Lewis
> > > >
> > > > $teacherID = $_POST[teacherID];
> > > > $deleteID = $_POST[deleteID];
> > > >
> > > > if(isset($delete_teacher)) {
> > > > This is where I should loop through checking for the chosen
> ones
> > to
> > > > delete.
> > >
> > > $query = "DELETE FROM table WHERE teacherID IN (" .
> > implode(',',$deleteID) .
> > > ")";
> > > mysql_query($query);
> > >
> > > > }
> > > >
> > > >
> > > > print " > > > value=\"$row[teacherID]\">";
> > > > print " value=\"Delete
> > the
> > > > Checked Teachers\">";
> > >
> > > Make sure the column names are correct, but that's it.
> > >
> > > ---John Holmes...
> > >
> > >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Checkboxes to gather rows to delete
> Hi there,
> I have double checked the column namesIts giving me a Warning: Bad
> arguments to implode() error
> Thanks.
> Lewis
What's the code you're using? Are you sure $deleteID is an array at the
point you call implode()? Are you sure it's available in the current
scope at the point you call implode()?
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/
>
> - Original Message -
> From: "1LT John W. Holmes" <[EMAIL PROTECTED]>
> To: "Lewis Watson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Monday, February 24, 2003 10:36 AM
> Subject: Re: [PHP-DB] Checkboxes to gather rows to delete
>
>
> > > Thanks. The below code returns each ID in an array like so...
> > > Array ( [0] =>101 [1] => 201 ). Thanks for the help!
> > > Lewis
> > >
> > > $teacherID = $_POST[teacherID];
> > > $deleteID = $_POST[deleteID];
> > >
> > > if(isset($delete_teacher)) {
> > > This is where I should loop through checking for the chosen
ones
> to
> > > delete.
> >
> > $query = "DELETE FROM table WHERE teacherID IN (" .
> implode(',',$deleteID) .
> > ")";
> > mysql_query($query);
> >
> > > }
> > >
> > >
> > > print " > > value=\"$row[teacherID]\">";
> > > print " the
> > > Checked Teachers\">";
> >
> > Make sure the column names are correct, but that's it.
> >
> > ---John Holmes...
> >
> >
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Checkboxes to gather rows to delete
On Monday 24 February 2003 23:57, George Pitcher wrote: > Can I raise a point of principle here. > > My databases never have records deleted - instead they are marked as being > deleted in a status field. That way, they are always there for reference. > > Unless you are running a system that needs the space or has extremely high > turnover of deleted records, this makes sesne. Better still, setup parallel tables and move deleted records over. That way you'll save cluttering up the main tables. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* A diplomat's life consists of three things: protocol, Geritol, and alcohol. -- Adlai Stevenson */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Checkboxes to gather rows to delete
Hi there,
I have double checked the column namesIts giving me a Warning: Bad
arguments to implode() error
Thanks.
Lewis
- Original Message -
From: "1LT John W. Holmes" <[EMAIL PROTECTED]>
To: "Lewis Watson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, February 24, 2003 10:36 AM
Subject: Re: [PHP-DB] Checkboxes to gather rows to delete
> > Thanks. The below code returns each ID in an array like so...
> > Array ( [0] =>101 [1] => 201 ). Thanks for the help!
> > Lewis
> >
> > $teacherID = $_POST[teacherID];
> > $deleteID = $_POST[deleteID];
> >
> > if(isset($delete_teacher)) {
> > This is where I should loop through checking for the chosen ones
to
> > delete.
>
> $query = "DELETE FROM table WHERE teacherID IN (" .
implode(',',$deleteID) .
> ")";
> mysql_query($query);
>
> > }
> >
> >
> > print " > value=\"$row[teacherID]\">";
> > print " > Checked Teachers\">";
>
> Make sure the column names are correct, but that's it.
>
> ---John Holmes...
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Checkboxes to gather rows to delete
> Thanks. The below code returns each ID in an array like so...
> Array ( [0] =>101 [1] => 201 ). Thanks for the help!
> Lewis
>
> $teacherID = $_POST[teacherID];
> $deleteID = $_POST[deleteID];
>
> if(isset($delete_teacher)) {
> This is where I should loop through checking for the chosen ones to
> delete.
$query = "DELETE FROM table WHERE teacherID IN (" . implode(',',$deleteID) .
")";
mysql_query($query);
> }
>
>
> print " value=\"$row[teacherID]\">";
> print " Checked Teachers\">";
Make sure the column names are correct, but that's it.
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Checkboxes to gather rows to delete
Thanks. The below code returns each ID in an array like so...
Array ( [0] =>101 [1] => 201 ). Thanks for the help!
Lewis
$teacherID = $_POST[teacherID];
$deleteID = $_POST[deleteID];
if(isset($delete_teacher)) {
This is where I should loop through checking for the chosen ones to
delete.
}
print "";
print "";
- Original Message -
From: "1LT John W. Holmes" <[EMAIL PROTECTED]>
To: "Lewis Watson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, February 24, 2003 10:21 AM
Subject: Re: [PHP-DB] Checkboxes to gather rows to delete
> > Thats just it. I am just not sure what to do with the array before my
> > "delete from" query now that I have it :-)
> > Thanks...
> > Lewis
>
> You don't have to do anything with it, just throw it into the line that
I
> gave you. Show the code you have now and someone can help you put it all
> together.
>
> ---John Holmes...
>
> > - Original Message -
> > From: "1LT John W. Holmes" <[EMAIL PROTECTED]>
> > To: "Lewis Watson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > Sent: Monday, February 24, 2003 10:13 AM
> > Subject: Re: [PHP-DB] Checkboxes to gather rows to delete
> >
> >
> > > > I appreciate all of the quick replies. I do have globals off.
> > Currently, I
> > > > have the values for each ID being returned in a array Array
( [0]
> > =>
> > > > 101 [1] => 201 ) where 101 and 201 were the id's of the rows I
> > checked. I
> > > > have to say I like the way of doing it that Mathieu has shown
using
> > the
> > > > explode function.
> > > > Thanks again.
> > > > Lewis
> > >
> > > You already have an array of IDs you want to delete. Explode is for
> > making
> > > arrays, so what would you use it on? That doesn't make sense.
> > >
> > > $query = "DELETE FROM table WHERE rowID IN (" .
> > > implode(',',$_POST['id_array']) . ")";
> > >
> > > is the most efficient, easiest solution, but use whatever you
> > understand.
> > >
> > > ---John Holmes...
> > >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Checkboxes to gather rows to delete
> Thats just it. I am just not sure what to do with the array before my
> "delete from" query now that I have it :-)
> Thanks...
> Lewis
You don't have to do anything with it, just throw it into the line that I
gave you. Show the code you have now and someone can help you put it all
together.
---John Holmes...
> - Original Message -
> From: "1LT John W. Holmes" <[EMAIL PROTECTED]>
> To: "Lewis Watson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Monday, February 24, 2003 10:13 AM
> Subject: Re: [PHP-DB] Checkboxes to gather rows to delete
>
>
> > > I appreciate all of the quick replies. I do have globals off.
> Currently, I
> > > have the values for each ID being returned in a array Array ( [0]
> =>
> > > 101 [1] => 201 ) where 101 and 201 were the id's of the rows I
> checked. I
> > > have to say I like the way of doing it that Mathieu has shown using
> the
> > > explode function.
> > > Thanks again.
> > > Lewis
> >
> > You already have an array of IDs you want to delete. Explode is for
> making
> > arrays, so what would you use it on? That doesn't make sense.
> >
> > $query = "DELETE FROM table WHERE rowID IN (" .
> > implode(',',$_POST['id_array']) . ")";
> >
> > is the most efficient, easiest solution, but use whatever you
> understand.
> >
> > ---John Holmes...
> >
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Checkboxes to gather rows to delete
Thats just it. I am just not sure what to do with the array before my
"delete from" query now that I have it :-)
Thanks...
Lewis
- Original Message -
From: "1LT John W. Holmes" <[EMAIL PROTECTED]>
To: "Lewis Watson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, February 24, 2003 10:13 AM
Subject: Re: [PHP-DB] Checkboxes to gather rows to delete
> > I appreciate all of the quick replies. I do have globals off.
Currently, I
> > have the values for each ID being returned in a array Array ( [0]
=>
> > 101 [1] => 201 ) where 101 and 201 were the id's of the rows I
checked. I
> > have to say I like the way of doing it that Mathieu has shown using
the
> > explode function.
> > Thanks again.
> > Lewis
>
> You already have an array of IDs you want to delete. Explode is for
making
> arrays, so what would you use it on? That doesn't make sense.
>
> $query = "DELETE FROM table WHERE rowID IN (" .
> implode(',',$_POST['id_array']) . ")";
>
> is the most efficient, easiest solution, but use whatever you
understand.
>
> ---John Holmes...
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Checkboxes to gather rows to delete
> I appreciate all of the quick replies. I do have globals off. Currently, I
> have the values for each ID being returned in a array Array ( [0] =>
> 101 [1] => 201 ) where 101 and 201 were the id's of the rows I checked. I
> have to say I like the way of doing it that Mathieu has shown using the
> explode function.
> Thanks again.
> Lewis
You already have an array of IDs you want to delete. Explode is for making
arrays, so what would you use it on? That doesn't make sense.
$query = "DELETE FROM table WHERE rowID IN (" .
implode(',',$_POST['id_array']) . ")";
is the most efficient, easiest solution, but use whatever you understand.
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Checkboxes to gather rows to delete
I appreciate all of the quick replies. I do have globals off. Currently, I have the values for each ID being returned in a array Array ( [0] => 101 [1] => 201 ) where 101 and 201 were the id's of the rows I checked. I have to say I like the way of doing it that Mathieu has shown using the explode function. Thanks again. Lewis -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Checkboxes to gather rows to delete
Hi all,
Can I raise a point of principle here.
My databases never have records deleted - instead they are marked as being
deleted in a status field. That way, they are always there for reference.
Unless you are running a system that needs the space or has extremely high
turnover of deleted records, this makes sesne.
Just my 2c.
George in Oxford
> -Original Message-
> From: Mathieu Dumoulin [mailto:[EMAIL PROTECTED]
> Sent: 24 February 2003 3:49 pm
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Checkboxes to gather rows to delete
>
>
> It is wrong to use that way of doing it John, cause this will delete ALL
> lines that where printed with a checkbox
> And also, if you are using a old version of PHP with register globals OFF,
> the _POST array will not be available
>
> Mathieu Dumoulin
>
> "1lt John W. Holmes" <[EMAIL PROTECTED]> a écrit dans le message de
> news: [EMAIL PROTECTED]
> > > I have a mysql database with a table using one column as a
> primary key.
> > > (rowID). On a php page I use a query to list all of the rows of the
> table
> > > and have a checkbox beside each row that should be used to
> check if you
> > > would like to delete this row. Can someone give me an example
> using post
> > > to pull the boxes that need to be deleted.
> >
> > Easy one.. :)
> >
> > Make sure your checkboxes have the rowID as their value, then you can
> simply
> > do this:
> >
> > $query = "DELETE FROM table WHERE rowID IN (" .
> > implode(',',$_POST['checkboxes']) . ")";
> >
> > and run that query.
> >
> > You'll end up with something that looks like this:
> >
> > DELETE FROM table WHERE rowID IN (1,2,3,4,5)
> >
> > where the numbers will come from only the checkboxes that you selected.
> >
> > ---John Holmes...
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Checkboxes to gather rows to delete
It is wrong to use that way of doing it John, cause this will delete ALL
lines that where printed with a checkbox
And also, if you are using a old version of PHP with register globals OFF,
the _POST array will not be available
Mathieu Dumoulin
"1lt John W. Holmes" <[EMAIL PROTECTED]> a écrit dans le message de
news: [EMAIL PROTECTED]
> > I have a mysql database with a table using one column as a primary key.
> > (rowID). On a php page I use a query to list all of the rows of the
table
> > and have a checkbox beside each row that should be used to check if you
> > would like to delete this row. Can someone give me an example using post
> > to pull the boxes that need to be deleted.
>
> Easy one.. :)
>
> Make sure your checkboxes have the rowID as their value, then you can
simply
> do this:
>
> $query = "DELETE FROM table WHERE rowID IN (" .
> implode(',',$_POST['checkboxes']) . ")";
>
> and run that query.
>
> You'll end up with something that looks like this:
>
> DELETE FROM table WHERE rowID IN (1,2,3,4,5)
>
> where the numbers will come from only the checkboxes that you selected.
>
> ---John Holmes...
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Checkboxes to gather rows to delete
> I have a mysql database with a table using one column as a primary key.
> (rowID). On a php page I use a query to list all of the rows of the table
> and have a checkbox beside each row that should be used to check if you
> would like to delete this row. Can someone give me an example using post
> to pull the boxes that need to be deleted.
Easy one.. :)
Make sure your checkboxes have the rowID as their value, then you can simply
do this:
$query = "DELETE FROM table WHERE rowID IN (" .
implode(',',$_POST['checkboxes']) . ")";
and run that query.
You'll end up with something that looks like this:
DELETE FROM table WHERE rowID IN (1,2,3,4,5)
where the numbers will come from only the checkboxes that you selected.
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Checkboxes to gather rows to delete
I have a mysql database with a table using one column as a primary key. (rowID). On a php page I use a query to list all of the rows of the table and have a checkbox beside each row that should be used to check if you would like to delete this row. Can someone give me an example using post to pull the boxes that need to be deleted. Thanks! Lewis -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
