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 81 82 83 84 85 86 87 88 89 90 91 92 93
| <?php
//Connecting to database
try
{
$bdd = new PDO('mysql:host=localhost;dbname=bdd;charset=utf8', 'user', 'mdp');
}
catch (Exception $e)
{
die('Erreur : ' . $e->getMessage());
}
$bdd = new PDO('mysql:host=localhost;dbname=bdd;charset=utf8', 'user', 'mdp');
//Setting values
$cliname = $_POST['client']; //Client
if (isset($_POST['tel'])) //Telephone
{
if ($_POST['tel'] !== "")
{
$clitel = $_POST['tel'];
}
else
{
$clitel = "Non défini";
}
}
else
{
$clitel = "Non défini";
}
$climail = $_POST['atmail']; //Adresse mail
$clidate = $_POST['date']; //Date souhaitee
if (isset($_POST['time'])) //Heure souhaitee
{
if ($_POST['time'] !== "")
{
$clitime = $_POST['time'];
}
else
{
$clitime = "Non défini";
}
}
else
{
$clitime = "Non d?ni";
}
$formule = $_POST['formule']; //Formule
//Calculating $servvalue
function ServCalc($g, $l, $e, $f)
{
$serv_ans = $g + $l + $e + $f;
return $serv_ans;
}
if (isset($_POST['gonflage']))
{
$serv_g = 1 ;
}
else
{
$serv_g = 0 ;
}
if (isset($_POST['lustrage']))
{
$serv_l = 2 ;
}
else
{
$serv_l = 0 ;
}
if (isset($_POST['essuigla']))
{
$serv_e = 5 ;
}
else
{
$serv_e = 0 ;
}
if (isset($_POST['flocage']))
{
$serv_f = 9 ;
}
else
{
$serv_f = 0 ;
}
$services = ServCalc($serv_g, $serv_l, $serv_e, $serv_f);
$marque = $_POST['marque'];
$modele = $_POST['modele'];
//Posting
$bdd->exec('INSERT INTO reserva(client, tel, mail, date, time, formule, services, marque, modele) VALUES(\''.$cliname.'\', \''.$clitel.'\', \''.$climail.'\', \''.$clidate.'\', \''.$clitime.'\', \''.$formule.'\', \''.$services.'\', \''.$marque.'\', \''.$modele.'\')');
var_dump("\nPDO::errorCode(): ", $bdd->errorCode(), $bdd->errorInfo());
//Leaving
header ('Location: reserv.php');
?> |
Partager