Affichage de donnees depuis mysql en php html

**gator** · 19/01/2010, 15h35

Bonjour à tous,

Je rencontre le problème suivant :

J'ai une page appelée show.php qui affiche le détail d'un véhicule, avec les images, description... Et les options : Visible à cette adresse

Si vous regardez dans les options, il n' en as que 5 d'affichées, et ce que je coches 5, 10 ou 20 Options, seuls 5 apparaissent:

* peinture métalisé * garantie constructeur * possibilité d'extension
* 2 Portes laterales et * Projecteurs bi-Xenon

Mon probéme est le suivant :
Depuis mon administration, j'ai coché 15 cases, Je devrais donc avoir Une quinzaine d'options affichées.

Dans mon administration, quand je cliques sur le véhicule, l'affichage est nickel, et je retrouve toutes mes options, qui sont bien stockées dans ma base !

Mais dans mon fichier show.php, nada, que 5 options d'affichées

Encore plus étrange, j'ai remonté ce script à un autre endroit visible a cet adresse

ET LA VOUS ALLEZ HALLUCINER !

Même en échangeant les fichiers show.php, sur ns 38 ca fonctionne et l'autre site non !

Alors, ou est mon problème ? Je cherches, je tournes et je ne trouves rien !!!
Si quelqu'un a une idée, je la prends bien volontiers !!!

Voici le code :

Je suis vert!

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
<?php require 'modules/module-initialize.php'; ?>
<!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> <?php if($row[model_year]) echo $row[model_year]." "; echo " A saisir ".$row['make']." ".$row['model']." ".$row['mileage']." kilométres "; ?></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta name="description" content="Occasions récentes multimarques à prix discount en provenance directe de notre centrale.Audi, Bmw,Ford,Opel,Mercedes..." />
<meta name="keywords" content="voiture,occasion,voiture d'occasion,négociant,direct;centrale,discount,auto,vn, vo,audi,bmw,ford,opel,mercedes,porsche" />
	<meta content="index,follow" name="robots" />
<meta content="INDEX, FOLLOW" name="GOOGLEBOT" />
<meta content="2 days" name="revisit-after" />
<meta content="Internet" name="document-classification" />
<meta content="Public" name="document-type" />
<base href="http://www.unevoiture.fr/occasion/"/> 
<script type='text/javascript'></script>
<link href="style/style.css" rel="stylesheet" type="text/css" />
<script type='text/javascript'>
function swap(target, fname) {
	document[target].src = "images/" + fname;
}
function new_window(src, width, height) {
	window.open(src, '', "width=" + width + ",height=" + height + ",scrollbars=yes");
}
</script>
</head>
<body style="background-image: url(images/bodybg.gif); background-repeat: repeat-x;">
<table width="930" border="0" align="center" cellpadding="0" cellspacing="0" height="100%">
  <tr>
    <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
	<tr>
        <td width="36%" height="61"><a href="http://www.unevoiture.fr/occasion/"><img alt="Unevoiture.fr" hspace="20" src="images/logo.jpg" border=0 /></a></td>
        <td width="37%" align="center"></td>
        <td width="28%" align="right" valign="top"><a href="http://www.unevoiture.fr/occasion/" title="Accueil"><img alt="Home" src="images/home-icon.gif" width="32" height="20" border="0" /></a> <a href="http://www.unevoiture.fr/occasion/content/sitemap/" title="Site Map"><img alt="Site Map" src="images/sitemap-icon.gif" border="0" /></a> <a href="http://www.unevoiture.fr/occasion/nous_contacter.php" title="Contact"><img alt="Contact" src="images/contact-icon.gif" border="0" /></a> &nbsp;</td>
  </tr>
      <tr>
        <td height="27" colspan="3">
		<div>
			<ul id="top-tabstrips">
											<li><a href="http://www.unevoiture.fr/occasion/"  class="current" title="Accueil"><EM>Accueil</EM></a></li>
																																																									<li><a href="http://www.unevoiture.fr/occasion/listings.php"  title="Acheter"><EM>Acheter</EM></a></li>
 
															<li><a href="http://www.unevoiture.fr/occasion/search.php"  title="Rechercher"><EM>Rechercher</EM></a></li>
 
															<li><a href="http://www.unevoiture.fr/occasion/admin/"  title="Login"><EM>Identifiez-vous</EM></a></li>
                                                            </ul>
		</div>	   </td>
      </tr>
      <tr>
        <td height="28" colspan="2">
																			<img src="http://www.unevoiture.fr/occasion/images/arrow.gif" width="7" height="7" class="arrow-padding" />
					<a href="http://www.unevoiture.fr/occasion/societe.php" class="topnav-link" title="Une voiture.fr">Qui sommes nous ?</a>																<img src="http://www.unevoiture.fr/occasion/images/arrow.gif" width="7" height="7" class="arrow-padding" />
										<a href="http://www.unevoiture.fr/occasion/faq.php" class="topnav-link" title="FAQ">FAQ</a>																<img src="http://www.unevoiture.fr/occasion/images/arrow.gif" width="7" height="7" class="arrow-padding" />
					<a href="http://www.unevoiture.fr/occasion/fonctionnement.php" class="topnav-link" title="Comment ca marche ?">Comment ca marche ?</a>																<img src="http://www.unevoiture.fr/occasion/images/arrow.gif" width="7" height="7" class="arrow-padding" />
					<a href="http://www.unevoiture.fr/occasion/nous_contacter.php" class="topnav-link" title="Nous contacter">Nous contacter</a>																																																																																																											</td>
        <td class="searchbg"><img align="absmiddle" src="images/search-leftcorner.gif" width="29" height="28" /> ?&gt;&gt; 
          <input value="" name="keyword" id="keyword" type="text" class="INPUT" size="18" />
          <!--<a href="javascript://" onclick="return searchItem('','');"  title="GO"><img src="http://www.unevoiture.fr/occasion/images/btn-go.gif" width="29" height="15" border="0" align="absmiddle" /></a>  --> <input type="submit" name="Submit" onclick="return searchItem('','');"  title="GO" class="go-buttonbg" value="GO" />          </td>
      </tr>
      <tr>
        <td colspan="3"><img src="http://www.unevoiture.fr/occasion/images/spacer.gif" width="1" height="1" /></td>
        </tr>
    </table>
