thinkphp-连贯操作
//SQL连贯操作
//连贯操作入门
/*
$user=M('Sks');
echo "<pre>";
//var_dump($user->where('id>1')->order('date DESC')->limit(2)->select());
//连贯操作:id大于1的 时间 只显示两个
var_dump($user->select(array('where'=>array('id'=>array('neq',1)),'order'=>'date DESC','limit'=>2)));
echo "</pre>";
*/
//查,删,排
/*
$user=M('Sks');
echo "<pre>";
//var_dump($user->where('id in (2,3)')->find());
//查 只能查取一个
//var_dump($user->where('id=12')->delete());
//删 删除id=12的$user=M('Sks');
//var_dump($user->order('id DESC')->select());
//排序
//var_dump($user->order('id DESC,date DESC')->select());
//当第一项相同时,会在比较第二项
echo "</pre>";
*/
//field
/*
$user=M('Sks');
echo "<pre>";
//var_dump($user->field('id,name')->select());
//只显示id和name
//var_dump($user->field('SUM(id) as count,name')->select());
//只显示id和name,并改变id的别名为count
//使用SQL函数和别名
//var_dump($user->field(array('id','LEFT(name,2)'=>'left_name'))->select());
//只显示id和name,naem只显示两位数,并且改变name的别名为left_name
//使用数组参数结合SQL函数
//var_dump($user->field()->select());
//获取所有字段
//var_dump($user->field('name,pass')->create());
//用于写入
echo "</pre>";
*/
//limit
/*
$user=M('Sks');
echo "<pre>";
//var_dump($user->limit(2)->select());
//只显示两个
//限制结果集数量
//var_dump($user->limit(2,2)->select());
//从2开始,显示两个--3、4
//分页查询
echo "</pre>";
*/
//page
/*
$user=M('Sks');
echo "<pre>";
//var_dump($user->page(2,2)->select());
//从2开始,显示两个--3、4
//page分页
echo "</pre>";
*/
//table
/*
$user=M('Sks');
echo "<pre>";
//var_dump($user->table('think_t2')->select());
//切换数据库
//var_dump($user->table('__SKS__')->select());
//获取简化表名
var_dump($user->field('a.name,b.name')->table(array('think_sks'=>'b','think_t2'=>'a'))->select());
//多表查询
echo "</pre>";
*/
//alias
/*
$user=M('Sks');
echo "<pre>";
var_dump($user->alias('a')->select());
//设置别名--think_sks a
echo "</pre>";
*/
//group
/*
$user=M('Sks');
echo "<pre>";
var_dump($user->field('name,sum(id)')->group('id')->select());
//分组统计
echo "</pre>";
*/
//having
/*
$user=M('Sks');
echo "<pre>";
var_dump($user->field('name,sum(id)')->group('id')->having('id>2')->select());
//分组统计结合having
echo "</pre>";
*/
//comment
/*
$user=M('Sks');
echo "<pre>";
var_dump($user->comment('所有用户')->select());
//SQL注释
echo "</pre>";
*/
//join
/*
$user=M('Sks');
echo "<pre>";
var_dump($user->join('think_t2 ON think_sks.id=think_t2.id','LEFT')->select());
//分组统计
echo "</pre>";
*/
//union
/* //有问题
$user=M('T2');
echo "<pre>";
var_dump($user->union("SELECT * FROM __SKS__")->select());
//合并
echo "</pre>";
*/
//distinct
/*
$user=M('T2');
echo "<pre>";
var_dump($user->distinct(true)->field('name')->select());
//返回不重复的name
echo "</pre>";
*/
//cache
/*
$user=M('T2');
echo "<pre>";
var_dump($user->cache(true)->select());
//查询缓存,第二次读取缓存内容
echo "</pre>";
*/