Forum
pdo = new PDO("sqlsrv:Server=" . $host . ";Database=" . $db, null, null); ``` Ca ne marche pas (je m'en doutais) et cela me retourne ce message: ```SQLSTATE[HY000]: [Microsoft][ODBC Driver 17 for SQL Server
pdo->prepare('SELECT * FROM utilisateurs WHERE id = ? AND reset_clef IS NOT NULL AND reset_clef = ? AND reset_clef_le > DATE_SUB(NOW(), INTERVAL 30 MINUTE)'); $req->execute([$_GET['id'], $_GET['reset
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
pdo->prepare('SELECT id FROM Membres WHERE email = ?'); $req->execute([$_POST['email']]); $user = $req->fetch(); if($user){ $errors['email'] = ' Cet email est déja utilisé '; } } if(empty($_POST['tel'])){ $errors['tel'] = " Votre
PDO; $req = $PDO->prepare('SELECT users.id,users.prenom,users.address,users.nom,roles.name,roles.slug,roles.level, users.active,users.dateFin FROM users LEFT JOIN roles ON users.role_id=roles.id WHERE address=:address AND password=md5(:password
PDO->prepare('SELECT * FROM filiale'); $select->execute(); while($users = $select->fetch(PDO::FETCH_OBJ)){ ?> Service :
PDO( $dns, $utilisateur, $motDePasse ); $bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $req = $bdd->prepare('SELECT * FROM profil WHERE identifiant= :identifiant AND password = SHA(:password)'); $req->execute(array( 'identifiant' => $_POST
PDO::PARAM_STR); $query->bindValue(':name', $name, PDO::PARAM_STR); $query->bindValue(':url', $url, PDO::PARAM_STR); $query->bindValue(':ordre', $ordre, PDO::PARAM_STR); $query->execute(); $query->CloseCursor(); // $this->session
PDO('mysql:host=localhost;dbname=acces','root','root'); $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE,PDO::FETCH_ASSOC); }catch (Exception $e){ echo 'Imposssible de se connecter'; echo $e->getMessage(); die(); } ?> Si quelqu
pdo->query("SELECT * FROM photo WHERE id_photo = '$id_photo'"); $photo = $data->fetch(PDO::FETCH_ASSOC); ?>