[PHP-DB] Passing key field, id, from form to procedure
I am just starting to learn php and mysql. I have a small php/html page and
database. All it does when starting shows the name of each person with a
delete and edit link beside each name. At the bottom of the list there is
an Add Record button. If you select delete it takes out the name and
reloads the page. If you select Add Record it brings up a form to add a
new name etc. with an Add It button under the form in which after
selecting INSERTs the new record and reloads the initial page. The add and
delete parts work fine.
The edit record is the problem. After selecting the edit beside the
appropriate name a form is brought up showing the current information for
that record with an Update Record button under the form. This works fine
to here. But when I select the Update Record button it will go into the
updaterecord procedure of my php/html page but it has no id for it to
apply the UPDATE to. So how can I have it pass the id to the updaterecord
procedure so it will apply the UPDATE to the appropriate record? I tried
two different ways of getting the id for updaterecord as you can see below.
Following is my editrecord and updaterecord procedures:
if (isset($_GET['editrecord'])) { //edit record
$zid = $_GET['editrecord'];
$sql = SELECT * FROM persinfo WHERE DID = $zid;
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$zid = $row[DID];
$zfname = $row[DFirst];
$zlname = $row[DLast];
?
form action=?=$_SERVER['PHP_SELF']? method=post
input type=hidden name='DID' value=? echo $zid; ?
First name: input type=text name=zfname
value=? echo $zfname; ?/ br
Last name: input type=text name=zlname
value=? echo $zlname; ?/ br
input type=submit name=updaterecord value=Update It /
/form
?php } ?
?php
if (isset($_GET['$updaterecord'])) { //update record
version 1
$zid = $_GET['$updaterecord'];
$sql = UPDATE persinfo SET DFirst='$zfname',
DLast = '$zlname' WHERE DID=$zid;
$result = mysql_query($sql);
}
}
//I also tried this
if ($updaterecord) {//update
record version 2
if ($zid) {
$sql = UPDATE persinfo SET DFirst='$zfname',
DLast = '$zlname' WHERE DID=$zid;
$result = mysql_query($sql);
}
}
?
If you want all of the code let me know. I could send it to your personal
email address. The whole thing is probably 130 lines of code.
Thanks for any help,
Doug Hull
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Passing key field, id, from form to procedure
Doug,
One way to handle this is the following:
On the page that lists the people, under the edit link, you put something
like a href=editscript.php?id=$idEdit/a. When the user clicks that
link, the $id will be passed in the URL.
In your editscript.php page, inside the form where you're editing the
information, you create an input type=hidden name=updateThisRecord
value=?php $_GET['id'] ? (or some variation thereof depending on how
your HTML is handled). This will place the ID into a hidden field that can
be passed to your update query via POST.
When the user hits the submit button, all of your form data can be used in
the UPDATE query and you just add a WHERE clause to the end of it. For
example: UPDATE personTable SET ...your column names and values here...
WHERE id=.$_POST[updateThisRecord].;
I'm sure there are other ways of handling this, but I've had success with
this methodology in the past. None of the code in here has been tested or
anything - just straight off the top of my head so I apologize in advance if
everything doesn't work verbatim.
Hope this helped.
Rich
-Original Message-
From: Hull, Douglas D [mailto:[EMAIL PROTECTED]
Sent: Friday, July 18, 2003 11:40 AM
To: Note To php mysql List (E-mail)
Subject: [PHP-DB] Passing key field, id, from form to procedure
I am just starting to learn php and mysql. I have a small
php/html page and
database. All it does when starting shows the name of each
person with a
delete and edit link beside each name. At the bottom of the
list there is
an Add Record button. If you select delete it takes out
the name and
reloads the page. If you select Add Record it brings up a
form to add a
new name etc. with an Add It button under the form in which after
selecting INSERTs the new record and reloads the initial
page. The add and
delete parts work fine.
The edit record is the problem. After selecting the edit beside the
appropriate name a form is brought up showing the current
information for
that record with an Update Record button under the form.
This works fine
to here. But when I select the Update Record button it will
go into the
updaterecord procedure of my php/html page but it has no id
for it to
apply the UPDATE to. So how can I have it pass the id to the
updaterecord
procedure so it will apply the UPDATE to the appropriate
record? I tried
two different ways of getting the id for updaterecord as you
can see below.
Following is my editrecord and updaterecord procedures:
if (isset($_GET['editrecord'])) { //edit record
$zid = $_GET['editrecord'];
$sql = SELECT * FROM persinfo WHERE DID = $zid;
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$zid = $row[DID];
$zfname = $row[DFirst];
$zlname = $row[DLast];
?
form action=?=$_SERVER['PHP_SELF']? method=post
input type=hidden name='DID' value=? echo $zid; ?
First name: input type=text name=zfname
value=? echo $zfname; ?/ br
Last name: input type=text name=zlname
value=? echo $zlname; ?/ br
input type=submit name=updaterecord value=Update It /
/form
?php } ?
?php
if (isset($_GET['$updaterecord'])) {
//update record
version 1
$zid = $_GET['$updaterecord'];
$sql = UPDATE persinfo SET DFirst='$zfname',
DLast = '$zlname' WHERE DID=$zid;
$result = mysql_query($sql);
}
}
//I also tried this
if ($updaterecord) {
//update
record version 2
if ($zid) {
$sql = UPDATE persinfo SET DFirst='$zfname',
DLast = '$zlname' WHERE DID=$zid;
$result = mysql_query($sql);
}
}
?
If you want all of the code let me know. I could send it to
your personal
email address. The whole thing is probably 130 lines of code.
Thanks for any help,
Doug Hull
--
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] Passing key field, id, from form to procedure
Douglas,
The form that shows the editable fields has a hidden field named 'DID'
having the value of $zid. In your updaterecord procedure, you will have to
use the variable $_GET[DID] instead of $zid. You can of course just add one
line of code:
$zid = $_GET[DID];
to help you out. One other trick is to echo out your query before actually
running it so that you don't update all of your records by mistake.
Ryan Marks
-Original Message-
From: Hull, Douglas D [mailto:[EMAIL PROTECTED]
Sent: Friday, July 18, 2003 10:40 AM
To: Note To php mysql List (E-mail)
Subject: [PHP-DB] Passing key field, id, from form to procedure
I am just starting to learn php and mysql. I have a small php/html page and
database. All it does when starting shows the name of each person with a
delete and edit link beside each name. At the bottom of the list there is
an Add Record button. If you select delete it takes out the name and
reloads the page. If you select Add Record it brings up a form to add a
new name etc. with an Add It button under the form in which after
selecting INSERTs the new record and reloads the initial page. The add and
delete parts work fine.
The edit record is the problem. After selecting the edit beside the
appropriate name a form is brought up showing the current information for
that record with an Update Record button under the form. This works fine
to here. But when I select the Update Record button it will go into the
updaterecord procedure of my php/html page but it has no id for it to
apply the UPDATE to. So how can I have it pass the id to the updaterecord
procedure so it will apply the UPDATE to the appropriate record? I tried
two different ways of getting the id for updaterecord as you can see below.
Following is my editrecord and updaterecord procedures:
if (isset($_GET['editrecord'])) { //edit record
$zid = $_GET['editrecord'];
$sql = SELECT * FROM persinfo WHERE DID = $zid;
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$zid = $row[DID];
$zfname = $row[DFirst];
$zlname = $row[DLast];
?
form action=?=$_SERVER['PHP_SELF']? method=post
input type=hidden name='DID' value=? echo $zid; ?
First name: input type=text name=zfname
value=? echo $zfname; ?/ br
Last name: input type=text name=zlname
value=? echo $zlname; ?/ br
input type=submit name=updaterecord value=Update It /
/form
?php } ?
?php
if (isset($_GET['$updaterecord'])) { //update record
version 1
$zid = $_GET['$updaterecord'];
$sql = UPDATE persinfo SET DFirst='$zfname',
DLast = '$zlname' WHERE DID=$zid;
$result = mysql_query($sql);
}
}
//I also tried this
if ($updaterecord) {//update
record version 2
if ($zid) {
$sql = UPDATE persinfo SET DFirst='$zfname',
DLast = '$zlname' WHERE DID=$zid;
$result = mysql_query($sql);
}
}
?
If you want all of the code let me know. I could send it to your personal
email address. The whole thing is probably 130 lines of code.
Thanks for any help,
Doug Hull
--
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
