function deleteU() { $pdo = Pdo1::getMysqlConnexion(); $sql = " DELETE FROM permission WHERE id_user=" . $id; $req = $pdo->prepare($sql); $req->execute(); }
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; }