php - 如何在 codeigniter 中发出 sql 请求

Question

如何在 codeigniter 中发出 sql 请求

Codeigniter 请求

  $this->db->select('visites.id, persons.fio, sum(services.cena)');
    $this->db->from('visites');
    $this->db->join('persons', 'visites.clients = persons.id', 'inner');
    $this->db->join('draft', 'draft.vis = visites.id', 'inner');
    $this->db->join('services', 'draft.ser = services.id', 'inner');
    $this->db->group_by(array("visites.id, persons.fio")); 

        if($_POST['length'] != -1)
        $this->db->limit($_POST['length'], $_POST['start']);
        $query = $this->db->get();
        return $query->result();

如何正确创建请求？

Answer 1

use
$this->db->select('visites.id, persons.fio, sum(services.cena)');
    $this->db->from('visites');
    $this->db->join('persons', 'visites.clients = persons.id', 'inner');
    $this->db->join('draft', 'draft.vis = visites.id', 'inner');
    $this->db->join('services', 'draft.ser = services.id', 'inner');
    $this->db->group_by(array("visites.id, persons.fio")); 



 if($_POST['length'] >= 0)
{
        $this->db->limit($_POST['length'], $_POST['start']);
}
        $query = $this->db->get();
        return $query->result();