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
|
try
{
$sql = 'CREATE TABLE '.$_POST['rfid_p'].'(
N SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
RFID VARCHAR(100) NOT NULL,
Chambre VARCHAR(100) NOT NULL,
Nom VARCHAR(100) NOT NULL,
Prenom VARCHAR(100) NOT NULL,
Sexe VARCHAR(100) NOT NULL,
Age VARCHAR(100) NOT NULL,
Taille FLOAT NOT NULL,
Poids FLOAT NOT NULL,
Alergies text NOT NULL,
Antecedents text NOT NULL,
Tension FLOAT NOT NULL,
Temperature FLOAT NOT NULL,
Rythme FLOAT NOT NULL,
Glycemie FLOAT NOT NULL,
photo LONGBLOB,
PRIMARY KEY (N)) ENGINE=INNODB;';
$req=$pdo->prepare($sql);
$req->execute();
$req->closeCursor();
}
catch (Exception $e)
{
echo 'Erreur : ', $e->getMessage(), "\n";
}
?> |
Partager