在數據搜索時最常見的就是調用同一個方法查詢，而查詢的字段卻可能是其中一個或其中的幾個字段一起組合查詢，例如：對列表的搜索，基本上都是幾個字段隨意組合搜索。那么在model里就需要判斷有那個字段組合，怎么組合。

function findByParam($param = array())  {    $select = new Customer();    if (isset($param['name']) && '' != $param['name'])    {      $select = $select->where('customer.name', '=', $param['name']);    }    if (isset($param['phone']) && '' != $param['phone'])    {      $select = $select->where('customer.phone', '=', $param['phone']);    }    if (isset($param['email']) && '' != $param['email'])    {      $select = $select->where('customer.email', '=', $param['email']);    }    if (isset($param['tel']) && '' != $param['tel'])    {      $select = $select->where('customer.tel', '=', $param['tel']);    }    if (isset($param['qq']) && '' != $param['qq'])    {      $select = $select->where('customer.qq', '=', $param['qq']);    }    if (isset($param['IDCard']) && '' != $param['IDCard'])    {      $select = $select->where('customer.IDCard', '=', $param['IDCard']);    }    // 執行分頁查詢    $customers = $select->leftJoin("member", function ($join)    {      $join->on("customer.memberID", "=", "member.id");    })      ->get(array(      'customer.id',      'customer.name',      'customer.sex',      'customer.tel',      'customer.phone',      'customer.address',      'customer.email',      'customer.qq',      'customer.headPic',      'customer.birthday',      'customer.IDCard',      'customer.enable',      'customer.memberID',      'customer.IDCard',      'customer.info',      'member.name as mname',      'member.discount'    ));    return json_encode($customers);

function anyFindbyparam()  {    $name = Input::get('name');    $tel = Input::get('tel');    $phone = Input::get('phone');    $email = Input::get('email');    $qq = Input::get('qq');    $IDCard = Input::get('IDCard');    $customer = new Customer();    $customers = $customer->findByParam(array(      'name' => $name,      'tel' => $tel,      'phone' => $phone,      'email' => $email,      'qq' => $qq,      'IDCard' => $IDCard    ));    return $customers;  }

鄭重聲明：本文版權歸原作者所有，轉載文章僅為傳播更多信息之目的，如作者信息標記有誤，請第一時間聯系我們修改或刪除，多謝。