Requête renvoyant une erreur

Mammouth du PHP | 702 Messages

30 mars 2012, 16:17

Bonjour, j'ai cette requête ci
<?php if (isset($_POST['categorie']) AND $_POST['categorie'] =="personne_physique" AND  $user['forme_juridique']!='autre' AND $user['forme_juridique']!="autre" AND $user['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']).'",`gsm_rep_legal`="'.mysql_real_escape_string($_POST['gsm_rep_legal']).'"
;



mysql_query($sql) or die(__LINE__.mysql_error().$sql);

echo "Fini ";
?>
<?php } ?>
le soucis est qu'elle me renvoit l'erreur sous-jacente:
( ! ) Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE in C:\wamp\www\NEOGETCASH\ADMIN\create-client2.php on line 112
du coup je ne vois pas ou est l'erreur.

Administrateur PHPfrance
Administrateur PHPfrance | 11457 Messages

30 mars 2012, 17:03

Déjà, il te manque l'aposotrophe fermant à la fin de ta requête.
$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']).'",
               gsm_rep_legal            = "'.mysql_real_escape_string($_POST['gsm_rep_legal']).'"';

Mammouth du PHP | 702 Messages

30 mars 2012, 17:15

merci :)

Ps: petite question: je ne vois pas le boutons pour marquer résolu?
d'avance merci.

Administrateur PHPfrance
Administrateur PHPfrance | 11457 Messages

30 mars 2012, 23:28

Le Bouton Résolu ? Y a plus ! :cry:

Mammouth du PHP | 702 Messages

31 mars 2012, 09:31

c'est bien domage. c'est pratique surtout. Merci pour l'aide :)