double requête et non respect des conditions.
Posté : 31 mars 2012, 12:43
Bonjour à tous, j'ai deux requête pour insérer mes données dans mysql (pour le moment), le soucis c'est qu'elles ont des conditions différentes en dépit de cela (condition non respectée), il les exécute quand meme les deux. Je ne comprends pas.
<?php if (isset($_POST['categorie']) AND $_POST['categorie'] =="personne_physique" AND $_POST['forme_juridique']!='autre' AND $_POST['qualite_rep_legal']!="autre") { ?><?php
$sql = 'INSERT INTO client
SET code_client = "'.mysql_real_escape_string($_POST['code_client']).'",
categorie = "'.mysql_real_escape_string($_POST['categorie']).'",
date_creation = "'.mysql_real_escape_string($_POST['date_creation']).'",
code_referent = "'.mysql_real_escape_string($_POST['code_referent']).'",
code_commercial = "'.mysql_real_escape_string($_POST['code_commercial']).'",
note = "'.mysql_real_escape_string($_POST['note']).'",
civilite_gerant = "'.mysql_real_escape_string($_POST['civilite_gerant']).'",
nom_gerant = "'.mysql_real_escape_string($_POST['nom_gerant']).'",
prenom_gerant = "'.mysql_real_escape_string($_POST['prenom_gerant']).'",
forme_juridique = "'.mysql_real_escape_string($_POST['forme_juridique']).'",
siret = "'.mysql_real_escape_string($_POST['siret']).'",
code_ape = "'.mysql_real_escape_string($_POST['code_ape']).'",
tva_intra = "'.mysql_real_escape_string($_POST['tva_intra']).'",
taux_tva = "'.mysql_real_escape_string($_POST['taux_tva']).'",
activite = "'.mysql_real_escape_string($_POST['activite']).'",
rue_siege_social = "'.mysql_real_escape_string($_POST['rue_siege_social']).'",
complement1_siege_social = "'.mysql_real_escape_string($_POST['complement1_siege_social']).'",
complement2_siege_social = "'.mysql_real_escape_string($_POST['complement2_siege_social']).'",
code_postal_siege_social = "'.mysql_real_escape_string($_POST['code_postal_siege_social']).'",
ville_siege_social = "'.mysql_real_escape_string($_POST['ville_siege_social']).'",
pays_siege_social = "'.mysql_real_escape_string($_POST['pays_siege_social']).'",
civilite_rep_legal = "'.mysql_real_escape_string($_POST['civilite_rep_legal']).'",
nom_rep_legal = "'.mysql_real_escape_string($_POST['nom_rep_legal']).'",
prenom_rep_legal = "'.mysql_real_escape_string($_POST['tel_rep_legal']).'",
fax_rep_legal = "'.mysql_real_escape_string($_POST['fax_rep_legal']).'",
gsm_rep_legal = "'.mysql_real_escape_string($_POST['gsm_rep_legal']).'",
e_mail_rep_legal = "'.mysql_real_escape_string($_POST['e_mail_rep_legal']).'",
login_rep_legal = "'.mysql_real_escape_string($_POST['login_rep_legal']).'",
pass_rep_legal = "'.mysql_real_escape_string($_POST['pass_rep_legal']).'",
tel_rep_legal = "'.mysql_real_escape_string($_POST['tel_rep_legal']).'"';
mysql_query($sql) or die(__LINE__.mysql_error().$sql);
echo "Fini ";
?>
<?php } ?>
<p><?php if (isset($_POST['categorie']) AND $_POST['categorie'] =="personne_physique" AND $_POST['forme_juridique']='autre' AND $_POST['qualite_rep_legal']!="autre") { ?>
<?php
$sql = 'INSERT INTO client
SET code_client = "'.mysql_real_escape_string($_POST['code_client']).'",
categorie = "'.mysql_real_escape_string($_POST['categorie']).'",
date_creation = "'.mysql_real_escape_string($_POST['date_creation']).'",
code_referent = "'.mysql_real_escape_string($_POST['code_referent']).'",
code_commercial = "'.mysql_real_escape_string($_POST['code_commercial']).'",
note = "'.mysql_real_escape_string($_POST['note']).'",
civilite_gerant = "'.mysql_real_escape_string($_POST['civilite_gerant']).'",
nom_gerant = "'.mysql_real_escape_string($_POST['nom_gerant']).'",
prenom_gerant = "'.mysql_real_escape_string($_POST['prenom_gerant']).'",
forme_juridique = "'.mysql_real_escape_string($_POST['forme_juridique2']).'",
siret = "'.mysql_real_escape_string($_POST['siret']).'",
code_ape = "'.mysql_real_escape_string($_POST['code_ape']).'",
tva_intra = "'.mysql_real_escape_string($_POST['tva_intra']).'",
taux_tva = "'.mysql_real_escape_string($_POST['taux_tva']).'",
activite = "'.mysql_real_escape_string($_POST['activite']).'",
rue_siege_social = "'.mysql_real_escape_string($_POST['rue_siege_social']).'",
complement1_siege_social = "'.mysql_real_escape_string($_POST['complement1_siege_social']).'",
complement2_siege_social = "'.mysql_real_escape_string($_POST['complement2_siege_social']).'",
code_postal_siege_social = "'.mysql_real_escape_string($_POST['code_postal_siege_social']).'",
ville_siege_social = "'.mysql_real_escape_string($_POST['ville_siege_social']).'",
pays_siege_social = "'.mysql_real_escape_string($_POST['pays_siege_social']).'",
civilite_rep_legal = "'.mysql_real_escape_string($_POST['civilite_rep_legal']).'",
nom_rep_legal = "'.mysql_real_escape_string($_POST['nom_rep_legal']).'",
prenom_rep_legal = "'.mysql_real_escape_string($_POST['tel_rep_legal']).'",
fax_rep_legal = "'.mysql_real_escape_string($_POST['fax_rep_legal']).'",
gsm_rep_legal = "'.mysql_real_escape_string($_POST['gsm_rep_legal']).'",
e_mail_rep_legal = "'.mysql_real_escape_string($_POST['e_mail_rep_legal']).'",
login_rep_legal = "'.mysql_real_escape_string($_POST['login_rep_legal']).'",
pass_rep_legal = "'.mysql_real_escape_string($_POST['pass_rep_legal']).'",
tel_rep_legal = "'.mysql_real_escape_string($_POST['tel_rep_legal']).'"';
mysql_query($sql) or die(__LINE__.mysql_error().$sql);
echo "Fini ";
?><?php } ?>
Le soucis c'est que j'ai un select avec l'option "autre" et un javascript qui affiche un input ce que je veux c'est que la deuxieme requete soit prise en consideration si le select est sur l'option autre. a priori, la deuxieme requete fonctionne bien mais la premiere ne devrait pas etre executée pourtant si.... Je ne comprends pas.