php string replace function

Question

I need to write a function that takes in a long string that is a sql command and searches for an equal sign goes back to the word before it and adds "post." before it.

Example:

input:

$sqlFilter = "WHERE sport = 'Hockey' AND team = 'New York Rangers';

Output:

$sqlFilter = "WHERE post.sport = 'Hockey' AND post.team = 'New York Rangers';

just looking for some sudo code on where to start.. I can scan the whole string with for loops find the equal character and then go back and replace using the spaces as markers but there might and probably is a better way — Ryan Claxton
– Ryan Claxton, Commented Jul 6, 2016 at 23:08
A regex pattern may work... probably not going to be battle proof though. regex101.com/r/rK1qP5/1 — scrowler
– scrowler, Commented Jul 6, 2016 at 23:15

zajonc · Accepted Answer · 2016-07-07 08:38:25Z

2

You don't need to write any function because you have a preg_replace.

You need to add this code

$newSqlFilter = preg_replace('/([^(\s]*?)[ ]{0,}=/', 'post.\0', $sqlFilter);

And the other thing - close your query string with " character.

edited Jul 7, 2016 at 8:38

answered Jul 6, 2016 at 23:16

zajonc

1,9695 gold badges21 silver badges25 bronze badges

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

2 Comments

Ryan Claxton Over a year ago

^ see this is why I asked.. my php knowledge is basically limited to C knowledge. Thank you.

Ryan Claxton Over a year ago

.. I am not so great with regex and actually have a bracket at the start and end of the filter variable so getting an error like "WHERE post.(sport = 'Hockey' AND post.team = 'New York Rangers') work around to get it on the inside of the bracket?

Atul Jindal · Accepted Answer · 2016-07-06 23:17:08Z

2

You can use regular expression search pattern, using function preg_replace_callback(), that accepts callback method name to make replacement. You use expression to find desired pattern and use callback method to make replacement.

Read more about here http://php.net/manual/en/function.preg-replace-callback.php

answered Jul 6, 2016 at 23:17

Atul Jindal

9769 silver badges8 bronze badges

Collectives™ on Stack Overflow

php string replace function

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related