PHP Bdd::sql_fetch_array_assoc示例

示例#1

文件： auth.php 项目： skapin/lol-team-manager

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;
}

示例#2

文件： User.php 项目： skapin/lol-team-manager

 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;
 }

示例#3

文件： Page.php 项目： skapin/lol-team-manager

 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'];
 }