Java, .NET, PHP, PYTHON, ANGULAR, .NET, ML, Data Scince, Testing, CI Tutorials in Easy Languages.

"Best Software Training, Internship, Project Development center of Indore India, Helpline 780506-3968"

1)First Create database and Table





Complete Code of Controller:-

<?php
class AjaxExample2 extends CI_Controller
{
   function __construct()
   {
    parent::__construct();
    $this->load->model('stumodel');
   }
   function index()
   {
      $data['r'] = $this->stumodel->getCountry();
    $this->load->view('countryview',$data);
   }

   function searchdata($id)
   {
     
     
      $data['res']=$this->stumodel->statesearch($id);
     
      $this->load->view('stview',$data);
   }

}








?>

Complete Code of Model
<?php
class Stumodel extends CI_Model
{
    function __construct()
    {
    parent::__construct();
    $this->load->database();
    }

     function getCountry()
     {
        return $this->db->get('country')->result_array();
     }
     function statesearch($id)
     {
        return $this->db->get_where('state',array("cid"=>$id))->result_array();
     }

?>

Complete Code of  Load View:

<!DOCTYPE html>
<html>
<head>
<title></title>
<style type="text/css">
select
{
margin-top: 50px;
width: 300px;
height: 40px;
}


</style>
<script type="text/javascript">
function showstate(a)
{

xmlhttp = new XMLHttpRequest();
  xmlhttp.onreadystatechange=function()
  {
  document.getElementById("state").innerHTML=xmlhttp.responseText;
  }
  xmlhttp.open("POST","<?php echo site_url(); ?>/ajaxexample2/searchdata/"+a,true);
  xmlhttp.send();
}

</script>
</head>
<body>

<select onchange="showstate(this.value)">
<option value="">Select Country</option>
<?php


foreach($r as $x)
{
?>
     
       <option value="<?php echo $x['countryid']; ?>"><?php echo $x['countryname']; ?></option>
<?php

}
?>

</select>

<div id="state"></div>
</body>
</html>

Complete Code of Stview.php

<!DOCTYPE html>
<html>
<head>
<title></title>

</head>
<body>

<select >

<?php


foreach($res as $x)
{
?>
     
       <option value="<?php echo $x['stateid']; ?>"><?php echo $x['statename']; ?></option>
<?php

}
?>

</select>


</body>
</html>

Post a Comment

If you have any doubt in programming or join online classes then you can contact us by comment .

Previous Post Next Post