PHP preg_replace with SQL

Question

I'm trying to replace a simple command from a basic CMS with a database call.

The user enters

[gallery id=x]

into the CMS, and I want this to go away, find the images included in that gallery, and display them (ready for the jQuery Cycle plugin)

I can get:

$pattern = '/\[gallery id=(\w+)\]/i';
$rpl     = 'Display Gallery ID ${1}';
$bubble  = preg_replace($pattern, $rpl, $bubble);

...which returns "Display Gallery 12" (for example). However I need it to do this:

$sql = "SELECT * FROM galleries INNER JOIN photos ON photos.PhotoGallery=galleries.GalleryID WHERE GalleryID='x'";
$set = mysql_query($sql);
echo '<div id="gallery">';
while($row = mysql_fetch_array($set))
{
 echo '<img src="'.$row['PhotoPath'].'" />';
}
echo '</div>';

The mysql_* functions will be deprecated in PHP 5.5. It is not recommended for writing new code as it will be removed in the future. Instead, either the MySQLi or PDO and be a better PHP Developer. — Jason McCreary
– Jason McCreary, Commented Jan 2, 2013 at 21:56
Are you just asking how to match and return the value rather than replace it? See preg_match. — ficuscr
– ficuscr, Commented Jan 2, 2013 at 22:02
I can't figure out what he's asking for. How does the query at the bottom relate to the substitution at the top? Is the question about how to get the value of x to substitute into the SQL? — Barmar
– Barmar, Commented Jan 2, 2013 at 22:03
@JasonMcCreary - Changed to read "need to do this". The ID number in the [gallery id=XXX] command needs to be carried through to an SQL statement (SELECT WHERE id=XXX) — Stuart Pinfold
– Stuart Pinfold, Commented Jan 2, 2013 at 22:04

Joe Day · Accepted Answer · 2013-01-02 22:03:01Z

1

You can use the preg_replace_callback function, which takes each match your regular expression finds and replaces it with the string returned from a provided callback. So you could do something like:

function generateGallery($matches) {
    // generate the string here, $matches[1] will be your gallery id
    return "Gallery Content for Gallery " . $matches[1];
}

$pattern = '/\[gallery id=(\w+)\]/i';
$bubble = preg_replace_callback($pattern, generateGallery, $bubble);

answered Jan 2, 2013 at 22:03

Joe Day

7,3744 gold badges27 silver badges26 bronze badges

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

4 Comments

Barmar Over a year ago

What does this do that you can't do with an ordinary preg_replace()?

Joe Day Over a year ago

He wanted to execute SQL statements based in the id number in the matched tag and generate the replacement that way. The generateGallery callback gives him a convenient place to do that once the id is known.

Barmar Over a year ago

But not a convenient way to echo the results of the query into the page, unless they happen to be part of the replacement.

Joe Day Over a year ago

He was using echo in his example, but what he was echoing was the replacement string.

Barmar · Accepted Answer · 2013-01-02 22:11:43Z

0

Use:

preg_match($pattern, $string, $matches);

After this, the ID is in $matches[1].

answered Jan 2, 2013 at 22:11

Barmar

789k57 gold badges554 silver badges669 bronze badges

Collectives™ on Stack Overflow

PHP preg_replace with SQL

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related