tp3.2sql条件查询

最新推荐文章于 2022-11-12 07:00:00 发布

weixin_40974880

最新推荐文章于 2022-11-12 07:00:00 发布

阅读量326

点赞数

本文链接：https://blog.csdn.net/weixin_40974880/article/details/86604976

版权

//查询我关注的课程
$attention_course = $attention_model
->join(“left join cmf_course as c on cmf_users_attention.touid = c.id”)
->where(array( “cmf_users_attention.type” => 2, “cmf_users_attention.status” => 1, “cmf_users_attention.uid” => $uid, “c.status>0”))
->order(“cmf_users_attention.create_time desc”)->fetchsql(true)
->getField(“c.id,c.course_id,c.title,c.start_time,c.deadline,c.uid,c.costs,c.front_cover,c.type”);