Databases
StackOverflow2013
Postsdbo
POPHP registration system user info not being stored in mysql
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPHP registration system user info not being stored in mysql
    text
    copied!<p>I have a basic registration system. Code is bellow. It is unable to register users. The connect.php site works ... the login part works if I manually add information to the database. I keep on getting an error message which I set see bellow ... "An error has occurred. Your account was not created."</p> <pre><code>&lt;?php if ( $_POST['registerbtn'] ){ $getuser = $_POST['user']; $getemail = $_POST['email']; $getpass = $_POST['pass']; $getretypepass = $_POST['retypepass']; if ($getuser){ if ($getemail){ if ($getpass){ if ($getretypepass){ if ( $getpass === $getretypepass ){ if( (strlen($getemail) &gt;= 7) &amp;&amp; (strstr($getemail,"@")) &amp;&amp; (strstr($getemail,".")) ){ require("./connect.php"); $query = mysql_query("SELECT * FROM users WHERE username='$getuser'"); $numrows = mysql_num_rows($query); if ($numrows == 0){ $query = mysql_query("SELECT * FROM users WHERE email='$getemail'"); $numrows = mysql_num_rows($query); if ($numrows == 0){ $password = md5(md5("18sde#@!".$password."@1kwe#28")); $date = date("F d, Y"); $code = md5(rand()); mysql_query("INSERT INTO user VALUES ('', '$getuser', '$password', '$getemail', '0', '$code', '$date')"); $query = mysql_query("SELECT * FROM users WHERE username='$getuser'"); $numrows = mysql_num_rows($query); if ($numrows == 1){ $site = "http://localhost/test"; $webmaster = "activation@test.com"; $headers = "From: $webmaster"; $subject = "Activate your account"; $message = "Thanks for registering. Click the link below to active your account."; $message .= "$site/activate.php?user=$getuser&amp;code=$code"; $message .= "You must activate your account to login."; if ( mail($getemail, $subject, $message, $headers) ){ $errormsg = "You have been registered. You must activate your account using your email $getemail"; $getusr = ""; $getemail = ""; } else $errormsg = "An error has occurred. Your activation email was not sent."; } else $errormsg = "An error has occurred. Your account was not created."; } else $errormsg ="There is already a email with that email."; } else $errormsg ="There is already a user with that username."; mysql_close(); } else $errormsg = "You must enter a valid email address to register."; } else $errormsg = "Your passwords did not match"; } else $errormsg = "You must retype your password to register."; } else $errormsg = "You must enter your password to register."; } else $errormsg = "You must enter your email to register."; } else $errormsg = "You must enter your username to register."; } $form = "&lt;form action='./register.php' method='post'&gt; &lt;table&gt; &lt;tr&gt; &lt;td&gt;&lt;/td&gt; &lt;td&gt;&lt;font color='red'&gt;$errormsg&lt;/font&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Username:&lt;/td&gt; &lt;td&gt;&lt;input type='text' name='user' value'$getuser' /&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'$getemail' /&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='pass' value'' /&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Retype Password:&lt;/td&gt; &lt;td&gt;&lt;input type='password' name='retypepass' value'' /&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;/td&gt; &lt;td&gt;&lt;input type='submit' name='registerbtn' value'Register' /&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/form&gt;"; echo $form; ?&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