Example #1
0
 public static function get_by_id($id)
 {
     global $mysqli;
     $config = new Config();
     $id = sanitize_input($id);
     $sql = "SELECT `id`, `username`, `email`, `full_name`, `bio`, `url`, `points`, `invites`, `password`, `date_added`, `date_joined` FROM `{$config->database->{$config->site_identifier}->prefix}users` WHERE `id` = {$id}";
     $query = mysqli_query($mysqli, $sql);
     $result = mysqli_fetch_assoc($query);
     if (!is_array($result)) {
         return null;
     } else {
         $user = new User($result);
         $user->email_notifications = $user->email_notifications();
         return $user;
     }
 }