mysql_connect('127.0.0.1','root',''); mysql_query("use fichierdemo;"); $res = mysql_query('select * from infofichier'); $nbligne = mysql_num_rows($res); $nbchamp = mysql_num_fields($res); echo '<table border="5"><tr bgcolor=#68DECF >'; for($i=0;$i<$nbchamp;$i++){ $nomchamp = mysql_field_name($res,$i); echo '<th>'.$nomchamp.'</th>';} for($j=0;$j<$nbligne;$j++){ echo '</tr><tr>'; $liste = mysql_fetch_array($res); extract($liste); for($i=0;$i<$nbchamp;$i++){ $nomchamp = mysql_field_name($res,$i); echo '<td>'.$liste[$nomchamp].'</td>'; }} echo '</tr>';
while($row = mysql_fetch_array($result)) { echo '<tr>'; echo '<td>'.$row["nom"].'</td>'; echo '<td>'.$row["prenom"].'</td>'; echo '<td>'.$row["adresse"].'</td>'; echo '<td>'.$row["cp"].'</td>'; echo '<td>'.$row["ville"].'</td>'; echo '</tr>'."\n"; } echo '</table>'."\n";
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question$res = mysql_query('select * from infofichier'); $nbligne = mysql_num_rows($res); $nbchamp = mysql_num_fields($res); echo '<table border="5"><tr bgcolor=#68DECF >'; for($i=0;$i<$nbchamp;$i++){ $nomchamp = mysql_field_name($res,$i); echo '<th>'.$nomchamp.'</th>'; } echo '</tr><tr>';
$res = mysql_query('select * from infofichier'); $nbligne = mysql_num_rows($res); $nbchamp = mysql_num_fields($res); echo ''; for($i=0;$i<$nbchamp;$i++){ $nomchamp[$i] = mysql_field_name($res,$i); echo ' '.$nomchamp[$i].' |'; } echo '---- ';
while($row = mysql_fetch_array($result)) { echo '---- '; foreach($nomchamp as $nomlu) { echo ''.$row[$nomlu].', '; } echo ''.\"\n\"; } echo ' '."\n";
$fields=mysql_num_fields($result); while($row = mysql_fetch_array($result)) { echo '<tr>'; for ($f=0; $f < $fields; $f++) { echo "<td>$row[$f]</td>"; } echo '</tr>'."\n"; } echo '</table>'."\n";