Viewing file: da_sa_smo_club.php (2.42 KB) -rwxr-xr-x Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include_once("sa_model.php");
class Da_sa_smo_club extends Sa_model {
// PK is sc_id
public $sc_id;
public $sc_code;
public $sc_name;
public $sc_name_eng;
public $sc_objective;
public $sc_detail;
public $sc_min_member;
public $sc_max_member;
public $sc_due;
public $sc_type;
public $sc_parentId;
public $sc_fr_date;
public $sc_to_date;
public $sc_fup_grp;
public $last_insert_id;
function Da_sa_smo_club() {
parent::__construct();
}
function insert() {
// if there is no auto_increment field, please remove it
$sql = "INSERT INTO $this->sa_dbname.sa_smo_club (sc_id, sc_code, sc_name, sc_name_eng, sc_objective, sc_detail, sc_min_member, sc_max_member, sc_due, sc_type, sc_parentId, sc_fr_date, sc_to_date,sc_fup_grp)
VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
$this->db->query($sql, array($this->sc_id, $this->sc_code, $this->sc_name, $this->sc_name_eng, $this->sc_objective, $this->sc_detail, $this->sc_min_member, $this->sc_max_member, $this->sc_due, $this->sc_type, $this->sc_parentId, $this->sc_fr_date, $this->sc_to_date,$this->sc_fup_grp));
$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_smo_club
SET sc_code=?, sc_name=?, sc_name_eng=?, sc_objective=?, sc_detail=?, sc_min_member=?, sc_max_member=?, sc_due=?, sc_type=?, sc_parentId=?, sc_fr_date=?, sc_to_date=? ,sc_fup_grp=?
WHERE sc_id=?";
$this->db->query($sql, array($this->sc_code, $this->sc_name, $this->sc_name_eng, $this->sc_objective, $this->sc_detail, $this->sc_min_member, $this->sc_max_member, $this->sc_due, $this->sc_type, $this->sc_parentId, $this->sc_fr_date, $this->sc_to_date, $this->sc_fup_grp, $this->sc_id));
}
function delete() {
// if there is no primary key, please remove WHERE clause.
$sql = "DELETE FROM $this->sa_dbname.sa_smo_club
WHERE sc_id=?";
$this->db->query($sql, array($this->sc_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_smo_club
WHERE sc_id=?";
$query = $this->db->query($sql, array($this->sc_id));
if ( $withSetAttributeValue ) {
$this->row2attribute( $query->row() );
} else {
return $query ;
}
}
} //=== end class Da_sa_smo_club
?>
|