Code php Limiter le nombre de ligne tableau

totdmm Messages postés 58 Statut Membre -  
totdmm Messages postés 58 Statut Membre -
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 Messages postés 58 Statut Membre
     
    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
    0
  2. totdmm Messages postés 58 Statut Membre
     
    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
    0