SWDB/application/page/frame/Collection_Collection_Frame.php

<?php

    require_once($path["frame"] . "Frame.php");
    require_once($path["entity"] . "Monster_Collection.php");


    /**
     * Collection's page monster list.
     */
    class Collection_Collection_Frame extends Frame{

        /**
         * {@see Monster_Collection} of owned monsters.
         */
        public $collection = [];

        /**
         * Monster to mark as selected
         */
        public $selected = -1;

        /**
         * Constructor.
         *
         * Retrieves the data and initializes the variables.
         *
         * @param SQLite3 $db Connection to the database.
         * @param Array $params Parameters array. May contain the 'selected' parameter
         *                      to mark a monster as selected.
         */
        public function __construct($db, $params){
            global $path;
            parent::__construct($db);
            $this->view = $path["view"] . "frame/collection.php";
            if (isset($params["selected"])){
                $this->selected = $params["selected"];
            }
            $s =
              "SELECT id " .
              "FROM monster_collection " .
              "WHERE level <> 0 " .
              "ORDER BY " .
              "  stars DESC, " .
              "  level DESC; ";
            $q = $this->db->query($s);
            while ($r = $q->fetchArray(SQLITE3_ASSOC)){
                array_push($this->collection, new Monster_Collection($this->db, $r["id"]));
            }
        }
    }
?>