Re: Problem with updating MySQL table
| From: | Jason Pruim | Date: | Wed, 27 Aug 2008 16:22:22 +0000 |
| Subject: | Re: Problem with updating MySQL table | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-278784@lists.php.net to get a copy of this message | ||
On Aug 27, 2008, at 12:06 PM, Jason Pruim wrote:
Hi Everyone, So I'm working on a project (Same one I sent the question about regarding the user access rights on monday) And now I am attempting to update the record... Here is some of my code: index.php <?PHP <form method="post" action="purlprocess.php"> First Name/Last Name<input type="text" name="txtFName" value="{$row['FName']}" $edit> <input type="text" name="txtLName" value="{$row['LName']}" $edit><br> Email Address <input type="text" name="txtEmail" value="{$row['email']}" $edit><br> Company name <input type="text" name="txtBusiness" value="{$row['Business']}" $edit><br> Company Address <input type="text" name="txtAddress1" value="{$row['Address1']}" $edit><br> City/State/Zip <input type="text" name="txtCity" value="{$row['City']}" $edit> <input type="text" name="txtState" value="{$row['State']}" $edit> <input type="text" name="txtZip" value="{$row['Zip']}" $edit><br> Phone <input type="text" name="txtPhone" value="{$row['phone']}" $edit><br> Your Favorite Type of coffee: <input type="radio" name="rdoCoffee" value="Starbucks"> <img src="../media/starbucks.jpeg" width="10%"> <input type="radio" name="rdoCoffee" value="Folgers"> <img src="../media/folgers.jpeg" width="10%"> <input type="radio" name="rdoCoffee" value="Other"> Other: <input type="text" name="txtCoffee" size="20"><br> When would a good time to bring it over be? <input type="text" name="txtMeeting"><br> <input type="submit" value="Yes! Give me the caffeine!"> <input type="hidden" name="Record" value="{$row['record']}"> </p> </form> ?> purlprocessing.php <?PHP $FName= $_POST['txtFName']; $LName= $_POST['txtLName']; $Email= $_POST['txtEmail']; $Business = $_POST['txtBusiness']; $Address1 = $_POST['txtAddress1']; $City = $_POST['txtCity']; $State = $_POST['txtState']; $Zip = $_POST['txtZip']; $CoffeeChoicetest = $_POST['rdoCoffee']; //$Coffee = $_POST['txtCoffee']; $Phone = $_POST['txtPhone']; $Record = $_POST['Record']; $Meeting = $_POST['txtMeeting']; $date = time(); $IPAddress = $_SERVER['REMOTE_ADDR']; if ($CoffeeChoicetest == "Other"){ $Coffee = $_POST['txtCoffee']; }else{ $Coffee = $_POST['rdoCoffee']; } $sql = "UPDATEOkay so I should have looked just a little bit longer before sending the e-mail... the $edit var that is in some of the text fields either contains NULL or "disabled" depending on an editing flag... disabled fields don't get passed back to the script and so it sets the fields to NULL... Now I just need to figure out how to overcome that limitation... What I'm trying to do, is if the text they are presented with is correct, don't give them the ability to "accidentally" edit it. Make them have to click a link to enable editing. It makes it a more intentional method, and hopefully will keep the bots out a LITTLE bit if they find the form and the pURL's... -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 11287 James St Holland, MI 49424 www.raoset.com japruim@raoset.comschreurset FName='{$FName}', LName='{$LName}', email='{$Email}', Business='{$Business}', Address1='{$Address1}', City='{$City}', State='{$State}', Zip='{$Zip}', Coffee='{$Coffee}', subscribed='0', date='{$date}', IPAddress='{$IPAddress}', Meeting='{$Meeting}' WHERE record='{$Record}'"; mysqli_query($link, $sql) or die("Could not update..." . mysqli_error($link)); ?> mysql> describe schreur; +------------+-------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+------------+-------------+------+-----+---------+-------+| FName | varchar(20) | YES | | NULL | | | LName | varchar(20) | YES | | NULL | | | email | varchar(50) | YES | | NULL | | | phone | varchar(12) | YES | | NULL | | | url | int(12) | YES | | NULL | | | record | int(7) | YES | | NULL | | | subscribed | int(1) | NO | | | | | date | varchar(12) | YES | | NULL | | | IPAddress | varchar(19) | YES | | NULL | | | Business | varchar(20) | YES | | NULL | | | Address1 | varchar(50) | YES | | NULL | | | City | varchar(20) | YES | | NULL | | | State | varchar(2) | YES | | NULL | | | Zip | varchar(10) | YES | | NULL | | | Coffee | varchar(20) | YES | | NULL | | | Meeting | text | YES | | NULL | |+------------+-------------+------+-----+---------+-------+ The problem is when I am attempting to update some of the info, it erases the info in the field. Anyone got a clue as to what is going on? :) Thanks for looking!