Untitled

0) { $row = mysqli_fetch_assoc($results); echo "Grade : ".$row['Grade']; } else { echo "Error: ".$sql."
".mysqli_error($con); } mysqli_close($con); } ?>

<!DOCTYPE html>
<html>
<body>
<script type="text/javascript">
function checkFunc()
{
    var indexNum = document.getElementById("indexBoxID").value;
    var nameBoxCheck = document.getElementById("nameBoxID").value;
    $bool=false;
    if(indexNum=="" && nameBoxCheck=="")
    {
        document.getElementById("nameBoxID").value="Can't be Empty";
        document.getElementById("indexBoxID").value="Can't be Empty";
    }

    else
    {
        if(indexNum.slice(0,2)=="as")
        {
            document.getElementById("nameBoxID").innerHTML="Please Type Index letters in Capital form";
        }

        else if(indexNum.slice(0,2)!="AS"&&indexNum.slice(0,2)!="as")
        {
            document.getElementById("indexBoxID").value="Not valid";
        }
        else
            $bool=true;
            //$.ajax({ url:'capture.php',type: 'post'}).done(function(){alert(JSON.stringify("Done"))});

    }
    return $bool;
}
</script>

<form action="capture.php" method="POST" onsubmit="return checkFunc();">
Name : <input type="text" id="nameBoxID" name="nameBox"><br>
Index : <input type="text" id="indexBoxID" name="indexBox"><br>
Grade : <input type="text" id="gradeBoxID" name="gradeBox" value="" readonly><br><br>
<input type="submit" value="Submit">

</body>
</html>

<?php
$nameBoxPhp =$_POST["nameBox"];
$indexBoxPhp = $_POST["indexdBox"];
dbConnect($nameBoxPhp,$indexBoxPhp);


function dbConnect($nameBox1, $indexBox1)
{
    $servername ="localhost";
    $username="root";
    $password="";
    $dbname="student";
    //To create a connection
    $con = mysqli_connect($servername,$username,$password,$dbname);

    //check connection
    if(!$con){
        die("Connection failed: ".mysqli_connect_error());
    }

    $sql="SELECT * FROM StudentRec";
    $results=mysqli_query($con,$sql);

    if(mysqli_num_rows($results)>0)
    {
        $row = mysqli_fetch_assoc($results);
        echo "Grade : ".$row['Grade'];
    }
    else
    {
        echo "Error: ".$sql."<br>".mysqli_error($con);
    }
    mysqli_close($con);
    }


    ?>