Viewing file: clsCourse.php (1.41 KB) -rwxr-xr-x Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
//--Class Course--------------------------
include_once "clsbase_Course.php";
class Course extends base_Course{
function RSCourseLimit($start, $pageSize){
$this->SetQuery("select * from Course order by courseId limit $start, $pageSize");
}
function RSCourseByCoCodeAndCoName($xKey, $yKey){
$this->SetQuery("select * from Course where courseCode like '%$xKey%' and courseName like '%$yKey%'");
}
function RSCourseByCoCodeAndCoNameLimit($xKey, $yKey, $start, $pageSize){
$this->SetQuery("select * from Course where courseCode like '%$xKey%' and courseName like '%$yKey%' order by courseId limit $start, $pageSize");
}
function SearchByCourseCode($xKey){
$this->SetQuery("select * from Course where courseCode='$xKey'");
}
// Use on page classTable.php
function SearchByCourseName($xKey){
$this->SetQuery("select * from Course where courseName like '%$xKey%' order by courseId");
}
//-- The End --
//-- Use on page addCourseInGroup.php --
function RSCourseByConId($cKey){
$this->SetQuery("select * from Course where conditionId='$cKey' order by courseId");
}
//-- The end --
// Use on page course.php
function SearchByCourseCodeAndCourseName($cCode,$cName,$cNameEng){
$this->SetQuery("select * from Course where courseCode like '%$cCode%' and courseName LIKE '%$cName%' and courseNameEng LIKE '%$cNameEng%' order by courseId");
}
//-- The End --
} //--End class Course--
?>
|