Code php Limiter le nombre de ligne tableau

totdmm -  
Bonjour, voici mon code :<?php

# FileName="Connection_php_mysql.htm"

# Type="MYSQL"

# HTTP="true"

$hostname= "localhost";

$database= "projet";

$username = "root";

$password = "tayebe0772";

$connection = mysql_connect($hostname, $username, $password) or trigger_error(mysql_error(),E_USER_ERROR);

mysql_select_db($database, $connection);

if (isset($_POST['GO'])){

$sql=("select pers_pia.MAT,pers_pia.NOM,pers_pia.PRENOM,pers_pia.POST_ACTUE,pai_pia.MAT,pai_pia.SB,pai_pia.IEP,pai_pia.NET,poste.code,poste.grade count from pai_pia,pers_pia,poste where pai_pia.MAT=pers_pia.MAT and pers_pia.POST_ACTUE=poste.code order by grade ");

$query=mysql_query($sql,$connection)or die (mysql_error());

$num=mysql_num_rows($query);

if ($num >0){

echo '<table border="1" align="center" bordercolor="#000000" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" >';

echo '<tr bgcolor="#FFFF71">';

echo '<td width="50" height="30" align="center" ><b><u>num</u></b></td>';

echo '<td width="50" height="30" align="center" ><b><u>nom</u></b></td>';

echo '<td width="250" align="center"><b><u>prenom </u></b></td>';

echo '<td width="250" align="center"><b><u> S_B </u></b></td>';

echo '<td width="250" align="center"><b><u>IEP</u></b></td>';

echo '<td width="250" align="center"><b><u>NET</u></b></td>';

echo '<td width="250" align="center"><b><u>GRADE</u></b></td>';

echo '<td width="250" align="center"><b><u>MODE</u></b></td>';

echo '</tr>';

$i=1;

while ($row=mysql_fetch_array($query) ){

$mat=$row['MAT'];

$nom=$row['NOM'];

$prenom=$row['PRENOM'];

$sb=$row['SB'];

$iep=$row['IEP'];

$net=$row['NET'];

$grade=$row['POST_ACTUE'];

if( $i<26 ){

echo '<tr bgcolor="#ffffff">';

echo "<td align='center' bgcolor='#FFFFFF'>$i</td>";

echo "<td align='center'>$nom</td>";

echo "<td align='center'>$prenom</td>";

echo "<td align='center' >$sb</td>";

echo "<td align='center'>$iep</td>";

echo "<td align='center'>$net</td>";

echo "<td align='center'>$grade</td>";

echo '</tr>';

$i=$i+1;

}else{

$i=1;}

}

}

}else {echo"erreur";}

?>

2 réponses

  1. totdmm Auteur
    1ere problème regarder colonne grade et num :

    grade TTN01 dernier num égale 5 normalement le num apres 5 egale a 1 parce que le grade a été changer exemple si il y a 27 TTN01 et 30 TTN111 résultat affiche num de 1 a 25 TTN01 et de 1 a 2 TTN01 et âpre de 1 a 25 TTN1111 et de 1 a 10 TTN111

    merci merci merci pour votre aide
    1. totdmm Auteur
      et résultat:

      num nom prenom S_B IEP NET GRADE MODE
      1 DIFALLAH AHMED 15660.00 9405.00 32655.97 TTN01
      2 BOUABDALLAH MOHAMED FOUAD 15660.00 9405.00 29655.97 TTN01
      3 BENKHALEF SALIHA 15660.00 7830.00 30162.50 TTN01
      4 BOUGHELOUM LILIA 15660.00 0.00 22018.40 TTN01
      5 DEMEN DEBBIH NACER 15660.00 7830.00 33762.35 TTN01
      6 SLIMANI ABDELHAMID 15660.00 9405.00 32249.35 TTN111
      7 BOUCHAILA YACINE 24165.00 2430.00 36108.56 TAN03
      8 MADADI RATIBA 24165.00 1215.00 29708.70 TAN03
      9 GUEDJALI ILHEM 24165.00 2430.00 34069.17 TAN03
      10 KASSAH LAOUAR CHOUBEILA 24165.00 2430.00 32869.17 TAN03
      11 MOULAHEM SOUHEILA 24165.00 7245.00 40679.00 TAN03
      12 BOULEKROUN SOUAD 24165.00 7245.00 42479.00 TAN03
      13 YOUCEFI NADIA 24165.00 9675.00 46039.70 TAN03
      14 CHAREF ISMAHAN 24165.00 0.00 30545.22 TAN03
      15 BOUKHMIS OUAHID 24165.00 0.00 30545.22 TAN03
      16 BEKKAI SOUHEILA 24165.00 9675.00 43575.50 TAN03
      17 BOUCHAILA LAMIA 24165.00 0.00 30545.22 TAN03
      18 BENAYACHE KARIM 24165.00 0.00 31945.22 TAN03
      19 BOUMEZBER MOHAMED EL HADI 24165.00 0.00 30545.22 TAN03
      20 BOURIOU NAIMA 24165.00 0.00 30545.22 TAN03
      21 BOUDERSSA DALEL 24165.00 1215.00 31708.70 TAN03
      22 SEDRATI SHAHINEZ 24165.00 2430.00 32869.17 TAN03
      23 BOUTECHE RAFIK 24165.00 0.00 30545.22 TAN03
      24 IZEM DJAOUIDA 24165.00 13275.00 26633.61 TAN03
      25 BERDOUDI LEILA 24165.00 0.00 30545.22 TAN03
      1 HOUAS YAKOUTA 24165.00 13275.00 51480.70 TAN03
      2 BOUCHLIT ANISS 24165.00 0.00 31145.22 TAN03
      3 HIMER MOHAMED 24165.00 0.00 10336.89 TAN03
      4 BENSSEBANE NAWEL 24165.00 7245.00 37470.65 TAN03
      5 GHODBANE ABDELGHANI 24165.00 10890.00 44708.52 TAN03
      6 OUACHRIA MERIEM 24165.00 0.00 30545.22 TAN03
      7 BELAIEB INESS 24165.00 3645.00 37783.10 TAN03
      8 LAHLAH SABAH 24165.00 8460.00 42384.57 TAN03
      9 DAOUD SAMIRA 24165.00 0.00 32567.72 TAN03
      10 DELIBA FATIMA 24165.00 12105.00 48276.80 TAN03
      11 AZZI FERIEL MANEL 24165.00 0.00 30545.22 TAN03
      12 AMIRECHE NEDJOUA 24165.00 8460.00 46054.17 TAN03
      13 AMIRECHE MANEL 24165.00 1215.00 37956.80 TAN03
      14 HEGUIB SALIMA 24165.00 1215.00 31708.70 TAN03
      15 SAADI REDHA 24165.00 1215.00 32908.69 TAN03
      16 AMIRECHE HOUDA 24165.00 1215.00 7542.04 TAN03
      17 BENAOUINA HAYDAR 24165.00 3645.00 37877.75 TAN03
      18 DJIMLI FAYROUZ 24165.00 2430.00 32869.17 TAN03
      19 MATMAT ABDELKADER 24165.00 7245.00 45118.75 TAN03
      20 BOUDRAA AFFAF 24165.00 3645.00 37728.19 TAN03
      21 HIMED FATIMA 24165.00 1215.00 11320.91 TAN03
      22 KSIR MED CHRIF 24165.00 3645.00 38452.69 TAN03
      23 BOUOUDENE SOROR