首页 > 编程语言 >thinkphp中或查询使用方法

thinkphp中或查询使用方法

时间:2023-01-11 10:23:58浏览次数:43  
标签:map dump user1 方法 查询 user thinkphp where

一:字符串条件查询

  1.   //直接实例化Model
  2.   $user=M('user1');
  3.   var_dump($user->where ('id=1 OR age=55')->select())

    二:使用索引数组作为查询条件

    1. $user=M('user1'); 
    2. $condition['age']='55';
    3.  $condition['name']='zs';
    4.  // 索引数组查询的默认逻辑关系是 AND,如果想改变为 OR,可以使用_logic 定义查询逻辑
    5.  $condition['_logic'] = 'OR';
    6.  var_dump($user->where($condition)->select());
    7. 组合查询
    1. //字符串查询(_string)
    2.  $user = M('user1');
    3. $map['name'] = array('eq', 'zs');
    4.  $map['_string'] ='age="30" AND email="[email protected]"';
    5.  var_dump($user->where($map)->select());
    6.  //请求字符串查询(_query)
    7.  $user = M('user1');
    8.  $map['id'] = array('eq', "1");
    9.  $map['_query'] ='name=zs&[email protected]&_logic=OR';
    10.  var_dump($user->where($map)->select());
    11.  //复合查询(_complex)
    12.  $user = M('user1');
    13.  $where['name'] = array('like', 'z');
    14.  $where['id'] = 1;
    15.  $where['_logic'] = 'OR';
    16.  $map['_complex'] = $where;
    17.  $map['id'] = 3;
    18.  $map['_logic'] = 'OR';
    19.  var_dump($user->where($map)->select());

 

标签:map,dump,user1,方法,查询,user,thinkphp,where
From: https://www.cnblogs.com/kevin-yang123/p/17042984.html

相关文章