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
| <?php
session_start();
include_once 'database.php';
if(isset($_POST['submit']) )
{
$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$city_name = $_POST['city_name'];
$email = $_POST['email'];
$gardon = $_POST['gardon'];
$breme = $_POST['breme'];
$tanche = $_POST['tanche'];
$carpe = $_POST['carpe'];
$carassin = $_POST['carassin'];
$ides = $_POST['ides'];
$hybride = $_POST['hybride'];
$perche = $_POST['perche'];
$ablette = $_POST['ablette'];
$rotengle = $_POST['rotengle'];
$sandre= $_POST['sandre'];
$brochet = $_POST['brochet'];
$anguille = $_POST['anguille'];
$goujon = $_POST['goujon'];
$gobies = $_POST['gobies'];
$truite = $_POST['truite'];
$cours_do = $_POST['cours_do'];
$duree = $_POST['duree'];
$checkbox1 = $_POST['technique'];
$chk="";
foreach($checkbox1 as $chk1)
{
$chk.= $chk1.",";
}
$checkbox2 = $_POST['meteo'];
$chkx="";
foreach($checkbox2 as $chk2)
{
$chkx.= $chk2.",";
}
$total=$gardon+$breme+$tanche+$carpe+$carassin+$ides+$hybride+$perche+$ablette+$rotengle+$sandre+$brochet+$anguille+$goujon+$truite+$gobies ;
$req= $bdd->prepare('INSERT INTO employee(first_name,last_name,city_name,email,gardon,breme,tanche,carpe,carassin,ides,hybride,perche,ablette,rotengle,sandre,brochet,anguille,goujon,gobies,truite,cours_do, duree,technique,meteo,total,date_inscription) VALUES(:first_name,:last_name,:city_name,:email,:gardon,:breme,:tanche,:carpe,:carassin,:ides,:hybride,:perche,:ablette,:rotengle,:sandre,:brochet,:anguille,:goujon,:gobies,:truite,:cours_do, :duree,:technique,:meteo,:total,CURDATE())');
$req->execute(array(
'first_name' => $first_name,
'last_name' => $last_name,
'city_name' => $city_name ,
'email' => $email,
'gardon' => $gardon, 'breme' => $breme ,'tanche' => $tanche,'carpe' => $carpe,'carassin' => $carassin,'ides' => $ides, 'hybride' => $hybride,'perche' => $perche,'ablette' => $ablette,'rotengle' => $rotengle,
'sandre' => $sandre,'brochet' => $brochet,'anguille' => $anguille ,'goujon' => $goujon,
'gobies' => $gobies,'truite' => $truite, 'cours_do' => $cours_do, 'duree' => $duree, 'technique' => $chk,'meteo' => $chkx ,'total' => $total ));
echo " Vos données sont enregistrées";
}
?> |
Partager