Query sql codeigniter

Question

Query sql codeigniter

Navigation

#1 by (1 votes)
#2 by (1 votes)

0

I have a table with dates and I would like to create a query that returns records with dates before the current day but I could not mount this query; below is my code and BD image:

function get_late_events($sort = 'idevento', $order = 'asc', $limit =null, $offset = null) {
    $this->db->order_by($sort, $order);

    if($limit){
        $this->db->limit($limit,$offset);
    }

    $this->db->select('idevento, cnome, inicio, fim, descricaoEvento, user, importancia');
    $this->db->from('eventos');
    $this->db->join('clientes','clientes.ccod = eventos.nomeEvento');
    $this->db->where('inicio', '<?php echo date('Y-m-d'); ?>');
    $query = $this->db->get(); 
    return $query->result();
}

Database:

php mysql sql codeigniter

asked by anonymous 01.07.2017 / 17:14

2 answers

Adapt JQUERY to HIDE and Show Format & End in print in Python

score 1 · Answer 1

The SQL normal query in PHP would look like this:

<?php 
$data = date('Y-m-d'); 

$sqlq = "

SELECT idevento, cnome, inicio, fim, descricaoEvento, user, importancia
FROM eventos xxx
LEFT JOIN clientes zzz ON (zzz.ccod = xxx.nomeEvento)
WHERE xxx.inicio = '$data'
ORDER BY xxx.inicio ASC

"
?>

score 1 · Answer 2

1

I solved it as follows and it worked.

$this->db->where('inicio <', date('Y-m-d'));

01.07.2017 / 18:10