I have a basic LIST where I am using add_action buttons to run some routines. All routines are working as expected ACCEPT when I delete a row, I want to display a javascript confirmation message alert( ). I am unable to figure out how to do this.
$crud->unset_delete(); if($_SESSION['admin'] == 1) $crud->add_action('Edit', '', 'setlistsongs','ui-icon-pencil'); if($_SESSION['admin'] == 1) $crud->add_action('Duplicate Set', '', 'dupesetlist','ui-icon-copy'); if($_SESSION['admin'] == 1) $crud->add_action('Delete Set', '', 'deletesetlist','ui-icon-circle-minus'); $output = $crud->render(); $this->load->view('raw',(array)$output);
Here is the function:
public function deletesetlist($id){ $this->load->model('admin_model'); $this->admin_model->delete_set_list($id); redirect('setlist', 'refresh'); return true; }
Here is the MODEL function:
public function delete_set_list($id){ $sql = 'DELETE FROM set_lists WHERE id = '.$id; $this->db->query($sql); $sql = 'DELETE FROM set_lists_songs WHERE setlist_id = '.$id; $this->db->query($sql); }
I tried using the built in callback_after_delete ( ) function, which has the generic CONF message, but when it did the routine, the DATATABLES did not update and the delete row still showed in the list (NO REFRESH). So I do not know what worse...NO Confirmation Message or a dead row in the list.
Any insights and advice would be appreciated.
Don