$sql="SELECT chp1,chp2 .... FROM table1, table2 .... Where {jointure}" if(isset($_POST["Mat"])) { $sql.=" AND MATRICULE =".$_POST["Mat"]." "; } if(isset($_POST["service"])) { $sql.=" AND SERVICE ='".$_POST["service"]."' "; } ... {Exécution du sql}
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionif (isset($_POST['text1']) && $_POST['text1']!='')
$sql = "SELECT s.libelle,a.Matricule,a.Nom,a.Prenom,d.Type,d.DateDemende,d.user,d.user FROM agents as a,demande as d,service as s where a.codemande=d.Codemande and a.Matricule=s.Matricule "; if (isset($_POST['text1'])) { $sql.=" and a.Matricule='".$_POST['text1']."' "; } if (isset($_POST['list2'])) { $sql.=" and s.libelle='".$_POST['list2']."' "; } if (isset($_POST['text2'])&& isset($_POST['text3'])) { $sql.=" and d.DateDemende between ".$_POST['text2']." and ".$_POST['text3']." "; }
LIKE '%".$_POST["text1"]."%'
$req = mysql_query($sql);
$req = mysql_query($sql); if (!$req) { $message = 'Requête invalide : ' . mysql_error() . "\n"; $message .= 'Requête complète : ' . $sql; die($message); }
if (isset($_POST['text2'])&& isset($_POST['text3'])) { $sql.=" and d.DateDemende between".$_POST['text2']." and".$_POST['text3'].""; }
if (isset($_POST['text2'])&& isset($_POST['text3']) && $_POST['text2']!='' && $_POST['text3']!='') { $sql.=" and d.DateDemende between".$_POST['text2']." and".$_POST['text3'].""; }
requete invalide:Erreur de syntaxe pr?s de 'and' ? la ligne 1 requete compete:SELECT s.libelle,a.Matricule,a.Nom,a.Prenom,d.Type,d.DateDemende,d.user,d.user FROM agents as a,demande as d,service as s where a.codemande=d.Codemande and a.Matricule=s.Matricule and a.Matricule='11' and s.libelle='dl' and d.DateDemende between and if (isset($_POST['text2'])&& isset($_POST['text3']) && $_POST['text2']!='' && $_POST['text3']!='') { $sql.=" and d.DateDemende between".$_POST['text2']." and".$_POST['text3'].""; } requete invalide:Erreur de syntaxe pr?s de 'between2010-08-10 and2010-08-13' ? la ligne 1 requete compete:SELECT s.libelle,a.Matricule,a.Nom,a.Prenom,d.Type,d.DateDemende,d.user,d.user FROM agents as a,demande as d,service as s where (a.Matricule=d.Matricule) and (a.Matricule=s.Matricule) and a.Matricule='11' and s.libelle='tcp' and d.DateDemende between2010-08-10 and2010-08-13
<?php $id=mysql_connect('localhost','root',''); mysql_select_db('ts',$id); if(isset($_POST['envoyer'])) { //recuperation du contenus de la liste $s=$_POST['list']; //la requet la varriabele .$mat c le code message que je recuper dans une autre requet $t="UPDATE demande SET Etat ='".$s."',user='".$_SESSION['user']."'where Codemande='".$mat ."'and Etat='ouvert'"; mysql_query($t); ?> <SCRIPT LANGUAGE="JavaScript"> document.location.href="gertest.php" </SCRIPT> <?php ;}else { ; } ?> </form> requete invalide:Erreur de syntaxe pr?s de 'and' ? la ligne 1 requete compete:SELECT s.libelle,a.Matricule,a.Nom,a.Prenom,d.Type,d.DateDemende,d.user,d.user FROM agents as a,demande as d,service as s where a.codemande=d.Codemande and a.Matricule=s.Matricule and a.Matricule='11' and s.libelle='dl' and d.DateDemende between and <?php if (isset($_POST['envoyer'])) { $id=mysql_connect('localhost','root',''); mysql_select_db('ts',$id); // lancement de la requete $sql = "SELECT s.libelle,a.Matricule,a.Nom,a.Prenom,d.Type,d.DateDemende,d.user,d.user FROM agents as a,demande as d,service as s where (a.Matricule=d.Matricule) and (a.Matricule=s.Matricule)"; if (isset($_POST['text1'])) { $sql.=" and a.Matricule='".$_POST['text1']."'";} // if (isset($_POST['list2'])) // { $sql.=" and s.libelle='".$_POST['list2']."'";} if (isset($_POST['text2'])&& isset($_POST['text3']) && $_POST['text2']!='' && $_POST['text3']!='') { $sql.=" and d.DateDemende between '".$_POST['text2']."' and'".$_POST['text3']."'";} $req = mysql_query($sql); if(!$req) { $message='requete invalide:'.mysql_error()."\n"; $message.='requete compete:'.$sql; die($message); } else{ // on recupere le resultat sous forme d'un tableau echo"service, Matricule, Nom, Prenom, Type demande, dateEnvoi de serveur, Last date, User, Etat, \"; while($data = mysql_fetch_row($req)){ echo\"---- \"; for($i=0;$i<count($data);$i++){ echo\"$data[$i], \" ;} echo\"\";} echo" " ; } }?>