Affichage.php

<?php
 require( "result.inc.php" );
?>
<form name="annuaire" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<input type="text"   name="critere"   value="Votre recherche ici.     <?php if(!$critere) echo stripslashes( $critere ); ?>" size="17" onFocus='document.forms["annuaire"].elements["critere"].value =""'/>
<input type="submit" name="envoyer" value="Traduire"/><input type="hidden" name="recherche" value="1"/></form>

<?Php
 include( "mysql.inc.php" );
 require( "fonctions.inc.php" );
 $path_parts = pathinfo($_SERVER['PHP_SELF']);
$page = $path_parts["basename"];

// compte le nombre de données totales
$select = 'SELECT count(id) FROM japfr';
$execution = mysql_query($select,$connection)  or die ('Erreur : '.mysql_error() );
$row = mysql_fetch_row($execution);
$total = $row[0];

// fixe le nombre de résultat par page et donne son état à la base
$nombre = 5;
 if(isset($_GET['limite'])) $limite=$_GET['limite'];    else   $limite=0;

// vérifie qu'un mot a bien été entré
  if( isset( $_POST["recherche"] ) ) $recherche = $_POST["recherche"];
  else                               $recherche = 0;
  if( isset( $_POST["critere"] ) )   $critere   = $_POST["critere"];

//si mot entré, execute 2 requetes
  if( $recherche==1 && !empty( $critere) )
  {
    $requete    = "SELECT * FROM japfr WHERE fr LIKE '%" . stripslashes( $critere ) . "%' limit ".$limite.",".$nombre;
	$requete2    = "SELECT * FROM japfr WHERE fr LIKE '%" . stripslashes( $critere ) . "%'";
	$result  = mysql_query( $requete, $connection ) OR die( "Impossible d'executer la Requete !" );
    $result2  = mysql_query( $requete2, $connection ) OR die( "Impossible d'executer la Requete !" );
    $nbr_tuples = @mysql_num_rows( $result2 ) ;
	if ($nbr_tuples > 0) {
?>
<p class="s11">Résultat : <span class="b"><?php echo $nbr_tuples; ?></span><br />
Mot recherché :<span class="b""color:#FF0000"> <?php echo colorise_query( $critere,$critere,$critere); ?></span></p>
<?php
      while( $un_mot = mysql_fetch_array( $result )) 
      {
?><ul><li><p class="style2"><strong><?php echo colorise_query( $un_mot["fr"], $critere,"stabylo" ); ?></strong></li></ul></p>
<p class="style8"><?php echo $un_mot["jap"] . " " . $un_mot["pro"]; ?><br /></p>
<p class="style5"><?php echo $un_mot["com"]; ?><br />
</p>
<?php
      }
      mysql_free_result( $result );
	  mysql_free_result( $result2 );
}

// si première requete vide, execute 2eme requete 
    else
    {
      $requete    = "SELECT * FROM japfr WHERE jap LIKE '%" . stripslashes( $critere ) . "%' OR pro LIKE '%". stripslashes( $critere ) . "%' limit ".$limite.",".$nombre;
	  $result = mysql_query( $requete, $connection ) OR die( "Impossible d'executer la Requete !" );
	  $requete2    = "SELECT * FROM japfr WHERE jap LIKE '%" . stripslashes( $critere ) . "%' OR pro LIKE '%". stripslashes( $critere ). "%'" ;
	  $result2 = mysql_query( $requete2, $connection ) OR die( "Impossible d'executer la Requete !" );
      $nbr_tuples = @mysql_num_rows( $result2 );
	  if ($nbr_tuples > 0) {
?>
<p class="s11">Résultat : <span class="b"><?php echo $nbr_tuples; ?></span><br />
Mot recherché :<span class="b""color:#FF0000"> <?php echo colorise_query( $critere,$critere,$critere ); ?></span></p>
<?php
        while( $un_mot = mysql_fetch_array( $result ) )
        {

?><ul><li><p class="style4"><strong><?php echo colorise_query( $un_mot["jap"],$critere,"stabylo" );?></strong></li></p></ul>
<p class="style8"><?php echo $un_mot["fr"]; ?><br /></p>
<p class="style5"><?php echo $un_mot["com"]; ?><br />
</p>
<?php
		}
      mysql_free_result( $result );
}

// si deuxième requete vide, affiche aucun resultat
	 else  
	echo "<div style='position: absolute; left: 16px; top:230px; width: 753px;background-color: #FFFFFF; layer-background-color: #FFFFFF; border: 1px none #000000;'><br />Aucune traduction disponible pour le moment.\n";	
}

// s'il y a plus de donnees que la limite, affiche les boutons de liens
if($total > $nombre) {
displayNextPreviousButtons($limite,$total,$nombre,$page);
}
}
?>
<?Php
  mysql_close();
?>

function displayNextPreviousButtons($limite,$total,$nombre,$page) {
$limiteSuivante = $limite + $nombre;
$limitePrecedente = $limite - $nombre;
echo  '<table><tr>'."\n";
if($limite != 0) {
        echo  '<td valign="top">'."\n";
        echo  '<form action="'.$page.'" method="post">'."\n";
        echo  '<input type="submit" value="précédents">'."\n";
        echo  '<input type="hidden" value="'.$limitePrecedente.'" name="limite">'."\n";
        echo  '</form>'."\n";
        echo  '</td>'."\n";
}
if($limiteSuivante < $total) {
        echo  '<td valign="top">'."\n";
        echo  '<form action="'.$page.'" method="post">'."\n";
        echo  '<input type="submit" value="suivants">'."\n";
        echo  '<input type="hidden" value="'.$limiteSuivante.'" name="limite">'."\n";
        echo  '</form>'."\n";
        echo  '</td>'."\n";
            
}
echo  '</tr></table>'."\n";
}