public function open_PDO() { require str_replace('\\', '/', __DIR__) . '/../../../application/resonance2/SQL/connect.php'; self::$pdo = new \PDO('mysql:host=' . $connectIP . ';dbname=' . $selectDB, $connectLog, $connectPass, array(\PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); \application\resonance2\debug\console::Trace("///PDO connection opened successfully!"); return self::$pdo; }
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 XML_getAttrValWhereAttr($url, $node, $getAttr, $withVal, $findAttr) { $this->XML_readXML($url); $this->XML_parse($node); foreach ($this->parsed as $nodule) { if ($nodule->getAttribute($getAttr) == $withVal) { self::$XML_attr = $nodule->getAttribute($findAttr); echo self::$XML_attr; break; } else { //Aucun Node \application\resonance2\debug\console::Trace("Attribut not found in XML"); } } }
public function url_checker($url) { \application\resonance2\debug\console::FunctionTrace(__FUNCTION__); $headers = get_headers($url); if ($headers[0] == 'HTTP/1.1 404 Not Found' or $headers[0] == 'HTTP/1.1 302 Found') { //404 introubable | 302 trouvable après redirection \application\resonance2\debug\console::Trace("CLASS: " . __CLASS__ . " Function: " . __FUNCTION__ . " url <u>not</u> find."); return "false"; //URL DOESN'T EXIST } else { \application\resonance2\debug\console::Trace("CLASS: " . __CLASS__ . " Function: " . __FUNCTION__ . " url find."); return "true"; //URL EXIST } }
public function close_PDO() { open_PDO::$pdo = null; \application\resonance2\debug\console::Trace("///PDO connection closed..."); return open_PDO::$pdo; }
public function SQLPDO_close_connection() { \application\resonance2\debug\console::FunctionTrace(__FUNCTION__); self::$pdo = null; \application\resonance2\debug\console::Trace("///PDO connection closed..."); }
private function disconnect() { \application\resonance2\debug\console::FunctionTrace(__FUNCTION__); \application\resonance2\debug\console::Trace("Access denied"); \application\resonance2\application::disconnect(); }