CodeIgniter Laravel PHP Example Javascript jQuery MORE Videos New
Need a Website Or Web Application Contact : +91 9437911966 (Whatsapp) Note: Paid Service

How to get data in select2 using Codeigniter AJAX

Step 1 :create a table with the below sql query.


CREATE TABLE `users` (
  `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  `username` varchar(80) NOT NULL,
  `name` varchar(80) NOT NULL,
  `password` varchar(80) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Step 2 :Create index.php file.

Path: application/view/index.php

index.php

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<link href='https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.3/css/select2.min.css' rel='stylesheet' type='text/css'>
<!-- Script -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script src='https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.3/js/select2.min.js'></script>
</head>
<body>

</body>
<script>
$(document).ready(function(){
    $("#portLoading").select2({
        ajax: { 
            url: "<?php echo base_url();?>/api/get_data.php",
            type: "get",
            dataType: 'json',
            delay: 250,
            data: function (params) {
                return {
                    searchTerm: params.term // search term
                };
            },
            processResults: function (response) {
                return {
                    results: response
                };
            },
            cache: true
        }
    });
});
</script>

</body>
</html>

Step 3:Create the controller file Api.php.

Path: application/controllers/Api.php

Api.php

<?php
require APPPATH . '/libraries/TokenHandler.php';
require APPPATH . 'libraries/REST_Controller.php';
class Api extends REST_Controller {
    public function __construct()
    {
        parent::__construct();
        $this->load->database();
        $this->tokenHandler = new TokenHandler();
        header('Content-Type: application/json');
    }
    public function port_get(){
        $searchTerm=$_GET['searchTerm'];
        $this->load->model('api_model');
        $portdata= $this->api_model->GetPort($searchTerm);
        $data = array();
        foreach($portdata as $row){
            $data[] = array("id"=>$row->Name, "text"=>$row->Name);
        }
        echo json_encode($data);
    }
    
    
}

Step 4: Create the model file api_model.php.

application/model/api_model.php

api_model.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Api_model extends CI_Model {

    /* constructor */
    function __construct()
    {
        parent::__construct();
        /*cache control*/
        $this->output->set_header('Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0');
        $this->output->set_header('Pragma: no-cache');
    }
    
    public function GetPort($searchTerm){
        $this->db->like('Name', $searchTerm);
        $query = $this->db->select("PortID,Name")->get('PortMst');
        $portlist = $query->result();
        return $portlist;
    }
    
}