php - codeigniter send id and get database values without refresh

Solution:

Try this code ,It is working .

    <script type="text/javascript">
    function getSummary(id)
    {
     $.post("<?php echo site_url('ajax_controller/getBranchDetails'); ?>",
        {branch_id:id},function(data,status){
              $('#summary').html(data);
    });
    }
    </script>
Copy code

Note : Check whether you have included jquery.min.js . If not mention the below code in view part header

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js">
Copy code

Solution:

Try this instead:

<script type="text/javascript">
function getSummary(id) {
  $.ajax({
    type: 'POST',
    url: "<?php echo site_url('ajax_controller/getBranchDetails'); ?>", // <-- properly quote this line
    cache: false,
    data: {branch_id: id}, // <-- provide the branch_id so it will be used as $_POST['branch_id']
    dataType: 'JSON', // <-- add json datatype
    success: function(data) {
        // if you need to present this in a html table,
        // likely, you need to use $.each() and build the markup using the json response 
        $('#summary').html(data);
    }
  });
}
</script>
Copy code

Model: (Don't directly use variables inside the query string)

$sql = 'SELECT * FROM companydetails WHERE id = ?';
$query = $this->db->query($sql, array($id));
Copy code

Controller:

public function getBranchDetails()
{
    $b_id = $this->input->post('branch_id', true);
    $this->load->model('ajax_model');
    $data['results'] = $this->ajax_model->getRecords($b_id);
    echo json_encode($data); // <-- uncomment
}
Copy code