</td>
  </tr>
    <tr><td>&nbsp;</td></tr>
    <tr>
    <td height="4"><img src="http://www.unevoiture.fr/occasion/images/spacer.gif" width="1" height="1" /></td>
  </tr>
   <tr>
    <td>
		 <table width="100%" border="0" cellspacing="0" cellpadding="0">
	       <tr>
	        <td width="182" valign="top"><script type="text/javascript" src="js/jgetVehicleDetail.js"></script>
<script type="text/javascript" src="js/tooltip_data.js"></script>
<script>
	var admin_url = 'http://www.unevoiture.fr/occasion/gsapanel/';
</script>
<link rel="stylesheet" type="text/css" href="style/tooltip.css">
<link rel="stylesheet" type="text/css" href="style/style-div.css">
 
<table width="100%" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td class="gray-table-border">
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td class="gray-table-border"><table class="leftlink" width="100%" border="0" cellspacing="0" cellpadding="1">
              <tr>
                <td colspan="2"><h1>Quick liens</h1></td>
              </tr>
              <tr>
                <td width="17%" align="center"><img src="http://www.unevoiture.fr/occasion/images/newarrival-icon.gif" /> </td>
                <td width="83%"><a href="http://www.unevoiture.fr/occasion/listings.php?category=&make=&model=&srt=added+DESC&p=10&submit=Rechercher" title="Les arrivages">Les ARRIVAGES !</a></td>
              </tr>
              <tr>
                <td colspan="2" class="dottedline-hr" height="3"><img src="http://www.unevoiture.fr/occasion/images/spacer.gif" width="1" height="1" /></td>
              </tr>
