Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- class User {
- public $id;
- public $username;
- public $password;
- public $first_name;
- public $last_name;
- public static function find_this_query($sql){
- global $database;
- return $database->query($sql);
- }
- public static function find_all_users(){
- return self::find_this_query("SELECT * FROM users");
- }
- public static function find_user_by_id($user_id){
- $result = self::find_this_query("SELECT * FROM users WHERE id=$user_id LIMIT 1");
- return $result->fetch(PDO::FETCH_OBJ);
- }
- public static function verify_user($username,$password){
- global $database;
- $query = self::find_this_query("SELECT * FROM users WHERE username='$username' and password='$password' LIMIT 1");
- if($query->rowCount() == 1) {
- return $query->fetch(PDO::FETCH_OBJ) ;
- }
- }
- public function create(){
- $query = self::find_this_query("INSERT INTO users (username,password,first_name,last_name) VALUES (
- '$this->username','$this->password','$this->first_name','$this->last_name') ");
- if($query->rowCount() === 1 ) {
- global $database;
- $this->id = $database->the_insert_id();
- return true;
- } else {
- return false;
- }
- }
- public function update(){
- global $database;
- $query = self::find_this_query("UPDATE users SET
- username = '$this->username',
- password = '$this->password',
- first_name = '$this->first_name',
- last_name = '$this->last_name'
- WHERE id='$this->id' ");
- return ($database->connection->affected_rows == 1 ) ? true : false ;
- }
- }// End of the user class
- $user = new User();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement