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 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80
|
<?php
try
{
$bdd = new PDO('mysql:host=localhost;dbname=tba','root','');
//$bdd->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
//$bdd->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
}
catch(Exception $e)
{
die('Erreur : '.$e->getMessage());
}
$nom = $_POST['nom'];
$url = $_POST['url'];
$dateCreation = $_POST['dateCreation'];
$idTypeCms = $_POST['idTypeCms'];
$dateMiseEnLigne = $_POST['dateMiseEnLigne'];
$dateDerniereModif = $_POST['dateDerniereModif'];
$reponse = $bdd->prepare('INSERT INTO sites (nom, url, dateCreation, idTypeCms, dateMiseEnLigne, dateDerniereModif) VALUES (:nom,:url,:dateCreation,:idTypeCms,:dateMiseEnLigne,:dateDerniereModif)');
$reponse->execute(array(
':nom' => $nom,
':url' => $url,
':dateCreation' => $dateCreation,
':idTypeCms' => $idTypeCms,
':dateMiseEnLigne' => $dateMiseEnLigne,
':dateDerniereModif' => $dateDerniereModif
));
// On ferme la requête avant d'en faire une autre
$reponse->closeCursor();
$reponse = null;
?>
<div align="left" id="fiche">
<h3 class="font">Formulaire ajouter un site </h3>
<div class="conteneur">
<form action="index.php" method="post" enctype="multipart/form-data" name="ajoutSite" id="ajoutSite">
<p><label for "nom">Nom</label></p>
<p><input type="text" required name="nom" id="nom" /></p>
<p><label for "URL">URL</label></p>
<p><input type="url" onfocus='this.value="http://www."' required name="url" id="url" /></p>
<p><label for "dateMiseEnLigne">Date de création</label></p>
<p><input style="width:100px" type="date" required pattern="\d{1,2}/\d{1,2}/\d{4}" name="dateMiseEnLigne" id="dateMiseEnLigne" /></p>
<p><label for "typeCms">Type de CMS</label></p>
<!--DEBUT SELECTION DU TYPE DE CMS-->
<?php
try
{
$reponse = $bdd->query('SELECT * FROM cms');
?>
<select name="typeCms" id="typeCms">
<?php
while ($donnees = $reponse->fetch())
{
?>
<p>
<option value="<?php echo $donnees['id']; ?>"><?php echo $donnees['nomCms']; ?></option>
</p>
<?php
}
?>
</select>
<?php
$reponse->closeCursor();
}
catch(Exception $e)
{
die('Erreur : '.$e->getMessage());
}
?>
<!--FIN SELECTION DU TYPE DE CMS-->
<p><label for "dateAjout">Date d'ajout</label></p>
<p><input style="width:100px" type="date" required pattern="\d{1,2}/\d{1,2}/\d{4}" name="dateAjout" id="dateAjout" /></p>
<p><label for "dateDerniereModif">Date de modification</label></p>
<p><input style="width:100px" type="date" required pattern="\d{1,2}/\d{1,2}/\d{4}" name="dateDerniereModif" id="dateDerniereModif" /></p>
<p> </p>
<p><input type="submit" name="envoyer" id="envoyer" value="Envoyer" /></p>
</form> |
Partager