ThinkPHP的数据库查询

最新推荐文章于 2024-07-15 17:00:02 发布

jimlong

最新推荐文章于 2024-07-15 17:00:02 发布

阅读量3.7k

点赞数

本文链接：https://blog.csdn.net/jimlong/article/details/8271749

版权

    $User = M("User"); // 实例化User对象
    $condition['name'] = 'thinkphp';
    $condition['status'] = 1;
    // 把查询条件传入查询方法
    $User->where($condition)->select();

最后生成的SQL语句是

SELECT * FROM think_user WHERE `name`='thinkphp' AND status=1

$User = M("User"); // 实例化User对象
$condition['name'] = 'thinkphp';
$condition['account'] = 'thinkphp';
$condition['_logic'] = 'OR';
// 把查询条件传入查询方法
$User->where($condition)->select();

最后生成的SQL语句是