public function session_checker($session_var)
{
if (!isset($_SESSION[$session_var])) {
//Access denied, user is redirected at the home page
\application\resonance2\debug\console::Trace("Access denied");
\application\resonance2\security\application::disconnect();
} else {
//Access granted
\application\resonance2\debug\console::Trace("Access granted");
}
}
public function count_row($table)
{
try {
\application\resonance2\security\application::open_PDO();
$rqst = "SELECT count(*) FROM `{$table}`";
$result = open_PDO::$pdo->prepare($rqst);
$result->execute();
$this->counter = $result->fetchColumn();
\application\resonance2\security\application::close_PDO();
return (double) $this->counter;
} catch (\Exception $e) {
\application\resonance2\debug\console::Trace("=> PDO connection problem");
}
}
public function sec_RQST($data)
{
\application\resonance2\debug\console::FunctionTrace(__FUNCTION__);
\application\resonance2\security\application::MD5($data);
}
public function SQLPDO_createTable($table)
{
\application\resonance2\debug\console::FunctionTrace(__FUNCTION__);
/* Define how many tables have to be create */
$num_table = count($table);
\application\resonance2\debug\console::Trace("Create gallery - Number gallery found: " . $num_table);
/* Launch only if it has a table inside the array */
if ($num_table > 0) {
var_dump($table);
for ($i = 0; $i < $num_table; $i++) {
//$num_table int| catch how many params each array get inside
//$num_table_setting = count( $table[$i] )
for ($j = 0; $j < $num_table; $j++) {
$name = $table[$i]["name"];
$params = null;
//Get the number of params
$num_table_params = count($table[$i]["params"]);
$a = null;
foreach ($table[$i]["params"] as $key => $value) {
$a++;
$params .= "`{$key}` {$value}";
if ($num_table_params > $a) {
$params .= ", ";
}
}
$primary = $table[$i]["primary"];
$setup = $table[$i]["setup"];
//Prepare the request
try {
\application\resonance2\security\application::SQLPDO_open_connection();
$rqt = \application\resonance2\security\application::SQLPDO_getPDO_object()->prepare("CREATE TABLE IF NOT EXISTS `{$name}` ( {$params}, {$primary} ) {$setup}");
$rqt->execute();
} catch (\PDOException $e) {
\application\resonance2\debug\console::Trace($e);
}
}
}
// $rqt = "CREATE TABLE IF NOT EXISTS `$galerie_name` (`ID` int(11) NOT NULL AUTO_INCREMENT, `ORDRE` int(11) NOT NULL,`LANGUE` varchar(2) COLLATE utf8_bin NOT NULL, `IMAGE` varchar(300) COLLATE utf8_bin NOT NULL, `ALT` varchar(100) COLLATE utf8_bin NOT NULL, `TITRE_FR` varchar(200) COLLATE utf8_bin NOT NULL, `DESCRIPTION_FR` text COLLATE utf8_bin NOT NULL, `TITRE_EN` varchar(200) COLLATE utf8_bin NOT NULL, `DESCRIPTION_EN` text COLLATE utf8_bin NOT NULL,`TITRE_ZH` varchar(200) COLLATE utf8_bin NOT NULL,`DESCRIPTION_ZH` text COLLATE utf8_bin NOT NULL,PRIMARY KEY (`ID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=31 ;");
}
}
