Removing specific characters from a string from database select

Question

I have stored data in cells like the following: RP1=8, RP2=6, RP3=8, RP4=7 is there a ways that when I call that data to strip out the RP1= portion just leaving the value?

$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 )

@JustOnUnderMillions I get this: Array ( [id] => 1 [dashboardId] => 1 [memberId] => 1 [rp1] => RP1=8 [rp2] => RP2=6 [rp3] => RP3=8 [rp4] => RP4=7 [teamId] => 1 ) — PhpDude
– PhpDude, Commented Feb 28, 2017 at 10:26
You should clean-up your values in the database itself; remove the column names from them. — jeroen
– jeroen, Commented Feb 28, 2017 at 10:27
Do this print preg_replace('#(RP[0-9]+=)#','','RP8=2'); like print preg_replace('#(RP[0-9]+=)#','',$row['rp1']); — JustOnUnderMillions
– JustOnUnderMillions, Commented Feb 28, 2017 at 10:44

JustOnUnderMillions · Accepted Answer · 2017-02-28 10:48:16Z

1

One way to rome:

$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'];

answered Feb 28, 2017 at 10:48

JustOnUnderMillions

3,80511 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Removing specific characters from a string from database select

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related