错误写法
$sql="select company_id from tplay_line where start like '%:start%' and end like '%:end%'";
$result =Db::query($sql,['start'=>$post['start'],'end'=>$post['end']]);
正确写法
$sql="select company_id from tplay_line where start like :start and end like :end";
$result =Db::query($sql,
[ 'start'=>'%'.$post['start'].'%',
'end'=>'%'.$post['end'].'%' ]);
近期评论