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