php codeigniter中的concat空间不工作

mo49yndu 于 2022-12-07 发布在 PHP

关注(0)|答案(3)|浏览(134)

我的选择查询总是提示一个错误，即使我已经在它的结尾放置了FALSE。

function preparedBy($series){
    $this->db->select('CONCAT (users.FirstName,' ',users.MiddleName,' ',users.LastName) as name',FALSE);
    $this->db->from ( 'users' );
    $this->db->join ( 'entry ', 'entry.ClericalAide = users.UserName');
    $this->db->where ( 'entry.Series', $series);
    $query = $this->db->get();
    return $query->row_array();
}

这是我在我的sql select

中悬停时的错误

codeigniter

来源：https://stackoverflow.com/questions/39403469/concat-space-in-php-codeigniter-not-working

3条答案

按热度按时间

vddsk6oq1#

你的报价全乱了。试着运行这个：

function preparedBy($series){
    $this->db->select('CONCAT (users.FirstName, users.MiddleName, users.LastName) as name',FALSE);
    $this->db->from ('users');
    $this->db->join ('entry','entry.ClericalAide = users.UserName');
    $this->db->where ('entry.Series', $series);
    $query = $this->db->get();
    return $query->row_array();
}

赞(0）回复(0）举报 2022-12-07

ulydmbyx2#

尝试将函数更改为

function preparedBy($series){
$this->db->select('CONCAT (users.FirstName,'". ."',users.MiddleName,'". ."',users.LastName) as name",FALSE);
$this->db->from ( 'users' );
$this->db->join ( 'entry ', 'entry.ClericalAide = users.UserName');
$this->db->where ( 'entry.Series', $series);
$query = $this->db->get();
return $query->row_array();
}

赞(0）回复(0）举报 2022-12-07

yks3o0rb3#

只要加上" "，而不是' '。

function preparedBy($series){
    $this->db->select('CONCAT (users.FirstName," ",users.MiddleName," ",users.LastName) as name',FALSE);
    $this->db->from ( 'users' );
    $this->db->join ( 'entry ', 'entry.ClericalAide = users.UserName');
    $this->db->where ( 'entry.Series', $series);
    $query = $this->db->get();
    return $query->row_array();
}

赞(0）回复(0）举报 2022-12-07

我来回答

php codeigniter中的concat空间不工作

3条答案

相关问题

热门标签

最新问答