Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- $_SESSION['message'] = "";
- $mysqli = new mysqli("localhost", "root", "", "accounts") or die ("Cannot connect");
- if ($_SERVER['REQUEST_METHOD'] == 'POST') {
- $fusername = $mysqli->real_escape_string($_POST['username']);
- if (empty($fusername) && empty($fpassword)) {
- $_SESSION['message'] = "Syötä käyttäjätieodt";
- }else{
- $sql = "SELECT `id`, `username`, `email`, `password`, `active` FROM `users` WHERE username = '$fusername'";
- $query = mysqli_query($mysqli, $sql);
- $count = mysqli_num_rows($query);
- if ($count > 0) {
- while($row = mysqli_fetch_array($query)){
- $_SESSION['username'] = $row['username'];
- $_SESSION['email'] = $row['email'];
- $_SESSION['id'] = $row['id'];
- $password = $row['password'];
- $active = $row['active'];
- if (password_verify($_POST['password'], $password)) {
- if ($active > 0) {
- $_SESSION['message'] = "Sisäänkirjautuminen onnsitui, sinut ohjataan takasin etusivulle.";
- sleep(2);
- header("location: index.php");
- }else{
- $_SESSION['message'] = "Tiliäsi ei ole aktovoitu.";
- }
- }else{
- $_SESSION['message'] = "Väärä käyttäjänimi tai salasana.";
- }
- }
- }
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement