thinkptp里面的常用表达式

TP运算符 	SQL运算符 	例子 	实际查询条件
eq 	= 	$map['id'] = array('eq',100); 	等效于:$map['id'] = 100;
neq 	!= 	$map['id'] = array('neq',100); 	id != 100
gt 	> 	$map['id'] = array('gt',100); 	id > 100
egt 	>= 	$map['id'] = array('egt',100); 	id >= 100
lt 	< $map['id'] = array('lt',100); id < 100 elt <= $map['id'] = array('elt',100); id <= 100 like like $map<'username'> = array('like','Admin%'); 	username like 'Admin%'
between 	between and 	$map['id'] = array('between','1,8'); 	id BETWEEN 1 AND 8
not between 	not between and 	$map['id'] = array('not between','1,8'); 	id NOT BETWEEN 1 AND 8
in 	in 	$map['id'] = array('in','1,5,8'); 	id in(1,5,8)
not in 	not in 	$map['id'] = array('not in','1,5,8'); 	id not in(1,5,8)
and(默认) 	and 	$map['id'] = array(array('gt',1),array('lt',10)); 	(id > 1) AND (id < 10) or or $map['id'] = array(array('gt',3),array('lt',10), 'or'); (id > 3) OR (id < 10) xor(异或) xor 两个输入中只有一个是true时,结果为true,否则为false,例子略。 1 xor 1 = 0 exp 综合表达式 $map['id'] = array('exp','in(1,3,8)'); $map['id'] = array('in','1,3,8');

小栗子一枚
($cat == 1)? ($where['sid'] = array(36)) : ($where['sid'] = array('in','37,38')); 
我想在$cat 为1的时候查找分类36 ,在不为1的时候查找37,38,用in

随机浏览