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
// Connexion
try {
$options = array(
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'
);
$dbh = new PDO('mysql:host=localhost;dbname=nom_de_la_bdd', 'root', '', $options);
}
catch (PDOException $e) {
echo 'Erreur : '.$e->getMessage();
exit();
}
try {
$sth = $dbh->prepare('INSERT INTO patient(nomP, numP, numCH, dateA)
VALUES(:nomP, :numP, :numCH, :dateA)');
$sth->bindValue(':nomP', $nom, PDO::PARAM_STR);
$sth->bindValue(':numP', $numP, PDO::PARAM_STR);
$sth->bindValue(':numCH', $chambre, PDO::PARAM_STR);
$sth->bindValue(':dateA', $dateA, PDO::PARAM_STR);
$sth->execute();
}
catch (PDOException $e) {
echo 'Erreur : '.$e->getMessage();
}
?> |
Partager