codeigniter return fetch data from controller to view via Ajax request

Question

I load the view in Which I want to display fetch record from the database through the ajax JSON request.But it's not showing the record.

Here is my view code

<div class="col-md-6" id="hodm_table">
<table class="table table-striped table-hover table-responsive">
  <thead>
    <tr>
      <th>Task Name</th>
      <th>Director</th>
      <th>Duration</th> 
      <th>Status</th>
    </tr>
  </thead>
  <tbody>
     <?php foreach($result as $hodm) { ?>
          <tr>
          <td><?php echo $hodm->t_name;?></td>
          <td><?php echo $hodm->director;?></td>
          <td><?php echo $hodm->duration;?></td>
          <td><?php echo $hodm->status;?></td>
      <?php } ?>
  </tbody>
</table> 
</div>
</div>
<script type='text/javascript' language='javascript'>
$(document).ready(function(){
$.ajax({
url:"<?php echo base_url();?>digital/dashboard/dig_short_hodm_table",
type: 'POST',
dataType: 'JSON',

success:function (data) {
  $('#hodm_table').html(data);
}

});
event.preventDefault();
});
</script>

Here is my model

public function get_hodm()
     {
          return $this->db->get("hodm");
     }

Here is my controller

public function dig_short_hodm_table(){

        $data['result']=$this->pojo->get_hodm();

        return json_encode($data);

     }

When I load my page then it showing the error

Message: Undefined variable: result

I want to when view load it fetch the record from the database and show in the view tables.

load a view page in controller function @xr33dx

Parvez Ahmed
– Parvez Ahmed

2017-04-11 07:20:38 +00:00
Commented Apr 11, 2017 at 7:20 — Parvez Ahmed
– Parvez Ahmed, Commented Apr 11, 2017 at 7:20
@Parvez its not working

iazizkhan
– iazizkhan

2017-04-11 07:24:25 +00:00
Commented Apr 11, 2017 at 7:24 — iazizkhan
– iazizkhan, Commented Apr 11, 2017 at 7:24

theEUG · Accepted Answer · 2017-04-11 08:04:57Z

6

Update your model:

public function get_hodm(){
      return $this->db->get("hodm")->result();
}

Your controller:

    public function dig_short_hodm_table(){    
    $result_html = '';
    $result_set = $this->pojo->get_hodm();

    foreach($result_set as $result) {
        $result_html .= '
            <tr>
                <td>' . $result->t_name . '</td>
                <td>' . $result->director . '</td>
                <td>' . $result->duration . '</td>
                <td>' . $result->status . '</td>
            </tr>';                   

    }

    echo json_encode($result_html);
}

Finally your view:

<div class="col-md-6" id="hodm_table">
    <table class="table table-striped table-hover table-responsive">
        <thead>
            <tr>
                <th>Task Name</th>
                <th>Director</th>
                <th>Duration</th> 
                <th>Status</th>
            </tr>
        </thead>
        <tbody id="hodm_results">

        </tbody>
    </table> 
</div>


<script type='text/javascript' language='javascript'>
    $(document).ready(function(){
        $.ajax({
            url:"<?php echo base_url();?>digital/dashboard/dig_short_hodm_table",
            type: 'POST',
            dataType: 'JSON',

            success:function (data) {
                $('#hodm_results').html(data);
            }
        });

        event.preventDefault();
    });
</script>

edited Apr 11, 2017 at 8:04

answered Apr 11, 2017 at 7:27

theEUG

4097 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

10 Comments

theEUG Over a year ago

Can you give me a descriptive error message that you are getting?

iazizkhan Over a year ago

A PHP Error was encountered Severity: Notice Message: Undefined variable: result Filename: digital/dashboard.php Line Number: 38 Backtrace: File: C:\xampp\htdocs\tmt_project\application\views\digital\dashboard.php Line: 38 Function: _error_handler File: C:\xampp\htdocs\tmt_project\application\controllers\digital\dashboard.php Line: 17 Function: view File: C:\xampp\htdocs\tmt_project\index.php Line: 292 Function: require_once

theEUG Over a year ago

I'll add another answer give me a few seconds

iazizkhan Over a year ago

Ok, Thank you. I am waiting

iazizkhan Over a year ago

Please click up to my question . I already mark your answer.. Thanx for help

|

Muhamad Riyan · Accepted Answer · 2017-04-11 07:23:19Z

0

you must change like this

public function get_hodm()
 {
      return $this->db->get("hodm")->result();
 }

answered Apr 11, 2017 at 7:23

Muhamad Riyan

451 silver badge7 bronze badges

13 Comments

Muhamad Riyan Over a year ago

tell me what the problem or message?

Muhamad Riyan Over a year ago

i know the problem you just change $data['result'] with $data

iazizkhan Over a year ago

first this message Message: Undefined variable: result blink then it show blank page

Muhamad Riyan Over a year ago

oh change this line to return json_encode($data); into echo json_encode($data);

Muhamad Riyan Over a year ago

what do you change and what the message, and do you know console? to detect your fault?

|

Gaurav · Accepted Answer · 2017-04-11 07:30:33Z

0

I have update Model View and Controller:

<script type='text/javascript' language='javascript'>
$(document).ready(function(){
$.ajax({
    url:"<?php echo base_url();?>digital/dashboard/dig_short_hodm_table",
    type: 'POST',
    dataType: 'JSON',

    success:function (data) {
        var result = data.result;'
        var row = "";
        for(i=0; i < result.length; i++) {
            row += "<tr>";
            row += "<td>"+result[i].t_name+"</td>";
            row += "<td>"+result[i].director+"</td>";
            row += "<td>"+result[i].duration+"</td>";
            row += "<td>"+result[i].status+"</td>";
            row += "</tr>";
        }
        $('#hodm_table > tbody').html(row);
    }

});
event.preventDefault();
});
</script>

Here is my model

public function get_hodm()
{
    $query = $this->db->get("hodm");
    return $query->result_array();
}

Here is my controller

public function dig_short_hodm_table(){

    $data['result']=$this->pojo->get_hodm();

    echo json_encode($data);

}

answered Apr 11, 2017 at 7:30

Gaurav

7135 silver badges14 bronze badges

2 Comments

Gaurav Over a year ago

Can you check in console? what response are you getting

iazizkhan Over a year ago

I got the answer thanks for help. I prefer theEUG answer

Gopal Bhuva · Accepted Answer · 2017-04-11 08:06:56Z

0

try to return in controller like this by changing header content

public function dig_short_hodm_table(){
header('Content-Type: application/x-json; charset=utf-8');
$data['result']=$this->pojo->get_hodm();
echo(json_encode($data));
}

answered Apr 11, 2017 at 8:06

Gopal Bhuva

6542 gold badges13 silver badges20 bronze badges

Comments

ImBhavin95 · Accepted Answer · 2017-04-11 08:35:47Z

0

Change Your Model Like Below

public function get_hodm()
{
    $query = $this->db->get("hodm");
    return $query -> result();
}

answered Apr 11, 2017 at 8:35

ImBhavin95

1,5232 gold badges18 silver badges29 bronze badges

Collectives™ on Stack Overflow

codeigniter return fetch data from controller to view via Ajax request

5 Answers 5

10 Comments

13 Comments

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

10 Comments

13 Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related