function deleteU()
{
$pdo = Pdo1::getMysqlConnexion();
$sql = " DELETE FROM permission WHERE id_user=" . $id;
$req = $pdo->prepare($sql);
$req->execute();
}
public static function getMysqlConnexion()
{
try {
require_once ROOT . 'core/config.php';
$DB_URL = 'mysql:dbname=bdd_annuaire;host=localhost';
self::$_instance = new PDO($DB_URL, DB_USERNAME, DB_PASSWORD);
self::$_instance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (Exception $e) {
die($e->getMessage());
}
return self::$_instance;
}
function allows($rang)
{
global $pdo;
$pdo = Pdo1::getMysqlConnexion();
$sql = 'SELECT slug, level FROM role';
$req = $pdo->prepare($sql);
$req->execute();
$data = $req->fetchAll();
$role = array();
foreach ($data as $d) {
$role[$d[0]] = $d[1];
}
if (!$this->users('slug')) {
header('Location: ' . $this->autrePage);
} else {
if ($role[$rang] > $this->users('level')) {
header('Location: ' . $this->autrePage);
} else {
return true;
}
}
}
/**
* Cette fonction permet de réaliser une pagination des elements concernant un tableau
* @param $page int l numéro de la page sur la quelle on se trouve
* @param $nbrElements int le nombre d'éléments à afficher par page
*/
public function paginate($page, $nbrElements)
{
$pdo = Pdo1::getMysqlConnexion();
$sql = 'SELECT COUNT(id) as nbrDemandes FROM ' . $this->table;
$req = $pdo->prepare($sql);
$req->execute();
$data = $req->fetch();
$nbrDemandes = $data['nbrDemandes'];
$perPage = $nbrElements;
$donnees['nbPage'] = ceil($nbrDemandes / $perPage);
if ($page && $page > 0 && $page <= $donnees['nbPage']) {
$cPage = $page;
} else {
$cPage = 1;
}
$donnees['cPage'] = $cPage;
$donnees['data'] = $this->find(array('limit' => ($cPage - 1) * $perPage . ', ' . $perPage, 'order' => 'date_modification DESC'));
return $donnees;
}