1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
| <?php
require_once 'accesBDD.php';
class Membre
{
private $_ID ;
private $_nom ;
private $_prenom ;
private $_dateDeNaissance ;
private $_telephone1 ;
private $_telephone2 ;
private $_adresseMail ;
private $_ville ;
private $_codePostal ;
private $_ligneAdresse1 ;
private $_ligneAdresse2 ;
private $_ligneAdresse3 ;
private $_statut ;
private $_login ;
private $_password ;
private $_sqlAjouter ;
private $_reqAjouter ;
public function __construct($nom, $prenom, $dateDeNaissance, $telephone1, $telephone2, $adresseMail, $ville, $codePostal, $ligneAdresse1, $ligneAdresse2, $ligneAdresse3, $statut)
{
$this->_nom = $nom ;
$this->_prenom = $prenom ;
$this->_dateDeNaissance = $dateDeNaissance ;
$this->_telephone1 = $telephone1 ;
$this->_telephone2 = $telephone2 ;
$this->_adresseMail = $adresseMail ;
$this->_ville = $ville ;
$this->_codePostal = $codePostal ;
$this->_ligneAdresse1 = $ligneAdresse1 ;
$this->_ligneAdresse2 = $ligneAdresse2 ;
$this->_ligneAdresse3 = $ligneAdresse3 ;
$this->_statut = $statut ;
$this->_login = $this->_prenom[0] . $this->_nom ;
$this->_password = $this->_prenom[0] . $this->_nom ;
}
public function ajouter($BDD)
{
$this->_sqlAjouter = 'INSERT INTO infos(nom, prenom, dateDeNaissance, telephone1, telephone2, adresseMail, ville, codePostal, ligneAdresse1, ligneAdresse2, ligneAdresse3, login, password) VALUES(:nom, :prenom, :dateDeNaissance, :telephone1, :telephone2, :adresseMail, :ville, :codePostal, :ligneAdresse1, :ligneAdresse2, :ligneAdresse3, :statut, :login, :password)' ;
$this->_connexion = $BDD->getConnexion();
$this->_reqAjouter = $this->_connexion->prepare($this->_sqlAjouter);
$this->_reqAjouter->execute(array(':nom' => $this->_nom, ':prenom' => $this->_prenom, ':dateDeNaissance' => $this->_dateDeNaissance, ':telephone1' => $this->_telephone1, ':telephone2' => $this->_telephone2, ':adresseMail' => $this->_adresseMail, ':ville' => $this->_ville, ':codePostal' => $this->_codePostal, ':ligneAdresse1' => $this->_ligneAdresse1, ':ligneAdresse2' => $this->_ligneAdresse2, ':ligneAdresse3' => $this->_ligneAdresse3, ':statut' => $this->_statut, ':login' => $this->_login, ':password' => $this->_password));
}
}
?> |
Partager