how to display my query in view codeignitier

Question

this my controler

public function ajax_pasien($Kode)
{
    $data = $this->infokamar->get_by_id1($Kode);
    echo json_encode($data);
}

this my model

public function get_by_id1($Kode)
{
    $sql = "select a.norm, b.nama as pasien, b.alamat, c.tanggal, c.tanggal1, f.jumlah, f.biaya from TTKunjungan a inner join TMPasien b on A.norm = b.norm inner join TTKunjunganDetail c on A.Kode = c.kodekunjungan inner join TMTrfTindakan d on c.kodetindakan = d.Kode inner join TMTrfLayanan e on d.kodelayanan = e.Kode left join (select kodett, sum(jumlah) as jumlah, sum(biaya) as biaya from TTKunjunganDetail where kodett is not null group by kodett) f on  c.Kode = F.kodett Where e.kodeklasifikasi = 2 and c.tanggal1 is null and c.kodett is null and c.kodetindakan = '{$Kode}'";
    $query = $this->db->query($sql);
    return($query->result_array());
}

and this my view but nothing show

Instead of echo try to use var_dump. But share some view code here. — Akhter Al Amin
– Akhter Al Amin, Commented Dec 28, 2016 at 5:13

k10gaurav · Accepted Answer · 2016-12-28 05:33:43Z

1

The best way to check your queries is by two ways:

1. Printing the last query Use below code to print last executed query

<?php echo $this>db->last_query() ?>

2. Enable profiler Make sure your output class is loaded/autoloaded. Just enable profiler in your controller's constructor by adding below code and see the magic after rendering the page

$this->output->enable_profiler(true)

-Cheers

answered Dec 28, 2016 at 5:33

k10gaurav

4627 silver badges25 bronze badges

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

Comments

Hikmat Sijapati · Accepted Answer · 2016-12-28 05:14:35Z

0

Send data from controller to your respective view as follows in controller..

public function ajax_pasien($Kode)
    {
        $data = $this->infokamar->get_by_id1($Kode);
        //echo json_encode($data);
        $this->load->view('view_name',$data);
    }

answered Dec 28, 2016 at 5:14

Hikmat Sijapati

6,9691 gold badge12 silver badges19 bronze badges

Collectives™ on Stack Overflow

how to display my query in view codeignitier

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related