Guest User

Untitled

a guest
May 22nd, 2018
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "root";
  4. $password = "";
  5. $dbname="sample";
  6.  
  7. // Create connection
  8. $conn = mysqli_connect($servername,$username,$password,$dbname);
  9. $pos=$_REQUEST['Position'];
  10. $date=$_REQUEST['JoinDate'];
  11. $name=$_REQUEST['FirstName'];
  12. $lname=$_REQUEST['LastName'];
  13. $PhNo=$_REQUEST['PhoneNumber'];
  14. $email=$_REQUEST['EmailId'];
  15. $dob=$_REQUEST['DateofBirth'];
  16. $pob=$_REQUEST['PlaceOfBirth'];
  17. $nationality=$_REQUEST['Nationality'];
  18. $status=$_REQUEST['MaritalStatus'];
  19. $address=$_REQUEST['Address'];
  20.  
  21. $insert_query="insert into sample.user_details (Position,JoinDate,FirstName,LastName,PhoneNumber,EmailId,DateofBirth,PlaceOfBirth,Nationality,MaritalStatus,Address) values ('$pos','$date','$name','$lname','$PhNo','$email','$dob','$pob','$nationality','$status','$address')";
  22.  
  23.  
  24.  
  25.  
  26. if($conn->query($insert_query)===TRUE) {
  27.  
  28. echo"yes";
  29. }else{
  30. echo "no";
  31. }
  32.  
  33.  
  34. ?>
Add Comment
Please, Sign In to add comment