case 'add': echo 'add news'; $sql = “insert into xxxx values('aa', 'bb')”; case 'edit': echo 'edit news'; $sql = 'update xxx set xxxx where id = “1”'; case 'delete': echo 'delete news'; $sql = 'delete xxx where id = “1”'; }
{ function index() { $data['todo_list'] = array('1', '2', '3', '4'); $data['title'] = "My Real Title"; $data['heading'] = "My Real Heading"; $this->load->view('blogview', $data); } } ?>
=> $name, 'date' => $date ); $this->db->where('id', $id); $this->db->update('mytable', $data); 產生 : UPDATE mytable SET title = '{$title}', name = '{$name}', date = '{$date}' WHERE id = $id