SQL查询语句 IN 封装

[一生小白]

 function SelectAdminIdsuo($a,$b,$c,$d){
        $sql = "select * from admin where  id in ($a,$b,$c,$d)";
        $mysqli_result = $this->query($sql, []);
        return $mysqli_result;
    }

应该怎么封装起来，如果我有很多值，或者1个值。求指教，谢谢

[hongmei85]

php5.5以上

function SelectAdminIdsuo(...$Ids){
    $sql = "select * from admin where  id in (". join(',',$Ids) .")";
    //$mysqli_result = $this->query($sql, []);
    return $sql;
}

var_dump(SelectAdminIdsuo(1,2,3,4,5));

[xuzuning]

任何 php 版本都可以

function SelectAdminIdsuo(){
  if(func_num_args() == 0)
     trigger_error("至少需要一个参数", E_USER_ERROR);
  $sql = sprintf("select * from admin where  id in (%s)", join(',',func_get_args()));
  $mysqli_result = $this->query($sql, []);
  return $mysqli_result;
}

[一生小白]

引用 2 楼 xuzuning 的回复:

任何 php 版本都可以

function SelectAdminIdsuo(){
  if(func_num_args() == 0)
     trigger_error("至少需要一个参数", E_USER_ERROR);
  $sql = sprintf("select * from admin where  id in (%s)", join(',',func_get_args()));
  $mysqli_result = $this->query($sql, []);
  return $mysqli_result;
}

万分感谢，学习了！