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
| <?php
$baseConnexion= mysqli_connect ('localhost','root','',"creationcompte");
if (! $baseConnexion)
{
die("ne pourrait pas se relier : ". mysqli_connect_error ());
}
$fname = mysqli_real_escape_string($baseConnexion, $_POST['fname']);
$lname = mysqli_real_escape_string($baseConnexion, $_POST['lname']);
$add = mysqli_real_escape_string($baseConnexion, $_POST['add']);
$mail = mysqli_real_escape_string($baseConnexion, $_POST['mail']);
$phone = mysqli_real_escape_string($baseConnexion, $_POST['phone']);
$brithdate = mysqli_real_escape_string($baseConnexion, $_POST['brithdate']);
$sql1='INSERT INTO info_personnelle VALUES("","'.$fname.'","'.$lname.'","'.$add.'","'.$mail.'","'.$phone.'","'.$brithdate.'") ';
if (!mysqli_query($baseConnexion,$sql1))
{
die('impossible dajouter cet enregistrement info perso : ' . mysqli_error($baseConnexion));
}
$nombreExp=intval($_POST["nbexp"]);
echo "Vos info perso ont bien ete prise en compte <br/> ".$nombreExp."<br/>".$_POST['exper5'][0];
// mysqli_close($baseConnexion);
//experiences
$sql2=[];
for($i=0;$i<$nombreExp;$i++)
{
$datdebut=mysqli_real_escape_string($baseConnexion, $_POST['exper1'][$i]);
$datfin=mysqli_real_escape_string($baseConnexion, $_POST['exper2'][$i]);
$titre=mysqli_real_escape_string($baseConnexion, $_POST['exper3'][$i]);
$lieu=mysqli_real_escape_string($baseConnexion, $_POST['exper4'][$i]);
$descrip=mysqli_real_escape_string($baseConnexion, $_POST['exper5'][$i]);
if (!mysqli_query($baseConnexion,'INSERT INTO expériences_profess VALUES("","'.$datdebut.'","'.$datfin.'","'.$titre.'","'.$lieu.'","'.$descrip.'")'))
{
die('impossible dajouter cet enregistrement d\'esxperience : ' . mysqli_error($baseConnexion));
}
echo "<br/>Vos experiences ont bien ete prise en compte <br/> ";
mysqli_close($baseConnexion);
}
?> |
Partager