Bonjour,
voici mon code de form/select pour chercher ma liste dans ma base SQL:
<form action="index.php?mod=adddivers" method="post">
<table width="740" border="0" cellspacing="2" cellpadding="2">
<tr>
<td colspan="4" bgcolor="#999999"><center>
<span class="style3">Type d'Acte* :</span>
<?php
echo "<select name=\"LIBELLE\" required>";
echo "<option value=\"\">Choisir le Type d'Acte</option>";
$reqA = "SELECT LIBELLE FROM act_type_div";
$resA = $KwsConnectBdd->query($reqA);
while ($dataA = mysqli_fetch_array($resA)) {
echo "<option value=".$dataA["LIBELLE"].">".$dataA["LIBELLE"]."</option>";
}
echo '</select>';
?>
</center></td>
</tr>
<tr>
<td colspan="4"></td>
</tr>
<tr>
<td bgcolor="#999999"><span class="style3">Date* :
<input name="DATETXT" type="date" required/>
ensuite je récupère de la sorte :
if (isset($_POST["newadd"])) {
### VARIABLES ###
$BIDON = "WEBSITEGG71";
$CODDEP = "71";
$TYPACT = "V";
$DEPART = "Saône-et-Loire";
$DTDEPOT = date('Y-m-d');
$DTMODIF = date('Y-m-d');
$VERIFIEU = "";
$PHOTOGRA = "";
$DEPOSANT = "";
$IDNIM = "";
$PHOTOS = "";
$DREPUB = "";
$ID = "";
$DATETXT = str_replace("'", "''", $_POST['DATETXT']);
$COTE = str_replace("'", "''", $_POST['COTE']);
$LIBRE = str_replace("'", "''", $_POST['LIBRE']);
$LIBELLE = $_POST["LIBELLE"];
$SIGLE = "";
$NOM = str_replace("'", "''", $_POST['NOM']);
$PRE = str_replace("'", "''", $_POST['PRE']);
$SEXE = str_replace("'", "''", $_POST['SEXE']);
$ORI = str_replace("'", "''", $_POST['ORI']);
$DNAIS = str_replace("'", "''", $_POST['DNAIS']);
$AGE = str_replace("'", "''", $_POST['AGE']);
$COM = str_replace("'", "''", $_POST['COM']);
$PRO = str_replace("'", "''", $_POST['PRO']);
$EXCON = str_replace("'", "''", $_POST['EXCON']);
$EXC_PRE = str_replace("'", "''", $_POST['EXC_PRE']);
$EXC_COM = str_replace("'", "''", $_POST['EXC_COM']);
$P_NOM = str_replace("'", "''", $_POST['P_NOM']);
$P_PRE = str_replace("'", "''", $_POST['P_PRE']);
$P_COM = str_replace("'", "''", $_POST['P_COM']);
$P_PRO = str_replace("'", "''", $_POST['P_PRO']);
$M_NOM = str_replace("'", "''", $_POST['M_NOM']);
$M_PRE = str_replace("'", "''", $_POST['M_PRE']);
$M_COM = str_replace("'", "''", $_POST['M_COM']);
$M_PRO = str_replace("'", "''", $_POST['M_PRO']);
$C_NOM = str_replace("'", "''", $_POST['NOM']);
$C_PRE = str_replace("'", "''", $_POST['PRE']);
$C_SEXE = str_replace("'", "''", $_POST['SEXE']);
$C_ORI = str_replace("'", "''", $_POST['ORI']);
$C_DNAIS = str_replace("'", "''", $_POST['DNAIS']);
$C_AGE = str_replace("'", "''", $_POST['AGE']);
$C_COM = str_replace("'", "''", $_POST['COM']);
$C_PRO = str_replace("'", "''", $_POST['PRO']);
$C_EXCON = str_replace("'", "''", $_POST['EXCON']);
$C_X_PRE = str_replace("'", "''", $_POST['EXC_PRE']);
$C_X_COM = str_replace("'", "''", $_POST['EXC_COM']);
$CP_NOM = str_replace("'", "''", $_POST['P_NOM']);
$CP_PRE = str_replace("'", "''", $_POST['P_PRE']);
$CP_COM = str_replace("'", "''", $_POST['P_COM']);
$CP_PRO = str_replace("'", "''", $_POST['P_PRO']);
$CM_NOM = str_replace("'", "''", $_POST['M_NOM']);
$CM_PRE = str_replace("'", "''", $_POST['M_PRE']);
$CM_COM = str_replace("'", "''", $_POST['M_COM']);
$CM_PRO = str_replace("'", "''", $_POST['M_PRO']);
$T1_NOM = str_replace("'", "''", $_POST['T1_NOM']);
$T1_PRE = str_replace("'", "''", $_POST['T1_PRE']);
$T1_COM = str_replace("'", "''", $_POST['T1_COM']);
$T2_NOM = str_replace("'", "''", $_POST['T2_NOM']);
$T2_PRE = str_replace("'", "''", $_POST['T2_PRE']);
$T2_COM = str_replace("'", "''", $_POST['T2_COM']);
$T3_NOM = str_replace("'", "''", $_POST['T1_NOM']);
$T3_PRE = str_replace("'", "''", $_POST['T1_PRE']);
$T3_COM = str_replace("'", "''", $_POST['T1_COM']);
$T4_NOM = str_replace("'", "''", $_POST['T2_NOM']);
$T4_PRE = str_replace("'", "''", $_POST['T2_PRE']);
$T4_COM = str_replace("'", "''", $_POST['T2_COM']);
$COMGEN = str_replace("'", "''", $_POST['COMGEN']);
### FIN DES VARIABLES ###
####################################
# Conversion date pour DATETXT #
# 30/01/2022 au lieu de 2022-01-30 #
####################################
$ladate = explode("-",''.$_POST["DATETXT"].'');
$xdatetxt =''.$ladate[2].'/'.$ladate[1].'/'.$ladate[0].' ';
### FIN CONVERSION DE DATE ###
### FIN CONVERSION DU LIBELLE ###
############################
# Vérification des données #
############################
if(!empty($_POST["DATETXT"]) && !empty($_POST["NOM"]) && !empty($_POST["PRE"])){
$sql = "INSERT INTO act_Pdiv3 VALUES('$BIDON', '$insee', '$commune', '$CODDEP', '$DEPART', '$TYPACT', '$xdatetxt', '$DREPUB', '$COTE', '$LIBRE', '$SIGLE', '$LIBELLE', '$NOM', '$PRE', '$SEXE', '$ORI', '$DNAIS', '$AGE', '$COM', '$PRO', '$EXCON', '$EXC_PRE', '$EXC_COM', '$P_NOM', '$P_PRE', '$P_COM', '$P_PRO', '$M_NOM', '$M_PRE', '$M_COM', '$M_PRO', '$C_NOM', '$C_PRE', '$C_SEXE', '$C_ORI', '$C_DNAIS', '$C_AGE', '$C_COM', '$C_PRO', '$C_EXCON', '$C_X_PRE', '$C_X_COM', '$CP_NOM', '$CP_PRE', '$CP_COM', '$CP_PRO', '$CM_NOM', '$CM_PRE', '$CM_COM', '$CM_PRO', '$T1_NOM', '$T1_PRE', '$T1_COM', '$T2_NOM', '$T2_PRE', '$T2_COM', '$T3_NOM', '$T3_PRE', '$T3_COM', '$T4_NOM', '$T4_PRE', '$T4_COM', '$COMGEN', '$IDNIM', '$PHOTOS', '$DATETXT', '', '$DEPOSANT', '$PHOTOGRA', '$indexeur', '$VERIFIEU', '$DTDEPOT', '$DTMODIF')";
#$KwsConnectBdd->query($sql);
echo "$LIBELLE";
echo "<center><span class=\"green\"> Acte enregistré avec succès</span></center>";
} else {
echo "<center><span class=\"red\">Formulaire incomplet (Vous devez impérativement renseigner les champs : Date, Sexe et Nom)</span></center>";
}
}
Mon problème: Quoi que je fasse, mon $_POST['LIBELLE'] - $_POST["LIBELLE"] ou encore $LIBELLE, je n'obtiens que le 1er mot de ma cellule alors que tout s'affiche très bien dans le menu déroulant, quelqu'un aurait une idée du problème ?
Merci par avance
Bonjour,
voici mon code de form/select pour chercher ma liste dans ma base SQL:
[PHP]
<form action="index.php?mod=adddivers" method="post">
<table width="740" border="0" cellspacing="2" cellpadding="2">
<tr>
<td colspan="4" bgcolor="#999999"><center>
<span class="style3">Type d'Acte* :</span>
<?php
echo "<select name=\"LIBELLE\" required>";
echo "<option value=\"\">Choisir le Type d'Acte</option>";
$reqA = "SELECT LIBELLE FROM act_type_div";
$resA = $KwsConnectBdd->query($reqA);
while ($dataA = mysqli_fetch_array($resA)) {
echo "<option value=".$dataA["LIBELLE"].">".$dataA["LIBELLE"]."</option>";
}
echo '</select>';
?>
</center></td>
</tr>
<tr>
<td colspan="4"></td>
</tr>
<tr>
<td bgcolor="#999999"><span class="style3">Date* :
<input name="DATETXT" type="date" required/>
[/PHP]
ensuite je récupère de la sorte :
[PHP]
if (isset($_POST["newadd"])) {
### VARIABLES ###
$BIDON = "WEBSITEGG71";
$CODDEP = "71";
$TYPACT = "V";
$DEPART = "Saône-et-Loire";
$DTDEPOT = date('Y-m-d');
$DTMODIF = date('Y-m-d');
$VERIFIEU = "";
$PHOTOGRA = "";
$DEPOSANT = "";
$IDNIM = "";
$PHOTOS = "";
$DREPUB = "";
$ID = "";
$DATETXT = str_replace("'", "''", $_POST['DATETXT']);
$COTE = str_replace("'", "''", $_POST['COTE']);
$LIBRE = str_replace("'", "''", $_POST['LIBRE']);
$LIBELLE = $_POST["LIBELLE"];
$SIGLE = "";
$NOM = str_replace("'", "''", $_POST['NOM']);
$PRE = str_replace("'", "''", $_POST['PRE']);
$SEXE = str_replace("'", "''", $_POST['SEXE']);
$ORI = str_replace("'", "''", $_POST['ORI']);
$DNAIS = str_replace("'", "''", $_POST['DNAIS']);
$AGE = str_replace("'", "''", $_POST['AGE']);
$COM = str_replace("'", "''", $_POST['COM']);
$PRO = str_replace("'", "''", $_POST['PRO']);
$EXCON = str_replace("'", "''", $_POST['EXCON']);
$EXC_PRE = str_replace("'", "''", $_POST['EXC_PRE']);
$EXC_COM = str_replace("'", "''", $_POST['EXC_COM']);
$P_NOM = str_replace("'", "''", $_POST['P_NOM']);
$P_PRE = str_replace("'", "''", $_POST['P_PRE']);
$P_COM = str_replace("'", "''", $_POST['P_COM']);
$P_PRO = str_replace("'", "''", $_POST['P_PRO']);
$M_NOM = str_replace("'", "''", $_POST['M_NOM']);
$M_PRE = str_replace("'", "''", $_POST['M_PRE']);
$M_COM = str_replace("'", "''", $_POST['M_COM']);
$M_PRO = str_replace("'", "''", $_POST['M_PRO']);
$C_NOM = str_replace("'", "''", $_POST['NOM']);
$C_PRE = str_replace("'", "''", $_POST['PRE']);
$C_SEXE = str_replace("'", "''", $_POST['SEXE']);
$C_ORI = str_replace("'", "''", $_POST['ORI']);
$C_DNAIS = str_replace("'", "''", $_POST['DNAIS']);
$C_AGE = str_replace("'", "''", $_POST['AGE']);
$C_COM = str_replace("'", "''", $_POST['COM']);
$C_PRO = str_replace("'", "''", $_POST['PRO']);
$C_EXCON = str_replace("'", "''", $_POST['EXCON']);
$C_X_PRE = str_replace("'", "''", $_POST['EXC_PRE']);
$C_X_COM = str_replace("'", "''", $_POST['EXC_COM']);
$CP_NOM = str_replace("'", "''", $_POST['P_NOM']);
$CP_PRE = str_replace("'", "''", $_POST['P_PRE']);
$CP_COM = str_replace("'", "''", $_POST['P_COM']);
$CP_PRO = str_replace("'", "''", $_POST['P_PRO']);
$CM_NOM = str_replace("'", "''", $_POST['M_NOM']);
$CM_PRE = str_replace("'", "''", $_POST['M_PRE']);
$CM_COM = str_replace("'", "''", $_POST['M_COM']);
$CM_PRO = str_replace("'", "''", $_POST['M_PRO']);
$T1_NOM = str_replace("'", "''", $_POST['T1_NOM']);
$T1_PRE = str_replace("'", "''", $_POST['T1_PRE']);
$T1_COM = str_replace("'", "''", $_POST['T1_COM']);
$T2_NOM = str_replace("'", "''", $_POST['T2_NOM']);
$T2_PRE = str_replace("'", "''", $_POST['T2_PRE']);
$T2_COM = str_replace("'", "''", $_POST['T2_COM']);
$T3_NOM = str_replace("'", "''", $_POST['T1_NOM']);
$T3_PRE = str_replace("'", "''", $_POST['T1_PRE']);
$T3_COM = str_replace("'", "''", $_POST['T1_COM']);
$T4_NOM = str_replace("'", "''", $_POST['T2_NOM']);
$T4_PRE = str_replace("'", "''", $_POST['T2_PRE']);
$T4_COM = str_replace("'", "''", $_POST['T2_COM']);
$COMGEN = str_replace("'", "''", $_POST['COMGEN']);
### FIN DES VARIABLES ###
####################################
# Conversion date pour DATETXT #
# 30/01/2022 au lieu de 2022-01-30 #
####################################
$ladate = explode("-",''.$_POST["DATETXT"].'');
$xdatetxt =''.$ladate[2].'/'.$ladate[1].'/'.$ladate[0].' ';
### FIN CONVERSION DE DATE ###
### FIN CONVERSION DU LIBELLE ###
############################
# Vérification des données #
############################
if(!empty($_POST["DATETXT"]) && !empty($_POST["NOM"]) && !empty($_POST["PRE"])){
$sql = "INSERT INTO act_Pdiv3 VALUES('$BIDON', '$insee', '$commune', '$CODDEP', '$DEPART', '$TYPACT', '$xdatetxt', '$DREPUB', '$COTE', '$LIBRE', '$SIGLE', '$LIBELLE', '$NOM', '$PRE', '$SEXE', '$ORI', '$DNAIS', '$AGE', '$COM', '$PRO', '$EXCON', '$EXC_PRE', '$EXC_COM', '$P_NOM', '$P_PRE', '$P_COM', '$P_PRO', '$M_NOM', '$M_PRE', '$M_COM', '$M_PRO', '$C_NOM', '$C_PRE', '$C_SEXE', '$C_ORI', '$C_DNAIS', '$C_AGE', '$C_COM', '$C_PRO', '$C_EXCON', '$C_X_PRE', '$C_X_COM', '$CP_NOM', '$CP_PRE', '$CP_COM', '$CP_PRO', '$CM_NOM', '$CM_PRE', '$CM_COM', '$CM_PRO', '$T1_NOM', '$T1_PRE', '$T1_COM', '$T2_NOM', '$T2_PRE', '$T2_COM', '$T3_NOM', '$T3_PRE', '$T3_COM', '$T4_NOM', '$T4_PRE', '$T4_COM', '$COMGEN', '$IDNIM', '$PHOTOS', '$DATETXT', '', '$DEPOSANT', '$PHOTOGRA', '$indexeur', '$VERIFIEU', '$DTDEPOT', '$DTMODIF')";
#$KwsConnectBdd->query($sql);
echo "$LIBELLE";
echo "<center><span class=\"green\"> Acte enregistré avec succès</span></center>";
} else {
echo "<center><span class=\"red\">Formulaire incomplet (Vous devez impérativement renseigner les champs : Date, Sexe et Nom)</span></center>";
}
}
[/PHP]
Mon problème: Quoi que je fasse, mon $_POST['LIBELLE'] - $_POST["LIBELLE"] ou encore $LIBELLE, je n'obtiens que le 1er mot de ma cellule alors que tout s'affiche très bien dans le menu déroulant, quelqu'un aurait une idée du problème ?
Merci par avance
