public function doMobileSelectUser2()
{
global $_W, $_GPC;
//查出已是商家用户
$sjuser = pdo_getall('cjdc_store', array('uniacid' => $_W['uniacid']), 'admin_id');
//二维数组转一维
function i_array_column($input, $columnKey, $indexKey = null)
{
if (!function_exists('array_column')) {
$columnKeyIsNumber = (is_numeric($columnKey)) ? true : false;
$indexKeyIsNull = (is_null($indexKey)) ? true : false;
$indexKeyIsNumber = (is_numeric($indexKey)) ? true : false;
$result = array();
foreach ((array)$input as $key => $row) {
if ($columnKeyIsNumber) {
$tmp = array_slice($row, $columnKey, 1);
$tmp = (is_array($tmp) && !empty($tmp)) ? current($tmp) : null;
} else {
$tmp = isset($row[$columnKey]) ? $row[$columnKey] : null;
}
if (!$indexKeyIsNull) {
if ($indexKeyIsNumber) {
$key = array_slice($row, $indexKey, 1);
$key = (is_array($key) && !empty($key)) ? current($key) : null;
$key = is_null($key) ? 0 : $key;
} else {
$key = isset($row[$indexKey]) ? $row[$indexKey] : 0;
}
}
$result[$key] = $tmp;
}
return $result;
} else {
return array_column($input, $columnKey, $indexKey);
}
}
$yuser = i_array_column($sjuser, 'admin_id');
$string = '';
if ($yuser) {
foreach ($yuser as $v) {
$string .= "'" . $v . "',";
}
$string = rtrim($string, ",");
}
if ($yuser) {
$sql = " select id,name from " . tablename('cjdc_user') . " where uniacid={$_W['uniacid']} and id not in ({$string}) and (name like '%{$_GPC['keywords']}%' || openid like '%{$_GPC['keywords']}%') and name !=''";
} else {
$sql = " select id,name from " . tablename('cjdc_user') . " where uniacid={$_W['uniacid']} and (name like '%{$_GPC['keywords']}%' || openid like '%{$_GPC['keywords']}%') and name !=''";
}
$user = pdo_fetchall($sql);
echo json_encode($user);
}
题目来源及自己的思路
相关代码
// 请把代码文本粘贴到下方(请勿用图片代替代码)
就是单纯的声明一个函数罢了:
结果: