POSIX Regex Functions
<?php
function mb_sql_regcase($string,$encoding='auto'){
$max=mb_strlen($item,$encoding);
for ($i = 0; $i < $max; $i++) {
$char=mb_substr($item,$i,1,$encoding);
$up=mb_strtoupper ($char,$encoding);
$low=mb_strtolower($char,$encoding);
$ret.=($up!=$low)?'['.$up.$low.']' : $char;
}
return $ret;
}
?>
sql_regcase
(PHP 4, PHP 5)
sql_regcase — Make regular expression for case insensitive match
Description
string sql_regcase
( string $string
)
Creates a regular expression for a case insensitive match.
Parameters
- string
-
The input string.
Return Values
Returns a valid regular expression which will match string , ignoring case. This expression is string with each alphabetic character converted to a bracket expression; this bracket expression contains that character's uppercase and lowercase form. Other characters remain unchanged.
Examples
Example #1 sql_regcase() example
<?php
echo sql_regcase("Foo - bar.");
?>
The above example will output:
[Ff][Oo][Oo] - [Bb][Aa][Rr].
This can be used to achieve case insensitive pattern matching in products which support only case sensitive regular expressions.
add a note
User Contributed Notessql_regcase
irker SOBACHKA irker DOT net
28-Sep-2008 11:14
28-Sep-2008 11:14
edge at gts dot smtn dot stavropol dot ru
25-Jun-2003 03:56
25-Jun-2003 03:56
if you set right locale:
setlocale(LC_CTYPE,"ru_RU.KOI8-R");
print sql_regcase("Цffnung");
will output:
"[Цц][Ff][Ff][Nn][Uu][Nn][Gg]"