Viewing file:  da_rg_RegistDetails.php (3 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include_once("my_model.php");
class Da_rg_RegistDetails extends My_model {
// PK is rdAcY, rdStdId, rdTmId, rdCoId, rdSeq
public $rdAcY;
public $rdStdId;
public $rdTmId;
public $rdCoId;
public $rdSeq;
public $rdCreditAttempt;
public $rdSection;
public $rdGrade;
public $rdDocNo;
public $rdCredit1;
public $rdCredit2;
public $rdNoCalGPA;
public $rdAllowPr;
public $rdCdId1;
public $rdCdId2;
public $rdUpdateDate;
public $rdUpdateUserId;
public $last_insert_id;
function Da_rg_RegistDetails() {
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_RegistDetails (rdAcY, rdStdId, rdTmId, rdCoId, rdSeq, rdCreditAttempt, rdSection, rdGrade, rdDocNo, rdCredit1, rdCredit2, rdNoCalGPA, rdAllowPr, rdCdId1, rdCdId2, rdUpdateDate, rdUpdateUserId)
VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
$this->db->query($sql, array($this->rdAcY, $this->rdStdId, $this->rdTmId, $this->rdCoId, $this->rdSeq, $this->rdCreditAttempt, $this->rdSection, $this->rdGrade, $this->rdDocNo, $this->rdCredit1, $this->rdCredit2, $this->rdNoCalGPA, $this->rdAllowPr, $this->rdCdId1, $this->rdCdId2, $this->rdUpdateDate, $this->rdUpdateUserId));
$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_RegistDetails
SET rdCreditAttempt=?, rdSection=?, rdGrade=?, rdDocNo=?, rdCredit1=?, rdCredit2=?, rdNoCalGPA=?, rdAllowPr=?, rdCdId1=?, rdCdId2=?, rdUpdateDate=?, rdUpdateUserId=?
WHERE rdAcY=? AND rdStdId=? AND rdTmId=? AND rdCoId=? AND rdSeq=?";
$this->db->query($sql, array($this->rdCreditAttempt, $this->rdSection, $this->rdGrade, $this->rdDocNo, $this->rdCredit1, $this->rdCredit2, $this->rdNoCalGPA, $this->rdAllowPr, $this->rdCdId1, $this->rdCdId2, $this->rdUpdateDate, $this->rdUpdateUserId, $this->rdAcY, $this->rdStdId, $this->rdTmId, $this->rdCoId, $this->rdSeq));
}
function delete() {
// if there is no primary key, please remove WHERE clause.
$sql = "DELETE FROM $this->rg_dbname.rg_RegistDetails
WHERE rdAcY=? AND rdStdId=? AND rdTmId=? AND rdCoId=? AND rdSeq=?";
$this->db->query($sql, array($this->rdAcY, $this->rdStdId, $this->rdTmId, $this->rdCoId, $this->rdSeq));
}
/*
* You have to assign primary key value before call this function.
*/
function get_by_key($withSetAttributeValue=FALSE) {
$sql = "SELECT *
FROM $this->rg_dbname.rg_RegistDetails
WHERE rdAcY=? AND rdStdId=? AND rdTmId=? AND rdCoId=? AND rdSeq=?";
$query = $this->db->query($sql, array($this->rdAcY, $this->rdStdId, $this->rdTmId, $this->rdCoId, $this->rdSeq));
if ( $withSetAttributeValue ) {
$this->row2attribute( $query->row() );
} else {
return $query ;
}
}
function last_insert_id(){
return $this->db->insert_id();
}
} //=== end class Da_rg_RegistDetails
?>
|