public function index()
{
$homeM = ModelIstance('home');
//---------------------查询-------------------------
//数组
//echo '------查询 多条-------';
$where['id'] = array('<', 16);
$res = $homeM->where($where)->field('label_id,label_name,id')->order('label_id DESC')->limit(1, 5)->fetchAll('label_id');
/*printarr($res);
//是否用的同一个数据库实例,同一个链接符号?
//字串
echo '------查询 单条-------';
$res = $homeM->where('id = 12')->field('label_id,label_name')->order('label_id DESC')->fetch();
printarr($res);
//model 方法查询
$homeM = new homeModel();
$res[] = $homeM->getById(1);
//原生查询
$res = $homeM->query('SELECT * FROM %t WHERE label_id IN(%n)',array('home',array(1,2,3,4)));
*/
//---------------------增加-------------------------
/*
//对象方式
$homeM->label_name = '马拉松';
$homeM->id = '2';
$insertid = $homeM->add();
echo $insertid.'<br>';
*/
//---------------------更新-------------------------
/*
$homeM->label_name = '短跑';
$homeM->id = 66;
$affectrow = $homeM->update(['label_name'=>'马拉松']);
echo $affectrow.'<br>';
*/
//---------------------删除-------------------------
/*
$affectrow = $homeM->where(['label_name'=>'短跑'])->delete();
echo $affectrow.'<br>';
*/
$data = $res;
//手机版主题
// $this->theme='mobile';
$this->assign('pageTitle', '我是PC版title');
$this->assign('data', $data);
$this->assign('content', '我是PC版内容');
$this->display();
}
public function index()
{
$s = ModelIstance('home');
$s->title = 'test title';
echo $s->title . '<br>';
$s->homeFetch();
echo '<br>';
$s->fetchAll();
//test
//$this->theme='mobile';
$arr = [1, 2, 3, 4, 5];
$one = 1;
$this->assign('pageTitle', '我是PC版title');
$this->assign('one', $one);
$this->assign('arr', $arr);
$this->assign('content', '我是PC版内容');
$this->display();
}
