我有50个值以此形式存储在表中的一个字段中,用逗号分隔(例如:472744,341750,263249,...
我可以在该表中查询该字段。我想将值转换为数组,并从数组中删除一个特定值。下面是我的代码,但它拒绝工作。有谁能解释一下原因吗?
public function getChurchPinInfo($id)
{
$query = $this->db -> prepare(
"SELECT * FROM church_pin_tbl WHERE church_id = ? LIMIT 1"
);
$query -> execute(array($id));
$result = $query->fetch();
return $result;
}
然后
$churchPinsArray = array((new Shop)->getChurchPinInfo($churchId)->pin);
if (($key = array_search(341750, $churchPinsArray)) !== false) {
unset($churchPinsArray[$key]);
print_r($churchPinsArray);
} else {
echo 'Not found';
}
发布于 2018-06-07 04:25:33
这实际上是我问题的答案,我成功地将逗号表示的值转换为数组,然后在内爆数组之前从数组列表中删除一个值
$churchPinList = (new Shop)->getChurchPinInfo($churchId)->pin;
$arr = explode(',', $churchPinList);
$churchPinsArray = array_map('intval', $arr);
$arrayWithoutUsedPin = array_diff($churchPinsArray, array($churchPin));
$newPins = implode(',', $arrayWithoutUsedPin);
echo $newPins;
https://stackoverflow.com/questions/50721049
复制相似问题