Extract specific data from a php string

Question

I have a url stored in a database in the following format

index.php?main_page=product_info&cPath=1_11&products_id=568

I want to be able to extract the cPath data, 1_11 in this case, and the products id '568' to two separate variables. Note that the cPath value could vary from being a single number such as 23 to a series of numbers and underscores such as 17_25_31. If extracting the cPath is too difficult I could use the products_id once it's extracted and query the database again, but this isn't ideal as I want to avoid additional requests as much as possible.

I really don't know the best (correct) way to go about this.

score 4 · Accepted Answer · 2016-11-16 03:03:34Z

4

A more refined approach as suggested by Robbie Averill

//first lets the the query string alone
$string=parse_url('index.php?main_page=product_info&cPath=1_11&products_id=568', PHP_URL_QUERY);

parse_str($string,$moo);

print_r($moo);

Output:

Array
(
    [main_page] => product_info
    [cPath] => 1_11
    [products_id] => 568
)

My original suggestion.

parse_str('index.php?main_page=product_info&cPath=1_11&products_id=568',$moo);

print_r($moo);

output:

Array
(
    [index_php?main_page] => product_info
    [cPath] => 1_11
    [products_id] => 568
)

edited Nov 16, 2016 at 3:03

answered Nov 16, 2016 at 2:51

user557846

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

5 Comments

scrowler Over a year ago

Better would probably be to parse_url first then just parse_str on the query string

user557846 Over a year ago

i thought about that, but he only wanted cPath and products_id so i thought lets make it real simple. But i will add that to the answer ;-)

Steve Price Over a year ago

Works beautifully, thank you. Was easily able to assign the values to variables as $cPath = ($moo['cPath']); $products_id = ($moo['products_id']);

user557846 Over a year ago

@StevePrice why reassign at all? your just doubling memory usage for no advantage

Steve Price Over a year ago

@Dagon Valid point. I changed my code to access it directly after your comment.

Collectives™ on Stack Overflow

Extract specific data from a php string

1 Answer 1

5 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Related