Databases
StackOverflow2013
Postsdbo
POMysql comparing user's data to database data
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMysql comparing user's data to database data
    primarykey
    data
    text
    <p>I am developing a registration form with validation and I have a database using mysql. And I want to compare the user's entered data to the data's in the database specially the email to check if it's already listed/used in the database. I have made an alert code if the user enters less than 6 characters for the password and I want to do the same for the email address if it is already existing in my database. Here is my code:</p> <p>Form Code:</p> <pre><code> &lt;?php //Start session session_start(); ?&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&gt; &lt;head&gt; &lt;meta charset="utf-8"&gt; &lt;title&gt; Athan Motorcycle Spare Parts and Accesories&lt;/title&gt; &lt;link rel="stylesheet" href="css/bootstrap.css" type="text/css"/&gt; &lt;script type="text/javascript"&gt; function validateForm() { var a=document.forms["abc"]["firstname"].value; var b=document.forms["abc"]["lastname"].value; var d=document.forms["abc"]["email"].value; var e=document.forms["abc"]["pword"].value; var f=document.forms["abc"]["ambot"].value; var g=document.forms["abc"]["number"].value; var h=document.forms["abc"]["house"].value; var i=document.forms["abc"]["street"].value; var j=document.forms["abc"]["city"].value; if ((a==null || a=="")) { alert("you must enter your username"); return false; } if ((b==null || b=="")) { alert("you must enter your password"); return false; } if ((d==null || d=="")) { alert("you must enter your email address"); return false; } if ((e==null || e=="")) { alert("you must enter your password"); return false; } if ((f==null || f=="")) { alert("Retype password"); return false; } if ((g==null || g=="")) { alert("you must enter your contact number"); return false; } if ((h==null || h=="")) { alert("you must enter your house location"); return false; } if ((i==null || i=="")) { alert("you must enter your Street"); return false; } if ((j==0 || j=="")) { alert("Please select your City"); return false; } if( e != f ) { alert("Password does not match"); return false; } var atpos=d.indexOf("@"); var dotpos=d.lastIndexOf("."); if (atpos&lt;1 || dotpos&lt;atpos+2 || dotpos+2&gt;=d.length) { alert("Not a valid e-mail address"); return false; } } &lt;/script&gt; &lt;script type="text/javascript" src="jquery.js"&gt;&lt;/script&gt; &lt;script type="text/javascript"&gt; $(document).ready(function(){ //called when key is pressed in textbox $("#contact").keypress(function (e) { //if the letter is not digit then display error and don't type anything if( e.which!=8 &amp;&amp; e.which!=0 &amp;&amp; (e.which&lt;48 || e.which&gt;57)) { //display error message $("#errmsg").html("Number Only").show().fadeOut("slow"); return false; } }); }); &lt;/script&gt; &lt;/script&gt; &lt;/head&gt; &lt;div id="fb-root"&gt;&lt;/div&gt; &lt;script&gt;(function(d, s, id) { var js, fjs = d.getElementsByTagName(s)[0]; if (d.getElementById(id)) return; js = d.createElement(s); js.id = id; js.src = "//connect.facebook.net/en_US/all.js#xfbml=1"; fjs.parentNode.insertBefore(js, fjs); }(document, 'script', 'facebook-jssdk'));&lt;/script&gt; &lt;script&gt;(function(d, s, id) { var js, fjs = d.getElementsByTagName(s)[0]; if (d.getElementById(id)) return; js = d.createElement(s); js.id = id; js.src = "//connect.facebook.net/en_US/all.js#xfbml=1"; fjs.parentNode.insertBefore(js, fjs); }(document, 'script', 'facebook-jssdk'));&lt;/script&gt; &lt;body&gt; &lt;script src="http://code.jquery.com/jquery-1.10.1.min.js"&gt;&lt;/script&gt; &lt;script src=”js/bootstrap.js”&gt;&lt;/script&gt; &lt;div class="container well"&gt; &lt;div class="navbar"&gt; &lt;div class="navbar-inner"&gt; &lt;div class="container"&gt; &lt;ul class="nav"&gt; &lt;li&gt;&lt;img src="img/12.jpg"&gt;&lt;/a&gt;&lt;/li&gt; &lt;li class="active"&gt;&lt;a href="index.html"&gt;Home&lt;/a&gt;&lt;/li&gt; &lt;li&gt;&lt;a href="customization.html"&gt;Customization&lt;/a&gt;&lt;/li&gt; &lt;li&gt;&lt;a href="error.php"&gt;Order Parts&lt;/a&gt;&lt;/li&gt; &lt;li&gt;&lt;a href="inspiration.html"&gt;Inspiration Gallery&lt;/a&gt;&lt;/li&gt; &lt;li&gt;&lt;a href="about.html"&gt;About us&lt;/a&gt;&lt;/li&gt; &lt;li&gt;&lt;a href="loginuser.php"&gt;Login&lt;/a&gt;&lt;/li&gt; &lt;/ul&gt; &lt;/div&gt; &lt;/div&gt; &lt;/div&gt; &lt;div class="hero-unit"&gt; &lt;!-- Skitter Styles --&gt; &lt;link href="css/skitter.styles.css" type="text/css" media="all" rel="stylesheet" /&gt; &lt;!-- Skitter JS --&gt; &lt;script type="text/javascript" language="javascript" src="js/jquery-1.6.3.min.js"&gt; &lt;/script&gt; &lt;script type="text/javascript" language="javascript" src="js/jquery.easing.1.3.js"&gt; &lt;/script&gt; &lt;script type="text/javascript" language="javascript" src="js/jquery.animate-colors- min.js"&gt;&lt;/script&gt; &lt;script type="text/javascript" language="javascript" src="js/jquery.skitter.min.js"&gt;&lt;/script&gt; &lt;!-- Init Skitter --&gt; &lt;script type="text/javascript" language="javascript"&gt; $(document).ready(function() { $('.box_skitter_large').skitter({ theme: 'clean', numbers_align: 'center', progressbar: true, dots: true, preview: true }); }); &lt;/script&gt; &lt;style type="text/css"&gt; input[type=number]::-webkit-inner-spin-button, input[type=number]::-webkit-outer-spin-button { -webkit-appearance: none; margin: 0; } &lt;/style&gt; &lt;br&gt; &lt;div style="width:400px; margin:0 auto; position:relative; border:3px solid rgba(0,0,0,0); -webkit-border-radius:5px; -moz-border-radius:5px; border-radius:5px; -webkit-box-shadow:0 0 18px rgba(0,0,0,0.4); -moz-box-shadow:0 0 18px rgba(0,0,0,0.4); box-shadow:0 0 18px rgba(0,0,0,0.4); margin-top:20px; color:#FF0A0A;"&gt; &lt;form id="form1" name="abc" method="post" action="addmem.php" onsubmit="return validateForm()"&gt; &lt;div style="background-color:#cccccc; font-family:Arial, Helvetica, sans-serif; color:#000000; padding:5px; height:22px; width:390px;"&gt; &lt;div style="float:left;"&gt;&lt;strong&gt;Members Registration&lt;/strong&gt;&lt;/div&gt; &lt;div style="float:right; margin-right:3px; background-color:#cccccc; width:25px; text-align:center; height:22px;"&gt;&lt;a href="loginuser.php"&gt;X&lt;/a&gt;&lt;/div&gt; &lt;/div&gt; &lt;table width="368" align="center"&gt; &lt;tr&gt; &lt;td colspan="2"&gt;&lt;div style="font-family:Arial, Helvetica, sans-serif; font-size:14px;"&gt;&lt;font color="white"&gt;All Field Mark with asterisk (&lt;span class="style1"&gt;&lt;b&gt;*&lt;/b&gt;&lt;/span&gt;) must be filled up&lt;/div&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td colspan="2"&gt;&lt;div style="font-family:Arial, Helvetica, sans-serif; color:#FF0000; font-size:12px;"&gt;&lt;?php if( isset($_SESSION['ERRMSG_ARR']) &amp;&amp; is_array($_SESSION['ERRMSG_ARR']) &amp;&amp; count($_SESSION['ERRMSG_ARR']) &gt;0 ) { echo '&lt;ul class="err"&gt;'; foreach($_SESSION['ERRMSG_ARR'] as $msg) { echo '&lt;li&gt;',$msg,'&lt;/li&gt;'; } echo '&lt;/ul&gt;'; unset($_SESSION['ERRMSG_ARR']); } ?&gt;&lt;/div&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td width="120" valign="top"&gt;&lt;div align="right"&gt; &lt;font color="#00EBFF"&gt;Firstname: &lt;/div&gt;&lt;/td&gt; &lt;td width="236"&gt;&lt;input type="text" name="firstname"&gt; &lt;span class="style2"&gt;*&lt;/span&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td valign="top"&gt;&lt;div align="right"&gt;&lt;font color="#00EBFF"&gt;Lastname:&lt;/div&gt; &lt;/td&gt; &lt;td&gt;&lt;input type="text" name="lastname"&gt; &lt;span class="style2"&gt;*&lt;/span&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td valign="top"&gt;&lt;div align="right"&gt;&lt;font color="#00EBFF"&gt;Email:&lt;/div&gt;&lt;/td&gt; &lt;td&gt;&lt;input type="text" name="email"&gt; &lt;span class="style2"&gt;*&lt;/span&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td valign="top"&gt;&lt;div align="right"&gt;&lt;font color="#00EBFF"&gt;Password:&lt;/div&gt; &lt;/td&gt; &lt;td&gt;&lt;input type="password" name="pword"&gt; &lt;span class="style2"&gt;*&lt;/span&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td valign="top"&gt;&lt;div align="right"&gt;&lt;font color="#00EBFF"&gt;Retype Password:&lt;/div&gt;&lt;/td&gt; &lt;td&gt;&lt;input type="password" name="ambot"&gt; &lt;span class="style2"&gt;*&lt;/span&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td valign="top"&gt;&lt;div align="right"&gt;&lt;font color="#00EBFF"&gt;Contact Number: &lt;/div&gt;&lt;/td&gt; &lt;td&gt;&lt;input name="number" type="number" min="0" id="contact" size="11"&gt; &lt;span style="font-family:Arial, Helvetica, sans-serif; font- size:12px; color:#FF0000; font-weight:bold;" id="errmsg"&gt;&lt;/span&gt;&lt;span class="style2"&gt;* &lt;/span&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td valign="top"&gt;&lt;div align="right"&gt;&lt;font color="#00EBFF"&gt;Brgy. and House: &lt;/div&gt;&lt;/td&gt; &lt;td&gt;&lt;input type="text" name="house"&gt; &lt;span class="style2"&gt;*&lt;/span&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td valign="top"&gt;&lt;div align="right"&gt;&lt;font color="#00EBFF"&gt;Street No:&lt;/div&gt; &lt;/td&gt; &lt;td&gt;&lt;input type="text" name="street"&gt; &lt;span class="style2"&gt;*&lt;/span&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td valign="top"&gt;&lt;div align="right"&gt;&lt;font color="#00EBFF"&gt;City:&lt;/div&gt;&lt;/td&gt; &lt;td&gt;&lt;select name="city"&gt;&lt;option value="0"&gt;--Select One--&lt;/option&gt; &lt;option value="Caloocan City"&gt;Caloocan City&lt;/option&gt; &lt;option value="Las Pinas City"&gt;Las Pinas City&lt;/option&gt; &lt;option value="Makati City"&gt;Makati City&lt;/option&gt; &lt;option value="Malabon City"&gt;Malabon City&lt;/option&gt; &lt;option value="Mandaluyong City"&gt;Mandaluyong City&lt;/option&gt; &lt;option value="Manila"&gt;Manila&lt;/option&gt; &lt;option value="Marikina City"&gt;Marikina City&lt;/option&gt; &lt;option value="Muntinlupa City"&gt;Muntinlupa City&lt;/option&gt; &lt;option value="Navotas"&gt;Navotas&lt;/option&gt; &lt;option value="Paranaque City"&gt;Paranaque City&lt;/option&gt; &lt;option value="Pasay City"&gt;Pasay City&lt;/option&gt; &lt;option value="Pasig City"&gt;Pasig City&lt;/option&gt; &lt;option value="Pateros"&gt;Pateros&lt;/option&gt; &lt;option value="Quezon City"&gt;Quezon City&lt;/option&gt; &lt;option value="San Juan"&gt;San Juan&lt;/option&gt; &lt;option value="Taguig"&gt;Taguig&lt;/option&gt; &lt;option value="Valenzuela City"&gt;Valenzuela City&lt;/option&gt;&lt;/select&gt; &lt;span class="style2"&gt;*&lt;/span&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td valign="top"&gt;&amp;nbsp;&lt;/td&gt; &lt;td&gt;&lt;input type="submit" value="Save"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/form&gt; &lt;/div&gt; &lt;hr&gt; &lt;div class="footer"&gt; &lt;p&gt;Copyright &amp;copy; Athan Motorcycle&lt;/p&gt; &lt;/div&gt; &lt;/body&gt; &lt;/html&gt; </code></pre> <p>And here is my PHP code where i put the error:</p> <pre><code>&lt;?php session_start(); $errmsg_arr = array(); $errflag = false; include('config.php'); $firstname=$_POST['firstname']; $lastname=$_POST['lastname']; $email=$_POST['email']; $pword=$_POST['pword']; $number=$_POST['number']; $house=$_POST['house']; $street=$_POST['street']; $city=$_POST['city']; $min_length = 6; // you can set minimum length of the query if you want if(strlen($pword) &gt;= $min_length){ //this one will not feed in the database if there's a duplicate but still a problem ohmaygawd:3 //mysql_query("INSERT INTO athan_members (firstname, lastname, email, number, house1, street1, city, password) VALUES ('$firstname', '$lastname', '$email', '$number', '$house', '$street', '$city', '$pword') ON DUPLICATE KEY UPDATE") mysql_query("INSERT INTO athan_members (firstname, lastname, email, number, house1, street1, city, password) VALUES ('$firstname', '$lastname', '$email', '$number', '$house', '$street', '$city', '$pword')"); header("location: loginuser.php"); } else { $errmsg_arr[] = 'password must contain not less than 6 characters'; $errflag = true; } if($errflag) { $_SESSION['ERRMSG_ARR'] = $errmsg_arr; session_write_close(); header("location: new.php"); exit(); } mysql_close($con); ?&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USNightshade
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POMysql comparing user's data to database data
      1. This table or related slice is empty.
      1. VTDownMod
    1. COPlease use `PDO` or `mysqli`. `mysql_` is deprecated.
      singulars
      1. POMysql comparing user's data to database data
      1. USRayhan Muktader
    2. COWhere are you learning to do things this way? This is a super antiquated and massively error prone way of doing things. Using a [development framework](http://codegeekz.com/best-php-frameworks-for-developers/) will make it a lot easier to get things done.
      singulars
      1. POMysql comparing user's data to database data
      1. UStadman
    3. COi'm just a super newbie sir @tadman and i'm just learning on my own way :3
      singulars
      1. POMysql comparing user's data to database data
      1. USNightshade
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

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