namespace Home\Controller;
use Think\Controller;
class IndexController extends Controller {
public function index(){
//$author = new \Model\AuthorModel();
//$paper_author = new \Model\PaperAuthorModel();
$author = M('Author');
//$paper_author = M('PaperAuthor');
//查询出paper_author表中pripority=1的author_id
//$info2 = $paper_author->field('author_id')->where('priority=1')->select();
$info = $author->where('id=2')->select();
var_dump($info);
$this->display();
上面的代码可以正常打印出$info 并输出页面-----------------------------------------------------------------
namespace Home\Controller;
use Think\Controller;
class IndexController extends Controller {
public function index(){
//$author = new \Model\AuthorModel();
//$paper_author = new \Model\PaperAuthorModel();
$author = M('Author');
$paper_author = M('PaperAuthor');
//查询出paper_author表中pripority=1的author_id
$info2 = $paper_author->field('author_id')->where('priority=1')->select();
$info = $author->where('id=2')->select();
var_dump($info2);
$this->display();
这部分代码打印$info出现 internal server error.--------------------------------------------------------------------------
1. 数据库表paper_author 与 author 都在同一个数据库里面，且它们的Model.class.php都在同一个位置，应该不会是找不到Model文件，而且如下代码输出是正常的
$author = M('Author');
$paper_author = M('PaperAuthor');
var_dump($paperauthor);
exit();
//查询出paper_author表中pripority=1的author_id
// $info2 = $paper_author->field('author_id')->where('priority=1')->select();
$info = $author->where('id=2')->select();
var_dump($info2);
$this->display();var_dump($paper_author)可以正常输出。2. 我怀疑是不是$Info2的查询语句出问题。于是在SHOW_PAGE_TRACE中看它的语句
SELECT `author_id` FROM `paper_author` WHERE ( priority=1 )
把该语句直接扔进数据库中运行可以正常查询
纳闷了，究竟是哪里出了问题？？？
最佳答案
