//1.接收url里面的内容
 public function newstype(Request $request)
    {

        $url = $request->url();
        $isfirst = input('isfirst');
        $uid = input('token');
}

 

//2.指针实例
a. 要有& 把$news里面的nowtime用$mm替换....
$news = Db::query('select news.nid,news.ntitle,news.nauthor,news.reviewnum,news.nowtime,news.iscollect,newreview.ncommtent from news,newreview WHERE news.nid=newreview.nid');
foreach($news as &$mm){
    //新闻评论
    $ncommtent = Db::query("select ncommtent from  newreview  where nid = {$mm['nid']}");
    foreach($ncommtent as $vvv){
        $mm['ncommtent'] = "{$vvv['ncommtent']}";

    }
    $nowtime = Db::query('select nowtime from  news ');
    foreach($nowtime as $n){
        $mm['nowtime'] = date("Y-m-d H:i:s", $n['nowtime']);

    }

}

  

b.把$vvv['ncommtent]追加到$new 里面

   $news = Db::query("select nid,ntitle,nauthor,reviewnum ,nowtime,iscollect from  news  where nsid = '{$ntid}' limit 6,6");
                    foreach($news as &$mm2){
                        //新闻评论
                        $ncommtent = Db::query("select ncommtent from  newreview  where nid = {$mm2['nid']}");
                        foreach($ncommtent as $vvv){
                            $mm2['ncommtent'] = "{$vvv['ncommtent']}";

                        }

  //3.输出json

 $data = array(

                'code' => 0,
                'msg' =>
                    array(
                        'news' => $news,
                        'newsimg' => $newsimg,
                        'comments' => $comments
                    )
            );
            return json_encode($data,256);  //转json,并且不出现乱码

  

posted on 2017-06-15 17:39  天启创道工作室  阅读(311)  评论(0编辑  收藏  举报