Bonjour à tous,
Je dois réaliser un espace membre pour un site :
Voici mon code :
User.php
home.php
<?php
class User {
private $_cnx;
public function __construct(PDO $cnx) {
$this->setCnx($cnx);
}
public function setCnx($dbh) {
$this->_cnx = $dbh;
}
public function insertUser(Post $users) {
$req = "INSERT INTO user (pseudo, email) VALUES(:pseudo, :email)";
$pseudo = $users->getPseudo();
$email = $users->getEmail();
$stmnt = $this->_cnx->prepare($req);
$stmnt->bindParam(':pseudo', $pseudo);
$stmnt->bindParam(':email', $email);
$stmnt->execute();
}
public function getUser($pseudo, $email) {
$sql = "SELECT pseudo, email FROM user WHERE pseudo = :pseudo AND email = :email";
$stmnt = $this->_cnx->prepare($req);
$stmnt->bindParam(':pseudo', $pseudo);
$stmnt->bindParam(':email', $email);
$stmnt->execute();
$count = $stmnt->rowCount();
if($count > 0) {
echo "Le pseudo & L'email existe dejà !";
}
else {
return true;
}
}
}
<?php
require('class/User.php');
require('class/Post.php');
try {
$db = new PDO('mysql:host=localhost;dbname=site', 'root', '');
}
catch(PDOException $e) {
echo 'Mauvaise requête ' . $e->getMessage();
}
if(isset($_POST['submit_form'])) {
$pseudo = $_POST['pseudo'];
$email = $_POST['email'];
if((empty($pseudo)) OR empty($email)) {
$message_error = 'Tous les champs doivent être remplis !</p>';
}
else {
$data_users = array(
'pseudo' => $pseudo,
'email' => $email
);
$cnx = new User($cnx);
$data_users = new Post($data_users);
$data_user = $manager->getUser($pseudo $email);
if(false === $data_user) {
return false;
}
else {
$cnx->insertUser($data_users);
}
}
}
Si quelqu'un pourrait m’éclaircir la chose. MerciNotice: Undefined index: pseudo in C:\wamp64\www\php_expert_devoir_2\process\process_registration.php on line 18
Notice: Undefined index: email in C:\wamp64\www\php_expert_devoir_2\process\process_registration.php on line 19
Partager