Regex str_replace

php mysql regex url str-replace
Mikkel Winther picture Mikkel Winther · Nov 23, 2012 · Viewed 45.3k times · Source

Would it be possible to incorporate a str_replace method with a regular expression, designed to catch url strings in a simple html < textfield > input type?

I'm considering something simple like a tip for the user to set it up as follows:

This is some text and click this link here.

Obviously the word "here" is a href to the url before it (or after it, if that makes a difference). The text input is drawn from a MySQL db.

I believe the start of my solution is something along the lines of:

$regex = '';
$pg = $row['pg'];
$pg = str_replace('{regex goes here}', $pg);

But I know things are missing. And then I would just output the $pg paragraph.

Answer

Wesley van Opdorp picture Wesley van Opdorp · Nov 23, 2012

Check out preg_replace here, this is what you are lookin for.

// From the documentation.
preg_replace($regularExpression, $replacement, $subject);

Related questions

Is there a MySQL equivalent of PHP's preg_replace?

I have a to match a field in MySQL, for which I thought I could use a regular expression, but it appears that MySQL doesn't have the functionality I need to do the job. Here's the scenario: I have a …

Read More
Remove trailing newline

I've a MySQL database from which I extract a string which is a list of words separated by newline. Now I want to remove only the trailing newline. I tried using preg_replace as $string = preg_replace('/\n/',…

Read More
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More