<!--               <tr>
                <td width="17%" align="center"><img src="http://www.unevoiture.fr/occasion/images/dealerdirectory-icon.gif" /></td>
                <td width="83%"><a href="#">Dealers Directory</a></td>
              </tr>
               <tr>
                <td colspan="2" class="dottedline-hr" height="3"><img src="http://www.unevoiture.fr/occasion/images/spacer.gif" width="1" height="1" /></td>
              </tr>
 -->              <tr>
                <td width="17%" align="center"><img src="http://www.unevoiture.fr/occasion/images/icone-excel.jpg" /> </td>
 
                <td width="83%"><a href="http://www.unevoiture.fr/occasion/admin/cp-list-export.php" title="Telecharger le Listing">Telecharger le Listing</a></td>
              </tr>
              <tr>
                <td colspan="2" class="dottedline-hr" height="3"><img src="http://www.unevoiture.fr/occasion/images/spacer.gif" width="1" height="1" /></td>
              </tr>
			  <!-- <tr >
                <td width="17%" align="center"><img src="http://www.unevoiture.fr/occasion/images/reviews-icon.gif" /> </td>
                <td width="83%"><a href="content/reviews/" title="Reviews">Reviews</a></td>
              </tr>
              <tr>
                <td colspan="2" class="dottedline-hr" height="3"><img src="http://www.unevoiture.fr/occasion/images/spacer.gif" width="1" height="1" /></td>
              </tr> -->
			  <tr >
                <td width="17%" align="center"><img src="http://www.unevoiture.fr/occasion/images/advancedsearch-icon.gif" /> </td>
                <td width="83%"><a href="http://www.unevoiture.fr/occasion/search.php" title="Recherche avanc&eacute;e">Recherche avanc&eacute;e</a></td>
              </tr>
             <!--  <tr>
                <td colspan="2" class="dottedline-hr" height="3"><img src="http://www.unevoiture.fr/occasion/images/spacer.gif" width="1" height="1" /></td>
              </tr>
			  <tr >
                <td width="17%" align="center"><img src="http://www.unevoiture.fr/occasion/images/testimonial-icon.gif" /> </td>
                <td width="83%"><a href="http://www.unevoiture.fr/occasion/content/testimonials/" title="Testimonials">Testimonials</a></td>
              </tr> -->
              <tr>
                <td colspan="2" class="dottedline-hr" height="3"><img src="http://www.unevoiture.fr/occasion/images/spacer.gif" width="1" height="1" /></td>
              </tr>
			              </table>
                          </td>
          </tr>
          <tr>
            <td height="4"><img src="http://www.unevoiture.fr/occasion/images/spacer.gif" width="1" height="1" /></td>
          </tr>
          <tr>
            <td class="gray-table-border"><table class="vehicle-link" width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td colspan="2"><h1>Par<span> Categorie</span></td>
              </tr>
			  <tr>
              <td width="50%" height="50" align="center" valign="top" >
							<a href="http://www.unevoiture.fr/occasion/listings.php?category=Coup%E9-Cabriolet&make=&model=&srt=make+ASC&p=10&submit=Rechercher"><img title="Voir les coupés & cabriolets" alt="Voir les coupés & cabriolets" src="http://www.unevoiture.fr/occasion/images/types_vehicules/sportive.gif"/></a>						</td>
											                        <td width="50%" height="50" align="center" valign="top" >
							<a href="http://www.unevoiture.fr/occasion/listings.php?category=Berline&make=&model=&srt=make+ASC&p=10&submit=Rechercher">
							<img title="Voir les Berlines" alt="Voir les Berlines" src="http://www.unevoiture.fr/occasion/images/types_vehicules/berline.gif" border="0" id="vehicletype_2" /></a>						</td>
					</tr><Tr>
											                        <td width="50%" height="50" align="center" valign="top" >
							<a href="http://www.unevoiture.fr/occasion/listings.php?category=4X4&make=&model=&srt=make+ASC&p=10&submit=Rechercher"><img title="Voir les 4x4 & SUV" alt="Voir les 4x4 & SUV" src="http://www.unevoiture.fr/occasion/images/types_vehicules/suv.gif"/></a>						</td>
											                        <td width="50%" height="50" align="center" valign="top" >
<a href="http://www.unevoiture.fr/occasion/listings.php?category=Monospace&make=&model=&srt=make+ASC&p=10&submit=Rechercher"><img title="Voir les monospaces" alt="Voir les monospaces" src="http://www.unevoiture.fr/occasion/images/types_vehicules/monospace.gif" border="0" id="vehicletype_4" /></a>					</td>
</tr><Tr>
											                        <td width="50%" height="50" align="center" valign="top" >
							<a href="http://www.unevoiture.fr/occasion/listings.php?category=Luxe&make=&model=&srt=make+ASC&p=10&submit=Rechercher"><img title="Voir les voitures de luxe" alt="Voir les voitures de luxe" src="http://www.unevoiture.fr/occasion/images/types_vehicules/luxe.gif"/></a>						</td>
											                        <td width="50%" height="50" align="center" valign="top" >
							<a href="http://www.unevoiture.fr/occasion/listings.php?category=Pick-Up&make=&model=&srt=make+ASC&p=10&submit=Rechercher"><img title="Voir les Pick-Up" alt="Voir les Pick-Up" src="http://www.unevoiture.fr/occasion/images/types_vehicules/pick-up.gif"/></a>						</td>
													</tr>
            </table></td>
          </tr>
          <tr>
            <td height="4"><img src="http://www.unevoiture.fr/occasion/images/spacer.gif" width="1" height="1" /></td>
          </tr>
		            <tr>
			<td class="gray-table-border dealername"><h1>Par<span> Marque</span></h1> <ul>
 
 
							  	<li><span class="omatternormal"><a class="omatternormal" href="http://www.unevoiture.fr/occasion/index.php?category=&make=ALFA&model=&srt=make+ASC&p=10&submit=Rechercher">ALFA ROMEO</a>
				</span></li>
 
                <li><span class="omatternormal">
					<a class="omatternormal" href="http://www.unevoiture.fr/occasion/index.php?category=&make=AUDI&model=&srt=make+ASC&p=10&submit=Rechercher">AUDI</a>
