如何在Codeigniter中正确使用Alias [英] How to properly use Alias in Codeigniter

问题描述

这是我的代码：

  $ this-> db-> select（'course_name AS Course Name，course_desc AS课程描述，display_public AS显示状态'，FALSE）; 
 $ this-> db-> from（'courses'）; 
 $ this-> db-> where（'tennant_id'，$ tennant_id）; 
 $ this-> db-> order_by（'course_name'，'ASC'）; 
 $ query = $ this-> db-> get（）; 
  

我收到一个错误：

 发生数据库错误
 
错误号：1064 
 
您的SQL语法有错误;检查与您的MySQL服务器版本对应的手册，以获得正确的语法在'Name，course_desc AS附近使用的语法AS课程描述，display_public AS显示状态FROM（'在第1行
 
 SELECT course_name AS课程名称，
 course_desc AS课程描述，
 display_public AS显示状态
 FROM（`courses`）WHERE`tennant_id` ='[e-mail]'
 ORDER BY`course_name'ASC 
 
文件名：C：\wamp\www\coursebooking\system\database\DB_driver.php 
 
行号：330 
  
 
 
解决方案
尝试
  $ this-> db-> select（'course_name AS` Course Name`，course_desc AS`Course Description`，display_public AS`Display Status`'，FALSE）; 
  
这是你的别名中的空间，是你搞错了。
 
 
 
 strong> UPDATE  
 
 
 
我不知道你为什么要，但我没有看到任何东西阻止你写
  $ this-> db-> select（course_name AS`{$ variable}`，FALSE）; 
  
（为了简单起见，只显示一个字段）
 
 
 
  UPDATE 2  
 
 
 
应该是标准字符串转换，所以我不知道为什么它不工作。 string ... 
  $ this-> db-> select（'course_name AS`'。$ variable。 '，FALSE）; 
  
 
Here is my code:
$this->db->select('course_name AS Course Name,course_desc AS Course Description,display_public AS Display Status',FALSE);
$this->db->from('courses');
$this->db->where('tennant_id',$tennant_id);
$this->db->order_by('course_name','ASC');
$query = $this->db->get();
and I got an error:
A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Name, course_desc AS Course Description, display_public AS Display Status FROM (' at line 1

SELECT course_name AS Course Name, 
       course_desc AS Course Description, 
       display_public AS Display Status 
FROM (`courses`) WHERE `tennant_id` = '[e-mail]' 
ORDER    BY `course_name` ASC

Filename: C:\wamp\www\coursebooking\system\database\DB_driver.php

Line Number: 330

解决方案
Try
$this->db->select('course_name AS `Course Name`, course_desc AS `Course Description`, display_public AS `Display Status`', FALSE);
It's the space in your alias that is messing with you.

UPDATE

I'm not sure why you would want to, but I see nothing preventing you from writing 
$this->db->select("course_name AS `{$variable}`", FALSE);
(showing just one field for simplicity)

UPDATE 2

Should be standard string conversion so I don't know why it doesn't work for you.. there's always split strings...
$this->db->select('course_name AS `' . $variable . '`', FALSE);


                        
这篇关于如何在Codeigniter中正确使用Alias的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！