merci pour la reponse
je viens donc de supprimer tous les enregistrements et j ai su entrer la colonne date
mais j ai un soucis avec mon code php lors de l insertion des données j ai ce message d erreur
Error: 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,pets,technique,meteo,total) VALUES ('a','a','a', '
[email protected]','2','0','0','0','0', '0','0','0','0','0', '0','0','0','0', '7','0', '3','perle,','neige,','9') Field 'date_inscription' doesn't have a default value
voici mon fichier php
es ce que je dois indiquer un morceau de code pour la date lors de l insertion des éléments dans la table
Code : Tout sélectionner
<?php
include_once 'database.php';
if(isset($_POST['save']))
{
$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'];
$pets = $_POST['pets'];
$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 ;
$sql = "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,pets,technique,meteo,total)
VALUES ('$first_name','$last_name','$city_name',
'$email','$gardon','$breme','$tanche','$carpe','$carassin',
'$ides','$hybride','$perche','$ablette','$rotengle',
'$sandre','$brochet','$anguille','$goujon',
'$gobies','$truite',
'$pets','$chk','$chkx','$total')";
if (mysqli_query($conn, $sql)) {
echo "ta journne de peche est bien enregistree ...felicitations ";
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
?>