Viewing file: da_rg_Student.php (4.08 KB) -rwxr-xr-x Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include_once("my_model.php");
class Da_rg_Student extends My_model {
// PK is stdId
public $stdId;
public $stdCode;
public $stdName;
public $stdNameE;
public $stdSurname;
public $stdSurnameE;
public $stdCreditAttempt;
public $stdCreditSatisfy;
public $stdGPA;
public $stdAdY;
public $stdAdmitDate;
public $stdGraduateY;
public $stdGraduateDate;
public $stdTotalPoint;
public $stdExitExam;
public $stdHonor;
public $stdMedal;
public $stdGenStatus;
public $stdPfId;
public $stdCurId;
public $stdTmIdAdmit;
public $stdSyId;
public $stdSstId;
public $stdGenId;
public $stdEtId;
public $stdEt2Id;
public $stdPaId;
public $stdSoId;
public $stdFsId;
public $stdSstIdTmp;
public $stdUpdateDate;
public $stdUpdateUsLogin;
public $last_insert_id;
function Da_rg_Student() {
parent::__construct();
$this->load->database('rg',TRUE);
}
function insert() {
// if there is no auto_increment field, please remove it
$sql = "INSERT INTO $this->rg_dbname.rg_Student (stdId, stdCode, stdName, stdNameE, stdSurname, stdSurnameE, stdCreditAttempt, stdCreditSatisfy, stdGPA, stdAdY, stdAdmitDate, stdGraduateY, stdGraduateDate, stdTotalPoint, stdExitExam, stdHonor, stdMedal, stdGenStatus, stdPfId, stdCurId, stdTmIdAdmit, stdSyId, stdSstId, stdGenId, stdEtId, stdEt2Id, stdPaId, stdSoId, stdFsId, stdSstIdTmp, stdUpdateDate, stdUpdateUsLogin)
VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
$this->db->query($sql, array($this->stdId, $this->stdCode, $this->stdName, $this->stdNameE, $this->stdSurname, $this->stdSurnameE, $this->stdCreditAttempt, $this->stdCreditSatisfy, $this->stdGPA, $this->stdAdY, $this->stdAdmitDate, $this->stdGraduateY, $this->stdGraduateDate, $this->stdTotalPoint, $this->stdExitExam, $this->stdHonor, $this->stdMedal, $this->stdGenStatus, $this->stdPfId, $this->stdCurId, $this->stdTmIdAdmit, $this->stdSyId, $this->stdSstId, $this->stdGenId, $this->stdEtId, $this->stdEt2Id, $this->stdPaId, $this->stdSoId, $this->stdFsId, $this->stdSstIdTmp, $this->stdUpdateDate, $this->stdUpdateUsLogin));
$this->last_insert_id = $this->db->insert_id();
}
function update() {
// if there is no primary key, please remove WHERE clause.
$sql = "UPDATE $this->rg_dbname.rg_Student
SET stdCode=?, stdName=?, stdNameE=?, stdSurname=?, stdSurnameE=?, stdCreditAttempt=?, stdCreditSatisfy=?, stdGPA=?, stdAdY=?, stdAdmitDate=?, stdGraduateY=?, stdGraduateDate=?, stdTotalPoint=?, stdExitExam=?, stdHonor=?, stdMedal=?, stdGenStatus=?, stdPfId=?, stdCurId=?, stdTmIdAdmit=?, stdSyId=?, stdSstId=?, stdGenId=?, stdEtId=?, stdEt2Id=?, stdPaId=?, stdSoId=?, stdFsId=?, stdSstIdTmp=?, stdUpdateDate=?, stdUpdateUsLogin=?
WHERE stdId=?";
$this->db->query($sql, array($this->stdCode, $this->stdName, $this->stdNameE, $this->stdSurname, $this->stdSurnameE, $this->stdCreditAttempt, $this->stdCreditSatisfy, $this->stdGPA, $this->stdAdY, $this->stdAdmitDate, $this->stdGraduateY, $this->stdGraduateDate, $this->stdTotalPoint, $this->stdExitExam, $this->stdHonor, $this->stdMedal, $this->stdGenStatus, $this->stdPfId, $this->stdCurId, $this->stdTmIdAdmit, $this->stdSyId, $this->stdSstId, $this->stdGenId, $this->stdEtId, $this->stdEt2Id, $this->stdPaId, $this->stdSoId, $this->stdFsId, $this->stdSstIdTmp, $this->stdUpdateDate, $this->stdUpdateUsLogin, $this->stdId));
}
function delete() {
// if there is no primary key, please remove WHERE clause.
$sql = "DELETE FROM $this->rg_dbname.rg_Student
WHERE stdId=?";
$this->db->query($sql, array($this->stdId));
}
/*
* You have to assign primary key value before call this function.
*/
function get_by_key($withSetAttributeValue=FALSE) {
$sql = "SELECT *
FROM $this->rg_dbname.rg_Student
WHERE stdId=?";
$query = $this->db->query($sql, array($this->stdId));
if ( $withSetAttributeValue ) {
$this->row2attribute( $query->row() );
} else {
return $query ;
}
}
function last_insert_id(){
return $this->db->insert_id();
}
} //=== end class Da_rg_Student
?>
|