mysql_query("INSERT INTO clients Nom_prenom,Date_de_naissance,Adresse,Ville,Cp,Civil,Email,Telephone,Code)VALUES('$Nom_prenom','$Date_de_naissance','$Adresse','$Ville','$Cp','$Civil','$Email','$Telephone','$Code')");
mysql_query("INSERT INTO clients (Nom_prenom,Date_de_naissance,Adresse,Ville,Cp,Civil,Email,Telephone,Code)VALUES('$Nom_prenom','$Date_de_naissance','$Adresse','$Ville','$Cp','$Civil','$Email','$Telephone','$Code')");
<?php if (isset($_POST['go']) && $_POST['go']= ='Valider') { if(empty($_POST['Nom_prenom']) || empty($_POST['Date_de_naissance']) || empty($_POST['Adresse']) || empty($_POST['Ville']) || empty($_POST['Cp']) || empty($_POST['Civil']) || empty($_POST['Email'])|| empty($_POST['Telephone'])|| empty($_POST['Code'])){ $erreur = ' Des champs sont vides ! '; } else { $Nom_prenom = $_POST['Nom_prenom']; $Date_de_naissance = $_POST['Date_de_naissance']; $Adresse =$_POST['Adresse']; $Ville = $_POST['Ville']; $Cp= $_POST['Cp']; $Civil = $_POST['Civil']; $Email = $_POST['Email']; $Telephone = $_POST['Telephone']; $Code = $_POST['Code']; $connect= mysql_connect('localhost','root',''); mysql_select_db("test"); $sql= "INSERT INTO clients (Nom_prenom,Date_de_naissance,Adresse,Ville,Cp,Civil,Email,Telephone,Code)VALUES('$Nom_prenom','$Date_de_naissance','$Adresse','$Ville','$Cp','$Civil','$Email','$Telephone','$Code')"; mysql_query($sql) or die ('Erreur SQL !'.$sql.' '.mysql_error()); mysql_close (); $erreur = ' Données correctement editées ! '; } } ?> <!DOCTYPE html> <html> <head> <meta charset ="utf-8" /> <title>Nouveau client-CashProg</title> <LINK rel="stylesheet" type="text/css" href="style.css"> </head> <center><?php // on affiche les erreurs éventuelles if (isset($erreur)) echo $erreur;?> </center> [nouveauxclient.php Actualiser] <form method="POST" action="nouveauxclient.php"> <center><fieldset><legend>Nouveaux Clients</legend> " />, <label for="Civil">Civilité:, <select name="Civil"> <option>Mr.</option> <option>Mlle</option> <option>Mme</option> </select>, Nom et prenom, , ---- Adresse, , Code Postal, , ---- Ville, , Telephone, , ---- Email, , Date de naissance, </center> <center> </center> </FORM> </fieldset><center> </html>
<?php mysql_error(); if(isset($_POST['Codebarre']) && isset($_POST['Designation']) && isset($_POST['Rayon']) && isset($_POST['Famille']) && isset($_POST['Poids']) && isset($_POST['Pointsdefidelite']) && isset($_POST['Datedesortie'])&& isset($_POST['Prixdereprise'])&& isset($_POST['Tva'])&& isset($_POST['Ventettc'])&& isset($_POST['Venteht'])&& isset($_POST['Stock'])&& isset($_POST['Neuf'])&& isset($_POST['Occasions'])&& isset($_POST['Fournisseurs']) && $_POST['Codebarre'] != "" && $_POST['Designation'] != "" && $_POST['Rayon'] != "" && $_POST['Famille'] != "" && $_POST['Poids'] != "" && $_POST['Pointsdefidelite'] != "" && $_POST['Datedesortie'] != ""&& $_POST['Prixdereprise'] != ""&& $_POST['Tva'] != ""&& $_POST['Ventettc'] != ""&& $_POST['Venteht'] != ""&& $_POST['Stock'] != ""&& $_POST['Neuf'] != ""&& $_POST['Occasions'] != ""&& $_POST['Fournisseurs'] != ""){ $Codebarre = $_POST['Codebarre']; $Designation = $_POST['Designation']; $Rayon =$_POST['Rayon']; $Famille = $_POST['Famille']; $Poids= $_POST['Poids']; $Pointsdefidelite = $_POST['Pointsdefidelite']; $Datedesortie = $_POST['Datedesortie']; $Prixdereprise = $_POST['Prixdereprise']; $Tva = $_POST['Tva']; $Ventettc = $_POST['Ventettc']; $Venteht = $_POST['Venteht']; $Stock = $_POST['Stock']; $Neuf = $_POST['Neuf']; $Occasions = $_POST['Occasions']; $Fournisseurs = $_POST['Fournisseurs']; $connect= mysql_connect('localhost','admin','31p71h49') or die('Impossible de se connecter au serveur MySQL'); mysql_select_db("cashprog"); mysql_query("INSERT INTO articles (Codebarre,Designation,Rayon,Famille,Poids,Pointsdefidelite,Datedesortie,Prixdereprise,Tva,Ventettc,Venteht,Stock,Neuf,Occasions,Fournisseurs)VALUES('$Codebarre','$Designation','$Rayon','$Famille','$Poids','$Poinstdefidelite','$Datedesortie','$Prixdereprise','$Tva','$Tva','$Ventettc','$Venteht','$Stock','$Neuf','$Neuf','$Occasions','$Fournisseurs')"); } ?> <!DOCTYPE html> <html> <head> <LINK rel="stylesheet" type="text/css" href="style.css"> <meta charset="utf-8" /> <title>Nouvel articles-CashProg</title> </head> <form method="POST" action="nouveauxarticle.php"> /!\ Tous les champs doivent être remplis /!\ <center><fieldset><legend>Général</legend> Code barre:, Occasions : Neuf :, ---- Designation:, , ---- Rayon:, Famille: , ---- Fournisseurs:, Poids: , ---- Points de fidélité:, Date de sortie: </fieldset></center> <center><fieldset><legend>Tarifications</legend> Prix de reprise:, Tva: , ---- Vente TTC:, Vente HT: , ---- Stock:, <TD> <center> </center> </FORM> </fieldset></center>
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question<?php //mysql_error(); echo ''; print_r($_POST); echo ' '; /* [Codebarre] => jsf [sexe] => Occasions [Designation] => sfj [Rayon] => sfj [Famille] => sfhsfh [Fournisseurs] => sfj [Poids] => sfhs [Poinstdefidelite] => sfj faux [Date_de_sortie] => sfj [Prixdereprise] => sf [Tva] => fj [Ventettc] => sfj [Venteht] => sfj [Stock] => sfj ($_POST['Neuf']) ? && isset($_POST['Datedesortie']) mais [Date_de_sortie] ... */ /* tu peux ecrire isset($var1,$var2 ...) pas besoin des && */ if(isset($_POST['Codebarre']) && isset($_POST['Designation']) && isset($_POST['Rayon']) && isset($_POST['Famille']) && isset($_POST['Poids']) //&& isset($_POST['Pointsdefidelite']) //&& isset($_POST['Datedesortie']) && isset($_POST['Prixdereprise']) && isset($_POST['Tva']) && isset($_POST['Ventettc']) && isset($_POST['Venteht']) && isset($_POST['Stock']) //&& isset($_POST['Neuf']) //&& isset($_POST['Occasions']) /*ici ton radio du formulaire est mauvais ...*/ //&& isset($_POST['Fournisseurs']) /* /*la fonction empty() comme !empty($var)*/ /* && $_POST['Codebarre'] != "" && $_POST['Designation'] != "" && $_POST['Rayon'] != "" && $_POST['Famille'] != "" && $_POST['Poids'] != "" && $_POST['Pointsdefidelite'] != "" && $_POST['Datedesortie'] != "" && $_POST['Prixdereprise'] != "" && $_POST['Tva'] != "" && $_POST['Ventettc'] != "" && $_POST['Venteht'] != "" && $_POST['Stock'] != "" && $_POST['Neuf'] != "" && $_POST['Occasions'] != "" && $_POST['Fournisseurs'] != "" */ ){ /*ici on doit securiser au moins avec strip_tags et mysql_real_escape_string mais PDO c'est mieux*/ /*ici il existe une fonction php extract qui fait ça*/ /*extract($_POST);*/ $Codebarre = $_POST['Codebarre']; $Designation = $_POST['Designation']; $Rayon =$_POST['Rayon']; $Famille = $_POST['Famille']; $Poids= $_POST['Poids']; $Pointsdefidelite = $_POST['Pointsdefidelite']; $Datedesortie = $_POST['Datedesortie']; $Prixdereprise = $_POST['Prixdereprise']; $Tva = $_POST['Tva']; $Ventettc = $_POST['Ventettc']; $Venteht = $_POST['Venteht']; $Stock = $_POST['Stock']; $Neuf = $_POST['Neuf']; $Occasions = $_POST['Occasions']; $Fournisseurs = $_POST['Fournisseurs']; /*fin ici il existe une fonction php extract qui fait ça*/ $connect= mysql_connect('localhost','admin','31p71h49') or die('Impossible de se connecter au serveur MySQL'); mysql_select_db("cashprog"); mysql_query("INSERT INTO articles (Codebarre,Designation,Rayon,Famille,Poids,Pointsdefidelite,Datedesortie,Prixdereprise,Tva,Ventettc,Venteht,Stock,Neuf,Occasions,Fournisseurs)VALUES('$Codebarre','$Designation','$Rayon','$Famille','$Poids','$Poinstdefidelite','$Datedesortie','$Prixdereprise','$Tva','$Tva','$Ventettc','$Venteht','$Stock','$Neuf','$Neuf','$Occasions','$Fournisseurs')"); }else{ echo 'le form ?'; } ?> <!DOCTYPE html> <html> <head> <LINK rel="stylesheet" type="text/css" href="style.css"> <meta charset="utf-8" /> <title>Nouvel articles-CashProg</title> </head> <form method="POST" action="nouveauxarticle.php"> /!\ Tous les champs doivent être remplis /!\ <center><fieldset><legend>Général</legend> Code barre:, Occasions : Neuf :, ---- Designation:, , ---- Rayon:, Famille: , ---- Fournisseurs:, Poids: , ---- Points de fidélité:, Date de sortie: </fieldset></center> <center><fieldset><legend>Tarifications</legend> Prix de reprise:, Tva: , ---- Vente TTC:, Vente HT: , ---- Stock:, <TD> <center> </center> </FORM> </fieldset></center>