<?php
class categoryModel extends ModelBase{
    public $tableName = 'sis_category';

    public function dolist(){
        $query = "SELECT * FROM ".$this->tableName;
        $result = $this->db->prepare($query);
        $result->execute();
        $num_rows = $result->rowCount();
        return array($result, $num_rows);
    }

    public function getCategory($id){
        $query = "SELECT * FROM ".$this->tableName
                ." WHERE idcategory = ".$id;
        $result = $this->db->prepare($query);
        $result->execute();
        return $result;
    }
}
?>