user

<?php

class User {

    public $id;
    public $username;
    public $password;
    public $first_name;
    public $last_name;
    public $submit;


     public static function find_all_users()
    {
        return self :: find_this_query("SELECT * FROM users");
    }


    public static function find_user_by_id($user_id)
    {
       global $database;

       $the_result_array = self :: find_this_query("SELECT * FROM users WHERE id =$user_id LIMIT 1");
       if (!empty($the_result_array)) { //el face altceva aici
           $first_item = array_shift($the_result_array);
           return $first_item;
       } else {
           return false;
       }      //pana aici
    }


    public static function find_this_query($sql)
    {
        global $database;

        $result_set = $database->query($sql);
        $the_object_array = array();
        while ($row = mysqli_fetch_array($result_set)) {
               $the_object_array[] = self :: instantiation($row);
        }
        return $the_object_array;
    }


    public static function verify_user($username, $password)
    {
        global $database;

        $username = $database->escape_string($username);
        $password = $database->escape_string($password);
        $sql = "SELECT * FROM users WHERE ";
        $sql .= "username = '{$username}' ";
        $sql .= "AND password = '{$password}' ";
        $sql .= "LIMIT 1";

        $the_result_array = self :: find_this_query($sql);
       if (!empty($the_result_array)) { //el face altceva aici
           $first_item = array_shift($the_result_array); //luam primul item
           return $first_item;
       } else {
           return false;
       }      //pana aici

    }


    public static function instantiation($the_record)
    { //$found_user este pe pagina cu admin_content, e vorba de o variabila care lucreaza cu functia find_user_by_id
        $the_object = new self;
        foreach ($the_record as $the_attribute => $value){
            if ($the_object->has_the_attribute($the_attribute)) {
                $the_object->$the_attribute = $value;
            }
        }
        return $the_object;


       /* $the_object->id         = $found_user['id'];
        $the_object->username   = $found_user['username'];
        $the_object->password   = $found_user['password'];
        $the_object->first_name = $found_user['first_name'];
        $the_object->last_name  = $found_user['last_name'];
              return $the_object; asta era fostul the_record */
    }


    private function has_the_attribute($the_attribute)
    {
        $object_properties = get_object_vars($this); //functie predefinita care verifica ce att are clasa
        return array_key_exists($the_attribute, $object_properties); //functie predefinita care verifica daca exista key
    }




}







?>