<?php
    session_start();

    // INPUT username = "Utilizator"
    // INPUT password = "Parola"
    // NUME TABEL BAZA DE DATE = "accounts"

    // Sa completezi tu mai jos cu datele din baza de date


    //configurare DB
    define('_HOST_NAME_', 'localhost');
    define('_USER_NAME_', '');
    define('_DB_PASSWORD', '');
    define('_DATABASE_NAME_', '');

    //conectare DB cu PDO
    try {
        $databaseConnection = new PDO('mysql:host='._HOST_NAME_.';dbname='._DATABASE_NAME_, _USER_NAME_, _DB_PASSWORD);
        $databaseConnection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    } catch(PDOException $e) {
        echo 'ERROR: ' . $e->getMessage();
    }

    if(isset($_POST['submit'])){
        $errMsg = '';
        //verificare user/parola trimise din form
        $username = trim($_POST['Utilizator']);
        $password = trim($_POST['Parola']);

        if($username == '')
            $errMsg .= 'Trebuie sa introduceti un nume de utilizator!<br>';

        if($password == '')
            $errMsg .= 'Trebuia sa introduceti o parola!<br>';


        if($errMsg == ''){
            $records = $databaseConnection->prepare('SELECT * FROM accounts WHERE username = :username');
            $records->bindParam(':username', $username);
            $records->execute();
            $results = $records->fetch(PDO::FETCH_ASSOC);
            if(count($results) > 0 && $password == $results['password']){
                $_SESSION['username'] = $results['username'];
                header('location:index.php');
                exit;
            }else{
                $errMsg .= 'Numele de utilizator sau parola sunt gresite!<br>';
                header('location:login.php');
            }
        }
    }

?>