PHP - remove last part of string - preg_replace

Question

I need to remove "from products where id = 153183". The id can change and so I need to use a preg_replace to remove everything after the word "from" and then possibly use str_replace to remove from. I have the below but this will only remove the word from if its last in a string. Can anyone suggest what I need to add?

//doesn't work

$str = "select id, productdescription, category, price, code, manufacturer, categoryid from  products where id = 153183";

$new_str = preg_replace('/from$/', '', $str);

Are you sure you need to remove FROM clause, not WHERE only? — raina77ow
– raina77ow, Commented May 17, 2013 at 14:48
There's not need for a regular expression. Especially when matching on a simple string. — Jason McCreary
– Jason McCreary, Commented May 17, 2013 at 14:53
yes I'm sure what I want to remove from he string. I don't know what he ID will be in the string therefore how can I do it without a reg ex? — LeeTee
– LeeTee, Commented May 17, 2013 at 14:55

antoox · Accepted Answer · 2013-05-17 15:13:31Z

2

you can do this:

$new_str = stristr($str, " from ", true);

As from is a reserved word in SQL you can't find this word elsewhere without quote or backtick (so I add a space after and before).

It returns the string before the "from" word.

strstr for a case-sensitive search.

UPDATE: Regular expression (not really needed for this question) :

$str = 'select id, productdescription, category, price, code, manufacturer, categoryid from  products where id = 153183';

preg_match('/(.*)\sfrom\s.*$/i', $str, $matches); // i for the insensitive case search

$new_str = $matches[1]; // Contains what you want

edited May 17, 2013 at 15:13

answered May 17, 2013 at 14:50

antoox

1,31911 silver badges9 bronze badges

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

6 Comments

Jason McCreary Over a year ago

+ for a non-regular expression solution.

Blazemonger Over a year ago

Wouldn't stristr be a better choice?

Blazemonger Over a year ago

Now we just need to consider the possibility of, say, newline characters around FROM instead of plain spaces.

antoox Over a year ago

Use regex for more complex search operation.

Denis de Bernardy Over a year ago

@Blazemonger: or of select foo_from from bar... :-)

|

Denis de Bernardy · Accepted Answer · 2013-05-17 14:47:30Z

1

You probably want something like /from.*$/ or simply /from.*/

answered May 17, 2013 at 14:47

Denis de Bernardy

79.1k14 gold badges138 silver badges158 bronze badges

5 Comments

Bart Over a year ago

If the word from is present multiple times you will be in trouble though.

Blazemonger Over a year ago

What about a statement like "SELECT roads_from_rome FROM maps"? \bfrom\b or \sfrom\s should help with that.

Denis de Bernardy Over a year ago

@Blazemonger: Yeyeye, but OP isn't going to solve that one using a regexp. He'd need a proper query parser. :-)

Henrique Barcelos Over a year ago

.*? is the not greedy version

LeeTee Over a year ago

Not sure what you mean by greedy but the first one works thanks. 'from' will only be in there the once. BTW - Im a she not a he @Denis ;)

Anthony Sterling · Accepted Answer · 2013-05-17 14:49:57Z

1

I'm a little confused by your question, this should get you going though.

<?php
$sql = 'SELECT * FROM products WHERE id = 153183';
$sql = preg_replace('~from products where id = [0-9]+$~i', '', $sql);
echo $sql;
/*
    SELECT * 
*/

answered May 17, 2013 at 14:49

Anthony Sterling

2,44116 silver badges10 bronze badges

Comments

Josh Balcitis · Accepted Answer · 2013-05-17 14:50:24Z

0

You could use a simple str_replace. Not sure how you are getting the id since it can change, I am assuming you have a variable for it.

$str = "select id, productdescription, category, price, code, manufacturer, categoryid from  products where id = 153183";
$new_str = str_replace("from products where id = " . $id, "", $str)

answered May 17, 2013 at 14:50

Josh Balcitis

4986 silver badges19 bronze badges

1 Comment

Anthony Sterling Over a year ago

The value of id can change.

Useless Intern · Accepted Answer · 2013-05-17 14:54:34Z

0

$string = "select id, productdescription, category, price, code, manufacturer, categoryid from  products where id = 153183";
$part1 = substr("$string",0, strrpos($string,'from  products where id '));
var_dump($part1);

Since the bulk of the string is static you can use a sub string up to the offending section.

RESULTS:

string(79) "select id, productdescription, category, price, code, manufacturer, categoryid "

answered May 17, 2013 at 14:54

Useless Intern

1,3021 gold badge10 silver badges21 bronze badges

Comments

Vijaya Pandey · Accepted Answer · 2013-05-17 15:04:39Z

0

Combination of preg_replace and str_replace will also work:

<?php

$str = "select id, productdescription, category, price, code, manufacturer, categoryid from  products where id = 153183";
$id_removed =  preg_replace('/\d/', '', $str); //remove dynamic product id
$new_str = str_replace("from  products where id =",'', $id_removed);
echo $new_str;


?>

answered May 17, 2013 at 15:04

Vijaya Pandey

4,2705 gold badges35 silver badges58 bronze badges

Collectives™ on Stack Overflow

PHP - remove last part of string - preg_replace

6 Answers 6

6 Comments

5 Comments

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

6 Comments

5 Comments

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related