</span></li>
 
 
							  	<li><span class="omatternormal">
					<a class="omatternormal" href="http://www.unevoiture.fr/occasion/index.php?category=&make=BMW&model=&srt=make+ASC&p=10&submit=Rechercher">BMW</a>
				</span></li>
 
 
							  	<li><span class="omatternormal">
					<a class="omatternormal" href="http://www.unevoiture.fr/occasion/index.php?category=&make=CITROEN&model=&srt=make+ASC&p=10&submit=Rechercher">CITROEN</a>
				</span></li>
 
 
							  	<li><span class="omatternormal">
					<a class="omatternormal" href="http://www.unevoiture.fr/occasion/index.php?category=&make=FIAT&model=&srt=make+ASC&p=10&submit=Rechercher">FIAT</a>
				</span></li>
 
 
							  	<li><span class="omatternormal">
					<a class="omatternormal" href="http://www.unevoiture.fr/occasion/index.php?category=&make=FORD&model=&srt=make+ASC&p=10&submit=Rechercher">FORD</a>
				</span></li>
 
 
							  	<li><span class="omatternormal">
					<a class="omatternormal" href="http://www.unevoiture.fr/occasion/index.php?category=&make=KIA&model=&srt=make+ASC&p=10&submit=Rechercher">KIA</a>
				</span></li>
 
                <li><span class="omatternormal">
					<a class="omatternormal" href="http://www.unevoiture.fr/occasion/index.php?category=&make=MERCEDES&model=&srt=make+ASC&p=10&submit=Rechercher">MERCEDES</a>
</span></li>
 
 
							  	<li><span class="omatternormal">
					<a class="omatternormal" href="http://www.unevoiture.fr/occasion/index.php?category=&make=OPEL&model=&srt=make+ASC&p=10&submit=Rechercher">OPEL</a>
				</span></li>
 
 
							  	<li><span class="omatternormal">
					<a class="omatternormal" href="http://www.unevoiture.fr/occasion/index.php?category=&make=PEUGEOT&model=&srt=make+ASC&p=10&submit=Rechercher">PEUGEOT</a>
				</span></li>
 
 
							  	<li><span class="omatternormal">
					<a class="omatternormal" href="http://www.unevoiture.fr/occasion/index.php?category=&make=RENAULT&model=&srt=make+ASC&p=10&submit=Rechercher">RENAULT</a>
				</span></li>
 
                <li><span class="omatternormal">
					<a class="omatternormal" href="http://www.unevoiture.fr/occasion/index.php?category=&make=VOLKSWAGEN&model=&srt=make+ASC&p=10&submit=Rechercher">VOLKSWAGEN</a>
				</span></li>	  						
 
 
				  </ul>
 
			  <div align="right"><img src="http://www.unevoiture.fr/occasion/images/more-arrow.gif" width="3" height="8" /></div>		  		</td>
          </tr>
		             <tr>
            <td height="4"><img src="http://www.unevoiture.fr/occasion/images/spacer.gif" width="1" height="1" /></td>
          </tr>
		             <tr></td>
          </tr>
 
	          </table></td>
          </tr>
          <tr>
            <td height="4"><img src="http://www.unevoiture.fr/occasion/images/spacer.gif" width="1" height="1" /></td>
          </tr>
          <tr>
            <td class="gray-table-border">&nbsp;</td>
          </tr>
          <tr>
            <td height="4"><img src="http://www.unevoiture.fr/occasion/images/spacer.gif" width="1" height="1" /></td>
          </tr>
		             <tr>
		               <td height="4"><img src="http://www.unevoiture.fr/occasion/images/spacer.gif" width="1" height="1" /></td>
              </tr>
 
	          </table>
<div id="tooltip" style="position:absolute;display:block;visibility:none;" ></div></td>
	        <td width="6"><img src="http://www.unevoiture.fr/occasion/images/spacer.gif" width="1" height="1" /></td>
			<Td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
			  <tr>
			    <td height="30" class="midd-gradient">details du <span>vehicule</span></td>
		      </tr>
			  <tr>
			    <td height="2"><img src="images/spacer.gif" alt="" width="1" height="1" /></td>
		      </tr>
			  <tr>
 
		      </tr>
			</table>
			  <table width="100%" border="0" cellspacing="0" cellpadding="0" height="100%">
	            </table>
			  <table width="100%" border="0" cellspacing="0" cellpadding="0" height="100%">
			    <tr>
			      <td class="midd-contnet-border"><?php require 'modules/module-show.php'; ?></td>
           </tr>
		      </table>
              <table width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td height="30" class="midd-gradient"><div class='right'> <a href='listings.php?<?php echo $pass_vars; ?>'>&lt;&lt; Retour au stock</a> <strong> +
      <?php if($row[link_url]) echo "<a href='$row[link_url]' target='_blank'>$row[link_text]</a>&nbsp;&nbsp;-&nbsp;"; ?>
      <a href="javascript:new_window('friend.php?id=<?php echo $_GET[id]; ?>', '700', '500');">Envoyer &agrave; un ami</a>&nbsp;&nbsp;+&nbsp; <a href="javascript:new_window('contact.php?id=<?php echo $_GET[id]; ?>', '700', '500');">Nous contacter</a>&nbsp;&nbsp;+&nbsp; <a href="javascript:new_window('print.php?id=<?php echo $_GET[id]; ?>', '700', '500');">Imprimer la fiche</a> </div>    </tr>
</table></td>
		      </table></td>
  </tr>
			  <tr>
			    <td height="5"></td>
		      </tr>
			  <tr>
			    <td height="162" align="center"><table width="100%" border="0" cellspacing="0" cellpadding="0">
			      <tr>
			        <td colspan="3" align="center">Une voiture.fr vous propose des listes de v&eacute;hicules de toutes marques, en provenance de grandes soci&eacute;t&eacute;s francaises. Nos listes sont actualis&eacute;es tous les jours. Si un v&eacute;hicule venait &agrave; manquer, venez nous rendre visite le jour suivant, il y a de fortes chances pour qu'il s'y trouve !</td>
		          </tr>
			      <tr>
			        <td width="5"><img src="http://www.unevoiture.fr/occasion/images/bott-leftcorner.gif" alt="" width="5" height="24" /></td>
			        <td width="100%" align="center" class="bott-cornerbg"><p><a href="http://www.unevoiture.fr/occasion/" class="bottlink" title="Accueil">Accueil</a>  |  <a href="http://www.unevoiture.fr/occasion/search.php" class="bottlink" title="Rechercher">Rechercher</a> | <a href="http://www.unevoiture.fr/occasion/societe.php" class="bottlink" title="Qui sommes nous ?">Qui sommes nous ?</a> | <a href="http://www.unevoiture.fr/occasion/nous_contacter.php" class="bottlink" title="Nous contacter">Nous contacter</a></p></td>
			        <td width="5"><img src="http://www.unevoiture.fr/occasion/images/bott-rightcorner.gif" alt="" width="5" height="24" /></td>
		          </tr>
			      <tr>
			        <td height="30" colspan="3" align="center" class="copyright">&copy; 2009 Unevoiture.fr, Tous droits r&eacute;serv&eacute;s. <a href="http://www.unevoiture.fr/occasion/conditions_generales.php" class="omatterlink" title="Conditions g&eacute;n&eacute;rales">Conditions g&eacute;n&eacute;rales</a> | <a href="http://www.unevoiture.fr/occasion/vie_privee.php" class="omatterlink" title="Vie priv&eacute;e">Vie priv&eacute;e</a></td>
		          </tr>
		        </table></td>
		      </tr>
		     </table></BR></TD>
  </tr>
	 </table>
		</td>
  </tr>
  <tr>
    <td height="5"><img src="http://www.unevoiture.fr/occasion/images/spacer.gif" width="1" height="1" /></td>
  </tr>
   <tr>
        <td class="graybg" height="3"><img src="http://www.unevoiture.fr/occasion/images/spacer.gif" width="1" height="1" /></td>
  </tr>
  <tr>
    <td><img src="http://www.unevoiture.fr/occasion/images/spacer.gif" width="1" height="1" /></td>
  </tr>
  <tr>    <td><script src="http://www.google-analytics.com/ga.js" type="text/javascript"></script>
	<script type="text/javascript">
		var pageTracker = _gat._getTracker("UA-sdd8269-3");
		pageTracker._initData();
		pageTracker._trackPageview();
	</script>
	</td>
  </tr>
</table>
</body>
</html>

Merci

**Vil'Coyote** · 26/01/2010, 10h18

j'aurais tendance à dire que si cela marche en admin et pas en front c'est que le choix n'est pas stocké en base de données ou pas lus.

Pourrais tu indiquer le code php complet stp de tes différente page car on peut voir un include d'module-initialize.php mais aussi module-show.php je pencherais pour surtout module-show.php

**gator** · 27/01/2010, 11h49

Salut,
Tout d'abord, merci de te pencher sur rmon cas, je commences a déprimer sévére.

Voici le code du module show

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
 
<table class='display' width='680' border='0' cellpadding='0' cellspacing='0'>
	<tr>
		<td width='390' valign='top'>
			<?php
			//echo "<br>".$row['images'];
			if($row['images']) {
				if($row['images'] > 0) echo "<img class='none' name='large' src='images/".$image_set[0]."' alt=''/>";
 
				/*$qry2=mysql_query ("SELECT id,fname FROM $dbimgs WHERE listid='".mysql_real_escape_string($row['id'])."' limit 1", $link);
				if (!mysql_num_rows($qry2)==0){	//if image exists do nothing
					
				}else{}*/
				// if there is more than one image, display the others as thumbnails
				if($row['images'] > 0) {
					echo "<table border='0' cellpadding='0' cellspacing='0'>";
					echo "<tr>";
					$n = 1;
					foreach($image_set as $image) {
						echo "<td style='padding-top:10px;' width='130' valign='top'>";
						echo "<a href=\"javascript:swap('large', '$image');\"><img class='none' src='thumbs/$image' alt=''/></a>";
						echo "</td>";
						if(!($n % 3) && $n < count($image_set)) echo "</tr><tr>";
						$n++;
					}
 
					echo "</tr>";
					echo "</table>";
					echo "<p style='margin-top:10px;'>Cliquez sur les vignettes pour les agrandir.</p>";
				}
			}else{
				echo "<img src='common/no-photo-large.jpg' alt=''/>";//no-photo-large.jpg
			}
			?>
		</td>
		<td width='20'><div style='width:20px;'></div></td>
		<td width='270' valign='top'>
			<table class='info' width='270' border='0' cellpadding='0' cellspacing='0'>
				<?php
 
				// general information
				echo "<tr><td class='title' colspan='2'>";
				echo "<tr><td class='title' colspan='2'>";
				if($row['model_year']) echo $row['model_year']." ";
				echo $row['make']." ".$row['model']."</td></tr>";
				echo "<tr><td class='label'>Société:</td><td>".$location['name']."</td></tr>";
 
				echo "<tr><td>Statut:</td><td>";
				if($row['status'] == 2) echo "<span class='alert'>".$status[$row['status']]."</span>";
				elseif($row['status'] == 3) echo "<span class='error'>".$status[$row['status']]."</span>";
				else echo $status[$row['status']];
				echo "</td></tr>";
 
				if($row['stock']) echo "<tr><td>N° de stock:</td><td>$row[stock]</td></tr>";
				if($row['vin']) echo "<tr><td>$conf[vin]:</td><td>$row[vin]</td></tr>";
				if($row['cond']) echo "<tr><td>Condition:</td><td>$row[cond]</td></tr>";
				if($row['mileage_alt']) echo "<tr><td>Kms:</td><td>$row[mileage_alt]</td></tr>";
				elseif($row['mileage']) echo "<tr><td>$conf[units]:</td><td>".number_format($row[mileage])." $conf[units]</td></tr>";
 
				if($row['ebay_url']) echo "<tr><td>Prix:</td><td><a href='$row[ebay_url]' target='_blank'><img class='none' src='common/ebay-logo.gif'/></a></td></tr>";
				elseif($row['price'])	echo "<tr><td>Prix:</td><td>".$conf[currency].number_format($row[price])."</td></tr>";
				elseif($row['price_alt']) echo "<tr><td>Prix:</td><td>$row[price_alt]</td></tr>";
				else echo "<tr><td>Price:</td><td>Nous contacter</td></tr>";
				if($row['sale']) echo "<tr><td>Prix promo:</td><td><span class='success'>".$conf[currency].number_format($row[sale])."</span></td></tr>";
 
				// dealership information
				if($conf['show_dealer']) {
 
					echo "<tr><td colspan='2'><hr/></td></tr>";
 
					echo "<tr><td>Société:</td><td>$location[name]</td></tr>";
					echo "<tr><td>Adresse Email:</td><td><a href=\"javascript:new_window('contact.php?id=$_GET[id]&mode=dealer', '700', '500');\">Contacter la société</a></td></tr>";
					if($location[url]) echo "<tr><td>Site Web:</td><td><a href='$location[url]' target='_blank'>Visiter le site</a></td></tr>";
					if($location[phone]) echo "<tr><td>Téléphone:</td><td>$location[phone]</td></tr>";
					if($location[fax]) echo "<tr><td>Fax:</td><td>$location[fax]</td></tr>";
 
					if($location[address]) {
						echo "<tr>";
						echo "<td class='label'>Adresse:</td>";
						echo "<td>";
						echo $location[address]."<br/>";
						if($location[address2]) echo $location[address2]."<br/>";
						if($location[zip]) echo $location[zip]."  --  ";
						if($location[city]) echo $location[city];
						if($location[city] || $location[state]) echo "<br/>";
						if($location[country]) echo $location[country];
						echo "</td>";
						echo "</tr>";
					}
				}
 
				// salesperson information
				if($user[contact]) {
 
					echo "<tr><td colspan='2'><hr/></td></tr>";
 
					echo "<tr><td>Contact:</td><td>$user[name]</td></tr>";
					echo "<tr><td>Adresse Email:</td><td><a href=\"javascript:new_window('contact.php?id=$_GET[id]&mode=sales', '700', '500');\">Ecrire au vendeur</a></td></tr>";
					if($user[phone]) echo "<tr><td>Téléphone:</td><td>$user[phone]</td></tr>";
 
				}
 
				echo "<tr><td colspan='2'><hr/></td></tr>";
 
				// additional details
				if($row['exterior']) echo "<tr><td>Couleur extérieure:</td><td>$row[exterior]</td></tr>";
				if($row['interior']) echo "<tr><td>Couleur intérieure:</td><td>$row[interior]</td></tr>";
				if($row['doors']) echo "<tr><td>Nb portes:</td><td>$row[doors]</td></tr>";
				if($row['fuel']) echo "<tr><td>Carburant:</td><td>$row[fuel]</td></tr>";
				if($row['drive']) echo "<tr><td>Roues motrices:</td><td>$row[drive]</td></tr>";
 
				// engine details
				if($row['engine']) echo "<tr><td>Moteur:</td><td>$row[engine]</td></tr>";
				if($row['trans']) echo "<tr><td>Boite de vitesse:</td><td>$row[trans]</td></tr>";
				if($row['top_speed']) echo "<tr><td>Vitesse Maxi:</td><td>$row[top_speed]</td></tr>";
				if($row['horsepower']) echo "<tr><td>Puissance fiscale:</td><td>$row[horsepower]</td></tr>";
				if($row['torque']) echo "<tr><td>Type(carte grise):</td><td>$row[torque]</td></tr>";
				if($row['towing']) echo "<tr><td>N° Immatriculation:</td><td>$row[towing]</td></tr>";
 
				?>						
			</table>
		</td>
	</tr>
 
	<?php 
	// listing description
	if($row['description']) {
		echo "<tr><td colspan='3'><hr/></td></tr>";
		echo "<tr><td colspan='3'>".nl2br($row[description])."</td></tr>";
	}
 
	// listing features
	if($row['features']) {
		echo "<tr><td colspan='3'><hr/></td></tr>";
		echo "<tr><td colspan='3'>";
		$tmp = explode("\n", $row['features']);
		foreach($tmp as $key => $value) if(!trim($value)) unset($tmp[$key]); else $tmp[$key] = trim($value); // remove empty lines
		$tmp = array_unique($tmp); // remove duplicate entries
		$cnt = count($tmp);
		$num = ceil($cnt / 4);
		echo "<table width='100%' border='0' cellpadding='0' cellspacing='0'>";
		echo "<tr>";
		echo "<td style='text-align:left;' width='25%' valign='top'><ul>";
		$n = 1;
		foreach($tmp as $value) {
			echo "<li>$value</li>";
			if($n % $num == 0 && $n < $cnt) echo "</ul></td><td style='text-align:left;' width='25%' valign='top'><ul>";
			$n++;
		}
		echo "</ul></td></tr>";
		echo "</table>";
		echo "</td></tr>";
	}
	?>
 
