preg_replace specific sql columns in php

Question

So I have code that goes something like this:

$sql = "SELECT * FROM LIST"
$result = $conn->query($sql);

if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {

echo "<div class=\"leftcol\"><p>".preg_replace('/\b0\b/', 'NA', $row["info"])."</p></div>
      <div class=\"rightcol\"<p>".preg_replace('/\b0\b/', 'NA', $row["stuff"])."</p></div>";

That works for them rows fine. But then I run into the problem where I need to use multiple replaces on $row["info"] AND $row["stuff"]. I would like to replace \b1\b with another word but at the same time as \b0\b.

What works best for this? Would there be something that does this better outside of the P tag or SQL info all together?

Why are you assigning a variable in the middle of the echo? What do you use $text for? — Barmar
– Barmar, Commented May 25, 2015 at 23:26
Oh I guess that just doesn't need to be there. I just put that in there from when I Iearned about preg_replace, I'll edit that out of my question. Thanks — Kyle Dunne
– Kyle Dunne, Commented May 25, 2015 at 23:29

Andrew · Accepted Answer · 2016-10-26 17:15:38Z

2

Just do the replaces before you echo the html, eg:

while($row = $result->fetch_assoc()) {

    $text = preg_replace('/\b0\b/', 'NA', $row["info"]);
    $text = preg_replace('/\b1\b/', 'NA2', $text);
    $text = preg_replace('/\b2\b/', 'NA3', $text);

    $text2 = preg_replace('/\b1\b/', 'NA2', $row["stuff"]);

    echo "<div class=\"leftcol\"><p>".$text."</p></div>
          <div class=\"rightcol\"<p>".$text2."</p></div>";

edited Oct 26, 2016 at 17:15

answered May 25, 2015 at 23:27

Andrew

20.4k13 gold badges110 silver badges122 bronze badges

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

1 Comment

Kyle Dunne Over a year ago

This works just fine for what I'm doing. I use money_format for the numbers and I use preg_replace to change the numbers to font. I could just use an if statement to make this work right?

Barmar · Accepted Answer · 2015-05-25 23:29:24Z

0

You can do multiple replacements by giving an array of patterns and replacements:

$info = preg_replace(array('/\b0\b', '\b1\b'), array('NA', 'NA2'), $row['info']);

So your code would look like:

echo "<div class=\"leftcol\"><p>".preg_replace(array('/\b0\b', '\b1\b'), array('NA', 'NA2'), $row["info"])."</p></div>
      <div class=\"rightcol\"<p>".preg_replace(array('/\b0\b', '\b1\b'), array('NA', 'NA2'), $row["stuff"])."</p></div>";

answered May 25, 2015 at 23:29

Barmar

789k57 gold badges554 silver badges669 bronze badges

Collectives™ on Stack Overflow

preg_replace specific sql columns in php

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related