1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
|
public static function getToken()
{
$token = bin2hex(random_bytes(64));
// $token = 'teste';
$idUser = session::sessionData("idUserActif");
$ip = $_SERVER['REMOTE_ADDR'];
$bd = bdApp::getConnection();
$sql = 'SELECT * FROM '.self::tableWsToken.' WHERE idUser = :idUser';
$req = $bd->prepare($sql);
$req->execute(array(':idUser' =>$idUser));
// si un enregsitrment contien l'id d'utilisateur on update
if($req->rowCount() > 0)
{
$sql = 'UPDATE '.self::tableWsToken.' SET token = :token ,ip = :ip WHERE idUser = :idUser ';
$req = $bd->prepare($sql);
$req->execute(array(':idUser' => $idUser, ':token' =>$token,':ip' => $ip));
}
//si aucun enregsitrement contien l Id user on créer un nouvelle enregistrment
else
{
$sql = 'INSERT INTO '.self::tableWsToken.'(idUser,token,ip) VALUES (:idUser,:token,:ip)';
$req = $bd->prepare($sql);
$req->execute(array(':idUser' => $idUser, ':token' =>$token,':ip' => $ip));
}
return $token;
} |
Partager