1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| public function addUser($nom, $prenom, $sexe, $birth, $mail, $adresse, $zip, $ville, $passDatabase, $newsletter){
$connexion = connexion::getInstance()->getConnexion();
$req = $connexion->prepare("INSERT INTO users (nom, prenom, sexe, birth, mail, adresse, zip, ville, pass, optin) VALUES (:nom, :prenom, :sexe, :birth, :mail, :adresse, :zip, :ville, :pass, :optin)");
$req->bindParam(":nom", $nom, PDO::PARAM_STR);
$req->bindParam(":prenom", $prenom, PDO::PARAM_STR);
$req->bindParam(":sexe", $sexe, PDO::PARAM_STR);
$req->bindParam(":birth", $birth, PDO::PARAM_STR);
$req->bindParam(":mail", $mail, PDO::PARAM_STR);
$req->bindParam(":adresse", $adresse, PDO::PARAM_STR);
$req->bindParam(":zip", $zip, PDO::PARAM_STR);
$req->bindParam(":ville", $ville, PDO::PARAM_STR);
$req->bindParam(":pass", $passDatabase, PDO::PARAM_STR);
$req->bindParam(":optin", $newsletter, PDO::PARAM_STR);
$req->execute();
return $connexion->lastInsertId();
} |
Partager