<?php

    class UserModel
    {
        public static function getAllUsers(){
            $pdo = DatabaseConnector::current();
            $request = $pdo->prepare("select * from users");
            $request->execute();
            $allUsers = $request->fetchAll(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, get_called_class());
            return $allUsers;
        }

        public static function getUserById($id){
            $pdo = DatabaseConnector::current();
            $request = $pdo->prepare("select * from users where id=".$id);
            $request->execute();
            $allUsers = $request->fetchAll(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, get_called_class());
            return $allUsers;
        }

        public static function createUser($name, $email){
            $pdo = DatabaseConnector::current();
            $request = $pdo->prepare("insert into users(id, name, email) values (NULL, '".$name."','".$email."')");
            $request->execute();
        }

        public static function deleteUser($id){
            $pdo = DatabaseConnector::current();
            $request = $pdo->prepare("delete from users where id=".$id);
            $request->execute();
        }

        public static function editUser($id, $name, $email){
            $pdo = DatabaseConnector::current();
            $request = $pdo->prepare("update users set name='".$name."', email='".$email."' where id=".$id);
            $request->execute();
        }
    }