codeigniter ajax dropdown example

Today, We want to share with you codeigniter ajax dropdown example.In this post we will show you how to get value in dropdownlist from database in codeigniter, hear for Codeigniter Ajax dropdown we will give you demo and example for implement.In this post, we will learn about Country State City Dynamic Dependent Dropdown Using Jquery In Codeigniter with an example.

Codeigniter – Dynamic dependent dropdown using jquery ajax Example

Step 1: Download Fresh Codeigniter 3

download fresh version of Codeigniter 3
download from here Free Download Codeigniter 3

Step 2: Create Database and Configuration

list_state table:

CREATE TABLE `list_state` (
  `id` int(11) NOT NULL,
  `name` varchar(155) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

list_cities table:

CREATE TABLE `list_cities` (
  `id` int(11) NOT NULL,
  `state_id` int(12) NOT NULL,
  `name` varchar(155) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

application/config/database.php

 '',
	'hostname' => 'localhost',
	'username' => 'Radhe_krishna',
	'password' => 'DSFg8g8fg8fg@#$#%$54',
	'database' => 'pakainfo',
	'dbdriver' => 'mysqli',
	'dbprefix' => '',
	'pconnect' => FALSE,
	'db_debug' => (ENVIRONMENT !== 'production'),
	'cache_on' => FALSE,
	'cachedir' => '',
	'char_set' => 'utf8',
	'dbcollat' => 'utf8_general_ci',
	'swap_pre' => '',
	'encrypt' => FALSE,
	'compress' => FALSE,
	'stricton' => FALSE,
	'failover' => array(),
	'save_queries' => TRUE
);

Step 3: Add Route

application/config/routes.php

Step 4: Create Controller
application/controllers/HomeController.php
load->database();
   }


   /**
    * Manage index
    *
    * @return Response
   */
   public function index() {
      $states = $this->db->get("list_state")->result();
      $this->load->view('commentfrm', array('states' => $states )); 
   } 


   /**
    * Manage storeProfileDP
    *
    * @return Response
   */
   public function commentfrmAjax($id) { 
       $result = $this->db->where("state_id",$id)->get("list_cities")->result();
       echo json_encode($result);
   }


} 


?>

Step 5: Create View Files
application/views/commentfrm.php



    
    
    





    

      
Select State and get bellow Related City
      



            

                Select State:
                
                    --- Select State ---
                     $value) {
                            echo "".$value->name."";
                        }
                    ?>
                
            


            

                Select City:
                
                
            


      
    









I hope you get an idea about Dynamic dependent dropdown in CodeIgniter with AJAX.

I would like to have feedback on my infinityknow.com blog.

Your valuable feedback, question, or comments about this article are always welcome.

If you enjoyed and liked this post, don’t forget to share.


 
Related posts:

dependent dropdown in php – How to make dependent dropdown list using jquery Ajax?
Jquery select2 ajax autocomplete example with demo in PHP codeigniter Example
how to select category and subcategory dropdown in php MySQL?
multiselect dropdown with checkbox – jQuery Multi-Select Dropdown Checkbox With Search
how to submit a form using ajax without page refresh in codeigniter?
How to Dynamic Populate Values in One HTML Dropdown List With Another Using Simple Javascript PHP?
Show country state city dropdown select box using javascript
onchange function in Jquery Get Selected Dropdown Value on Change Event Example
multiple drop down list in php using ajax
jquery ajax dropdown onchange example in php MySQL Database