Advertisement
Guest User

Untitled

a guest
Jan 6th, 2019
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None | 0 0
  1. <?php
  2.  
  3. //$query = "INSERT INTO tbluser (FirstName,LastName,Username,Password) VALUES ('$FirstName', '$LastName',$UserName','$Password')";
  4.  
  5. function Signup()
  6. {
  7. $con=mysqli_connect('localhost','root','','site');
  8.  
  9.  
  10.  
  11. if(isset($_POST['user']))
  12. {
  13. $query = mysqli_query($con, "SELECT * FROM cliente WHERE Username = \"".$_POST["user"]."\" AND Password = \"".$_POST["pass"]."\";");
  14.  
  15. if(!$row = mysqli_fetch_array($query))
  16. {
  17. $reg_query = "INSERT INTO tbluser VALUES (0, '".$_POST["FName"]."', '".$_POST["LName"]."', '".$_POST["BirthDate"]."' , '".$_POST["user"]."', '".$_POST["pass"]."', '".$_POST["Email"]."');";
  18.  
  19. mysqli_query($con, $reg_query);
  20. }
  21. else
  22.  
  23. {
  24. $data = mysqli_fetch_array($query, MYSQLI_NUM);
  25. if ($data[0] > 1) {
  26. echo "User Already exists";
  27. }
  28.  
  29. }
  30. }
  31.  
  32. }
  33.  
  34.  
  35. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement