Sujet Précédent Sujet Suivant

Ne pas afficher la recherche vide

Résolu/Fermé
Sinistrus Messages postés 1017 Date d'inscription mercredi 12 décembre 2007 Statut Membre Dernière intervention 6 juin 2023 - Modifié par Sinistrus le 19/09/2012 à 13:34
Sinistrus Messages postés 1017 Date d'inscription mercredi 12 décembre 2007 Statut Membre Dernière intervention 6 juin 2023 - 19 sept. 2012 à 16:11
Bonjour à tous !

Dans une boucle, j'affiche des imprimantes dans un tableau avec ce code : 
<?php echo $data['Printer01']; ?><br><?php echo $data['Printer02']; ?><br><?php echo $data['Printer03']; ?><br><?php echo $data['Printer04']; ?><br><?php echo $data['Printer05']; ?><br><?php echo $data['Printer06']; ?><br><?php echo $data['Printer07']; ?><br><?php echo $data['Printer08']; ?><br><?php echo $data['Printer09']; ?><br><?php echo $data['Printer10']; ?><br><?php echo $data['Printer11']; ?><br><?php echo $data['Printer12']; ?><br><?php echo $data['Printer13']; ?><br><?php echo $data['Printer14']; ?><br><?php echo $data['Printer15']; ?><br><?php echo $data['Printer16']; ?><br><?php echo $data['Printer17']; ?><br><?php echo $data['Printer18']; ?><br><?php echo $data['Printer19']; ?><br><?php echo $data['Printer20']; ?><br><?php echo $data['Printer21']; ?><br><?php echo $data['Printer22']; ?><br><?php echo $data['Printer23']; ?><br><?php echo $data['Printer24']; ?><br><?php echo $data['Printer25']; ?><br><?php echo $data['Printer26']; ?><br><?php echo $data['Printer27']; ?><br><?php echo $data['Printer28']; ?><br><?php echo $data['Printer29']; ?><br><?php echo $data['Printer30']; ?><br><?php echo $data['Printer31']; ?><br><?php echo $data['Printer32']; ?><br><?php echo $data['Printer33']; ?><br><?php echo $data['Printer34']; ?><br><?php echo $data['Printer35']; ?><br><?php echo $data['Printer36']; ?><br><?php echo $data['Printer37']; ?><br><?php echo $data['Printer38']; ?><br><?php echo $data['Printer39']; ?><br><?php echo $data['Printer40']; ?><br><?php echo $data['Printer41']; ?><br><?php echo $data['Printer42']; ?><br><?php echo $data['Printer43']; ?><br><?php echo $data['Printer44']; ?><br><?php echo $data['Printer45']; ?><br><?php echo $data['Printer46']; ?><br><?php echo $data['Printer47']; ?><br><?php echo $data['Printer48']; ?><br><?php echo $data['Printer49']; ?><br><?php echo $data['Printer50']; ?><br><?php echo $data['Printer51']; ?><br><?php echo $data['Printer52']; ?><br><?php echo $data['Printer53']; ?><br><?php echo $data['Printer54']; ?><br><?php echo $data['Printer55']; ?><br><?php echo $data['Printer56']; ?><br><?php echo $data['Printer57']; ?><br><?php echo $data['Printer58']; ?><br><?php echo $data['Printer59']; ?><br><?php echo $data['Printer60']; ?><br><?php echo $data['Printer61']; ?><br><?php echo $data['Printer62']; ?><br><?php echo $data['Printer63']; ?><br><?php echo $data['Printer64']; ?><br><?php echo $data['Printer65']; ?><br><?php echo $data['Printer66']; ?><br><?php echo $data['Printer67']; ?><br><?php echo $data['Printer68']; ?><br><?php echo $data['Printer69']; ?><br><?php echo $data['Printer70']; ?>


