I am not sure which is the best method to run a DB query ( or what the difference is for that matter ) between :

$this->db
 ->select('*')
 ->from('table');
$this->db->get();

ve

$this->db->query($sql);

I found that i need the get() class because i need to have pagination vethat is needed for limiters....but maybe the other one allows for pagination too?

SQL enjeksiyon ile ilgili ikinci bölümü yeterince iyi mi? ne değilse?

  $this->db
     ->select('*')
     ->from('table');
    $this->db->get();
 ->where('id >'.$this->db->escape(1));

teşekkür ederim.