Viewing file:  clsStudentBio.php (2.02 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//--Class StudentBio--------------------------
include_once "clsbase_StudentBio.php";
class StudentBio extends base_StudentBio {
function Save2(){
if($this->status==1) {
$sql = "insert into StudentBio(studentId, studentSex, parentName, parentRelation, parentAddress, parentDistrictId, parentAmphurId, parentProvinceId, parentZipcode, parentPhoneNo, parentMobile, parentOcc, parentIncome, parentEmail, canRefund, healthPrivId) values('$this->studentId', '$this->studentSex', '$this->parentName', '$this->parentRelation', '$this->parentAddress', $this->parentDistrictId, $this->parentAmphurId, $this->parentProvinceId, '$this->parentZipcode', '$this->parentPhoneNo', $this->parentMobile, '$this->parentOcc', '$this->parentIncome', '$this->parentEmail', '$this->canRefund', $this->healthPrivId)";
}else {
$sql = "update StudentBio set studentSex='$this->studentSex', parentName='$this->parentName', parentRelation='$this->parentRelation', parentAddress='$this->parentAddress', parentDistrictId=$this->parentDistrictId, parentAmphurId=$this->parentAmphurId, parentProvinceId=$this->parentProvinceId, parentZipcode='$this->parentZipcode', parentPhoneNo='$this->parentPhoneNo', parentMobile=$this->parentMobile, parentOcc='$this->parentOcc', parentIncome='$this->parentIncome', parentEmail='$this->parentEmail', canRefund='$this->canRefund', healthPrivId=$this->healthPrivId where studentId='$this->studentId'";
}
$this->SetQuery($sql);
}
// Use on page addResultExamOcc.php
function RSStudentBioByStudIdAndNonAdd($xKey){
$this->SetQuery("select * from StudentBio where studentId='$xKey' ");
// $this->SetQuery("select * from StudentBio where studentId='$xKey' and occExamResult='' ");
}
//-- The End --
function RSStudentBioByDate($date){
$this->SetQuery("select * from StudentBio where birthDate = '$date' ");
}
function RSStudentBioByDayAndMonth($day,$month){
$this->SetQuery("select * from StudentBio where DAYOFMONTH(birthDate) = '$day' AND MONTH(birthDate) = '$month'");
}
} //--End class StudentBio--
?>
|