regex help

ungovernable

Hello,

Here is my situation:

I have a variable ($title) which contains various names separated by a "+"

exemple: $title = "Bob + Mike + Scott"

i am trying to convert each of the names to a link to the corresponding page

so the example above would give the following result:
"<a href="Bob.html">Bob</a> + <a href="Mike.html">Mike</a> + <a href="Scott.html">Scott</a>"

could anyone help me to do this? i suck with regex...

bradmasterx

<?php

$title="Bob+Silly+Admin+Site";
$title=explode("+", $title);

?>

and then you will need to use the "foreach" function to do what you need each one to do

bradgrafelman

Try something like:

$pattern = '/(?<=^|\+ )(.*?)(?=$| \+)/';
$replace = '<a href="$1.html">$1</a>';

echo preg_replace($pattern, $replace, $title);

ungovernable

thanks a lot

ungovernable

Hey, i have one more question

What i am trying to do now is modify the script so it does the replacement only if the value is found in the database

here is the code:

<?php
$stuff = $eventinfo[title];
$pattern = '/(?<=^{|+ )(.*?)(?=$| +)/';

$query = "SELECT * FROM news2 WHERE title = '$1'";

$res = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($res)) {

$found = $row["genre"];

}

if (empty($found)) {

$replace = '$1';

} else {

$replace = '<a href="punk_band?groupe=$1&id=">$1</a>';

}

echo preg_replace($pattern, $replace, $stuff);

?>}

but $1 isn't working 🙁

any help?

bradgrafelman

That's because $1 isn't a real variable - it's a placeholder so that the PCRE engine knows where you want the replacement. In other words, it's only valid in the context of the preg_*() functions themselves.

Instead, you could do something like:

function check_db($title) {
	$query = 'SELECT 1 FROM news2 WHERE title = \'' . mysql_real_escape_string($title) . '\' LIMIT 1';
	$exec = mysql_query($query);

return mysql_num_rows($exec);
}

$pattern = '/(?<=^|\+ )(.*?)(?=$| \+)/e';
$replace = 'check_db("$1") ? \'<a href="punk_band?groupe=$1&id=">$1</a>\' : "$1"';
echo preg_replace($pattern, $replace, $stuff);

Adding the 'e' modifier to the pattern tells the PCRE engine that the replacement string should be evaluated as PHP code.