Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $sql = mysqli_connect("bla" , "bla" , "bla" , "db");
- $password = $_POST['password'];
- $emailuser = $_POST['unameemail'];
- $password = mysqli_real_escape_string($sql , $password);
- $emailuser = mysqli_real_escape_string($sql , $emailuser);
- $stmt = $sql->prepare("SELECT password FROM `private` AS p
- INNER JOIN `user_private_data`
- AS pa ON pa.id=p.id
- WHERE username=? OR email=?");
- if ($stmt) {
- /* Bind parameters: s - string, b - blob, i - int, etc */
- $stmt -> bind_param("ss", $emailuser , $emailuser);
- /* Execute it */
- $stmt -> execute();
- /* Bind results */
- $stmt -> bind_result($pwresult);
- /* Fetch the value */
- $stmt -> fetch();
- /* Close statement */
- $stmt -> close();
- }
- $mysqliThing1 = "SELECT * FROM private AS f INNER JOIN user_private_data AS h ON f.id = h.id WHERE username='.$emailuser.' OR email='.$emailuser.'";
- $mysqliResult1 = mysqli_query($sql , $mysqliThing1);
- $msqlArr1 = mysqli_fetch_array($mysqliResult1, MYSQLI_ASSOC);
- if (password_verify($password , $pwresult)) {
- $_SESSION['username'] = $msqlArr1['username'];
- $_SESSION['logged'] = true;
- $_SESSION['type'] = "private";
- echo $_SESSION['username'];
- echo $_SESSION['logged'];
- echo $_SESSION['type'];
- exit;
- header("refresh:0;url=../home.php");
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement