On Wednesday 18 August 2004 20:07, Ford, Mike [LSS] wrote:
> > > $sql = 'SELECT ' . implode(', ', $chkboxes) . 'FROM form';
> >
> > Just note that with either solution, someone can post a value of "*
> > FROM table WHERE 1#" and see everything in any table in your database.
>
> I was waiting for
On 18 August 2004 15:53, John Holmes wrote:
> Ford, Mike [LSS] wrote:
>
> > > $chkboxes = $_POST['ch'];
> > > $sql = 'SELECT ';
> > > foreach($chkboxes as $k => $v)
> > > {
> > > $sql .= $v;
> > > if($k < (sizeof($chkboxes) - 1))
> > > {
> > > $sql .= ', ';
> > > }
> > > }
> > >
Ford, Mike [LSS] wrote:
$chkboxes = $_POST['ch'];
$sql = 'SELECT ';
foreach($chkboxes as $k => $v)
{
$sql .= $v;
if($k < (sizeof($chkboxes) - 1))
{
$sql .= ', ';
}
}
$sql .= ' FROM form';
$sql = 'SELECT ' . implode(', ', $chkboxes) . 'FROM form';
J
yeah yeah...it's damn near 4 in the morning here...my brain isn't
exactly on at the moment.
:)
On Wed, 18 Aug 2004 11:35:59 +0100, Ford, Mike [LSS]
<[EMAIL PROTECTED]> wrote:
> On 18 August 2004 11:24, randy wrote:
>
> > $chkboxes = $_POST['ch'];
> > $sql = 'SELECT ';
> > foreach($
On 18 August 2004 11:24, randy wrote:
> $chkboxes = $_POST['ch'];
> $sql = 'SELECT ';
> foreach($chkboxes as $k => $v)
> {
> $sql .= $v;
> if($k < (sizeof($chkboxes) - 1))
> {
> $sql .= ', ';
> }
> }
> $sql .= ' FROM form';
$sql = 'SELECT ' . implode(', ',
g_Units
> Unit_Consumed
>
>
>
>
> -Original Message-
> From: John Holmes [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 18, 2004 5:43 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Check Boxes
>
> balwantsin
ge-
From: John Holmes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 18, 2004 5:43 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Check Boxes
balwantsingh wrote:
> can somebody advise me
> i want to use checkboxes on my website, i want that if user selects some
>
balwantsingh wrote:
can somebody advise me
i want to use checkboxes on my website, i want that if user selects some
checkboxes (there will be more than 20 checkboxes), checkbox's value will be
stored in variables and than SELECT query command will be run using these
variables through PHP. but my p
can somebody advise me
i want to use checkboxes on my website, i want that if user selects some
checkboxes (there will be more than 20 checkboxes), checkbox's value will be
stored in variables and than SELECT query command will be run using these
variables through PHP. but my problem is that in SE
sday, March 27, 2003 6:16 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] check boxes and php
>
>
> I want to create a page where the user will have a list of
> its favorites and
> by ticking a box opposite the item will be able to delete it
> by clicking the
> submit
I want to create a page where the user will have a list of its favorites and
by ticking a box opposite the item will be able to delete it by clicking the
submit button. I want to make this dynamic so that the php works out the
one to delete based on the value of the tickbox (I'm thinking), having
I want to create a page where the user will have a list of its favorites and
by ticking a box opposite the item will be able to delete it by clicking the
submit button. I want to make this dynamic so that the php works out the
one to delete based on the value of the tickbox (I'm thinking), having
ammer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Julio Cuz, Jr. [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 29, 2002 10:33 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DB] Check Boxes
Hi--
Does anyone have any suggestions, SAMPLES, or ideas on how to
Hi--
Does anyone have any suggestions, SAMPLES, or ideas on how to STORE,
RETRIEVE, AND PROCESS values for "Check Boxes" w/PHP & Postgresql?
Thanks!
Julio Cuz, Jr.
Riverside Community College
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://
S["chkAuthStatus_${i}"] = 'on')
or:if($HTTP_POST_VARS["chkAuthStatus_{$i}"] = 'on')
-Original Message-
From: Matt C [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 19, 2001 6:43 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Check Boxes!
I still
Try removing the parenthesis from your update sql query
$sql = "UPDATE vacancies SET AuthStatus='1' WHERE JobID = '$JobID'";
HTH
Paul
- Original Message -
From: "Matt C" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent:
I still can't get my damn code working :( :( :(
All I want to do is have any records with a checked check box given the
value of 1 in the AuthStatus row.
Can anyone help me please?
-
JobID;
for ($i = 0; $i <= $Max_JobID; $i++) {
if($HTTP_POST_VARS["chkAuthStatus_$i"] = 'on') {
>-Original Message-
>From: Matt C [mailto:[EMAIL PROTECTED]]
>Sent: 03 October 2001 23:17
>To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
>Subject: RE: [PHP-DB] Check Boxes/UPDATE
>
>
>I am sorry but I still really don't get it :(
>
>How do I do the array t
eck Boxes/UPDATE
I am sorry but I still really don't get it :(
How do I do the array thing?
>-Original Message-
>From: Jason G. [mailto:[EMAIL PROTECTED]]
>Sent: 03 October 2001 12:12
>To: Matt C; [EMAIL PROTECTED]
>Subject: Re: [PHP-DB] Check Boxes/UPDATE
>
>
I am sorry but I still really don't get it :(
How do I do the array thing?
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [E
>-Original Message-
>From: Jason G. [mailto:[EMAIL PROTECTED]]
>Sent: 03 October 2001 12:12
>To: Matt C; [EMAIL PROTECTED]
>Subject: Re: [PHP-DB] Check Boxes/UPDATE
>
>
>Matt,
>
>Assuming that you have a variable number of records being displayed out of
>
Matt,
Assuming that you have a variable number of records being displayed out of
the database:
As you write out the HTML, give each checkbox a name containing the ID# of
the record that is being written out. Ex:
Use code like the following to Write and Read the web form...
id;
riginal Message-
From: Matt C [mailto:[EMAIL PROTECTED]]
Sent: 03 October 2001 03:23
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Check Boxes/UPDATE
I have a page of jobs with AuthStatus set to 0. Basically I want to list
each job title with a checkbox next to it. This I have done.
What I really d
I have a page of jobs with AuthStatus set to 0. Basically I want to list
each job title with a checkbox next to it. This I have done.
What I really don't understand is how do I make it so that the rows in my
table for all the different records when ticked are updated to 1?
Please help.
Matt
24 matches
Mail list logo
