include 'dbConnect.php'; if($con) { //echo "connection done"; } else { //echo "connection error"; } if(isset($_POST["register"])) { $userName = $_POST["userName"]; $password = $_POST["password"]; $designation = $_POST["designation"]; $area = $_POST["area"]; //Slno activityId activityName priority dateInit area taskCo remarks status lastUpdated deadline category //echo $area." ".$category." ".$activity." ". $taskcoordinator." ".$officerresponsible." ".$dateInit." ".$ststus; $sql2 = "select * from userMaster where designation = '$designation'"; $query2 = mysqli_query($con,$sql2 ) or mysqli_error(); $rowCount = mysqli_num_rows($query2); if($rowCount==1) { echo ""; } else { $sql3 = "insert into userMaster (slNo,userName,password,designation,area) values ('','$userName','$password','$designation','$area')"; $query3 = mysqli_query($con,$sql3 ) or mysqli_error(); //echo $sql00; echo ""; //session_start(); //$_SESSION["userName"] = $userName; //$_SESSION["password"] = $password; //header("location:activityMain.php"); } //echo $sql2; } ?>