PHP Code:
class Member {
// Function login ( register.php )
public function login($username, $password){
$pdo = PDO2::getInstance();
$requete = $pdo->prepare('SELECT id, username, email, tribe, access, gold, gender, birthday, location, desc1, desc2, plus, b1, b2, b3, b4, sit1, sit2,
alliance, act, timestamp, ap, apall, dp, dpall, protect, quest, gpack, cp, lastupdate, RR, Rc, ok, clp, oldrank
FROM '.TB_PREFIX.'users
WHERE username = :user and password = :password and access != '.BANNED);
$requete->bindValue(':user', $username, PDO::PARAM_STR);
$requete->bindValue(':password', md5($password), PDO::PARAM_STR);
$requete->execute();
if($requete->rowCount() == 1){
/*
// Create $_SESSION
// id, username, email, tribe, access, gold, gender, birthday, location, desc1, desc2, plus, b1, b2, b3, b4, sit1, sit2, alliance, act,
// timestamp, ap, apall, dp, dpall, protect, quest, gpack, cp, lastupdate, RR, Rc, ok, clp, oldrank
// The session will serve as a cache server and a faith is connected does not touch a ca disappear unless the session
// (session time exceeded or browser closed)
*/
$result = $requete->fetch(PDO::FETCH_OBJ); // Return result in objet
$_SESSION['id'] = $result->id;
$_SESSION['email'] = $result->email;
return true;
}
else{
return false;
}
}
public function update_email_adress($email){
$pdo = PDO2::getInstance();
$requete = $pdo->prepare('UPDATE '.TB_PREFIX.'users SET email = :email WHERE id = :id_user');
$requete->bindValue(':id_user', $_SESSION['uid']);
$requete->bindValue(':email', $email);
$_SESSION['email'] = $email; // Update session cache
return $requete->execute();
}
}
$member = new Member;
and finally to pass the parameter we have a simple
