OmarElGabry / miniPHP

class Todo extends Model{

    public function getAll(){

        $database = Database::openConnection();

        $query  = "SELECT todo.id AS id, users.id AS user_id, users.name AS user_name, todo.content ";

        $query .= "FROM users, todo ";

        $query .= "WHERE users.id = todo.user_id ";

        $database->prepare($query);

        $database->execute();

        $todo = $database->fetchAllAssociative();

        return $todo;

     }

    public function create($userId, $content){

     * @param  integer $userId

     * @return array

     */

    public function getNotifications($userId){

        $database = Database::openConnection();

        $query = "SELECT target, count FROM notifications WHERE user_id = :user_id";

        $database->prepare($query);

        $database->bindValue(":user_id", $userId);

        $database->execute();

        $notifications = $database->fetchAllAssociative();

        return $notifications;

      }

    /**

     * Clear Notifications for a specific target