php将数组转化成拼接IN字符串实现mysql使用where in 用法

select * from table where uname
in(‘aaa’,bbb’,‘ccc’,‘ddd’,‘eee’,ffff’’);

/* 拼接成in格式: IN('a','b','c')
   * @access   public
   * @param    mix      $list      列表数组或字符串
   * @return   string
*/
function create_in($list = '')
{
  if (empty($list)) {
    return " IN ('') ";
  } else {
    $str = joinString($list);
    return trim($str) == '' ? " IN ('') " : " IN (" . $str . ") ";
  }
}


/*
 * @name 拼接字符串，并且去掉重复项: 'a','b','c'
 * @access   public
 * @param    mix      $list      列表数组或字符串
 * @param    bool  $res_arr 是否返回数组
 * @return   string
 */
function joinString($list = '', $delimiter = ',', $res_arr = false)
{
  if (!is_array($list)) {
    $list = explode($delimiter, $list);
  }
  $list = array_unique($list);
  $arr  = array();
  foreach ($list AS $v) {
    if (is_array($v)) {
      foreach ($v as $key => $val) {
        $arr[] = "'" . $val . "'";
      }
    } elseif ($v !== '') {
      $arr[] = "'$v'";
    }
  }
  if ($res_arr) {
    return $arr;
  }
  return count($arr) == 0 ? " " : join($delimiter, $arr);
}

Done!