Hi,
I have a dynamic HTML page with 4 columns of data, retrieved with PHP
from a MySQL database.
At the end of every row I have an UPDATE submit button, which activates
a php update script to update the database. I now encounter the problem
that in the update script I cannot trace back for which row the UPDATE
buttom was pressed.
I first had defined the UPDATE button as : <input name="update"
value="UPDATE" type="submit">. That doesn't work ...
If I change the definition to <input name="update" value=<? echo
"UPDATE".$nt['id']; ?type="submit">, then I can get the id number in
the update script, but the display is not that good, because you see
UPDATE1, UPDATE7,UPDATE4 and so on ...
So I need something, so I can find back in the update script for which
row the update button was pressed. Each row has his unique id (which is
not shown in the table)
Anyone has a suggestion on how to solve this ?
Thanks in advance. 6 17707
On Wed, 24 Jan 2007 17:56:33 +0100, rukkie <ru****@belgacom.netwrote:
I first had defined the UPDATE button as : <input name="update"
value="UPDATE" type="submit">. That doesn't work ...
If I change the definition to <input name="update" value=<? echo
"UPDATE".$nt['id']; ?type="submit">, then I can get the id number in
the update script, but the display is not that good, because you see
UPDATE1, UPDATE7,UPDATE4 and so on ...
So I need something, so I can find back in the update script for which
row the update button was pressed. Each row has his unique id (which is
not shown in the table)
Anyone has a suggestion on how to solve this ?
'<input name="update['.$id.']" value="UPDATE" type="submit">'
In the update:
$id = intval(reset(array_keys($_POST['update'])));
--
Rik Wasmus
* I'm testing several new newsreaders at the moment. Please excuse
possible errors and weird content. *
Thanks for the reply ....
Now I get some weird warning :
Warning: array_keys(): The first argument should be an array in
xxxx.php on line 9
and line 9 is the line with : $id =
intval(reset(array_keys($_POST['update'])));
Any suggestion of what could be wrong ?
On 24 jan, 18:03, Rik <luiheidsgoe...@hotmail.comwrote:
On Wed, 24 Jan 2007 17:56:33 +0100, rukkie <ruk...@belgacom.netwrote:
I first had defined the UPDATE button as : <input name="update"
value="UPDATE" type="submit">. That doesn't work ...
If I change the definition to <input name="update" value=<? echo
"UPDATE".$nt['id']; ?type="submit">, then I can get the id number in
the update script, but the display is not that good, because you see
UPDATE1, UPDATE7,UPDATE4 and so on ...
So I need something, so I can find back in the update script for which
row the update button was pressed. Each row has his unique id (which is
not shown in the table)
Anyone has a suggestion on how to solve this ?'<input name="update['.$id.']" value="UPDATE" type="submit">'
In the update:
$id = intval(reset(array_keys($_POST['update'])));
--
Rik Wasmus
* I'm testing several new newsreaders at the moment. Please excuse
possible errors and weird content. *
Message-ID: <11**********************@s48g2000cws.googlegroups .comfrom
rukkie contained the following:
>I first had defined the UPDATE button as : <input name="update" value="UPDATE" type="submit">. That doesn't work ... If I change the definition to <input name="update" value=<? echo "UPDATE".$nt['id']; ?type="submit">, then I can get the id number in the update script, but the display is not that good, because you see UPDATE1, UPDATE7,UPDATE4 and so on ... So I need something, so I can find back in the update script for which row the update button was pressed. Each row has his unique id (which is not shown in the table)
Anyone has a suggestion on how to solve this ?
One way is to make each row a separate form and use a hidden field. to
pass the id. Alternatively use checkboxes to get an array of ids and do
a multiple update with a single submit button.
--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/
On Wed, 24 Jan 2007 18:23:36 +0100, rukkie <ru****@belgacom.netwrote:
Thanks for the reply ....
Thank me by not topposting.
On 24 jan, 18:03, Rik <luiheidsgoe...@hotmail.comwrote:
>On Wed, 24 Jan 2007 17:56:33 +0100, rukkie <ruk...@belgacom.netwrote:
I first had defined the UPDATE button as : <input name="update"
value="UPDATE" type="submit">. That doesn't work ...
If I change the definition to <input name="update" value=<? echo
"UPDATE".$nt['id']; ?type="submit">, then I can get the id number in
the update script, but the display is not that good, because you see
UPDATE1, UPDATE7,UPDATE4 and so on ...
So I need something, so I can find back in the update script for which
row the update button was pressed. Each row has his unique id (which
is
not shown in the table)
Anyone has a suggestion on how to solve this ?'<input
name="update['.$id.']" value="UPDATE" type="submit">'
In the update: $id = intval(reset(array_keys($_POST['update'])));
Now I get some weird warning :
Warning: array_keys(): The first argument should be an array in
xxxx.php on line 9
Did you alter the name of the input like I told you?
The HTML-source should look like: '<input name="update[123]"
value="UPDATE">';
After posting, var_dump $_POST to see what it contains.
--
Rik Wasmus
* I'm testing several new newsreaders at the moment. Please excuse
possible errors and weird content. *
Hi,
thanks a lot.
At the end I've got it working with this part of code : <?echo "<input
name=\"update[".$nt['id']."]\""; ?>
Some quotes and/or double quotes makes the difference
Thanks !!
On 24 jan, 18:49, Rik <luiheidsgoe...@hotmail.comwrote:
On Wed, 24 Jan 2007 18:23:36 +0100, rukkie <ruk...@belgacom.netwrote:
Thanks for the reply ....Thank me by not topposting.
On 24 jan, 18:03, Rik <luiheidsgoe...@hotmail.comwrote:
On Wed, 24 Jan 2007 17:56:33 +0100, rukkie <ruk...@belgacom.netwrote:
I first had defined the UPDATE button as : <input name="update"
value="UPDATE" type="submit">. That doesn't work ...
If I change the definition to <input name="update" value=<? echo
"UPDATE".$nt['id']; ?type="submit">, then I can get the id number in
the update script, but the display is not that good, because you see
UPDATE1, UPDATE7,UPDATE4 and so on ...
So I need something, so I can find back in the update script for which
row the update button was pressed. Each row has his unique id (which
is
not shown in the table)
Anyone has a suggestion on how to solve this ?'<input
name="update['.$id.']" value="UPDATE" type="submit">'
In the update:
$id = intval(reset(array_keys($_POST['update'])));
Now I get some weird warning :
Warning: array_keys(): The first argument should be an array in
xxxx.php on line 9Did you alter the name of the input like I told you?
The HTML-source should look like: '<input name="update[123]"
value="UPDATE">';
After posting, var_dump $_POST to see what it contains.
--
Rik Wasmus
* I'm testing several new newsreaders at the moment. Please excuse
possible errors and weird content. *
On Wed, 24 Jan 2007 20:04:32 +0100, rukkie <ru****@belgacom.netwrote:
thanks a lot.
You'd really thank me by starting to bottompost instead of toppost.
>'<input name="update['.$id.']" value="UPDATE" type="submit">'
In the update: $id = intval(reset(array_keys($_POST['update'])));
Now I get some weird warning :
Warning: array_keys(): The first argument should be an array in
xxxx.php on line 9Did you alter the name of the input like I told you?
The HTML-source should look like: '<input name="update[123]" value="UPDATE">'; After posting, var_dump $_POST to see what it contains.
At the end I've got it working with this part of code : <?echo "<input
name=\"update[".$nt['id']."]\""; ?>
Some quotes and/or double quotes makes the difference
That's why I said:
'<input name="update['.$id.']" value="UPDATE" type="submit">'
Seems a lot more readable then:
"<input name=\"update[".$nt['id']."]\"" value=\"UPDATE\"
type=\"submit\">";
--
Rik Wasmus
* I'm testing several new newsreaders at the moment. Please excuse
possible errors and weird content. * This discussion thread is closed Replies have been disabled for this discussion. Similar topics
6 posts
views
Thread by dev |
last post: by
|
7 posts
views
Thread by Gary |
last post: by
|
reply
views
Thread by Dan Jones |
last post: by
|
reply
views
Thread by Jim Moseby |
last post: by
|
5 posts
views
Thread by elyob |
last post: by
|
3 posts
views
Thread by fjm67 |
last post: by
|
16 posts
views
Thread by Ian Davies |
last post: by
|
4 posts
views
Thread by Bob |
last post: by
| | | | | | | | | | | |