Question

thinkphp 多表多字段模糊查询怎么实现

Answer 1

$Model = M('Artist');
    $map['name'] = array('like','thinkphp%');
    $Model
    ->join('think_work ON 卖悔悉think_artist.id = think_work.artist_id')
    ->join('think_card ON think_artist.card_id = think_card.id')
    中乎->where($map)
    前圆->select();

Answer 2

where = '1'
where .= "and 字段 like %变量% "