Advertisement
Guest User

DB_Connect

a guest
Feb 26th, 2018
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.40 KB | None | 0 0
  1. <?php
  2. // Used to Login & Register users
  3. ob_start();
  4. session_start();
  5.  
  6. //---------------------------------
  7.  //Error Array
  8.  
  9.     $errors = array();
  10.     $fname = "";
  11.     $lname = "";
  12.     $userName = "";
  13.  
  14. // To Connect To The Server - Used MySQLi
  15.  
  16. $db_connect = mysqli_connect('localhost','root','mariadb123','users');
  17.  
  18. If($db_connect){
  19.     echo "sucess";
  20. }
  21.  
  22. else  {
  23.     echo "Failed";
  24. }
  25.  
  26. if(isset($_POST['register'])){
  27.  
  28.     $fName = mysqli_real_escape_string($db_connect,$_POST['FirstName']);
  29.     $lName = mysqli_real_escape_string($db_connect,$_POST['LastName']);
  30.     $userName = mysqli_real_escape_string($db_connect,$_POST['UserName']);
  31.     $pass_1 = mysqli_real_escape_string($db_connect,$_POST['password_1']);
  32.     $pass_2 = mysqli_real_escape_string($db_connect,$_POST['password_2']);
  33.     $userEmail = mysqli_real_escape_string($db_connect,$_POST['Email']);
  34.  
  35.  
  36.     // Check if fields are filled.
  37.  
  38.     if(empty($fName)){
  39.         array_push($errors,"First Name is required.");
  40.     }
  41.  
  42.     if(empty($lName)){
  43.         array_push($errors,"Last Name is required.");
  44.     }
  45.  
  46.     if(empty($userName)){
  47.         array_push($errors,"User Name is required.");
  48.     }
  49.  
  50.     if(empty($userEmail)){
  51.         array_push($errors,"Email is required.");
  52.     }
  53.  
  54.     if(empty($pass_1)){
  55.         array_push($errors,"Password is required.");
  56.     }
  57.  
  58.     if(empty($pass_2)){
  59.         array_push($errors,"Please Confirm the passwords.");
  60.     }
  61.  
  62.     if($pass_1 != $pass_2){
  63.         array_push($errors,"Passwords do not match. Please try again.");
  64.     }
  65.  
  66.     if(count($errors)==0){
  67.  
  68.         $password = password_hash($pass_1,PASSWORD_DEFAULT);
  69.  
  70.         $query = "INSERT INTO user_t(user_FName,user_LName,user_userName,user_Email,user_Password) VALUES ('$fName','$lName','$userName','$userEmail','$password')";
  71.  
  72.         $result = mysqli_query($db_connect,$query);
  73.  
  74.         $query = "SELECT user_ID from user_t WHERE user_Email='$userEmail';";
  75.         $result = mysqli_query($db_connect,$query);
  76.         $row = mysqli_fetch_array($result, MYSQLI_BOTH);
  77.         mkdir("../../users/$row[0]", 0777, true);
  78.  
  79.         $_SESSION['userName'] = $userName;
  80.         //header('location:../index.php');
  81.     }
  82.  
  83. }
  84.  
  85. if(isset($_POST['login'])){
  86.  
  87. $email_or_userName = mysqli_real_escape_string($db_connect,$_POST['email']);
  88. $pass =  mysqli_real_escape_string($db_connect,$_POST['password']);
  89.  
  90.  
  91.  // checks with userName or Email
  92. $loginQuery = "SELECT * FROM user_t WHERE user_Email='$email_or_userName' OR user_userName = '$email_or_userName'";
  93. $result = mysqli_query($db_connect,$loginQuery); // Inserts Query into The Database and returns mysqli_result Object.
  94. $userRow = mysqli_fetch_array($result, MYSQLI_BOTH); // Stores the object into an array;
  95. $password = password_verify($pass,$userRow["user_Password"]); // Verifies the password
  96.  
  97. if(($userRow["user_Email"]==$email_or_userName || $userRow["user_userName"]==$email_or_userName) && $userRow["user_Password"]==$password ){
  98.  
  99.     $_SESSION['user_ID'] = $userRow["user_ID"]; // Sets user_ID session Variable to ID of the logged in User.
  100.     header("Location:../../index.html");
  101.  
  102. }
  103. }
  104. /*
  105. if(isset($_POST['post_ad'])){
  106.  
  107.     $itemTitle = mysqli_real_escape_string($db_connect,$_POST['item_Title']);
  108.     $itemPrice = mysqli_real_escape_string($db_connect,$_POST['FirstName']);
  109.     $itemCategory = mysqli_real_escape_string($db_connect,$_POST['FirstName']);
  110.     $itemLocation = mysqli_real_escape_string($db_connect,$_POST['FirstName']);
  111.     $itemDescription = mysqli_real_escape_string($db_connect,$_POST['FirstName']);
  112.  
  113.     // Image Upload And Checking
  114.  
  115.     $image
  116.  
  117. }
  118.  
  119. */
  120. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement