Viewing file: da_sa_adviser_record.php (2.19 KB) -rwxr-xr-x Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include_once("sa_model.php");
class Da_sa_adviser_record extends Sa_model {
// PK is avr_id
public $avr_id;
public $avr_grp;
public $avr_acy;
public $avr_tm;
public $avr_type;
public $avr_title;
public $avr_date;
public $avr_time;
public $avr_detail;
public $avr_prs_id;
public $avr_std_id;
public $last_insert_id;
function Da_sa_adviser_record() {
parent::__construct();
$this->load->database('esa',TRUE);
}
function insert() {
// if there is no auto_increment field, please remove it
$sql = "INSERT INTO $this->sa_dbname.sa_adviser_record (avr_id, avr_grp, avr_acy, avr_tm, avr_type, avr_title, avr_date, avr_time, avr_detail, avr_prs_id, avr_std_id)
VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
$this->db->query($sql, array($this->avr_id, $this->avr_grp, $this->avr_acy, $this->avr_tm, $this->avr_type, $this->avr_title, $this->avr_date, $this->avr_time, $this->avr_detail, $this->avr_prs_id, $this->avr_std_id));
$this->last_insert_id = $this->db->insert_id();
}
function update() {
// if there is no primary key, please remove WHERE clause.
$sql = "UPDATE $this->sa_dbname.sa_adviser_record
SET avr_acy=?, avr_grp=?, avr_tm=?, avr_type=?, avr_title=?, avr_date=?, avr_time=?, avr_detail=?, avr_prs_id=?, avr_std_id=?
WHERE avr_id=?";
$this->db->query($sql, array($this->avr_acy, $this->avr_grp, $this->avr_tm, $this->avr_type, $this->avr_title, $this->avr_date, $this->avr_time, $this->avr_detail, $this->avr_prs_id, $this->avr_std_id, $this->avr_id));
}
function delete() {
// if there is no primary key, please remove WHERE clause.
$sql = "DELETE FROM $this->sa_dbname.sa_adviser_record
WHERE avr_id=?";
$this->db->query($sql, array($this->avr_id));
}
/*
* You have to assign primary key value before call this function.
*/
function get_by_key($withSetAttributeValue=FALSE) {
$sql = "SELECT *
FROM $this->sa_dbname.sa_adviser_record
WHERE avr_id=?";
$query = $this->db->query($sql, array($this->avr_id));
if ( $withSetAttributeValue ) {
$this->row2attribute( $query->row() );
} else {
return $query ;
}
}
} //=== end class Da_sa_adviser_record
?>
|