从数据库select中删除字符串中的特定字符

Question

我已经将数据存储在单元格中，如下所示：RP1=8, RP2=6, RP3=8, RP4=7，当我调用这些数据时，有没有办法去掉RP1=部分，只留下值？

$row = $result->fetch_assoc();
echo $row['rp1'];
echo $row['rp2'];
echo $row['rp3'];
echo $row['rp4'];

print_r($row)；

Array ( [id] => 1 [dashboardId] => 1 [memberId] => 1 [rp1] => RP1=8 [rp2] => RP2=6 [rp3] => RP3=8 [rp4] => RP4=7 [teamId] => 1 )

Answer 1

去罗马的一种方法：

$row = $result->fetch_assoc();
#replace can go over all entries here, it is specific enuff
$row = array_map(function($a){return preg_replace('#^(RP[0-9]+=)#','',trim($a));},$row);
echo $row['rp1'];
echo $row['rp2'];
echo $row['rp3'];
echo $row['rp4'];