/**
* Création des tables avec la lecture du fichier SQL
* @param void $sqlfile
*/
public function create_new_sqltable($sqlfile)
{
if (self::load_sql_file($sqlfile) != false) {
foreach (self::load_sql_file($sqlfile) as $query) {
$query = magixcjquery_filter_var::trimText($query);
self::layerDB()->createTable($query);
}
return true;
}
}
/**
* function isEmpty
*
* @param string $val
* @return false
*/
public static function isEmpty($val)
{
$val = magixcjquery_filter_var::trimText($val);
return empty($val) && $val !== 0;
}
/**
* Join function for get Intéger
*
*
* @see magixcjquery_filter_var::trimText
* @see magixcjquery_filter_isVar::isPostNumeric
* @see magixcjquery_filter_isVar::sizeLargestString
*
* @param string $str
* @param intéger $lg_max
*/
public static function getCleanInteger($str, $lg_max)
{
$string = magixcjquery_filter_isVar::isPostNumeric(magixcjquery_filter_var::trimText($str));
$string .= magixcjquery_filter_isVar::sizeLargestString($str, $lg_max);
return $string;
}
/**
* Combine function trimText and isPostNumeric for input
* @param string $str
*
*/
public static function inputNumeric($str)
{
return magixcjquery_filter_var::trimText(magixcjquery_filter_isVar::isPostNumeric($str));
}
public static function make2tagString($str)
{
/**Clean accent*/
$Caracs = array("¥" => "Y", "µ" => "u", "À" => "A", "Á" => "A", "Â" => "A", "Ã" => "A", "Ä" => "A", "Å" => "A", "Æ" => "A", "Ç" => "C", "È" => "E", "É" => "E", "Ê" => "E", "Ë" => "E", "Ì" => "I", "Í" => "I", "Î" => "I", "Ï" => "I", "Ð" => "D", "Ñ" => "N", "Ò" => "O", "Ó" => "O", "Ô" => "O", "Õ" => "O", "Ö" => "O", "Ø" => "O", "Ù" => "U", "Ú" => "U", "Û" => "U", "Ü" => "U", "Ý" => "Y", "ß" => "s", "à" => "a", "á" => "a", "â" => "a", "ã" => "a", "ä" => "a", "å" => "a", "æ" => "a", "ç" => "c", "è" => "e", "é" => "e", "ê" => "e", "ë" => "e", "ì" => "i", "í" => "i", "î" => "i", "ï" => "i", "ð" => "o", "ñ" => "n", "ò" => "o", "ó" => "o", "ô" => "o", "õ" => "o", "ö" => "o", "ø" => "o", "ù" => "u", "ú" => "u", "û" => "u", "ü" => "u", "ý" => "y", "ÿ" => "y");
$str = strtr("{$str}", $Caracs);
$str = magixcjquery_filter_var::trimText($str);
/* stripcslashes backslash */
$str = magixcjquery_filter_var::cleanQuote($str);
/*replace blank and special caractère*/
$cSpec = array("@'@i", '[\\?]', '[\\#]', '[\\@]', '[\\,]', '[\\!]', '[\\:]', '[\\(]', '[\\)]');
$rSpec = array(" ", " ", " ", " ", " ", " ", " ", " ", " ");
/*Removes the indent if end of string*/
$str = rtrim(preg_replace($cSpec, $rSpec, $str), "");
/*Convert UTF8 encode*/
$str = magixcjquery_string_convert::decode_utf8($str);
/*Convert lower case*/
$str = magixcjquery_string_convert::downTextCase($str);
return $str;
}
