<?php $_POST["nom"]=""; $_POST["region"]=""; $_POST["village"]=""; $_POST["tel"]=""; $NOM=trim($_POST["nom"]); $NOM=trim($_POST["region"]); $NOM=trim($_POST["village"]); $NOM=trim($_POST["tel"]); $color=array('#333333','#999999'); $i=0; //On se connecte à la base de donnée include("connection.php"); // on crée la requête SQL $sql = "SELECT DISTINCT questionnaire,nom,region,village,tel FROM victime "; // on envoie la requête $req = mysql_query($sql) or die('Erreur SQL ! '.$sql.' '.mysql_error()); while ($liste_etu=mysql_fetch_assoc($req)) { echo $liste_etu['nom']; echo $liste_etu['region']; echo $liste_etu['village']; echo $liste_etu['tel']; } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Document sans titre</title> </head> <form id="form1" name="form1" method="post" action=""> , </form> </html>
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question<?php if(isset($_POST['numvictime']) && !empty($_POST['numvictime'])){ include("connection.php"); $id=(int)$_POST['numvictime']; $id=mysql_real_escape_string($id); $sql = "SELECT DISTINCT questionnaire,nom,region,village,tel FROM victime where id='".$id."'"; $req = mysql_query($sql) or die('Erreur SQL ! '.$sql.' '.mysql_error()); while ($liste_etu=mysql_fetch_array($req)){ echo $liste_etu['nom']; echo $liste_etu['region']; echo $liste_etu['village']; echo $liste_etu['tel']; } }else{ //rien de demander } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Document sans titre</title> </head> <form id="form1" name="form1" method="post" action=""> Num victime : , </form> </html>
<?php if(isset($_POST['numvictime']) && !empty($_POST['numvictime'])){ include("connection.php"); $id=(int)$_POST['numvictime']; $id=mysql_real_escape_string($id); $sql = "SELECT DISTINCT questionnaire,nom,region,village,tel FROM victime where id='".$id."'"; $req = mysql_query($sql) or die('Erreur SQL ! '.$sql.' '.mysql_error()); echo ''; while ($liste_etu=mysql_fetch_array($req)){ echo '---- '; echo ''.$liste_etu['nom'].', '; echo ''.$liste_etu['region'].', '; echo ''.$liste_etu['village'].', '; echo ''.$liste_etu['tel'].', '; echo ''; } echo ' '; }else{ //rien de demander } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Document sans titre</title> </head> <form id="form1" name="form1" method="post" action=""> Num victime : , </form> </html>
<?php if(isset($_POST['questionnaire']) && !empty($_POST['questionnaire'])){ include("connection.php"); $id= (int)$_POST['questionnaire']; $id=mysql_real_escape_string($id); $sql = "SELECT DISTINCT questionnaire,nom,region,village,tel FROM victime where questionnaire='".$id."'"; $req = mysql_query($sql) or die('Erreur SQL ! '.$sql.' '.mysql_error()); } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Document sans titre</title> <style type="text/css"> <!-- .Style3 {color: #FFFFFF} .Style6 { color: #0000FF; font-style: italic; font-weight: bold; } .Style9 {color: #0000FF} --> </style> </head> <form id="form1" name="form1" method="post" action=""> Accueil, , ---- Numero du Questionnaire , </form> | , ---- NOM ET PRENOMS | REGION | VILLAGE | TEL | <?php while ($liste_etu =mysql_fetch_assoc($req)) { $j=$i%2; ?> ---- <?php echo $liste_etu['nom'] ?>, <?php echo $liste_etu['region'] ?>, <?php echo $liste_etu['village'] ?>, <?php echo $liste_etu['tel'] ?>, <?php } ?> </html>