$sql = "SELECT * FROM users WHERE username = :username "; $a_datas = array(":username"=>$username ); try{ $prepare = $bdd->prepare($sql); $prepare->execute($a_datas); //on stocke le résultat dans un array $donnees = $prepare->fetchAll(); } catch (Exception $e) { echo 'Erreur : ' . $e->getMessage(); exit(); }
entre deux date
SELECT * FROM tatable WHERE tonchampdate BETWEEN '2016-01-01' AND '2016-03-09'