dayname（curdate（））在codeigniter php中不起作用 [英] dayname(curdate()) NOT working in codeigniter php

问题描述

此sql在phpmyadmin中工作，但在codeigniter php中不工作

This sql works in phpmyadmin but not working in codeigniter php

function getProgramsHomepage(){
    $data = array();
    $this->db->select("p_name,p_start");
    $this->db->where('p_channel', 'tv');
    $this->db->where('p_day', DAYNAME(CURDATE()));
    $this->db->order_by('id','asc');
    //$this->db->limit($limit);
    $Q = $this->db->get('programs');
    if($Q->num_rows() > 0){
        foreach($Q->result_array() as $row){
            $data[] = $row;
        }
    }
    $Q->free_result();
    return $data;
}

推荐答案

DAYNAME（CURDATE（））将尝试执行PHP函数 CURDATE 和 DAYNAME ，您需要以CI不能逃脱的方式将它们作为字符串传递。应该这样做：

DAYNAME(CURDATE()) will try to execute the PHP functions CURDATE and DAYNAME, you need to pass them as strings in a way that CI will not escape. This should do it:

$this->db->where('p_day = DAYNAME(CURDATE())');

这篇关于dayname（curdate（））在codeigniter php中不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！