How to convert this mysqli_fetch_array code to codeigniter

Question

How can I convert this mysqli_fetch_array in php to codeigniter?

$kueri7 = "SELECT ceil(count(kelas_id)/(select count(user_id) from tuser where matpel_id = $idmatpel)) as jumlah from tkelas";
$cocok8 = mysqli_query($con, $kueri7);
$cocok_kelas_maksimal = mysqli_fetch_array($cocok8);

Thanks in advance.

https://www.codeigniter.com/userguide3/database/queries.html & https://www.codeigniter.com/userguide3/database/results.html - check this one — Jaydp, May 30 '18 at 04:19
(https://stackoverflow.com/questions/6047149/subquery-in-codeigniter-active-record) — Vijay Makwana, May 30 '18 at 04:54

score 0 · Accepted Answer · edited May 30 '18 at 07:27

0

With codeIgniter, your code would look like this:

$query = $this->db->query("SELECT ceil(count(kelas_id)/(select count(user_id) from tuser where matpel_id = $idmatpel)) as jumlah from tkelas", FALSE);
$cocok_kelas_maksimal = $query->result_array();

edited May 30 '18 at 07:27

user1834095

5,332
2
20
38

answered May 30 '18 at 05:33

Salim Ibrohimi

1,351
3
17
35

1

And for result object array `$cocok_kelas_maksimal = $query->result();` – Deepak M May 30 '18 at 07:28

How to convert this mysqli_fetch_array code to codeigniter

1 Answers1