Databases
StackOverflow2013
Postsdbo
POform echoes success without submittting anything to database. Is there something wrong with my flow control?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POform echoes success without submittting anything to database. Is there something wrong with my flow control?
    text
    copied!<p>Here is the code. </p> <p>I really dont why it is not submitting my information.</p> <pre><code>&lt;?php //Includes mass includes containing all the files needed to execute the full script //Also shows homepage elements without customs include ("includes/mass.php"); //Grabbing data form POST array and storing in variables plus the date $username = ($_POST['username']); $password = ($_POST['password']); $conpassword= ($_POST['password2']); $firstname = ($_POST['firstname']); $lastname = ($_POST['lastname']); $email = ($_POST['email']); $submit = ($_POST['submit']); $date = date("Y-m-d"); //Reigstration Form $register = "&lt;div id='registration'&gt; &lt;h2&gt;Register Here!&lt;/h2&gt; &lt;form action='register.php' method='post'&gt; &lt;table&gt; &lt;tr&gt; &lt;td&gt; Username &lt;/td&gt; &lt;td&gt; &lt;input type='text' name='username' value='$username' &gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; Password &lt;/td&gt; &lt;td&gt; &lt;input type='password' name ='password'&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; Confirm Password &lt;/td&gt; &lt;td&gt; &lt;input type='password' name ='password2'&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; Firstname &lt;/td&gt; &lt;td&gt; &lt;input type='text' name='firstname' value='$firstname'&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; Lastname &lt;/td&gt; &lt;td&gt; &lt;input type='text' name='lastname' value='$lastname' &gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; Email &lt;/td&gt; &lt;td&gt; &lt;input type='text' name='email' value= '$email' &gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; &lt;input type='submit' class='button' name='submit' value='Sign Up'&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/form&gt; &lt;/div&gt;"; echo $register; //Check to make sure user has submitted the correct details echo "&lt;div id='regform'&gt;"; if (isset($submit)) { //Querying the database for if the username already exists $sql = "SELECT * FROM user WHERE username = '$username'"; $query = mysql_query($sql); $numrows = mysql_num_rows($query); while ($row = mysql_fetch_assoc($query)) { $dbusername = $row['username']; $dbpassword = $row['password']; } if (strlen($username)&lt;2) { echo ("&lt;br&gt;You must enter a longer username&lt;/br&gt;"); exit; } elseif (strlen($username) &gt; 25) { echo ("You must enter a shorter username&lt;br&gt;"); exit; } if ($username==$dbusername) { echo ("That username already exists!"); exit; } elseif (strlen($password)&lt;6) { echo ("&lt;br&gt;'Password must be be between 6 &amp; 26 characters'&lt;br&gt;"); exit; } if ($password != $conpassword) { echo ("&lt;br&gt;Your passwords dont match&lt;br&gt;"); exit; } elseif (strlen($firstname)&lt;=0) { echo ("&lt;br&gt;You must enter your firstname&lt;br&gt;"); exit; } if (strlen($lastname)&lt;=0) { echo ("&lt;br&gt;You must enter your lastname&lt;br&gt;"); exit; } elseif (!preg_match('/@/',$email) || (strlen($email)&lt;=6) ) { echo ("&lt;/br&gt;You must enter a proper email address!"); exit; } if (!isset($password)) { echo "You must enter a password!"; exit; } elseif (!isset($conpassword)) { echo ("You must confirm your password"); exit; } else { //Encrypt the password $password = md5($password); $conpassword = md5($conpassword); //Start Session session_start(); //push this information to the database //Submit data to database plus store exec into variable. $sqlsubmit ="INSERT INTO user VALUES ('','$firstname','$lastname','$username','$password','$email','$date',)"; mysql_query($sqlsubmit); //echo success. echo "successfully submitted to the database"."&lt;br&gt;"."&lt;a href='user.php'&gt;Click Here To Go To Your Accont&lt;/a&gt;"; exit; } } elseif(!isset($submit)) { echo "&lt;/br&gt;"."Enter your info here!!!!! :))"; } echo "&lt;/div&gt;"; ?&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