โค้ด: เลือกทั้งหมด
case 'insert' :
$name_causative = request_var('name_causative', '', true);
$classification = request_var('classification', '', true);
$disease_name_thai = request_var('disease_name_thai', '', true);
$name_picter = request_var('name_picter', '', true);
$sql_ary = array(
'name_causative' => $name_causative,
'classification' => $classification,
'related_diseases' => $disease_name_thai,
'name_picter' => $name_picter,
);
$user_ary = array(
'id_diagseat' => $id,
);
if ($id) {
$sql = ' UPDATE ' . $table_prefix . 'm_causative SET ' . $db->sql_build_array('UPDATE', $sql_ary) . ' WHERE id = ' . $id;
$db->sql_query($sql);
meta_refresh(2, $this->u_action);
trigger_error($user->lang['SHOW_UPDATE'] . adm_back_link($this->u_action));
} else {
$sql = ' INSERT ' . $table_prefix . 'm_causative ' . $db->sql_build_array('INSERT', $sql_ary);
$db->sql_query($sql);
$id = $db->sql_nextid();
$sql = ' INSERT ' . $table_prefix . 'm_map_diagseat ' . $db->sql_build_array('INSERT', $user_ary);
meta_refresh(2, $this->u_action);
trigger_error($user->lang['SHOW_INSERT'] . adm_back_link($this->u_action));
}