Databases
StackOverflow2013
Postsdbo
POPHP not performing UPDATE
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPHP not performing UPDATE
    text
    copied!<p>I created a database with user's first name, last name, email, and temp password. When a user logs in for the first time they are shown a profile with the information already in the database as well as some additional fields they must fill in. On clicking submit the form should then update their profile in the database but it doesn't. The database is called 'users'. Could someone please tell me what I'm doing wrong?</p> <pre><code> &lt;?php $testerID = preg_replace('#[^0-9]#i', '', $_SESSION["id"]); // filter everything but numbers and letters $tester = preg_replace('#[^A-Za-z0-9]#i', '', $_SESSION["tester"]); // filter everything but numbers and letters $password = preg_replace('#[^A-Za-z0-9]#i', '', $_SESSION["password"]); // filter everything but numbers and letters include "scripts/connect_to_mysql.php"; $sql = mysql_query("SELECT * FROM users WHERE id='$testerID' AND username='$tester' AND password='$password' LIMIT 1"); // query the person $row = mysql_fetch_array($sql); $fname = $row['fname']; $lname = $row['lname']; $email = $row['email']; $existCount = mysql_num_rows($sql); // count the row nums if ($existCount == 0) { // evaluate the count echo "Your login session data is not on record in the database."; exit(); } ?&gt; &lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt; &lt;html xmlns="http://www.w3.org/1999/xhtml"&gt; &lt;head&gt; &lt;meta http-equiv="Content-Type" content="text/html; charset=utf-8" /&gt; &lt;title&gt;Tester Home&lt;/title&gt; &lt;/head&gt; &lt;body&gt; &lt;table width="886"&gt; &lt;tr&gt; &lt;td width="876"&gt;&lt;h1&gt;Welcome &lt;?php echo $fname; ?&gt; to the Closed Beta&lt;/h1&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;p&gt;&amp;nbsp;&lt;/p&gt; &lt;div id="content"&gt; &lt;?php $date = getdate(); // Parse the form data and add inventory item to the system if (isset($_POST['$new_password'])) { $new_email = mysql_real_escape_string($_POST['email']); $new_password = mysql_real_escape_string($_POST['new_password']); $phone_model = mysql_real_escape_string($_POST['phone_model']); $carrier = mysql_real_escape_string($_POST['carrier']); $sql_update = mysql_query("UPDATE users SET email='$new_email', password='$new_password', phone_model='$phone_model', carrier='$carrier' WHERE id='$testerID'"); } if(is_null($test_start)){ echo " &lt;form action=\"index.php\" enctype=\"multipart/form-data\" name=\"myForm\" id=\"myform\" method=\"post\"&gt; &lt;table width=\"90%\" border=\"0\" cellspacing=\"0\" cellpadding=\"6\"&gt; &lt;tr&gt; &lt;td width=\"20%\" align=\"right\"&gt;ID: &lt;/td&gt; &lt;td width=\"80%\"&gt;&lt;label&gt; $testerID &lt;/label&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align=\"right\"&gt;Username: &lt;/td&gt; &lt;td&gt;&lt;label&gt; $tester &lt;/label&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align=\"right\"&gt;First Name: &lt;/td&gt; &lt;td&gt;&lt;label&gt; $fname &lt;/label&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align=\"right\"&gt;Last Name: &lt;/td&gt; &lt;td&gt;&lt;label&gt; $lname &lt;/label&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align=\"right\"&gt;Email Address: &lt;/td&gt; &lt;td&gt;&lt;label&gt; &lt;input type=\"text\" name=\"email\" id=\"email\" value=\"\"/&gt; &lt;/label&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align=\"right\"&gt;Old password: (the one you were assigned)&lt;/td&gt; &lt;td&gt;&lt;label&gt; &lt;input type=\"text\" name=\"old_password\" id=\"old_password\" value=\"$password\"/&gt; &lt;/label&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align=\"right\"&gt;New Password: &lt;/td&gt; &lt;td&gt;&lt;label&gt; &lt;input type=\"text\" name=\"new_password\" id=\"newPassField\" /&gt; &lt;/label&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align=\"right\"&gt;Confirm New Password: &lt;/td&gt; &lt;td&gt;&lt;label&gt; &lt;input type=\"text\" name=\"confirm_password\" id=\"newPassField\" /&gt; &lt;/label&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align=\"right\"&gt;Phone Model: &lt;/td&gt; &lt;td&gt;&lt;label&gt; &lt;input type=\"text\" name=\"phone_model\" id=\"phone_model\" value=\"$phone_model\"/&gt; (a 4 digit number) &lt;/label&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align=\"right\"&gt;Carrier: &lt;/td&gt; &lt;td&gt;&lt;label&gt; &lt;input type=\"text\" name=\"carrier\" id=\"carrier\" cols=\"64\" rows=\"5\" value=\"$carrier\"/&gt; &lt;/label&gt;&lt;/td&gt; &lt;/tr&gt; &lt;input type=\"submit\" name=\"button\" id=\"button\" value=\"Update\" /&gt; &lt;/table&gt; &lt;/form&gt;"; }else{ } ?&gt; &lt;/div&gt; &lt;p&gt;&amp;nbsp;&lt;/p&gt; &lt;/body&gt; &lt;/html&gt; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload