Answered by : real-rat-rqipzrtl3nxt

print_r($this->db->last_query()); 

Source : https://stackoverflow.com/questions/6142099/how-to-print-sql-statement-in-codeigniter-model | Last Update : Wed, 26 Aug 20

Answered by : poor-peacock-j635r4syd822

 $sql="Select * from my_table where 1"; $query = $this->db->query($SQL); return $query->result_array();

Source : https://stackoverflow.com/questions/16435390/how-to-execute-my-sql-query-in-codeigniter | Last Update : Thu, 10 Sep 20

Answered by : jumping-boy

$query = $this->db->query('YOUR QUERY HERE');

Source : https://codeigniter.com/userguide3/database/queries.html?__cf_chl_managed_tk__=6b40831dbb4d1e62c8a50b8f43290e3ef7c3891e-1626356055-0-AaBDHy0k8oTPzyLZJFbe1Cv4-k3_4VHyn17qTLjNdTOgp2JiwbX7auoUG5iS0r9xWbkz8oDp8tD9lguq3K59U7VK73ogo9AuW-sYiPpRU3FkelGRkA_TmZ0H4wfHVWZuuydAuR-jf3S3T_MJvf7VrkWxbFA6-T1R97F5MgN7Jo17niumcO1Cs9YgZ92M4SCOrNSC1V4eR4_P9g_QRiUMq09W0bnpHefcOIuNRYZFtKmXxPx4pCoYqawtgSNKq7QIPFKkYb7vOydIRwrVJZL57mOybmCMWxZdQUvAaR_Al1em4mmB4K4a56lY4nINTCCNMETbGnvjQvVQpOLBlYz5E3t5NxqR5FdeFKV5Aqqd8npGFqp3lEyhJvpITr6V25sVrX6bn_RI1ulo89LSh8wKTvUFcgMdCGzyFJS14mtJGhtE8smrLZtUF4lRoiqm2rLKf0RaGiid_wvkKC8o3aLzaC9rVc2Gzdv1lS035nk22vu-47lqo8qEA4EvAis0_Dx255MJas-MKIeAg5LFsqnL8xsf63feMGjfo9Epl4ocAGAbZFiAsDRh3H0kqxSEc8OPP1Qe-REVdgyvaRAJ-YBFP2pcKQiY-Mm9T3RRO4Czlvv6Jji07joYiuq3-wMZC9grj-O3AGV3Kw6ZcT23CvVd1AtRg78WV8S7PdW3YN_HbpHU | Last Update : Thu, 22 Jul 21

Answered by : indonesia-people

$query = $this->db->query("SELECT * FROM users;");
foreach ($query->result('User') as $user)
{ echo $user->name; // access attributes echo $user->reverse_name(); // or methods defined on the 'User' class
}

Source : https://codeigniter.com/userguide3/database/results.html | Last Update : Fri, 17 Dec 21

Answered by : mysterious-moth-69l5pheojwzy

$this->db->get_compiled_select()

Source : https://stackoverflow.com/questions/9010128/echo-query-before-execution-and-without-execution-in-codeigniter-active-record | Last Update : Mon, 20 Jun 22

Answered by : fair-finch-gwb1sz47j6qe

$query = $db->query('YOUR QUERY HERE');

Source : https://codeigniter.com/user_guide/database/queries.html | Last Update : Tue, 11 Aug 20

Answered by : alamin-win

$sql = $this->db->get_compiled_select('mytable');
echo $sql;
// Prints string: SELECT * FROM mytable

Source : https://codeigniter.com/userguide3/database/query_builder.html | Last Update : Wed, 21 Dec 22