PHP Like thing similar to MySQL Like, for if statement?

Question

I want an if statement that uses same thingy like mysql something LIKE '%something%'

I want to build an if statement in php.

if ($something is like %$somethingother%)

Is it possible?

The reason for me asking this question is that I don't want to change the MySQL command, it's a long page with many stuff on it, I don't want to build a different function for this.

Let me know if this is possible, if possible then how to do it .

Answer 1

if ($something is like %$somethingother%)

Is it possible?

no.

I don't want to change the MySQL command, it's a long page with many stuff on it

Use some good editor, that supports regular expressions in find & replace, and turn it to something like:

if(stripos($something, $somethingother) !== FALSE){

}

Answer 2

I know, this question isn't actual but I've solved similar problem :)

My solution:

/**
 * SQL Like operator in PHP.
 * Returns TRUE if match else FALSE.
 * @param string $pattern
 * @param string $subject
 * @return bool
 */
function like_match($pattern, $subject)
{
    $pattern = str_replace('%', '.*', preg_quote($pattern, '/'));
    return (bool) preg_match("/^{$pattern}$/i", $subject);
}

Examples:

like_match('%uc%','Lucy'); //TRUE
like_match('%cy', 'Lucy'); //TRUE
like_match('lu%', 'Lucy'); //TRUE
like_match('%lu', 'Lucy'); //FALSE
like_match('cy%', 'Lucy'); //FALSE

Answer 3

look on strstr function

Answer 4

Use this function which works same like SQL LIKE operator but it will return boolean value and you can make your own condition with one more if statement

function like($str, $searchTerm) {
    $searchTerm = strtolower($searchTerm);
    $str = strtolower($str);
    $pos = strpos($str, $searchTerm);
    if ($pos === false)
        return false;
    else
        return true;
}
$found = like('Apple', 'app'); //returns true
$notFound = like('Apple', 'lep'); //returns false

if($found){
    // This will execute only when the text is like the desired string
}

Answer 5

Use function, that search string in another string like: strstr, strpos, substr_count.

Answer 6

strpos() is not working for so i have to use this preg_match()

$a = 'How are you?';

if (preg_match('/\bare\b/', $a)) {
    echo 'true';
}

like in this e.g i am matching with word "are" hope for someone it will be helpful