Home > Backend Development > PHP Tutorial > thinkphp3.1视图模型生成的SQL语句执行不了,该怎么处理

thinkphp3.1视图模型生成的SQL语句执行不了,该怎么处理

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-13 12:13:12
Original
1055 people have browsed it

thinkphp3.1视图模型生成的SQL语句执行不了
在做一个订单系统,在用视图模型的时候打印不出东西。
自定义的视图模型

<?php<br />//订单视图<br /><br />Class OrderViewModel extends ViewModel{<br />	public $viewFields = array(<br />		'order' => array('id','orderNo','date','money','memo','state','_type'=>'LEFT'),<br />		'client' => array('clientName','_on'=>'order.client_id=client.id','_type'=>'RIGHT'),<br />		'user' => array('userName','_on'=>'order.user_id=user.id'), <br />	);<br />	<br />}<br />?>
Copy after login


表结构









执行了下列语句之后,打印出一片空白
$Model = D("OrderView");<br />		$result = $Model->select();<br />		p($result);die;
Copy after login


查看日志文件后,生成的SQL语句是
SELECT order.id AS id,order.orderNo AS orderNo,order.date AS date,order.money AS money,order.memo AS memo,order.state AS state,client.clientName AS clientName,user.userName AS userName FROM or_order order LEFT JOIN or_client client ON order.client_id=client.id RIGHT JOIN or_user user ON order.user_id=user.id 
Copy after login


请各位大神帮帮忙。这是一个期末设计性实验,还有几天就要交了,万分紧急,谢谢!
------解决思路----------------------
表的别名不要用order,
order是关键字~

Related labels:
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template