jeudi 28 mai 2015

codeigniter sqlite not giving results

i just started working with codeigniter and with sqlite,

i have succesfully loaded the sqlite file but when i try to run a get request i get this:

Table 'gl0rix.gl0rix' doesn't exist

SELECT * FROM `gl0rix`

the full code:

public function __construct() {
    parent::__construct();
    $this->load->database("https://****/*/****/database.sqlite");
}

public function getAll() {
    $query = $this->db->get("gl0rix");
    if ($query->num_rows() >= 1) {
        return $query->result();
    } else {
        return false;
    }
}

so can anybody please help me? i'm using codeIgniter 3.0.0

Aucun commentaire:

Enregistrer un commentaire