how do i compare the with if else statement. in mysql query i can use LIKE % statement.
i want to compare the string result with php.
ie: Pro Tan 3mins, Pro Tan 6mins, Pro Tan 9mins
in mysql :
$db->query("SELECT * FROM treat WHERE tanning LIKE 'Pro Tan%'");
in php:
if($tanning == 'Pro Tan') :
echo 'xxx';
else :
echo 'zzz';
endif
// output zzz
There are a variety of different comparison functions you can use, depending on how sophisticated you want to make your comparison. To find specifically a string that starts with "Pro Tan", you could do:
if (strpos($tanning, 'Pro Tan') === 0)
echo 'xxx';
Note the triple ===, since if strpos returns false, that's not at all the same as returning 0.
Assuming the result begins with the value, you can use strncmp.
$foo = 'Pro Tan 6mins';
if (strncmp($foo,'Pro Tan', 7) === 0)
echo 'match';
For case-insensative, you can also use strncasecmp.
You are looking for the strstr() function in PHP, which allows you to search for a string within a string.
if(strstr($tanning, 'Pro Tan')):
echo 'xxx';
else :
echo 'zzz';
endif;
if(preg_match("/^Pro Tan/",$foo)) {....}
Other answers given will also work, but regular expressions using preg_match() is more flexible and will continue to work with more complex matching.
(some will say that regex is slow, but in this case, since it's just matching a straight string anchored to the start, it's a very efficient query)
