return $result->fetch_assoc(); } static function getList($params=null) { $sql = "SELECT con.title, con.id, cat.id AS cat_id, cat.title AS cat_title, sec.id AS sec_id, sec.title AS sec_title FROM jos_content AS con JOIN jos_categories AS cat ON con.catid=cat.id JOIN jos_sections AS sec ON sec.id=cat.section ORDER BY cat.title DESC, sec.id"; $result = self::$database->query($sql); return new JoomlaArticleModelList($result); } } class JoomlaArticleModelList { private $result; function __construct($result){ $this->result = $result; } function getAssoc(){ return $this->result->fetch_assoc(); } function getCount(){ return $this->result->num_rows; } //abstract function reset(); } JoomlaArticleModel::$database = new mysqli($config["database_host"], $config["database_user"], $config["database_password"], $config["database_joomla"]);