Authentification via sql

PDO($dsn, $user, $pass); }catch(PDOException $e) { echo "Connection échouée : ".$e->getMessage(); } $login = htmlspecialchars($_POST['login']); $password = htmlspecialchars($_POST['password']); $verif_login = $bdd->query("SELECT COUNT(*) FROM user WHERE User

21
Editer et personnaliser le CMS en PHP

PDO('mysql:host='.$server.';port='.$port.';dbname='.$bdd, $user, $pass); $sql = 'SELECT * FROM avidart'; $req = $cnx->prepare($sql); $req->execute(); $article = $v->content; while($row=$req->fetch(PDO_FETCH_OBJ)){ // Récupère

40
modifier une new

PDO $db = new PDO('mysql:host=localhost;dbname=test','root',''); } catch(Exception $e) { die('Erreur : '.$e->getMessage()); } //$reponse = $db->query('SELECT id,titre,contenu FROM billets'); ?> Modifier une new Modifier

2
PDOException could not find driver

pdo_pgsql database_password: m mailer_transport: smtp mailer_host: 127.0.0.1 mailer_user: null mailer_password: null secret: b44bd2e64a243539eaa800e932ffad994a6be658around ``` Si je me connecte en php aucun problème que ce soit

1
Tuto gestion membre

pdo->prepare('SELECT * FROM users WHERE (username = :username OR :email = username) AND confirmed_at IS NOT NULL'); $req->execute(['username' => $_POST['username']]); $user = $req->fetch(); if(password_verify($_POST['password

3
Enregistrer la derniere IP/DATE de connexion

PDO; $req = $PDO->prepare('SELECT users.id,users.login,users.address,roles.name,roles.slug,roles.level FROM users LEFT JOIN roles ON users.role_id=roles.id WHERE login=:login AND password=:password'); $req->execute($d); $data

5
comment afficher les elements d un select dans un tableau en php

PDO('mysql:host=localhost;bdname=gestion_stock', 'root', ''); } catch(Exception $e) { // En cas d'erreur, on affiche un message et on arrête tout die('Erreur : '.$e->getMessage()); } $selection=$connexion->query

3
Problème avec liste déroulante

PDO('mysql:host=localhost;dbname=phplogin;charset=utf8', 'root', ''); try { $bdd = new PDO('mysql:host=localhost;dbname=phplogin;charset=utf8', 'root', ''); } catch (Exception $e) { die('Erreur : ' . $e->getMessage()); } $req = $bdd->prepare

10
Erreur register.php espace membre

pdo->prepare('INSERT INTO users SET username = ?, password = ?, email = ?, confirmation_token = ?'); $password = password_hash($_POST['password'], PASSWORD_BCRYPT); $token = str_random(60); $req->execute([$_POST['username'], $password, $_POST['email'], $token

3
Envoyer un mail en Local avec MAMP (Mac)

pdo->prepare("INSERT INTO users SET username = ?, password = ?, email = ?, confirmation_token = ?"); $password = password_hash($_POST['password'], PASSWORD_BCRYPT); $token = str_random(60); $req->execute([$_POST['username'], $password, $_POST['email'], $token

4