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
|
<?php
$servername = "localhost";
$username = //
password = //
$dbname = "dbreservationsalle";
$salle=$_POST['selectbasicSalle'];
$date=$_POST['dateReunion'];
$heurededebut=$_POST['selectheuredebut'];
$heuredefin=$_POST['selectheurefin'];
// Permet de convertir la date pour le format de date de la base de donnee
$dateEn = substr($date, 6, 4).'-'.substr($date, 3, 2).'-'.substr($date, 0, 2);
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Si tout va bien, on peut continuer
function test($dbname,$salle,$date)
{
foreach($dbname->query('SELECT * FROM reservation') as $row)
{
echo $row['salle_idsalle'].' '.$row['Date_reunion'];
}
}
test($dbname,$salle,$date);
?> |
Partager