Advertisement
Guest User

Untitled

a guest
Oct 5th, 2016
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.25 KB | None | 0 0
  1. <?php
  2. define('HOST','mysql.hostinger.in');
  3. define('USER','u320657157_kumbh');
  4. define('PASS','#pass');
  5. define('DB','u320657157_kumbh');
  6.  
  7. $con = mysqli_connect(HOST,USER,PASS,DB) or die('Unable to Connect');
  8.  
  9. <?php
  10. if($_SERVER['REQUEST_METHOD']=='POST'){
  11. $name = $_POST['name'];
  12. $username = $_POST['username'];
  13. $password = $_POST['password'];
  14. $email = $_POST['email'];
  15.  
  16. if($name == '' || $username == '' || $password == '' || $email == ''){
  17. echo 'please fill all values';
  18. }else{
  19. require_once('dbConnect.php');
  20. $sql = "SELECT * FROM users WHERE username='$username' OR email='$email'";
  21.  
  22. $check = mysqli_fetch_array(mysqli_query($con,$sql));
  23.  
  24. if(isset($check)){
  25. echo 'username or email already exist';
  26. }else{
  27. $sql = "INSERT INTO users (name,username,password,email) VALUES('$name','$username','$password','$email')";
  28. if(mysqli_query($con,$sql)){
  29. echo 'successfully registered';
  30. }else{
  31. echo 'oops! Please try again!';
  32. }
  33. }
  34. mysqli_close($con);
  35. }
  36. }else{
  37. echo 'error';
  38. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement