Re: [PHP] mysql, php, checkbox
Indeed, now it works, I put the form tag by mistake...
Thanks,
Adrian
- Original Message -
From: rija [EMAIL PROTECTED]
To: Adrian Partenie [EMAIL PROTECTED]
Sent: Tuesday, December 03, 2002 11:30 PM
Subject: Re: [PHP] mysql, php, checkbox
There are form/form tags around input type=checkbox ... What are
they
supposed to do?
I think your problem lies there, because ids[] belong to this new form not
to the first one and then ids[] cannot be set.
Secondly, method='post' inside input does nothing.
Hope that helps.
- Original Message -
From: Adrian Partenie [EMAIL PROTECTED]
To: php [EMAIL PROTECTED]
Sent: Wednesday, December 04, 2002 4:50 AM
Subject: Re: [PHP] mysql, php, checkbox
It works, but just for the first row selected from the table. I think
that
the problem is that the checkboxes are declared inside a while loop. If
i
declare manually all checkboxes it works. Any ideas ? Or maybe I'm doing
something wrong?
echo form method=\post\ action=\selectare.php?ids[]\;
echo input type=\Submit\ value=\Trimite\;
/* Connecting, selecting database */
$link = mysql_connect(localhost, root, adrian)
or die(Could not connect);
print Connected successfully;
mysql_select_db(menagerie) or die(Could not select database);
/* Performing SQL query */
$query = SELECT * FROM reclamatie;
$result = mysql_query($query) or die(Query failed);
/* Printing results in HTML */
echo table border=1;
echo
trtd/tdtdID/tdtdSubject/tdtdOpen/tdtdClose/td/tr;
while($row = MySQL_fetch_array($result)) {
echo trtdforminput type=\checkbox\ method=\post\
name=\ids[]\ value=\{$row['id']}\/form/td;
echo tda href=\lowerframe.php?id={$row['id']}\
target=\lowerframe\{$row['id']}/a/td;
echo td{$row['subject']}/td;
echo td{$row['open']}/td;
echo td{$row['close']}/td/tr;
}
echo /table;
/* Free resultset */
mysql_free_result($result);
/* Closing connection */
mysql_close($link);
echo /form;
?
###
//selectare.php (just displays the id's of selected checkboxes)
//$useri=$_POST['useri'];
$ids=$_POST['ids'];
reset($ids);
while (list ($key, $value) = each ($ids)) {
echo $valuebr /\n;
}
?
#
As I said, when I select the first checkbox, I get the id, but when I
select
any other checkbox, I get the errors
PHP Notice: Undefined index: ids in selectare.php
PHP Warning: Variable passed to each() is not an array or object in
selectare.php
- Original Message -
From: John W. Holmes [EMAIL PROTECTED]
To: 'Adrian Partenie' [EMAIL PROTECTED]; 'php'
[EMAIL PROTECTED]
Sent: Thursday, November 28, 2002 5:54 PM
Subject: RE: [PHP] mysql, php, checkbox
I'm displaying the content of a mysql table with autoincrement
index.
I
want to be able to select the each row from the table using the
check
boxes. In order to do that, i want to assign to each checkbox the
name=index of selected row.
I assign to the checkboxes the value of selected id, but I can't
retreiveit later for further processing. My code looks like this
$query = SELECT * FROM reclamatie;
$result = mysql_query($query) or die(Query failed);
/* Printing results in HTML */
echo table border=1;
echo
trtd/tdtdID/tdtdSubject/tdtdOpen/tdtdClose/td/tr
;
while($row = MySQL_fetch_array($result)) {
echo trtdforminput type=\checkbox\
method=\post\
name=\{$row['id']}\/form/td; // ??
It looks like your naming it as a number, which won't work for PHP.
You
want to name all of your checkboxes the same, with a [] on the name to
make the results an array in PHP.
... name=id[] value={$row['id']}
Then, you'll have $_POST['id'][x] as an array in PHP. Only the
checkboxes that were selected will be in the array, from zero to
however
many were checked. The value of $_POST['id'][x] will be whatever was
in
the value=... part of the HTML checkbox...
---John Holmes...
--
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] mysql, php, checkbox
It works, but just for the first row selected from the table. I think that
the problem is that the checkboxes are declared inside a while loop. If i
declare manually all checkboxes it works. Any ideas ? Or maybe I'm doing
something wrong?
echo form method=\post\ action=\selectare.php?ids[]\;
echo input type=\Submit\ value=\Trimite\;
/* Connecting, selecting database */
$link = mysql_connect(localhost, root, adrian)
or die(Could not connect);
print Connected successfully;
mysql_select_db(menagerie) or die(Could not select database);
/* Performing SQL query */
$query = SELECT * FROM reclamatie;
$result = mysql_query($query) or die(Query failed);
/* Printing results in HTML */
echo table border=1;
echo
trtd/tdtdID/tdtdSubject/tdtdOpen/tdtdClose/td/tr;
while($row = MySQL_fetch_array($result)) {
echo trtdforminput type=\checkbox\ method=\post\
name=\ids[]\ value=\{$row['id']}\/form/td;
echo tda href=\lowerframe.php?id={$row['id']}\
target=\lowerframe\{$row['id']}/a/td;
echo td{$row['subject']}/td;
echo td{$row['open']}/td;
echo td{$row['close']}/td/tr;
}
echo /table;
/* Free resultset */
mysql_free_result($result);
/* Closing connection */
mysql_close($link);
echo /form;
?
###
//selectare.php (just displays the id's of selected checkboxes)
//$useri=$_POST['useri'];
$ids=$_POST['ids'];
reset($ids);
while (list ($key, $value) = each ($ids)) {
echo $valuebr /\n;
}
?
#
As I said, when I select the first checkbox, I get the id, but when I select
any other checkbox, I get the errors
PHP Notice: Undefined index: ids in selectare.php
PHP Warning: Variable passed to each() is not an array or object in
selectare.php
- Original Message -
From: John W. Holmes [EMAIL PROTECTED]
To: 'Adrian Partenie' [EMAIL PROTECTED]; 'php'
[EMAIL PROTECTED]
Sent: Thursday, November 28, 2002 5:54 PM
Subject: RE: [PHP] mysql, php, checkbox
I'm displaying the content of a mysql table with autoincrement index.
I
want to be able to select the each row from the table using the check
boxes. In order to do that, i want to assign to each checkbox the
name=index of selected row.
I assign to the checkboxes the value of selected id, but I can't
retreiveit later for further processing. My code looks like this
$query = SELECT * FROM reclamatie;
$result = mysql_query($query) or die(Query failed);
/* Printing results in HTML */
echo table border=1;
echo
trtd/tdtdID/tdtdSubject/tdtdOpen/tdtdClose/td/tr
;
while($row = MySQL_fetch_array($result)) {
echo trtdforminput type=\checkbox\ method=\post\
name=\{$row['id']}\/form/td; // ??
It looks like your naming it as a number, which won't work for PHP. You
want to name all of your checkboxes the same, with a [] on the name to
make the results an array in PHP.
... name=id[] value={$row['id']}
Then, you'll have $_POST['id'][x] as an array in PHP. Only the
checkboxes that were selected will be in the array, from zero to however
many were checked. The value of $_POST['id'][x] will be whatever was in
the value=... part of the HTML checkbox...
---John Holmes...
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] mysql, php, checkbox
Hello,
I'm displaying the content of a mysql table with autoincrement index. I want to be
able to select the each row from the table using the check boxes. In order to do that,
i want to assign to each checkbox the name=index of selected row.
I assign to the checkboxes the value of selected id, but I can't retreiveit later for
further processing. My code looks like this
$query = SELECT * FROM reclamatie;
$result = mysql_query($query) or die(Query failed);
/* Printing results in HTML */
echo table border=1;
echo trtd/tdtdID/tdtdSubject/tdtdOpen/tdtdClose/td/tr;
while($row = MySQL_fetch_array($result)) {
echo trtdforminput type=\checkbox\ method=\post\
name=\{$row['id']}\/form/td; // ??
echo tda href=\lowerframe.php?id={$row['id']}\
target=\lowerframe\{$row['id']}/a/td; //for other purposes, it works fine
echo td{$row['subject']}/td;
echo td{$row['open']}/td;
echo td{$row['close']}/td/tr;
}
echo /table;
Any sugestions if i want to use forms, something like
form method=post action=selectare.php?id=$row['id']
input type=Submit value=Trimite
/form
Thanks, Adrian
RE: [PHP] mysql, php, checkbox
I'm displaying the content of a mysql table with autoincrement index.
I
want to be able to select the each row from the table using the check
boxes. In order to do that, i want to assign to each checkbox the
name=index of selected row.
I assign to the checkboxes the value of selected id, but I can't
retreiveit later for further processing. My code looks like this
$query = SELECT * FROM reclamatie;
$result = mysql_query($query) or die(Query failed);
/* Printing results in HTML */
echo table border=1;
echo
trtd/tdtdID/tdtdSubject/tdtdOpen/tdtdClose/td/tr
;
while($row = MySQL_fetch_array($result)) {
echo trtdforminput type=\checkbox\ method=\post\
name=\{$row['id']}\/form/td; // ??
It looks like your naming it as a number, which won't work for PHP. You
want to name all of your checkboxes the same, with a [] on the name to
make the results an array in PHP.
... name=id[] value={$row['id']}
Then, you'll have $_POST['id'][x] as an array in PHP. Only the
checkboxes that were selected will be in the array, from zero to however
many were checked. The value of $_POST['id'][x] will be whatever was in
the value=... part of the HTML checkbox...
---John Holmes...
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
