PHP: How to find the beginning and end of a substring in a string?

Question

This is the content of one mysql table field:

Flash LEDs: 0.5W
LED lamps: 5mm
Low Powers: 0.06W, 0.2W
Remarks(1): this is remark1
----------
Accessories: Light Engine
Lifestyle Lights: Ambion, Crane Fun
Office Lights: OL-Deluxe Series
Street Lights: Dolphin
Retrofits: SL-10A, SL-60A
Remarks(2): this is remark2
----------
Infrared Receiver Module: High Data Rate Short Burst
Optical Sensors: Ambient Light Sensor, Proximity Sensor, RGB Color Sensor
Photo Coupler: Transistor
Remarks(3): this is remark3
----------
Display: Dot Matrix
Remarks(4): this is remark4

Now, I want to read the remarks and store them in a variable. Remarks(1), Remarks(2), etc. are fixed. 'this is remark1', etc. come from form input fields, so they are flexible.

Basically what I need is: Read everything between 'Remarks(1):' and '--------' and save it in a variable.

Thanks for your help.

Why do you need to do this? The data should probably be stored in a proper table structure in the database. — Jords
– Jords, Commented Sep 14, 2010 at 4:51

NullUserException · Accepted Answer · 2010-09-14 04:50:18Z

1

You can use regex:

preg_match_all("~Remarks\(([^)]+)\):([^\n]+)~", $str, $m);

As seen on ideone.

The regex will put X in match group 1, Y in match group 2 (Remarks(X): Y)

edited Sep 14, 2010 at 4:50

answered Sep 14, 2010 at 4:45

NullUserException

85.8k31 gold badges212 silver badges239 bronze badges

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

2 Comments

Stefan Schneider Over a year ago

Great thanks, that works for me. But how do I save each remark in a separate variable?

NullUserException Over a year ago

They will be in an array ($m[2]), so you could do list($remark1, $remark2, $remark3, $remark4) = $m[2]). But an array looks cleaner IMO (eg: $remarks = $m[2])

Aaron Anodide · Accepted Answer · 2010-09-14 04:42:37Z

0

This would be a job for regular expressions, which allow you to match on exactly the kinds of rules your requirements express. Here is a tutorial for you.

answered Sep 14, 2010 at 4:42

Aaron Anodide

17.2k15 gold badges67 silver badges129 bronze badges

Comments

Karthik · Accepted Answer · 2010-09-14 05:02:37Z

0

Use preg function for this or otherwise you can explode and implode function to get correct result. Don't Use Substring it may not provide correction.

Example of Implode and Explode Function for your query string :

    $sdr = "Remarks(4): this is remark4";

    $sdr1 = explode(":",$sdr);
    $frst = $sdr1[0];

    $sdr2 = array_shift($sdr1);

    $secnd = implode(" ", $sdr1);

    echo "First String - ".$frst;
    echo "<br>";
    echo "Second String - ".$secnd;
    echo "<br>";

Your Answer :

First String - Remarks(4)

Second String - this is remark4

answered Sep 14, 2010 at 5:02

Karthik

3,3415 gold badges31 silver badges38 bronze badges

Collectives™ on Stack Overflow

PHP: How to find the beginning and end of a substring in a string?

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related