ThinkPHP裡面用原生SQL

標籤：

public function rewardlog(){        $adminNav = C(‘ADMIN_NAV‘);        $adminNav[1][‘class‘] = ‘cur‘;        $this->assign(‘adminNav‘,$adminNav);        $where = ‘And 1=1‘;        if($_POST){            $input = trim($_POST[‘input‘]);            if($input != ‘‘){            $where = ‘AND u.nickname like \‘%‘.$input.‘%\‘ OR r.message_code like \‘%‘.$input.‘%\‘ group by r.id‘;            }        }        $sql ="SELECT r.id,u.nickname,p.pname,r.choosetime,r.message_code,r.gettime FROM `1008_reward` r,`1008_user` u,`1008_prize` p WHERE r.uid = u.id AND r.rid = p.id $where";        $model = M();        $list = $model->query($sql);        $count = count($list);        $Page       = new Page($count,10);        $show       = $Page->show();        $res = $model->query($sql." limit {$Page->firstRow},{$Page->listRows}");        $this->assign(‘input‘,$input);        $this->assign(‘res‘,$res);        $this->assign(‘page‘,$show);        $this->assign(‘title‘,‘中獎記錄‘);        $this->display();    }

1、查詢用query   添加與修改用execute

ThinkPHP裡面用原生SQL