On Mar 25, 2008, at 1:17 PM, Matt Anderton wrote:
I usually pre-populate the form with the values that are already in
the
record:
(... using PEAR's MDB2 package -- http://pear.php.net/packages/MDB2 )
$query = "SELECT * FROM member WHERE username = '" .
$_POST['username'] .
"'";
$result = $db->query($query);
$member = $result->fetchRow(MDB2_FETCHMODE_ASSOC);
foreach ($member as $key => $value) {
$$key = $value;
}
<form name="member_edit" action="<?= $_SERVER['PHP_SELF'] ?>"
method="POST">
<input type="hidden" name="_submit" value="1" />
<input type="text" name="fname" value="<?= $fname ?>" />
<input type="text" name="lname" value="<?= $lname ?>" />
<input type="text" name="email" value="<?= $email ?>" />
....
....
....
</form>
then when they submit, the record is just repopulated with whatever
is in
the form when they submit. ie -- only fields they changed get
changed in
the db.
if($_POST['_submit']) {
$update = "UPDATE member SET ...... blah, blah..."
}
that way, none of the fields are blank unless they were in the db
blank to
begin with. and you can add client or server-side validation to
prevent
that.
-- matt
Hi Matt,
That's what I'm doing for most of the fields, but how would you handle
a password that has been MD5'ed and includes some variables to make it
harder to crack? :)
ie: $PW = md5("$salt$password");
I can't undo the MD5 and I don't really want to... Just want to be
able to change it rather then view what it is.
On Tue, Mar 25, 2008 at 11:59 AM, Jason Pruim <japruim@xxxxxxxxxx>
wrote:
Hi everyone,
I am attempting to update a record for a login system while leaving
certain fields untouched if they arn't changed, and am running into
issues.
Basically what I want to do, is say I have these fields:
Field1
Field2
Field3
Field4
I update Field1 and Field3 but not Field2 and Field4. What I want to
do is change the values in Field1 and Field3 without touching the
values in Field2 and Field4.
I have tried this code:
$tab = "\t";
if (!isset($_POST['txtLoginName']) ||
empty($_POST['txtLoginName'])) {
$loginName =
mysqli_real_escape_string($chpwpostlink,
$_POST['txtLoginName']);
}
else
{
$loginName = $tab;
}
which works the fields that I've changed, but if I don't submit a
value in the form it sets the field to be blank in MySQL. Which is
what I am trying to avoid. Any ideas?
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424-9337
www.raoset.com
japruim@xxxxxxxxxx
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424-9337
www.raoset.com
japruim@xxxxxxxxxx
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
