Get query result as array in codeigniter

Question

I have a query, how do I get the result as an array?

function get_all_transaksi_proses() {
    $rs = $this->db->query("SELECT a.id_transaksi,
                                   a.nama,
                                   a.tgl_transaksi, 
                                   (SELECT COUNT( id_transaksi ) AS jum  
                                     FROM  tbl_detail_trs_menu  
                                     WHERE id_transaksi = a.id_transaksi)  AS jumlah, 
                                   a.status_transaksi, 
                                   a.total, 
                                   b.status_pelanggan, 
                                   c.nama_karyawan 

                            FROM   tbl_transaksi a 

                                   LEFT JOIN  tbl_pelanggan b 
                                      ON a.id_pelanggan = b.id_pelanggan 

                                   LEFT JOIN tbl_karyawan c 
                                      ON a.id_karyawan = c.id_karyawan 

                            WHERE  a.status_transaksi =  'PROSES' ");  

  echo json_encode(array("result" => $rs)); 
}

Stack Programmer · Accepted Answer · 2018-12-08 10:41:20Z

5

Like this:

$rs = $this->db->query(...);
$array = $rs->result_array();

https://www.codeigniter.com/user_guide/database/results.html

edited Dec 8, 2018 at 10:41

Stack Programmer

6796 silver badges18 bronze badges

answered Nov 20, 2013 at 21:09

jszobody

29k6 gold badges66 silver badges76 bronze badges

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

8 Comments

user3012773 Over a year ago

Message: preg_match() expects parameter 2 to be string, object given

jszobody Over a year ago

@user3012773 eh? there's no preg_match() in the code that you're showing. is that somewhere else in your code? don't think it has anything to do with this question.

user3012773 Over a year ago

but i think this error from my query, because I run the query directly on routes codeigniter.. can help me

jszobody Over a year ago

That error should also tell you which php file and what line number its coming from. Without seeing all of your code its impossible for me to know.

user3012773 Over a year ago

function index() { $this->model_transaksi->get_all_transaksi_proses(); }

|

Sabbir · Accepted Answer · 2015-05-28 11:36:28Z

2

To get a result in array you have to do this CI 2.2.2:

    return $query->result_array();

answered May 28, 2015 at 11:36

Sabbir

1461 silver badge3 bronze badges

Comments

Denmark · Accepted Answer · 2013-11-21 05:29:31Z

1

$query = $this->db->query("select....");

return $query->result(); // it will result an array
or
echo json_encode($query->result()); // this will also result array but direct to json_encode

....hope i help you!

answered Nov 21, 2013 at 5:29

Denmark

5382 gold badges9 silver badges27 bronze badges

Collectives™ on Stack Overflow

Get query result as array in codeigniter

3 Answers 3

8 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

8 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest