How to search string for value using array in PHP?

Question

Hi! I want to search string having value like "CMS" in array $row, below code is searching for exact "CMS".

if (mysql_num_rows($sql_result)>0)
  { 
    while ($row = mysql_fetch_assoc($sql_result))
        { $counter++; 
           if (in_array("CMS", $row)) 
               { $cms++; }
          }
    }

I'll be grateful if any one can guide me to how to search string for value LIKE "CMS" in array $row.

It will more usefull to use SQL to count your data. – Barif Apr 04 '14 at 09:46 — Barif, Apr 04 '14 at 09:46
You'd better do the job with sql but not in php side. – xdazz Apr 04 '14 at 09:47 — xdazz, Apr 04 '14 at 09:47

Shankar Narayana Damodaran · Accepted Answer · 2014-04-04T09:53:09.277

Use strpos and serialize

if (mysql_num_rows($sql_result)>0)
  { 
    while ($row = mysql_fetch_assoc($sql_result))
        { $counter++; 
           if (strpos(serialize($row),"CMS")!==false)  //<--- Changed this `if` statement, nothing else
               { $cms++; }
          }
    }

You could serialize your array and then do a strpos to check whether the needle is inside the array or not. This is something similar like doing a LIKE as you requested.

score 0 · Answer 2 · answered Apr 04 '14 at 09:49

Loop over each of the columns in the row and use strpos

if (mysql_num_rows($sql_result)>0) 
{ 
    while ($row = mysql_fetch_assoc($sql_result))
    { 
        $counter++; 
        foreach($row as $column)
        {
            if (strpos($column, 'CMS'))
            {
                $cms++;
            }
        }
    }
}

score 0 · Answer 3 · answered Apr 04 '14 at 09:50

if (mysql_num_rows($sql_result)>0)
  { 
    while ($row = mysql_fetch_assoc($sql_result))
        { $counter++; 
           foreach ($row as $column) {
              if (strpos($column, "CMS") !== false) {
                  $cms++;
              }
           } 

        }
    }

How to search string for value using array in PHP?

3 Answers3