PDO. L'inscription fonctionne au niveau de l'insertion des données dans ma BDD. Parcontre ça coince pour récupérer les données de l'utilisateur sur la page du profil. Pareil
pdo->prepare('SELECT * FROM Membres WHERE id = ? AND reset_token IS NOT NULL AND reset_token = ? AND reset_at > DATE_SUB(NOW(), INTERVAL 30 MINUTE)'); $req->execute([$_GET['id'], $_GET['token
PDO('mysql:host=localhost;dbname=net','root','root'); echo "conection1"; mysql_query("SET NAMES UTF8"); $bdd2= new PDO('mysql:host=localhost;dbname=wordpress','root','root'); echo "connection2"; mysql_query("SET NAMES
PDO::FETCH_CLASS, $class_name); if($one){ $datas = $req->fetch(); } else{ $datas = $req->fetchAll(); } return $datas; } public function prepare($statement, $attributes, $class_name, $one = false) { $req = $this->GetPDO()->prepare($statement
PDO::FETCH_ASSOC)) { $cat_title = $row['cat_title']; $cat_id = $row['cat_id']; echo " "; echo " {$cat_id} "; echo " {$cat_title} "; echo " Supprimer "; echo " Modifier "; echo " "; } ?>
PDO //Lecture de la table pour aujourd'hui $register = $this->DB->query('SELECT * FROM registre_tmb WHERE d_dem = "'.date('Y-m-d').'" '); $this->arrayToday = $register->fetchAll(PDO::FETCH_ASSOC
PDO->prepare("SELECT * FROM item_template LEFT JOIN itemsets ON itemsets.id=item_template.panoplie WHERE type='1' ORDER BY level"); Mais j'aimerai aussi joindre à cela ma table craft qui serait
PDO('mysql:host='.$host.';dbname='.$db, $db_user, $db_password); $req = $bdd->prepare("SELECT * FROM users WHERE username = :username"); $req->execute(array('username' => $_SESSION['pseudo'])); $user = $req->fetch(PDO::FETCH
PDO("mysql:host=$hostname;dbname=$db_name", $username, $password); // a query get all the records from the users table $sql = 'SELECT * FROM SITES'; // use prepared statements, even if not strictly
PDO('mysql:host=localhost;dbname=image', 'root', ''); } catch (Exception $e) { exit('Erreur : ' . $e->getMessage()); } $search=$_GET['search']; $s=explode(" ",$search); $req = $bdd->prepare('SELECT * FROM images'); $req->execute(array($idImg