Skip to content

Shorting Searching not working in codeigniter 3.0.6 #114

@deepesh0102

Description

@deepesh0102

This library working on CodeIgniter version 2.1.3. Similar code not working in CodeIgniter version 3.0.6.

view page code:-

load->view('includes/header'); $this->load->view('includes/left_sidebar'); $this->load->view('includes/navigation'); ?>
Basic Data Tables example with responsive plugin
                <div class="table-responsive">
                    <table id="static_content" class="table table-striped table-bordered table-hover dataTables-example" >
                        <thead>
                            <tr>
                                <th>First Name</th>
                                <th>Last Name</th>
                                <th>Email</th>
                                
                                
                            </tr>
                        </thead>
                        <tbody>
                            
                        </tbody>
                        
                    </table>
                </div>

            </div>
        </div>
    </div>
</div>
load->view('includes/footer'); ?> <script type="text/javascript"> $(document).ready(function() { var oTable = $('#static_content').dataTable( { "bProcessing": true, "bServerSide": true, "sAjaxSource": 'static-content/customerlist', "bJQueryUI": true, "sPaginationType": "full_numbers", "iDisplayStart ":1, "oLanguage": { "sProcessing": "" }, "fnInitComplete": function() { //oTable.fnAdjustColumnSizing(); }, 'fnServerData': function(sSource, aoData, fnCallback) { $.ajax ({ 'dataType': 'json', 'type' : 'POST', 'url' : sSource, 'data' : aoData, 'success' : fnCallback }); } } ); } ); </script>

Controller static-content/customerlist :-

load->library('Datatables'); $this->load->model('Static_content_model'); } /** - script * - This function contains javascript * - - @return array */ public function script() { /\* -- Mainly scripts -- _/ $data['js_include'][] = '<script src="' . root_url() . 'asset/js/admin/inspinia.js"></script>'; $data['js_include'][] = '<script src="' . root_url() . 'asset/js/admin/plugins/pace/pace.min.js"></script>'; $data['js_include'][] = '<script src="' . root_url() . 'asset/js/admin/plugins/iCheck/icheck.min.js"></script>'; /_ */ $data['js_include'][] = '<script src="' . root_url() . 'asset/js/admin/plugins/summernote/summernote.min.js"></script>'; $data['style_include'][] = ''; $data['style_include'][] = ''; return $data; } public function add() { // var_dump($_POST); // echo $this->validate_content($this->input->post('content')); ``` $data = $this->script(); $data['title'] = 'Admin | Add Content'; if ($this->input->server('REQUEST_METHOD') === 'POST') { //Changing the Error Delimiters $this->form_validation->set_error_delimiters('', ''); $this->form_validation->set_rules('titles', 'Title', 'trim|required|min_length[3]|max_length[64]|xss_clean'); $this->form_validation->set_rules('meta_title', 'Meta title', 'trim|required|xss_clean|min_length[3]|max_length[64]'); $this->form_validation->set_rules('meta_description', 'Meta description', 'trim|required|xss_clean|min_length[5]|max_length[64]'); $this->form_validation->set_rules('meta_key', 'Meta key', 'trim|required|xss_clean|min_length[3]|max_length[128]'); $this->form_validation->set_rules('content', 'Content', 'trim|required|callback_validate_content|xss_clean'); ``` // print_r($this->input->post()); ``` $data['titles'] = $this->input->post('titles'); $data['meta_title'] = $this->input->post('meta_title'); $data['meta_description'] = $this->input->post('meta_description'); $data['meta_key'] = $this->input->post('meta_key'); $data['content'] = $this->input->post('content'); ``` // print_r($data); exit; ``` if ($this->form_validation->run() == true) { $dataArray['title'] = $this->input->post('titles'); $dataArray['meta_title'] = $this->input->post('meta_title'); $dataArray['meta_description'] = $this->input->post('meta_description'); $dataArray['meta_key'] = $this->input->post('meta_key'); $dataArray['content'] = htmlspecialchars($this->input->post('content')); ``` // $userInfo = $this->user_model->isExitsEmail($this->input->post('email')); ``` $dataArray['modify_date'] = date('Y-m-d h:i:s'); $this->Static_content_model->addContent($dataArray); $data['success_message'] = 'Content Added Successfuly!'; ``` // print_r($data); exit; // mail } else { ``` $data['error_message'] = 'Content Not Added , please try again!'; } } ``` // print_r($data); ``` $this->load->view('static_content/static_content_form', $data); } public function edit() { $content_id = $this->uri->segment(3); $getdata = $this->Static_content_model->editContent($content_id); $data = $this->script(); $data['title'] = 'Admin | Edit Content'; $data['titles'] = $getdata['title']; $data['meta_title'] = $getdata['meta_title']; $data['meta_description'] = $getdata['meta_description']; $data['meta_key'] = $getdata['meta_key']; $data['content'] = $getdata['content']; ``` // $string = $this->parser->parse('static_content/static_content_form', $data); $this->load->view('static_content/static_content_form', $data); } ``` public function delete() { } /** * Validate String empty or not removing html tags * * @param string * @return boole */ public function validate_content($content) { $fillter_string = strip_tags($content); if (empty($fillter_string)) { $this->form_validation->set_message('validate_content', 'The {field} field is required.'); return FALSE; } else { return TRUE; } } /** * View Static Content Function * */ public function view() { $data['title'] = 'Admin | View Content'; /* -- Mainly scripts -- */ $data['js_include'][] = '<script src="' . root_url() . 'asset/js/admin/plugins/dataTables/datatables.min.js"></script>'; $data['style_include'][] = ''; $this->load->view('static_content/static_content_view', $data); } /** * @customerlist Function * @return Json */ public function customerlist() { $this->datatables->select('customer_id,first_name,last_name,email') ->unset_column('customer_id') ->from('customers'); echo $this->datatables->generate(); } public function static_content_list() { $this->datatables->select('content_id,title,add_date,modify_date,staus') ->from('static_content'); echo $this->datatables->generate(); } ``` } shorting searching not working

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions