Databases
StackOverflow2013
Postsdbo
POCheck the username availability and update the fields and also the username without ajax and jquery
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCheck the username availability and update the fields and also the username without ajax and jquery
    text
    copied!<pre><code>&lt;!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"&gt; &lt;?php include('db_connection.php'); error_reporting(E_ALL); session_start(); ?&gt; &lt;html&gt; &lt;head&gt; &lt;title&gt;Register Form&lt;/title&gt; &lt;link rel="STYLESHEET" type="text/css" href="style.css"&gt; &lt;script type="text/javascript"&gt; function validate(form) { var name = document.register.name.value; var email = document.register.email.value; var apos = document.register.email.value.indexOf("@"); var dotpos = document.register.email.value.lastIndexOf("."); var username = document.register.username.value; var password = document.register.password.value; var con_password = document.register.con_password.value; if (name==null || name=="") { alert("Enter The Name"); document.register.name.focus(); return false; } else if (email==null || email=="") { alert("Enter The Email"); document.register.name.focus(); return false; } else if ( apos&lt;1 || dotpos-apos&lt;2) { alert("Invalid Email Address!!!") document.register.email.focus(); return false } else if (username==null || username=="") { alert("Enter The User Name"); document.register.username.focus(); return false; } else if (password.length &lt; 6 || password.length &gt; 12 ) { alert("Password must contain at least 6 less than 12 characters!"); document.register.password.focus(); return false; } else if (con_password.length &lt; 6 || con_password.length &gt; 12) { alert("Password must contain at least 6 less than 12 characters!"); document.register.con_password.focus(); return false; } else if (password != con_password) { alert("You did not enter the same new password twice.Please re-enter your password!"); document.register.con_password.focus(); return false; } else { return true; } } &lt;/script&gt; &lt;/head&gt; &lt;body&gt; &lt;?php if(isset($_SESSION['session_name1'])) { unset($_SESSION['session_name1']); unset($_SESSION['session_email1']); unset($_SESSION['session_username1']); } if(isset($_GET['action'])) { $action=$_GET['action']; } else { $action = 'add'; } if($action=='edit' &amp;&amp; $_GET['id']!="") { $id = $_GET['id']; $user_edit = mysql_query("SELECT Name,Email,UserName,Password,Date FROM loginform WHERE UserId='$id'"); $row_edit = mysql_fetch_array($user_edit); $edit_name = $row_edit['Name']; $edit_email = $row_edit['Email']; $edit_username = $row_edit['UserName']; $edit_password = $row_edit['Password']; } if(isset($_POST['submit'])) { $name = $_POST['name']; $email = $_POST['email']; $username = $_POST['username']; $password = $_POST['password']; if($action=='add') { $query = "SELECT UserName FROM loginform WHERE UserName = '$username'"; $result = mysql_query($query) or die (); $check_username = mysql_num_rows($result); if($check_username ==0) { mysql_query("insert into loginform (UserId,Name,Email,UserName,Password,Date)Values('','$name','$email','$username','$password',now()) ") or die(mysql_error()); header("Location:Login.php"); } else {?&gt; &lt;center&gt;&lt;b&gt;&lt;?php echo "Ohhh....User Name Already Taken";?&gt;&lt;/b&gt;&lt;/center&gt; &lt;?php } } if($action=='edit') { $query = "SELECT UserId,UserName FROM loginform WHERE UserName = '$username'"; $result = mysql_query($query) or die (); $check_username = mysql_num_rows($result); echo "=====&gt;".$check_username; if($check_username ==0) { mysql_query("UPDATE loginform SET Name='$name',Email='$email',UserName='$username',Password='$password' WHERE UserId='$id'") or die(mysql_error()); header("Location:list_view.php"); } else { echo "&lt;b&gt;Ohhh....User Name Already Taken&lt;/b&gt;"; //mysql_query("UPDATE loginform SET Name='$name',Email='$email',Password='$password' WHERE UserId='$id'") or die(mysql_error()); //header("Location:list_view.php"); } } } ?&gt; &lt;form name="register" action="" method="post"&gt; &lt;table align="center" border="1" cellpadding="2" cellspacing="1"&gt; &lt;tr&gt; &lt;td colspan="2" align="center"&gt;&lt;?php if(!empty($_GET['id'])) { ?&gt;&lt;h2&gt;Update Form&lt;/h2&gt;&lt;?php } else { ?&gt;&lt;h2&gt;Register Form&lt;/h2&gt;&lt;?php }?&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Name:&lt;/td&gt; &lt;td&gt;&lt;input type="Text" name="name" id="name" value="&lt;?php if($action=='edit') echo $edit_name; ?&gt;"/&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" id="email" value="&lt;?php if($action=='edit') echo $edit_email; ?&gt;"/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;User Name:&lt;/td&gt; &lt;td&gt;&lt;input type="Text" name="username" id="username" value="&lt;?php if($action=='edit') echo $edit_username; ?&gt;"/&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" id="password" value="&lt;?php if($action=='edit') echo $edit_password; ?&gt;"/&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="con_password" id="con_password" value="&lt;?php if($action=='edit') echo $edit_password; ?&gt;"/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td colspan="2" align="center"&gt;&lt;?php if(!empty($_GET['id'])) { ?&gt; &lt;input type="submit" value="Update" title="Update" name="submit" onclick="return validate(this.form);"/&gt; &lt;?php } else { ?&gt; &lt;input type="submit" name="submit" title="Add" value="Submit" onclick="return validate(this.form);"/&gt; &lt;?php }?&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/form&gt; &lt;?php ?&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