setbdd(); } public function setbdd() { $caught = true; try { $this->bdd = new PDO('mysql:host=' . $this->config->host() . ';dbname=' . $this->config->dbname() . ';charset=utf8', $this->config->user(), $this->config->password(), array(PDO::ATTR_ERRMODE => PDO::ERRMODE_SILENT)); //$this->bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { $caught = false; echo '

Error 500, database offline

'; if ($this->session() >= self::EDITOR) { echo '

Error : ' . $e->getMessage() . '

'; if ($this->session() == self::ADMIN) { echo '

Go to the Admin Panel to edit your database credentials

'; } else { echo '

Logout and and come back with an admin password to edit the database connexions settings.

'; } } else { echo '

Homepage for admin login (connect on the top right side)

'; } exit; } return $caught; } public function settable(Config $config) { if (!empty($config->arttable())) { $this->arttable = $config->arttable(); } else { echo '

Table Error

'; if ($this->session() >= self::EDITOR) { if ($this->session() == self::ADMIN) { echo '

Go to the Admin Panel to select or add an Article table

'; } else { echo '

Logout and and come back with an admin password to edit table settings.

'; } } else { echo '

Homepage for admin login (connect on the top right side)

'; } $caught = false; exit; } } public function bddinit(Config $config) { $test = $this->setbdd($config); if ($test) { $this->settable($config); } } public function tableexist($dbname, $tablename) { $req = $this->bdd->prepare('SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = :dbname AND table_name like :tablename'); $req->execute(array( 'dbname' => $dbname, 'tablename' => $tablename )); $donnees = $req->fetch(PDO::FETCH_ASSOC); $req->closeCursor(); $exist = intval($donnees['COUNT(*)']); return $exist; } public function tablelist($dbname) { $request = 'SHOW TABLES IN ' . $dbname; $req = $this->bdd->query($request); $donnees = $req->fetchAll(PDO::FETCH_ASSOC); $req->closeCursor(); $arttables = []; foreach ($donnees as $table) { $arttables[] = $table['Tables_in_' . $dbname]; } return $arttables; } public function tableduplicate($dbname, $arttable, $tablename) { $arttable = strip_tags($arttable); $tablename = str_clean($tablename); if ($this->tableexist($dbname, $arttable) && !$this->tableexist($dbname, $tablename)) { $duplicate = " CREATE TABLE `$tablename` LIKE `$arttable`;"; $alter = "ALTER TABLE `$tablename` ADD PRIMARY KEY (`id`);"; $insert = "INSERT `$tablename` SELECT * FROM `$arttable`;"; $req = $this->bdd->query($duplicate . $alter . $insert); return 'tableduplicated'; } else { return 'tablealreadyexist'; } } }