Hide Rows That Contain A Certain String Using PHP and MySQL

Question

I have this block of PHP code which is pulling its information from a database.

All I want to do is filter/hide the rows that has "Player" like "string".

    <?php
    while ($row = mysql_fetch_assoc($result))
    {
        echo "<tr>";

        echo "<td>";
        echo $row["player"];
        echo "</td>";

        echo "<td>";
        echo $row["by"];
        echo "</td>";

        echo "</tr>";
    }
    ?>

For example I would have a table below:

BEFORE

And I want it to look like the table below:

AFTER

Sean · Accepted Answer · 2015-05-28 04:08:48Z

2

using strpos() you can check if (strpos($row["player"], 'String') === false) and only echo if true

<?php
while ($row = mysql_fetch_assoc($result))
{

  if (strpos($row["player"], 'String') === false){

    echo "<tr>";

    echo "<td>";
    echo $row["player"];
    echo "</td>";

    echo "<td>";
    echo $row["by"];
    echo "</td>";

    echo "</tr>";

  }
}
?>

Per @Fred-ii's comment-
If you have the possibility of string vs String, you could use stripos() instead of strpos()

if (stripos($row["player"], 'string') === false)

Edit
Per @Fred-ii's first comment, you could also filter them out in your query, so you don't have to 'hide' them in the php code.

SELECT ... FROM ... WHERE player NOT LIKE 'String%'

edited May 28, 2015 at 4:08

answered May 28, 2015 at 3:49

Sean

12.4k3 gold badges31 silver badges49 bronze badges

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

4 Comments

Funk Forty Niner Over a year ago

I think LIKE may be better since there are "String" with different numbers following

Sean Over a year ago

@Fred-ii- LIKE would be in the mysql query, not the php loop though, correct?

Funk Forty Niner Over a year ago

indeed, yeah ok. I see what you did using strpos but since the columns have camel case, it'd probably best to use stripos, least I think it'd be best just in case it changes later on to "string" in lowercase. Just an insight.

Funk Forty Niner Over a year ago

That way the OP won't need to worry, should "string" or "STRING" etc. happen to be entered somewhere and if it's coming from user-input or not. Again, just an insight. It won't hurt anything to use it ;-)

Collectives™ on Stack Overflow

Hide Rows That Contain A Certain String Using PHP and MySQL

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related