Viewing file:  clsmapprogram.php (2.07 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//--Class MapProgram--------------------------
//--PK of MapProgram ::
// 1. mapId
class MapProgram extends clsDB{
var $result;
var $mapId;
var $programId_reg;
var $programId_alumni;
function MapProgram(&$c){
$this->c=$c->c;
$this->DB=$c->db;
}
function Save(){
if ($this->status==1){
//uncomment a line below if your table use ID as running number
//$this->mapId=$this->GetNextCode();
$sql = "insert into MapProgram values(
'$this->mapId',
'$this->programId_reg',
'$this->programId_alumni'
)";
}else {
$sql = "update MapProgram set
programId_reg='$this->programId_reg',
programId_alumni='$this->programId_alumni'
where mapId='$this->mapId'";
}
return $this->Dml($sql);
}
function Delete(){
return $this->Dml("delete from MapProgram where mapId='$this->mapId'");
}
function GetNextCode(){
$this->SetQuery("select max(mapId) as num from MapProgram");
if ($result=$this->GetResult()) {
return $result['num']+1;
}
}
function RSMapProgram(){
$this->SetQuery("select * from MapProgram order by mapId");
}
function GetRecord(){
if ($this->result = $this->GetResult()) {
$this->mapId = $this->result['mapId'];
$this->programId_reg = $this->result['programId_reg'];
$this->programId_alumni = $this->result['programId_alumni'];
return 1;
}else {
return 0;
}
}
function SearchByKey($xKey){
if ($this->SetQuery("select * from MapProgram where mapId= '$xKey'")){
return 1;
}else {
return 0;
}
}
//****************** You can add new functions below **********************//
function SearchByprogramId_reg($xKey){
if ($this->SetQuery("select * from MapProgram where programId_reg= '$xKey'")){
return 1;
}else {
return 0;
}
}
function NextPage($pg=1){
if ($this->lastSql<>""){
$this->frRowNum=($pg-1)*$GLOBALS["rowPerPage"];
$sql = $this->lastSql." limit $this->frRowNum,".$GLOBALS["rowPerPage"];
$this->SetQueryPage($sql);
}
}
function NumPage() {
return ceil($this->numRows/$GLOBALS["rowPerPage"]);
}
} //--End class MapProgram--
?>
|