php: extracting substring from a string

Question

I have in my database record products and price on the same column. EG:

product name 2- RM 120.00

product name 6 - RM 10.00

product name 77 - RM 1.00

product name 3243 - RM 18.00

I am currently trying to separate the name & price into 2 columns, so the name column will only have 'product name' while price column only the price '120.00'

I tried using substr function but that would only work on the number number of characters behind. Is there anyway I can get all the numbers behind the '- RM' ?

you can also use preg_match for your purpose, but frankly saying explode is a better option. — stackMonk
– stackMonk, Commented Nov 3, 2014 at 6:06

heychez · Accepted Answer · 2014-11-03 05:56:09Z

2

$data = explode(" - RM ", $record); //your (string) database record in $record

echo $data[0]; //product name 2
echo $data[1]; //120.00

echo $data[2]; //product name 6
echo $data[3]; //10.00

answered Nov 3, 2014 at 5:56

heychez

6481 gold badge6 silver badges12 bronze badges

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

Comments

gview · Accepted Answer · 2014-11-03 05:56:44Z

0

The explode function makes this pretty easy.

$values = explode(' - RM ', $field);
var_dump($values);

answered Nov 3, 2014 at 5:56

gview

15.5k3 gold badges53 silver badges56 bronze badges

Collectives™ on Stack Overflow

php: extracting substring from a string

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related