2 /* vim: set expandtab sw=4 ts=4 sts=4: */
4 * Specialized String Functions for phpMyAdmin
6 * Copyright 2002 Robin Johnson <robbat2@users.sourceforge.net>
7 * http://www.orbis-terrarum.net/?l=people.robbat2
9 * Defines a set of function callbacks that have a pure C version available if
10 * the "ctype" extension is available, but otherwise have PHP versions to use
13 * The SQL Parser code relies heavily on these functions.
16 * @uses PMA_PHP_INT_VERSION
18 * @uses extension_loaded()
20 * @uses function_exists()
21 * @uses mb_internal_encoding()
23 * @todo a .lib filename should not have code in main(), split or rename file
26 /* Try to load mbstring, unless we're using buggy php version */
27 if (PMA_PHP_INT_VERSION
!= 40203) {
28 if (!@extension_loaded
('mbstring')) {
34 * windows-* and tis-620 are not supported and are not multibyte,
35 * others can be ignored as they're not multibyte
37 * @global boolean $GLOBALS['using_mb_charset']
39 $GLOBALS['using_mb_charset'] =
40 substr($GLOBALS['charset'], 0, 8) != 'windows-' &&
41 substr($GLOBALS['charset'], 0, 9) != 'iso-8859-' &&
42 substr($GLOBALS['charset'], 0, 3) != 'cp-' &&
43 $GLOBALS['charset'] != 'koi8-r' &&
44 $GLOBALS['charset'] != 'tis-620';
46 $GLOBALS['PMA_allow_mbstr'] = @function_exists
('mb_strlen') && $GLOBALS['using_mb_charset'];
48 if ($GLOBALS['PMA_allow_mbstr']) {
49 // the hebrew lang file uses iso-8859-8-i, encoded RTL,
50 // but mb_internal_encoding only supports iso-8859-8
51 if ($GLOBALS['charset'] == 'iso-8859-8-i'){
52 mb_internal_encoding('iso-8859-8');
54 mb_internal_encoding($GLOBALS['charset']);
58 // This is for handling input better
59 if (defined('PMA_MULTIBYTE_ENCODING') ||
$GLOBALS['PMA_allow_mbstr']) {
60 $GLOBALS['PMA_strpos'] = 'mb_strpos';
61 require './libraries/string_mb.lib.php';
63 $GLOBALS['PMA_strpos'] = 'strpos';
64 require './libraries/string_native.lib.php';
67 if (!@extension_loaded
('ctype')) {
71 if (@extension_loaded
('ctype')) {
72 require './libraries/string_type_ctype.lib.php';
74 require './libraries/string_type_native.lib.php';
78 * This checks if a string actually exists inside another string
79 * We try to do it in a PHP3-portable way.
80 * We don't care about the position it is in.
83 * @param string string to search for
84 * @param string string to search in
85 * @return boolean whether the needle is in the haystack or not
86 * @todo rename PMA_STR_inStr()
88 function PMA_STR_strInStr($needle, $haystack)
90 // PMA_STR_pos($haystack, $needle) !== false
91 // return (is_integer(PMA_STR_pos($haystack, $needle)));
92 return (bool) PMA_STR_pos(' ' . $haystack, $needle);
93 } // end of the "PMA_STR_strInStr()" function
96 * Checks if a given character position in the string is escaped or not
102 * @param string string to check for
103 * @param integer the character to check for
104 * @param integer starting position in the string
105 * @return boolean whether the character is escaped or not
107 function PMA_STR_charIsEscaped($string, $pos, $start = 0)
109 $pos = max(intval($pos), 0);
110 $start = max(intval($start), 0);
111 $len = PMA_strlen($string);
113 // Check for string length or invalid input or special case of input
115 if ($pos <= $start ||
$len <= max($pos, $start)) {
121 while ($pos >= $start && PMA_substr($string, $pos, 1) == '\\') {
122 $escaped = !$escaped;
127 } // end of the "PMA_STR_charIsEscaped()" function
131 * Checks if a number is in a range
133 * @param integer number to check for
134 * @param integer lower bound
135 * @param integer upper bound
136 * @return boolean whether the number is in the range or not
138 function PMA_STR_numberInRangeInclusive($num, $lower, $upper)
140 return ($num >= $lower && $num <= $upper);
141 } // end of the "PMA_STR_numberInRangeInclusive()" function
145 * Checks if a character is an accented character
147 * Presently this only works for some character sets. More work may be needed
150 * @uses PMA_STR_numberInRangeInclusive()
152 * @param string character to check for
153 * @return boolean whether the character is an accented one or not
155 function PMA_STR_isAccented($c)
157 $ord_min1 = 192; //ord('A');
158 $ord_max1 = 214; //ord('Z');
159 $ord_min2 = 216; //ord('A');
160 $ord_max2 = 246; //ord('Z');
161 $ord_min3 = 248; //ord('A');
162 $ord_max3 = 255; //ord('Z');
166 return PMA_STR_numberInRangeInclusive($ord_c, $ord_min1, $ord_max1)
167 ||
PMA_STR_numberInRangeInclusive($ord_c, $ord_min2, $ord_max2)
168 ||
PMA_STR_numberInRangeInclusive($ord_c, $ord_min2, $ord_max2);
169 } // end of the "PMA_STR_isAccented()" function
173 * Checks if a character is an SQL identifier
175 * @uses PMA_STR_isAlnum()
176 * @uses PMA_STR_isAccented()
177 * @param string character to check for
178 * @param boolean whether the dot character is valid or not
179 * @return boolean whether the character is an SQL identifier or not
181 function PMA_STR_isSqlIdentifier($c, $dot_is_valid = false)
183 return (PMA_STR_isAlnum($c)
184 ||
PMA_STR_isAccented($c)
187 ||
($dot_is_valid != false && $c == '.'));
188 } // end of the "PMA_STR_isSqlIdentifier()" function
192 * Binary search of a value in a sorted array
194 * $arr MUST be sorted, due to binary search
196 * @param string string to search for
197 * @param array sorted array to search into
198 * @param integer size of sorted array to search into
200 * @return boolean whether the string has been found or not
202 function PMA_STR_binarySearchInArr($str, $arr, $arrsize)
208 while ($top >= $bottom && $found == false) {
209 $mid = intval(($top +
$bottom) / 2);
210 $res = strcmp($str, $arr[$mid]);
213 } elseif ($res < 0) {
221 } // end of the "PMA_STR_binarySearchInArr()" function