<?php
class detailTestModel extends ModelBase{
    public $tableName = 'sis_detail_test';

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

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

    public function dolistbyTest($idtest){
        $query = "SELECT * FROM ".$this->tableName
                ." WHERE idtest = ".$idtest." ORDER BY idcategory";
        $result = $this->db->prepare($query);
        $result->execute();
        $num_rows = $result->rowCount();
        return array($result, $num_rows);
    }
}
?>