Voici ma requete 
<?php
$req = mysql_query("SELECT * FROM Ink_Search ORDER BY Reference;");
$ligne=0;
while($data = mysql_fetch_assoc($req)){
$NumId 			= $data["NumId"];
$Identifiant 	= $data["Reference"];
?>


J'aimerais que lorsque dans la base de donnée le champ est vide, il ne me met pas dans le tableau un espace <br>.

Pouvez-vous m'aider svp ?

3 réponses

Réponse 1 / 3
Alain_42 Messages postés 5361 Date d'inscription dimanche 3 février 2008 Statut Membre Dernière intervention 13 février 2017 894
19 sept. 2012 à 14:54
ou en beaucoup plus court avec une boucle: 

<?php 
for ($p=1;$p<=70;$p++){
	if($p<10){$champ="Printer0".$p;}else{$champ="Printer".$p;}
	if (!empty($data[$champ])) {echo $data[$champ] ."<br />";}
}
 ?>
1
Réponse 2 / 3
Sinistrus Messages postés 1017 Date d'inscription mercredi 12 décembre 2007 Statut Membre Dernière intervention 6 juin 2023 17
19 sept. 2012 à 14:09
J'ai trouvé !!! (et tout seule hihi :p) 

<?php if (!empty($data["Printer01"])) {echo $data["Printer01"] ."<br>";} ?>
            <?php if (!empty($data["Printer02"])) {echo $data["Printer02"] ."<br>";} ?>
            <?php if (!empty($data["Printer03"])) {echo $data["Printer03"] ."<br>";} ?>
            <?php if (!empty($data["Printer04"])) {echo $data["Printer04"] ."<br>";} ?>
            <?php if (!empty($data["Printer05"])) {echo $data["Printer05"] ."<br>";} ?>
            <?php if (!empty($data["Printer06"])) {echo $data["Printer06"] ."<br>";} ?>
            <?php if (!empty($data["Printer07"])) {echo $data["Printer07"] ."<br>";} ?>
            <?php if (!empty($data["Printer08"])) {echo $data["Printer08"] ."<br>";} ?>
            <?php if (!empty($data["Printer09"])) {echo $data["Printer09"] ."<br>";} ?>
            <?php if (!empty($data["Printer10"])) {echo $data["Printer10"] ."<br>";} ?>
            <?php if (!empty($data["Printer11"])) {echo $data["Printer11"] ."<br>";} ?>
            <?php if (!empty($data["Printer12"])) {echo $data["Printer12"] ."<br>";} ?>
            <?php if (!empty($data["Printer13"])) {echo $data["Printer13"] ."<br>";} ?>
            <?php if (!empty($data["Printer14"])) {echo $data["Printer14"] ."<br>";} ?>
            <?php if (!empty($data["Printer15"])) {echo $data["Printer15"] ."<br>";} ?>
            <?php if (!empty($data["Printer16"])) {echo $data["Printer16"] ."<br>";} ?>
            <?php if (!empty($data["Printer17"])) {echo $data["Printer17"] ."<br>";} ?>
            <?php if (!empty($data["Printer18"])) {echo $data["Printer18"] ."<br>";} ?>
            <?php if (!empty($data["Printer19"])) {echo $data["Printer19"] ."<br>";} ?>
            <?php if (!empty($data["Printer20"])) {echo $data["Printer20"] ."<br>";} ?>
            <?php if (!empty($data["Printer21"])) {echo $data["Printer21"] ."<br>";} ?>
            <?php if (!empty($data["Printer22"])) {echo $data["Printer22"] ."<br>";} ?>
            <?php if (!empty($data["Printer23"])) {echo $data["Printer23"] ."<br>";} ?>
            <?php if (!empty($data["Printer24"])) {echo $data["Printer24"] ."<br>";} ?>
            <?php if (!empty($data["Printer25"])) {echo $data["Printer25"] ."<br>";} ?>
            <?php if (!empty($data["Printer26"])) {echo $data["Printer26"] ."<br>";} ?>
            <?php if (!empty($data["Printer27"])) {echo $data["Printer27"] ."<br>";} ?>
            <?php if (!empty($data["Printer28"])) {echo $data["Printer28"] ."<br>";} ?>
            <?php if (!empty($data["Printer29"])) {echo $data["Printer29"] ."<br>";} ?>
            <?php if (!empty($data["Printer30"])) {echo $data["Printer30"] ."<br>";} ?>
            <?php if (!empty($data["Printer31"])) {echo $data["Printer31"] ."<br>";} ?>
            <?php if (!empty($data["Printer32"])) {echo $data["Printer32"] ."<br>";} ?>
            <?php if (!empty($data["Printer33"])) {echo $data["Printer33"] ."<br>";} ?>
            <?php if (!empty($data["Printer34"])) {echo $data["Printer34"] ."<br>";} ?>
            <?php if (!empty($data["Printer35"])) {echo $data["Printer35"] ."<br>";} ?>
            <?php if (!empty($data["Printer36"])) {echo $data["Printer36"] ."<br>";} ?>
            <?php if (!empty($data["Printer37"])) {echo $data["Printer37"] ."<br>";} ?>
            <?php if (!empty($data["Printer38"])) {echo $data["Printer38"] ."<br>";} ?>
            <?php if (!empty($data["Printer39"])) {echo $data["Printer39"] ."<br>";} ?>
            <?php if (!empty($data["Printer40"])) {echo $data["Printer40"] ."<br>";} ?>
            <?php if (!empty($data["Printer41"])) {echo $data["Printer41"] ."<br>";} ?>
            <?php if (!empty($data["Printer42"])) {echo $data["Printer42"] ."<br>";} ?>
            <?php if (!empty($data["Printer43"])) {echo $data["Printer43"] ."<br>";} ?>
            <?php if (!empty($data["Printer44"])) {echo $data["Printer44"] ."<br>";} ?>
            <?php if (!empty($data["Printer45"])) {echo $data["Printer45"] ."<br>";} ?>
            <?php if (!empty($data["Printer46"])) {echo $data["Printer46"] ."<br>";} ?>
            <?php if (!empty($data["Printer47"])) {echo $data["Printer47"] ."<br>";} ?>
            <?php if (!empty($data["Printer48"])) {echo $data["Printer48"] ."<br>";} ?>
            <?php if (!empty($data["Printer49"])) {echo $data["Printer49"] ."<br>";} ?>
            <?php if (!empty($data["Printer50"])) {echo $data["Printer50"] ."<br>";} ?>
            <?php if (!empty($data["Printer51"])) {echo $data["Printer51"] ."<br>";} ?>
            <?php if (!empty($data["Printer52"])) {echo $data["Printer52"] ."<br>";} ?>
            <?php if (!empty($data["Printer53"])) {echo $data["Printer53"] ."<br>";} ?>
            <?php if (!empty($data["Printer54"])) {echo $data["Printer54"] ."<br>";} ?>
            <?php if (!empty($data["Printer55"])) {echo $data["Printer55"] ."<br>";} ?>
            <?php if (!empty($data["Printer56"])) {echo $data["Printer56"] ."<br>";} ?>
            <?php if (!empty($data["Printer57"])) {echo $data["Printer57"] ."<br>";} ?>
            <?php if (!empty($data["Printer58"])) {echo $data["Printer58"] ."<br>";} ?>
            <?php if (!empty($data["Printer59"])) {echo $data["Printer59"] ."<br>";} ?>
            <?php if (!empty($data["Printer60"])) {echo $data["Printer60"] ."<br>";} ?>
            <?php if (!empty($data["Printer61"])) {echo $data["Printer61"] ."<br>";} ?>
            <?php if (!empty($data["Printer62"])) {echo $data["Printer62"] ."<br>";} ?>
            <?php if (!empty($data["Printer63"])) {echo $data["Printer63"] ."<br>";} ?>
            <?php if (!empty($data["Printer64"])) {echo $data["Printer64"] ."<br>";} ?>
            <?php if (!empty($data["Printer65"])) {echo $data["Printer65"] ."<br>";} ?>
            <?php if (!empty($data["Printer66"])) {echo $data["Printer66"] ."<br>";} ?>
            <?php if (!empty($data["Printer67"])) {echo $data["Printer67"] ."<br>";} ?>
            <?php if (!empty($data["Printer68"])) {echo $data["Printer68"] ."<br>";} ?>
            <?php if (!empty($data["Printer69"])) {echo $data["Printer69"] ."<br>";} ?>
            <?php if (!empty($data["Printer70"])) {echo $data["Printer70"] ."<br>";} ?>
0
Réponse 3 / 3
Sinistrus Messages postés 1017 Date d'inscription mercredi 12 décembre 2007 Statut Membre Dernière intervention 6 juin 2023 17
19 sept. 2012 à 16:11
Waw ! Mais ce que ça facilite !!!

Merci Alain_42 !
0

Discussions similaires

Comment faire le symbole coeur vide/coeur blanc
Paria -
2008G.C -

60 réponses
le frigo ne marche pas....
Nemo6456 -
Templier Nocturne -

1 réponse
programme qui n'affiche pas le mot secret
EMy.chev -
yg_be -

3 réponses
[référencement] Ne pas être référencé
kij_82 -
Searaphina -

10 réponses
Formaté mais pas de connexion Internet ?
VissErale -
VissErale -

4 réponses