</table>

Et ci dessous le code du module initialize

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
<?php
require_once 'admin/cp-includes/inc-confdata.php';
require_once 'admin/cp-includes/inc-general.php';
require_once 'admin/cp-includes/inc-functions.php';
//error_reporting(E_ALL);
// check installation status
if(!$dbhost) header('location:setup.php');
 
$link = mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbname, $link);
 
// make data query-safe
$_GET = safe_data($_GET, 'query');
 
// create variable string
$pass_vars = '';
foreach($_GET as $name => $value) $pass_vars .= $name.'='.$value.'&amp;';
$pass_vars = ltrim($pass_vars, '&amp;');
 
// get configuration info
$result = mysql_query("SELECT * FROM $dbconf", $link);
$conf = mysql_fetch_array($result);
$conf = safe_data($conf, 'display');
 
// current page
$this_page = pathinfo($_SERVER['PHP_SELF'], PATHINFO_BASENAME);
 
// initialization steps for the main listings page
if($this_page == 'index.php' || $this_page == 'listings.php') {
 
	require 'modules/module-query.php';
 
	// get last updated date from inventory
	$result = mysql_query("SELECT updated FROM $dblist ORDER BY updated DESC LIMIT 1", $link);
	$updated = mysql_fetch_array($result);
 
	// get total number of listings for display
	$result = mysql_query("SELECT COUNT(*) FROM $dblist WHERE hide!='1' AND (expire>'".time()."' OR expire='' OR expire='0') AND (user_expire>'".time()."' OR user_expire='' OR user_expire='0')", $link);
	$display_total = mysql_fetch_array($result);
 
	// set default pagenation values
	if(!$_GET[p]) $_GET[p]       = $conf[perpage]; // default number of entries per page
	if(!$_GET[page]) $_GET[page] = 1; // current page
	if(!$_GET[srt]) $_GET[srt]   = $conf[srt]; // default sort order
	$start = ($_GET[page] - 1) * $_GET[p]; // start row for query
 
	// get total number of entries for pagenation
	$result = mysql_query("SELECT COUNT(*) FROM $dblist $where", $link);//echo "SELECT COUNT(*) FROM $dblist $where";
	$total  = mysql_fetch_array($result); $total = $total[0]; // total number of listings
	$pages  = ceil($total / $_GET[p]); // number of pages
}
 
