Viewing file: da_rg_RealStudyPlan.php (2.14 KB) -rwxr-xr-x Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include_once("my_model.php");
class Da_rg_RealStudyPlan extends My_model {
// PK is rspId
public $rspId;
public $rspAdY;
public $rspNoCalGPA;
public $rspCurId;
public $rspSyId;
public $rspTmId;
public $rspCrsId;
public $rspCoId;
public $rspCdId1;
public $rspCdId2;
public $last_insert_id;
function Da_rg_RealStudyPlan() {
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_RealStudyPlan (rspId, rspAdY, rspNoCalGPA, rspCurId, rspSyId, rspTmId, rspCrsId, rspCoId, rspCdId1, rspCdId2)
VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
$this->db->query($sql, array($this->rspId, $this->rspAdY, $this->rspNoCalGPA, $this->rspCurId, $this->rspSyId, $this->rspTmId, $this->rspCrsId, $this->rspCoId, $this->rspCdId1, $this->rspCdId2));
$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_RealStudyPlan
SET rspAdY=?, rspNoCalGPA=?, rspCurId=?, rspSyId=?, rspTmId=?, rspCrsId=?, rspCoId=?, rspCdId1=?, rspCdId2=?
WHERE rspId=?";
$this->db->query($sql, array($this->rspAdY, $this->rspNoCalGPA, $this->rspCurId, $this->rspSyId, $this->rspTmId, $this->rspCrsId, $this->rspCoId, $this->rspCdId1, $this->rspCdId2, $this->rspId));
}
function delete() {
// if there is no primary key, please remove WHERE clause.
$sql = "DELETE FROM $this->rg_dbname.rg_RealStudyPlan
WHERE rspId=?";
$this->db->query($sql, array($this->rspId));
}
/*
* You have to assign primary key value before call this function.
*/
function get_by_key($withSetAttributeValue=FALSE) {
$sql = "SELECT *
FROM $this->rg_dbname.rg_RealStudyPlan
WHERE rspId=?";
$query = $this->db->query($sql, array($this->rspId));
if ( $withSetAttributeValue ) {
$this->row2attribute( $query->row() );
} else {
return $query ;
}
}
function last_insert_id(){
return $this->db->insert_id();
}
} //=== end class Da_rg_RealStudyPlan
?>
|