Login

<?php
/**
 * Created by PhpStorm.
 * User: Edward
 * Date: 5/16/2018
 * Time: 3:48 PM
 */

include('connection.php');    // aici ii conectiunea la baza de date ($connection = mysqli_connect("127.0.0.1" etc.. )
session_start();
$error = false;

if($_SERVER["REQUEST_METHOD"] == "POST") {

    $myusername = mysqli_real_escape_string($connection, $_POST['username']);
    $mypassword = mysqli_real_escape_string($connection, $_POST['password']);
    $mypassword = md5($mypassword); // parola ii criptata in baza de date cu md5

    $sql = "SELECT * FROM users WHERE username = '$myusername' and password = '$mypassword'";
    $result = mysqli_query($connection, $sql);
    $row = mysqli_fetch_array($result, MYSQLI_ASSOC);

    $count = mysqli_num_rows($result);

    // If result matched $myusername and $mypassword, table row must be 1 row

    if ($count == 1) {
        $_SESSION['username'] = $myusername;
        $_SESSION['login_user'] = $myusername;

        header("location: dashboard.php");
    } else {
        $error = true;
    }
}
?>