// initialization steps for listing details page, print page, and send to a friend page
elseif($this_page == 'show.php' || $this_page == 'print.php' || $this_page == 'friend.php' || $this_page == 'slideshow.php') {
 
	if($_POST['submit']) $_GET['id'] = $_POST['id'];
 
	// get listing information
	$result = mysql_query("SELECT * FROM $dblist WHERE id='".mysql_real_escape_string($_GET['id'])."' LIMIT 1", $link);
	$row = mysql_fetch_array($result);
	$row = safe_data($row, 'display');
 
	// do not display zeros for integer fields
	if(!$row['model_year']) $row['model_year'] = '';
 
	// log visit in stats table and increment number of views
	if($this_page == 'show.php') {
 
		mysql_query("UPDATE $dblist SET viewed=viewed+1 WHERE id='".$row['id']."' LIMIT 1", $link);
 
		$tstamp = time() + (3600*$conf['toffset']);
 
		mysql_query("INSERT INTO $dbstat VALUES('0',
		'".$row['id']."',
		'".$row['userid']."',
		'".$row['user_type']."',
		'".$tstamp."',
		'".date('j', $tstamp)."',
		'".date('n', $tstamp)."',
		'".date('Y', $tstamp)."',
		'".date('G', $tstamp)."',
		'".$_SERVER['REMOTE_ADDR']."')", $link) or die(mysql_error());
 
	}
 
	// get QuickSelect features
	$result = mysql_query("SELECT * FROM $dbfeat WHERE id='".$_GET['id']."' LIMIT 1", $link);
	if(mysql_num_rows($result)) {
		$features = mysql_fetch_array($result);
		foreach($features as $id => $value) {
			if(substr($id, 0, 2) == 'cp' && $value == 1) {
				if(isset($id) && $id[2]="\\")$id=str_replace("\\","",$id);
				// get caption
				$result = mysql_query("SELECT caption FROM $dbcapt WHERE id='".substr($id, 2)."' LIMIT 1", $link);
				$caption = mysql_fetch_array($result);
				$caption = safe_data($caption, 'display');
 
				$row[features] .= "\n".$caption[caption];
			}
		}
	}
 
	// get user information
	$result = mysql_query("SELECT *,CONCAT(first_name,' ',last_name) AS name FROM $dbacct WHERE id='$row[userid]' LIMIT 1", $link);
	$user = mysql_fetch_array($result);
	$user = safe_data($user, 'display');
 
	// get location information
	$result = mysql_query("SELECT * FROM $dbloca WHERE id='$row[location]' LIMIT 1", $link);
	$location = mysql_fetch_array($result);
	$location = safe_data($location, 'display');
 
	// get images
	if($row['images']) {
		$image_set = array();
		$result = mysql_query("SELECT fname FROM $dbimgs WHERE listid='$_GET[id]' ORDER BY id ASC", $link);
		while($images = mysql_fetch_array($result)) {
			array_push($image_set, $images['fname']);
		}
	}
 
	// subject line for send to a friend page
	if(!$_POST['subject']) {
		if($row['model_year']) $_POST['subject'] = $row['model_year']." ";
		$_POST['subject'] .= $row['make']."	".$row['model'];
		if($row['stock']) $_POST['subject'] .= " (N° de stock: ".$row['stock'].")";
	}
}
 
// initialization steps for advanced search page
elseif($this_page == 'search.php') {
 
	// set default pagenation values
	if(!$_GET[p]) $_GET[p]       = $conf[perpage]; // default number of entries per page
	if(!$_GET[srt]) $_GET[srt]   = $conf[srt]; // default sort order
 
}
 
// initialization steps for contact us page
elseif($this_page == 'contact.php') {
 
	if($_POST[submit]) $_GET = $_POST;
 
	// get listing information
	$result = mysql_query("SELECT * FROM $dblist WHERE id='$_GET[id]' LIMIT 1", $link);
	$row = mysql_fetch_array($result);
	$row = safe_data($row, 'display');
 
	// do not display zeros for integer fields
	if(!$row[model_year]) $row[model_year] = '';
 
	if(!$_POST[subject]) {
		if($row[model_year]) $_POST[subject] = $row[model_year]." ";
		$_POST[subject] .= "$row[make] $row[model]";
		if($row[stock]) $_POST[subject] .= " (N° de stock: $row[stock])";
	}
	if(!$_POST[message]) {
		$_POST[message] = "Je souhaite des informations complémentaires concernant un véhicule de ";
		if($row[model_year]) $_POST[message] .= "$row[model_year], une  ";
		$_POST[message] .= "$row[make] $row[model] affichée sur votre site.";
		if($row[stock]) $_POST[message] .= "\n\nNuméro de stock: $row[stock]";
	}
 
	// determine where to send message
	if($_GET[mode] == 'sales') {
 
		// get user information
		$result = mysql_query("SELECT email,contact FROM $dbacct WHERE id='$row[userid]' LIMIT 1", $link);
		$result = mysql_fetch_array($result);
		$result = safe_data($result, 'display');
		$sendto = $result[email];
 
	} else {
 
		// get user information
		$result = mysql_query("SELECT email FROM $dbloca WHERE id='$row[location]' LIMIT 1", $link);
		$result = mysql_fetch_array($result);
		$result = safe_data($result, 'display');
		$sendto = $result[email];
 
	}
 
}
 
?>

J'ai egalement 3 require mais je ne penses pas que ce soit le probléme

**gator** · 03/02/2010, 14h12

Pas d'idée ??

Affichage de donnees depuis mysql en php html

Langage PHP

Discussions similaires

Partager

Partager