'."\n";
$bool_indent = false;
} // if ($bool_indent)
if (!is_array($array_passed))
{
echo $array_str.' = '.$array_passed;
return;
} // if (!is_array($array_passed))
foreach($array_passed as $array_key => $array_value)
{
array_print($array_value, $array_key, false);
} // foreach($array_passed as $array_key => $array_value)
} // function array_print($array_passed)
function echo_query ($rsc_query, $bool_head=false)
{
$count_row = 1;
while ($row_query = mysqli_fetch_assoc($rsc_query))
{
if ($bool_head)
{
$bool_head = false;
// echo '
'."\n";
echo ''."\n";
$arr_row_keys = array_keys($row_query);
echo '| row | '."\n";
foreach ($arr_row_keys as $value_key)
{
echo ''.(($value_key != '') ? $value_key : ' ').' | '."\n";
} // foreach (array_keys($row_query) as $value_key)
echo '
'."\n";
// echo ''."\n";
// echo '
'."\n";
} // if ($int_row++ == 0)
echo ''."\n";
echo '| '.$count_row++.' | '."\n";
foreach ($row_query as $key_query => $value_query)
{
echo ''.$value_query.' | '."\n";
} // foreach ($row_query as $key_query => $value_query)
echo '
'."\n";
} // while ($row_describe = mysqli_fetch_assoc($rsc_describe))
// echo ''."\n";
} // function echo_query ($rsc_query, $bool_head = false)
function escapeMySQL($boolDebugEscapeMySQL, $name_userInput, $userInput)
{
// undo magic_quotes_gpc if magic_quotes_gpc directive is enabled
if (get_magic_quotes_gpc())
{
$userInput = stripcslashes($userInput);
} // if (get_magic_quotes_gpc())
// process fields for MySQL storage
$userInput = str_replace("<", "<", $userInput);
$userInput = str_replace(">", ">", $userInput);
$userInput = str_replace("\"", """, $userInput);
$userInput = str_replace("'", "'", $userInput);
// replace UTF-8 characters.
$userInput = str_replace
(
array
(
'\xe2\x80\x98', // left single smart quote
'\xe2\x80\x99', // right single smart quote
'\xe2\x80\x9c', // left double smart quote
'\xe2\x80\x9d', // right double smart quote
'\xe2\x80\x93', // n-dash
'\xe2\x80\x94', // m-dash
'\xe2\x80\xa6' // ellipses
),
array
(
'‘', // left single smart quote
'’', // right single smart quote
'“', // left double smart quote
'”', // right double smart quote
'–', // n-dash
'—', // m-dash
'…' // ellipses
),
$userInput
);
// replace their Windows-1252 equivalents.
$userInput = str_replace
(
array
(
chr(145), // left single smart quote
chr(146), // right single smart quote
chr(147), // left double smart quote
chr(148), // right double smart quote
chr(150), // n-dash
chr(151), // m-dash
chr(133) // ellipses
),
array
(
'‘', // left single smart quote
'’', // right single smart quote
'“', // left double smart quote
'”', // right double smart quote
'–', // n-dash
'—', // m-dash
'…' // ellipses
),
$userInput
);
$userInput = mysql_real_escape_string($userInput);
$userInput = str_replace("\\r\\n\\r\\n", "
\n
\n", $userInput);
$userInput = str_replace("\\r\\n", "
\n", $userInput);
if ($boolDebugEscapeMySQL)
{
echo "
".$userInput."
\n";
} // if ($boolDebugescapeMySQL)
return $userInput;
} // function escapeMySQL($boolDebugEscapeMySQL, $name_userInput, $userInput)
function FileLine()
{
echo backtrace(debug_backtrace());
} // function FileLine()
/*
function count_instance($str_path, $str_haystack, $str_needle, $bool_debug=FALSE)
{
$stream_file = fopen($str_path, 'r');
if (!$stream_file) {
throw new Exception('Could not open the file!');
}
while (($str_line = fgets($stream_file)) !== false)
{
if (strpos($str_line, $str_haystack) !== false)
{
$int_instance = substr_count(substr($str_line, 0, strpos($str_line, $str_needle)), $str_needle);
fclose($stream_file);
return $int_instance;
}
}
fclose($stream_file);
return $str_haystack;
}
*/
function intab($str_echo, $str_indent=null, $str_linebreak=null)
{
global $int_tabIndent;
$array_EOL = array('n' => "\n", 'b' => "
\n", ' ' => '');
if (($str_linebreak === null) && ($str_indent === null))
{
echo $str_echo;
return;
} // if ($str_indent === null)
else
{
$str_linebreak = 'n';
if (is_numeric($str_indent))
{
echo str_repeat(' ', $str_indent).$str_echo.$array_EOL[$str_linebreak];
return;
} // if (is_numeric($str_indent))
elseif (strpos($str_indent, ' ') !== false)
{
if ($str_indent[0] != ' ')
{
$int_tabIndent = $int_tabIndent + $str_indent[0]*strpos($str_indent, ' ');
} // elseif ($str_indent[0] == '-'))
else
{
$int_tabIndent = $int_tabIndent;
} // elseif ($str_indent[0] == '-')) else
} // elseif (strpos($str_indent, ' ') !== false)
echo str_repeat(' ', $int_tabIndent).$str_echo.$array_EOL[$str_linebreak];
} // if (($str_linebreak === null) && ($str_indent === null)) else
return;
} // intab($str_indent, $str_echo, $str_linebreak)
function validEmail($email)
{
// Validate an email address.
// Provide email address (raw input)
// Returns true if the email address has the email
// address format and the domain exists.
// from: http://www.linuxjournal.com/article/9585?page=0,3
$isValid = true;
$atIndex = strrpos($email, "@");
if (is_bool($atIndex) && !$atIndex)
{
$isValid = false;
} // if (is_bool($atIndex) && !$atIndex)
else
{
$domain = substr($email, $atIndex+1);
$local = substr($email, 0, $atIndex);
$localLen = strlen($local);
$domainLen = strlen($domain);
if ($localLen < 1 || $localLen > 64)
{
// local part length exceeded
$isValid = false;
} // if ($localLen < 1 || $localLen > 64)
else if ($domainLen < 1 || $domainLen > 255)
{
// domain part length exceeded
$isValid = false;
} // else if ($domainLen < 1 || $domainLen > 255)
else if ($local[0] == '.' || $local[$localLen-1] == '.')
{
// local part starts or ends with '.'
$isValid = false;
} // else if ($local[0] == '.' || $local[$localLen-1] == '.')
else if (preg_match('/\\.\\./', $local))
{
// local part has two consecutive dots
$isValid = false;
} // else if (preg_match('/\\.\\./', $local))
else if (!preg_match('/^[A-Za-z0-9\\-\\.]+$/', $domain))
{
// character not valid in domain part
$isValid = false;
} // else if (!preg_match('/^[A-Za-z0-9\\-\\.]+$/', $domain))
else if (preg_match('/\\.\\./', $domain))
{
// domain part has two consecutive dots
$isValid = false;
} // else if (preg_match('/\\.\\./', $domain))
else if (!preg_match('/^(\\\\.|[A-Za-z0-9!#%&`_=\\/$\'*+?^{}|~.-])+$/',str_replace("\\\\","",$local)))
{
// character not valid in local part unless
// local part is quoted
if (!preg_match('/^"(\\\\"|[^"])+"$/', str_replace("\\\\","",$local)))
{
$isValid = false;
} // if (!preg_match('/^"(\\\\"|[^"])+"$/', str_replace("\\\\","",$local)))
} // else if (!preg_match('/^(\\\\.|[A-Za-z0-9!#%&`_=\\/$\'*+?^{}|~.-])+$/',str_replace("\\\\","",$local)))
if ($isValid && !(checkdnsrr($domain,"MX") || checkdnsrr($domain,"A")))
{
// domain not found in DNS
$isValid = false;
} // if ($isValid && !(checkdnsrr($domain,"MX") || checkdnsrr($domain,"A")))
} // if (is_bool($atIndex) && !$atIndex) else
return $isValid;
} // function validEmail($email)
function varSizeOf($str_var)
{
$start_memory = memory_get_usage();
$tmp = unserialize(serialize($str_var));
return (memory_get_usage() - $start_memory);
} // function varSizeOf($str_var)
function varName(&$ref_var, &$array_varsDefined)
{
foreach ($array_varsDefined as $key_varsDefined=>$value_varsDefined)
{
$array_varsDefined_0[$key_varsDefined] = $value_varsDefined;
} // foreach ($array_varsDefined as $key_varsDefined=>$value_varsDefined)
$ref_varSave = $ref_var;
$ref_var = !$ref_var;
$array_keysDiff = _array_keys(_array_diff_assoc($array_varsDefined_0, $array_varsDefined));
$ref_var = $ref_varSave;
return $array_keysDiff[intab0];
}
/*
function search_Site($txt_searchSite, $txt_searchAction, $txt_searchTerms)
{
echo '
');
} // function search_Site($terms)
*/
function successQuery($str_query, $query_query, $bool_debug=false)
{
$rsc_query = mysqli_query($GLOBALS['icnt_db'], $query_query);
if ($bool_debug)
{
echo '
'."\n";
if ($str_query != '')
{
echo backtrace(debug_backtrace()).' result of:'."\n";
echo '
'."\n";
echo $str_query.' = "'.$query_query.'"'."\n";
echo '
'."\n";
if (mysqli_error($GLOBALS['icnt_db']))
{
echo 'is: '.str_repeat(' ', 1).mysqli_errno($GLOBALS['icnt_db']).' - '.mysqli_error($GLOBALS['icnt_db'])."\n";
} // if ((mysql_error())
else
{
echo 'is error free';
if (is_bool($rsc_query) === true)
{
echo ', but $rsc_query = '.($rsc_query ? "true" : "false");
} // if (is_bool($rsc_query) === true)
else
{
echo ', and mysqli_num_rows() = '.mysqli_num_rows($rsc_query)."
\n";
echo '
'."\n";
echo '
'."\n";
echo_query($rsc_query, true);
echo '
'."\n";
echo '
'."\n";
} // if (is_bool($rsc_query) === true) else
} // if ((mysql_error()) else
} // if ($query_query != '')
else
{
echo '
'."\n";
echo 'QUERY IS BLANK! $str_query = "'.$query_query.'"'."\n";
echo '
'."\n";
} // if ($str_query != '') else
echo '
'."\n";
$rsc_query = mysqli_query($GLOBALS['icnt_db'], $query_query);
} // if ($bool_debug)
return $rsc_query;
} // function successQuery($bool_debug, $str_query, $rsc_query)
?>