Pages
Résolu
thomason
Messages postés
91
Date d'inscription
Statut
Membre
Dernière intervention
-
thomason Messages postés 91 Date d'inscription Statut Membre Dernière intervention -
thomason Messages postés 91 Date d'inscription Statut Membre Dernière intervention -
Bonjour,
svp comment faire que mes enregistrements que jè sélectionnés dans la bd s'affichent en vagues de 30
sur plusieurs pages . en bref je veux faire une pagination.
voici le code.
<div align="center"><?php
$bdd = "projet";
$host= "localhost";
$user= "root";
$pass= "";
$tabReponse='';
if (mysql_connect($host,$user,$pass)){
//echo'connexion';
}
else {
echo '"Impossible de se connecter à la base de données"'.mysql_error(); }
if(mysql_select_db('projet')){
echo'';
}
else{
echo'"erreur"'.mysql_error();
}
$requete= "SELECT * FROM employes";
$resultat = mysql_query($requete) or die ('erreur '.$requete.' '.mysql_error());
if ($tabreponse = mysql_num_rows( $resultat )){;
?>
<em><strong><span class="Style6">Employés</span>:</strong></em></div>
<table width="862" border="0" align="center" >
<tr bgcolor="#000000" onMouseOut="javascript:this.style.background='#000000'" onMouseOver="javascript:this.style.background='#CCCCCC'">
<td width="133"><div align="center" class="Style8">Nom</div></td>
<td width="133"><div align="center" class="Style8">Numero</div></td>
<td width="133"><div align="center" class="Style8">Crédit</div></td>
<td width="133"><div align="center" class="Style8">Compte</div></td>
<td width="133"><div align="center" class="Style8">Date de création</div></td>
<td width="133"><div align="center" class="Style8">Date de modification</div></td>
<td width="133"><div align="center" class="Style8">Supprimer</div></td>
</tr>
</table>
<?php
while($tabReponse = mysql_fetch_array( $resultat )){?>
<table width="862" border="0" align="center" bgcolor="#FF9562" >
<tr onMouseOut="javascript:this.style.background='#FF9562'" onMouseOver="javascript:this.style.background='#CCCCCC'" >
<td width="133" align="center" style="font-weight:bold;color:#444444" ><?php echo $tabReponse['nom']; ?></td>
<td width="133" align="center" style="font-weight:bold;"><?php echo $tabReponse[ 'numero'];?></td>
<td width="133" align="center" style="font-weight:bold;color:#444444"><?php echo $tabReponse['montant_credit'];?></td>
<td width="133" align="center" style="font-weight:bold;color:#444444"><?php echo $tabReponse['compte'];?></td>
<td width="133" align="center" style="font-weight:bold;color:#444444"><?php echo $tabReponse['date_enregistrement'];?></td>
<td width="133" align="center" style="font-weight:bold;color:#444444"><?php echo $tabReponse['date_modification'];?></td>
<td width="133"><div align="center"><a href='delete_employe.php?nUMERO=<?php echo $tabReponse['numero']; ?>'><em><strong>Supprimer</strong></em></a></div></td>
</tr>
</table>
<?php
}
}
?>
</TR>
</TABLE>
<p align="center">
<p align="center">
<p align="center">
<a name="bas"></a>
<p align="right"><a href="#haut" class=btn1 Style4
onmouseover="this.style.color = 'black';"
onmouseout="this.style.color = '';">Haut de page</a></p><br>
<TABLE cellSpacing=0 cellPadding=3 width="97%" align=center border=0>
<TABLE width="97%" align=center border=0>
<TBODY>
<TR>
<TD class=btn1 align=middle background="bas.png"><div align="center" ><A class=btn1
onmouseover="this.style.color = 'black';"
onmouseout="this.style.color = '';"
href="https://www.orange.cm/" >http://www.orange.cm/</A></div></TD></TR></TBODY>
</TABLE>
</TR>
</TABLE>
svp comment faire que mes enregistrements que jè sélectionnés dans la bd s'affichent en vagues de 30
sur plusieurs pages . en bref je veux faire une pagination.
voici le code.
<div align="center"><?php
$bdd = "projet";
$host= "localhost";
$user= "root";
$pass= "";
$tabReponse='';
if (mysql_connect($host,$user,$pass)){
//echo'connexion';
}
else {
echo '"Impossible de se connecter à la base de données"'.mysql_error(); }
if(mysql_select_db('projet')){
echo'';
}
else{
echo'"erreur"'.mysql_error();
}
$requete= "SELECT * FROM employes";
$resultat = mysql_query($requete) or die ('erreur '.$requete.' '.mysql_error());
if ($tabreponse = mysql_num_rows( $resultat )){;
?>
<em><strong><span class="Style6">Employés</span>:</strong></em></div>
<table width="862" border="0" align="center" >
<tr bgcolor="#000000" onMouseOut="javascript:this.style.background='#000000'" onMouseOver="javascript:this.style.background='#CCCCCC'">
<td width="133"><div align="center" class="Style8">Nom</div></td>
<td width="133"><div align="center" class="Style8">Numero</div></td>
<td width="133"><div align="center" class="Style8">Crédit</div></td>
<td width="133"><div align="center" class="Style8">Compte</div></td>
<td width="133"><div align="center" class="Style8">Date de création</div></td>
<td width="133"><div align="center" class="Style8">Date de modification</div></td>
<td width="133"><div align="center" class="Style8">Supprimer</div></td>
</tr>
</table>
<?php
while($tabReponse = mysql_fetch_array( $resultat )){?>
<table width="862" border="0" align="center" bgcolor="#FF9562" >
<tr onMouseOut="javascript:this.style.background='#FF9562'" onMouseOver="javascript:this.style.background='#CCCCCC'" >
<td width="133" align="center" style="font-weight:bold;color:#444444" ><?php echo $tabReponse['nom']; ?></td>
<td width="133" align="center" style="font-weight:bold;"><?php echo $tabReponse[ 'numero'];?></td>
<td width="133" align="center" style="font-weight:bold;color:#444444"><?php echo $tabReponse['montant_credit'];?></td>
<td width="133" align="center" style="font-weight:bold;color:#444444"><?php echo $tabReponse['compte'];?></td>
<td width="133" align="center" style="font-weight:bold;color:#444444"><?php echo $tabReponse['date_enregistrement'];?></td>
<td width="133" align="center" style="font-weight:bold;color:#444444"><?php echo $tabReponse['date_modification'];?></td>
<td width="133"><div align="center"><a href='delete_employe.php?nUMERO=<?php echo $tabReponse['numero']; ?>'><em><strong>Supprimer</strong></em></a></div></td>
</tr>
</table>
<?php
}
}
?>
</TR>
</TABLE>
<p align="center">
<p align="center">
<p align="center">
<a name="bas"></a>
<p align="right"><a href="#haut" class=btn1 Style4
onmouseover="this.style.color = 'black';"
onmouseout="this.style.color = '';">Haut de page</a></p><br>
<TABLE cellSpacing=0 cellPadding=3 width="97%" align=center border=0>
<TABLE width="97%" align=center border=0>
<TBODY>
<TR>
<TD class=btn1 align=middle background="bas.png"><div align="center" ><A class=btn1
onmouseover="this.style.color = 'black';"
onmouseout="this.style.color = '';"
href="https://www.orange.cm/" >http://www.orange.cm/</A></div></TD></TR></TBODY>
</TABLE>
</TR>
</TABLE>
A voir également:
- Pages
- Supprimer des pages sur word - Guide
- Comment numeroter les pages word - Guide
- Comment numéroter les pages sur powerpoint - Guide
- Comment restaurer les pages google - Guide
- Séparer pages pdf - Guide
1 réponse
je lai utilisé pour faire un livre d'or, mai il y a juste quelques trucs a modifier et c'est bon :
<?php
mysql_connect("localhost", "user", "***");
mysql_select_db("bdd");
$nbrmessages = 10;
$retour = mysql_query('SELECT COUNT(*) AS nb_messages FROM livreor');
$donnees = mysql_fetch_array($retour);$messages = $donnees['nb_messages'];
$nbrpages = ceil($messages / $nbrmessages);
echo 'Pages : ';
for ($i = 1 ; $i <= $nbrpages ; $i++)
{
echo '<a href="livre-or.php?page=' . $i . '">' . $i . '</a> ';
}
if (isset($_GET['page']))
{
$page = $_GET['page'];
}
else
{
$page = 1;
}
$firstmessage = ($page - 1) * $nbrmessages;
$reponse = mysql_query('SELECT * FROM livreor ORDER BY id DESC LIMIT ' . $firstmessage . ', ' . $nbrmessages);
while ($donnees = mysql_fetch_array($reponse))
{
echo '<p><strong>' . $donnees['pseudo'] . '</strong> :<br />' . $donnees['message'] . '</p>';
}
mysql_close();
?>
la, le code affiche 10 messages par page mais il suffit de changer la variables $nbrmessages et c'est bon
<?php
mysql_connect("localhost", "user", "***");
mysql_select_db("bdd");
$nbrmessages = 10;
$retour = mysql_query('SELECT COUNT(*) AS nb_messages FROM livreor');
$donnees = mysql_fetch_array($retour);$messages = $donnees['nb_messages'];
$nbrpages = ceil($messages / $nbrmessages);
echo 'Pages : ';
for ($i = 1 ; $i <= $nbrpages ; $i++)
{
echo '<a href="livre-or.php?page=' . $i . '">' . $i . '</a> ';
}
if (isset($_GET['page']))
{
$page = $_GET['page'];
}
else
{
$page = 1;
}
$firstmessage = ($page - 1) * $nbrmessages;
$reponse = mysql_query('SELECT * FROM livreor ORDER BY id DESC LIMIT ' . $firstmessage . ', ' . $nbrmessages);
while ($donnees = mysql_fetch_array($reponse))
{
echo '<p><strong>' . $donnees['pseudo'] . '</strong> :<br />' . $donnees['message'] . '</p>';
}
mysql_close();
?>
la, le code affiche 10 messages par page mais il suffit de changer la variables $nbrmessages et c'est bon
tu m'as vraiment aidé
merci