我有以下查詢，它在 MySQL 中作業
SELECT
t_pegtug.idtug
FROM
t_pegtug
INNER JOIN
t_tugas
ON
t_pegtug.idtug = t_tugas.idtug
INNER JOIN
t_peg
ON
t_pegtug.idpeg = t_peg.idpeg
WHERE
t_tugas.tgl_pulang >= '2021-03-04' AND
t_tugas.tgl_berangkat <= '2021-03-04' AND
t_pegtug.idpeg IN ((
SELECT
t_pegtug.idpeg
FROM
t_pegtug
INNER JOIN t_tugas ON t_pegtug.idtug = t_tugas.idtug
INNER JOIN t_peg ON t_pegtug.idpeg = t_peg.idpeg
WHERE
t_tugas.idtug = '9'
))
但是，如果我轉換 Codeigniter 方式，則查詢不起作用。如何在 Codeigniter 中撰寫此查詢？我嘗試了以下代碼，但它顯示
“試圖獲取非物件的屬性”
$query=$this->db->query('
SELECT t_pegtug.idtug FROM t_pegtug
INNER JOIN t_tugas ON t_pegtug.idtug = t_tugas.idtug
INNER JOIN t_peg ON t_pegtug.idpeg = t_peg.idpeg
WHERE t_pegtug.idpeg in (
SELECT t_pegtug.idpeg FROM t_pegtug
INNER JOIN t_tugas ON t_pegtug.idtug = t_tugas.idtug
INNER JOIN t_peg ON t_pegtug.idpeg = t_peg.idpeg
WHERE t_tugas.idtug = "9"
)
AND t_tugas.tgl_pulang >= "2021-03-04"
AND t_tugas.tgl_berangkat <= "2021-03-04"
ORDER BY t_tugas.idtug ASC');
return $query;
uj5u.com熱心網友回復：
嘗試使用方法result_array()一樣，
$query->result_array()
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/322247.html