ecshop后台通过email搜索用户的功能开发实例

$filter['email'] = empty($_REQUEST['email']) ? '' : trim($_REQUEST['email']);

if ($filter['keywords'])
{
$ex_where .= " AND user_name LIKE '%" . mysql_like_quote($filter['keywords']) ."%'";
}

if ($filter['keywords'] && $filter['email'])
{
$ex_where .= " AND user_name LIKE '%" . mysql_like_quote($filter['keywords']) ."%' AND email LIKE '%" . mysql_like_quote($filter['email']) ."%'";
}
  elseif($filter['keywords'])
  {
   $ex_where .= " AND user_name LIKE '%" . mysql_like_quote($filter['keywords']) ."%'";
  }
  elseif($filter['email'])
  {
  $ex_where .= " AND email LIKE '%" . mysql_like_quote($filter['email']) ."%'";
  }

;邮箱地址 ;<input type="text" name="email" /> <input type="submit" value="{$lang.button_search}" />

listTable.filter['email'] = document.forms['searchForm'].elements['email'].value;