Untitled

<html>
<head><title>Updating User Details</title>
<script src="js/jquery-1.12.4.js"></script>
  <script src="js/jquery-ui.js"></script></head>
<body>
<div id="display">
<header> <img src="images/ipoint.png" class="logo" /> USER REGISTRATION</header>
<div class="container">
<h1 style="text-align:center">UPDATING THE USER DETAILS</h1>
<style>
#display {
color:red;
font-size:12px;
text-align:center;
}
.logo {
padding:5px;
float:left;
}
header {
background-color:#074e7c;
height:60px;
width:100%;
text-align:center;
color:white;
font-size:40px;

}
#wrap {
text-align:center;
}
</style>
<?php
include('db.php');

?>
<input type="hidden" name="userid" id="userid">
<?php
$userid=mysql_real_escape_string($_POST['userid']);
$userName=mysql_real_escape_string($_POST['userName']);
$userEmail=mysql_real_escape_string($_POST['userEmail']);
$userPassword=mysql_real_escape_string($_POST['userPassword']);
$string="update coeds_user set userName='$userName',userPassword='$userPassword',userEmail='$userEmail' where userId=$userid";
echo $string;
$query=mysqli_query($string);
if($query)
{
$display="Update Successful";
}
else
{
$display= "Update Failed";
}
echo $display;

?>
</div>
</div>
<script type="text/javascript">
$(document).ready(function(){

$("#update").click(function(e){


    var userName = $("#userName").val();
    var userEmail = $("#userEmail").val();
    var userPassword = $("#userPassword").val();


    var dataString='userName='+userName+'&userEmail='+userEmail+'&userPassword='+userPassword;
    alert(dataString);
    if(userName==""||userEmail==""||userPassword=="")
    {
    document.getElementById("display").innerHTML="Please Enter The Fields";
    }

    else
    {
    $.ajax({
                type: "POST",
                url: "user_update.php",
                data: dataString,
                cache: false,
                success: function(result){
                //alert("submitted"+result);
                $('#display').html(result);

                },
                error: function (xhr, ajaxOptions, thrownError) {
                        alert(xhr.status);
                        alert(thrownError);
                }
                });

                }
                e.preventDefault();
                });
                });
                </script>
</body>
</html>

<?php
$user="root";
$server="localhost";
$password="";
$db="coedsproddb1";
$dbconn= mysqli_connect($server,$user,$password);
mysql_select_db($db,$dbconn);

?>
<html>
<head><title>Insert</title>
<link rel="stylesheet" href="css/jquery-ui.css">
<script src="js/jquery-1.12.4.js"></script>
  <script src="js/jquery-ui.js"></script>
</head>
<body>
<header> <img src="images/ipoint.png" class="logo" /> USER REGISTRATION</header>
<div class="container">
<h1 style="text-align:center">ADDING THE USER DETAILS</h1>
<style>
#display {
color:red;
font-size:12px;
text-align:center;
}
.logo {
padding:5px;
float:left;
}
header {
background-color:#074e7c;
height:60px;
width:100%;
text-align:center;
color:white;
font-size:40px;

}
#wrap {
text-align:center;
}
</style>
<form name="useradd" id="useradd" action="#" method="post">
<table align='center' border='1'>

    <tr>

           <td> <label for="userName">UserName</label></td>
            <td ><input id="userName" name="userName"  type="text" /></td>


        </tr>
        <tr>
        <td> <label for="userEmail">Email</label></td>
        <td ><input id="userEmail" name="userEmail" type="text"/></td>
        </tr>
        <tr>
        <td>
            <label for="userPassword">password</label></td>
            <td ><input id="userPassword" name="userPassword" type="password" /></td>


        </tr>


        <tr>

           <td> <label for="ogeeid">Ogeeid</label></td>
           <td ><input id="ogeeid" name="ogeeid" type="text" />  </td>

        </tr>

        </table>


<br>
<div id="wrap">
<input type="submit" name="add" value="add" id="add">
<input type="submit" name="update" value="update" id="update">
</div>
</form>
<div id="display">
</div>

</div>
<script type="text/javascript">
$(document).ready(function(){

$("#add").click(function(e){


    var userName = $("#userName").val();
    var userEmail = $("#userEmail").val();
    var userPassword = $("#userPassword").val();


    var ogeeid = $("#ogeeid").val();


    var dataString='userName='+userName+'&userEmail='+userEmail+'&userPassword='+userPassword+'&ogeeid='+ogeeid;
    alert(dataString);
    if(userName==""||userEmail==""||userPassword==""||ogeeid=="")
    {
    document.getElementById("display").innerHTML="Please Enter The Fields";
    }
    else if(!validate1($.trim(userName)))
    {
    document.getElementById("display").innerHTML="Please Enter The Valid UserName";
    document.getElementById("display").focus();
    }
    else if(!ValidateEmail($.trim(userEmail)))
    {
    document.getElementById("display").innerHTML="Please Enter The Valid Emailid";
    document.getElementById("display").focus();
    }
    else
    {
    $.ajax({
                type: "POST",
                url: "insert.php",
                data: dataString,
                cache: false,
                success: function(result){
                //alert("submitted"+result);
                $('#display').html(result);

                },
                error: function (xhr, ajaxOptions, thrownError) {
                        alert(xhr.status);
                        alert(thrownError);
                }
                });

                }
                e.preventDefault();
                });
                function validate1(userName)
                {
                var u=userName;
                var filter=/^[a-zA-Z0-9]+$/;
                if(filter.test(u))
                {
                return true;
                }
                else
                {
                return false;
                }
                }
                function ValidateEmail(userEmail)
       {
         var e=userEmail;
         var filter=/^w+([.-]?w+)*@w+([.-]?w+)*(.w{2,3})+$/;
         if(filter.test(e)) {
                return true;
            }
            else {
                return false;
            }
        }


                });
                </script>


</body>
</html>