function loggin() { $_SESSION['username'] = getPost("pseudo"); $pass = getPost("password"); $datas = Bdd::sql_fetch_array_assoc("SELECT *\n FROM LOL_user\n WHERE pseudo=?", array($this->get_pseudo())); if ($data[0] == 0) { return false; } $_SESSION['id_user'] = $datas[1]['id']; $_SESSION['nom'] = $datas[1]['nom']; $_SESSION['prenom'] = $datas[1]['prenom']; $_SESSION['pseudo'] = $datas[1]['pseudo']; $_SESSION['mail'] = $datas[1]['mail']; $_SESSION['pass'] = $datas[1]['password']; return true; }
public static function getAll() { $table_user = User::$table_user; $membres = Bdd::sql_fetch_array_assoc("\n\t\tSELECT " . $table_user . ".pseudo, " . $table_user . ".id as IDD, count(MBL_fiche_lecture.id_user) as NBR_LECTURE,\n( SELECT count(MBL_biblio.id_user) FROM " . $table_user . " JOIN MBL_biblio ON " . $table_user . ".id=MBL_biblio.id_user WHERE " . $table_user . ".id =IDD) as NBR_LIVRE\nFROM `" . $table_user . "` \nLEFT OUTER JOIN MBL_fiche_lecture ON " . $table_user . ".id=MBL_fiche_lecture.id_user\nGROUP BY " . $table_user . ".id, MBL_fiche_lecture.id_user"); return $membres; }
public function loggin() { $_SESSION['username'] = getPost("pseudo"); $pass = getPost("password"); $datas = Bdd::sql_fetch_array_assoc("SELECT *\n\t\t\t\t\t\t\t\t\t\t\t\t\tFROM MBL_user \n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE pseudo=?", array($this->get_pseudo())); $_SESSION['id_user'] = $datas[1]['id']; $_SESSION['nom'] = $datas[1]['nom']; $_SESSION['prenom'] = $datas[1]['prenom']; $_SESSION['pseudo'] = $datas[1]['pseudo']; $_SESSION['mail'] = $datas[1]['mail']; $_SESSION['pass'] = $datas[1]['password']; }