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 ;"); } }