Advertisement
Guest User

Untitled

a guest
Jun 11th, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.31 KB | None | 0 0
  1. function compte_existe($id)
  2. {
  3.     $base = new bdd();
  4.     $base->changer_db('realmd');
  5.    
  6.     $q = 'SELECT COUNT(id) AS nb FROM comptes_boutique WHERE id = '.$id;
  7.     echo $q;
  8.     $requete = $base->faire_requete($q);
  9.    
  10.     $obj = $base->recuperer_objet($requete);
  11.     if ($obj->nb>0)
  12.         return true;
  13.     return false;
  14. }
  15.  
  16.  
  17.  
  18.  
  19. class bdd{
  20.     var $dbConnection;
  21.    
  22.     var $host='localhost';
  23.     var $user='root';
  24.     var $password='';
  25.     var $dbname='realmd';
  26.        
  27.     function __construct(){
  28.       $this->dbConnection=mysql_connect($this->host, $this->user, $this->password);
  29.       mysql_select_db($this->dbname);
  30.       mysql_query("SET NAMES 'utf8'");
  31.     }
  32.    
  33.     function __destruct(){
  34.         @mysql_close($this->dbConnection);
  35.     }
  36.    
  37.     function faire_requete($query_string){
  38.         $query_results = mysql_query($query_string, $this->dbConnection) or die(mysql_error());
  39.         return $query_results;
  40.     }
  41.    
  42.     function changer_db($nouvelle_db) {
  43.         mysql_select_db($nouvelle_db);
  44.     }
  45.    
  46.     function compter_objets_requete($query_results){
  47.         return mysql_num_rows($query_results);
  48.     }
  49.    
  50.     function recuperer_objet($query_results){
  51.         $result_line=mysql_fetch_object($query_results);
  52.         return $result_line;
  53.     }
  54. }
  55.  
  56. if (!empty($_SESSION['id']))
  57. {
  58.     if (!compte_existe($_SESSION['id']))
  59.         initialiser_compte($_SESSION['id']);
  60. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement