PHP Navigation Buttons
Posted: Sat Oct 07, 2006 4:44 pm
Please, what is the syntax to create navigation Buttons (Next, Previous, First, Last) in PHP using mySql?
Thanks for your help...
Thanks for your help...
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
LIMIT $a,$displaySearch these forums and google for pagination.jeva39 wrote:Please, what is the syntax to create navigation Buttons (Next, Previous, First, Last) in PHP using mySql?
Thanks for your help...
Code: Select all
<?php
@mysql_connect("localhost", "root", "*****") or die("ERROR--CAN'T CONNECT TO SERVER");
@mysql_select_db(midis) or die("ERROR--CAN'T CONNECT TO DB");
$limit = 25;
$query_count = "SELECT * FROM temas";
$result_count = mysql_query($query_count);
$totalrows = mysql_num_rows($result_count);
if(empty($page)){
$page = 1;
}
$limitvalue = $page * $limit - ($limit);
$query = "SELECT * FROM temas order by tema LIMIT $limitvalue, $limit";
$result = mysql_query($query) or die("Error: " . mysql_error());
if(mysql_num_rows($result) == 0){
echo("Nothing to Display!");
}
$bgcolor = "#E0E0E0"; // light gray
echo("<table>");
while($row = mysql_fetch_array($result)){
if ($bgcolor == "#E0E0E0"){
$bgcolor = "#FFFFFF";
}else{
$bgcolor = "#E0E0E0";
}
echo("<tr bgcolor=".$bgcolor."><td>");
echo($row["tema"]);
echo("</td><td>");
echo($row["autor"]);
echo("</td><td>");
echo($row["ritmo"]);
echo("</td></tr>");
}
echo("</table>");
if($page != 1){
$pageprev = $page--;
echo("<a href=\"pagina.php&page=$pageprev\">PREV".$limit."</a> ");
}else{
echo("PREV".$limit." ");
}
$numofpages = $totalrows / $limit;
for($i = 1; $i <= $numofpages; $i++){
if($i == $page){
echo($i." ");
}else{
echo("<a href=\"pagina.php?page=$i\">$i</a> ");
}
}
if(($totalrows % $limit) != 0){
if($i == $page){
echo($i." ");
}else{
echo("<a href=\"pagina.php?page=$i\">$i</a> ");
}
}
if(($totalrows - ($limit * $page)) > 0){
$pagenext = $page++;
$page=$pagenext;
echo("<a href=\"pagina.php?page=$pagenext\">NEXT".$limit."</a>");
}else{
echo("NEXT".$limit);
}
mysql_free_result($result);
?>Code: Select all
if(empty($page)){
$page = 1;
}Code: Select all
$page = (empty($_GET['page']) ? 1 : $_GET['page']);Code: Select all
function tabla{
......more code....
echo '<tr><td width="48%" valign="middle" align="left"><strong>Fecha (dd/mm/yyyy)</strong></td><td width="52%" valign="middle" align="left"><input type="text" name="fecha" value=""size="35"></td></tr>';
.....more code......
}Code: Select all
<?php
$fecha=22;
echo '$fecha'; //would output $fecha
echo "$fecha"; // would output 22
?>Code: Select all
echo "blah blah \"rhubarb\" blah ";Code: Select all
<?php
function myfunction($fecha) {
echo $fecha;
}
?>Code: Select all
$fecha= date("M d, Y");
function tabla() {
if (!isset($_POST['tema'])) $_POST['tema'] = '';
if (!isset($_POST['arreglo'])) $_POST['arreglo'] = '';
if (!isset($_POST['autor'])) $_POST['autor'] = '';
if (!isset($_POST['ritmo'])) $_POST['ritmo'] = '';
if (!isset($_POST['archivo'])) $_POST['archivo'] = '';
if (!isset($_POST['clase'])) $_POST['clase'] = '';
if (!isset($_POST['fecha'])) $_POST['fecha'] = '';
echo '<center><p><h2><font color="red">Todos los campos son requeridos.</font></h2></p></center>';
echo '<form name="Buscar" method="POST" action="nuevoreg.php">';
echo '<table border="1" cellpadding="10" cellspacing="1" bgcolor="#f7efde" ALIGN=CENTER>';
echo '<tr><td width="48%" valign="middle" align="left"><strong>Tema</strong></td><td width="52%" valign="middle" align="left"><input type="text" name="tema" size="35" ></td></tr>';
echo '<tr><td width="48%" valign="middle" align="left"><strong>Arreglo</strong></td><td width="52%" valign="middle" align="left"><input type="text" name="arreglo" size="25"></td></tr>';
echo '<tr><td width="48%" valign="middle" align="left"><strong>Autor</strong></td><td width="52%" valign="middle" align="left"><input type="text" name="autor" size="35"></td></tr> ';
echo '<tr><td width="48%" valign="middle" align="left"><strong>Ritmo</strong></td><td width="52%" valign="middle" align="left"><input type="text" name="ritmo" size="35"></td></tr> ';
// This is the line of problem
echo '<tr><td width="48%" valign="middle" align="left"><strong>Fecha (dd/mm/yyyy)</strong></td><td width="52%" valign="middle" align="left"><input type="text" name="fecha" value="????????????"size="35"></td></tr>';
echo '<tr><td width="48%" valign="middle" align="left"><strong>Nuevo</strong></td><td width="52%" valign="middle" align="left"><input type="checkbox" name="nuevo" CHECKED></td></tr>';
echo '<tr><td width="48%" valign="middle" align="left"><strong>Clase</strong></td><td width="52%" valign="middle" align="left"><input type="text" name="clase" size="2"></td></tr>';
echo '<tr><td width="48%" valign="middle" align="left"><strong>KAR</strong></td><td width="52%" valign="middle" align="left"><input type="text" name="kar" size="3"></td></tr>';
echo '<td width="48%" align=center colspan=2><center><BR></B></FONT><input type="submit" name="submit" value="Submit"> <input type="reset" name="cancel" value="Cancelar"><BR><BR></center></td></tr>';
echo ' ';
echo '</table>';
echo '</form>';
}