CodeIgniter Forums
Query Builder - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: Query Builder (/showthread.php?tid=71491)



Query Builder - Zeref_x - 08-19-2018

I have studying a code below, I am curious why there is no select statement in the code? And it works perfectly fine. Thank you

$this->db->from('Users');
$where_array = array( 'Username' => $username,
                                  'Password' => $password,
                                 'Active' => 1);
  $this->db->where($where_array);
  $query = $this->db->get();


RE: Query Builder - kilishan - 08-19-2018

When a query is executed through the Query Builder that doesn't have any select statement specified, it assumes select *.


RE: Query Builder - Zeref_x - 08-21-2018

(08-19-2018, 08:21 PM)kilishan Wrote: When a query is executed through the Query Builder that doesn't have any select statement specified, it assumes select *.

Thanks I just want to clarify it, because I can't find it in the documentation.