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
| <?php
class mysql{
private $dsn = 'mysql:dbname=souper;host=localhost';
private $user = 'root';
private $password = '';
private $connexion;
function mysql() {
}
private function connect_db()
{
try {
$this->connexion = new PDO($this->dsn, $this->user, $this->password);
}
catch(Exception $e)
{
echo 'Erreur : '.$e->getMessage().'<br />';
echo 'N° : '.$e->getCode();
}
}
public function inscription($tab)
{
$this->connect_db();
$requete_preparee = $this->connexion->prepare("INSERT INTO inscription values('',:nom,:prenom,:adresse,:cp,:ville,:email,:tel)");
$requete_preparee->execute($tab);
print_r($tab);
$requete_preparee = $this->connexion->prepare("INSERT INTO backup values('',:nom,:prenom,:adresse,:cp,:ville,:email,:tel)");
$requete_preparee->execute($tab);
return true;
} |
Partager