Jump to content

Create page number and next/previous buttons in php page

lostpr

By lostpr
in PHP Coding Help

 Share

Recommended Posts

lostpr Newbie

lostpr

Posted
Posted

Hi,

The code I show below works correctly. But I need to develop the page numbers and next / previous buttons.

some help

thanks

<html>
<head>
<title>Búsqueda de doctores</title>
<style type="text/css">

table {
background-color: #fcf;
}

th {
width: 150px;
text-align: left;
}

</style>
</head>
<body>
<h1>Búsqueda de doctores</h1>

<form method="post" action="busquedadoctores.php">
<input type="hidden" name="submitted" value="true" />

<label>Busqueda por especialidad:

<select name="especialidad">
<?php
if(trim($_POST['especialidad']) != ""){
echo '<option value="'.stripslashes($_POST['especialidad']).'">'.stripslashes($_POST['especialidad']).'</option>
';
}
?>
<option value=" ">Please select</option>
<option value="Alergista e Inmunología">Alergista e Inmunología</option>
<option value="Anestesiólogo">Anestesiólogo</option>
<option value="Cardiólogo">Cardiólogo</option>
<option value="Cirujano">Cirujano</option>
<option value="Cirujano cardiovascular">Cirujano cardiovascular</option>
<option value="Cirujano maxilofacial">Cirujano maxilofacial</option>
<option value="Cirujano plástico">Cirujano plástico</option>
<option value="Dentista">Dentista</option
<option value="Dermatólogo">Dermatólogo</option //verify why this option has this color
<option value="Emergenciólogo">Emergenciólogo</option>
<option value="Endocrinólogo">Endocrinólogo</option>
<option value="Fisiatra">Fisiatra</option>
<option value="Gastroenterólogo">Gastroenterólogo</option>
<option value="Generalista">Generalista</option>
<option value="Ginecólogo">Ginecólogo</option>
<option value="Hematólogo">Hematólogo</option
<option value="Infectólogo">Infectólogo</option>
<option value="Internista">Internista</option>
<option value="Nefrólogo">Nefrólogo</option>
<option value="Neumólogo">Neumólogo</option>
<option value="Neurólogo">Neurólogo</option
<option value="Oftalmólogo">Oftalmólogo</option>
<option value="Oncólogo">Oncólogo</option>
<option value="Optómetra">Optómetra</option>
<option value="Ortopeda">Ortopeda</option>
<option value="Pediatra">Pediatra</option>
<option value="Podiatra">Podiatra</option>
<option value="Proctólogo">Proctólogo</option>
<option value="Psiquiatra">Psiquiatra</option
<option value="Quiropráctico">Quiropráctico</option>
<option value="Reumatólogo">Reumatólogo</option>
<option value="Urólogo">Urólogo</option>


</select>
</label>Busqueda por pueblo:

<select name="pueblo">
<?php
if(trim($_POST['pueblo']) != ""){
echo '<option value="'.stripslashes($_POST['pueblo']).'">'.stripslashes($_POST['pueblo']).'</option>
';
}
?>
<option value=" ">Please select</option>
<option value="Adjuntas">Adjuntas</option>
<option value="Aguada">Aguada</option>
<option value="Aguadilla">Aguadilla</option>
<option value="Aguas Buenas">Aguas Buenas</option>
<option value="Aibonito">Aibonito</option>
<option value="Añasco">Añasco</option>
<option value="Arecibo">Arecibo</option>
<option value="Arroyo">Arroyo</option>
<option value="Barceloneta">Barceloneta</option>
<option value="Barranquitas">Barranquitas</option>
<option value="Bayamón">Bayamón</option>
<option value="Cabo Rojo">Cabo Rojo</option>
<option value="Caguas">Caguas</option>
<option value="Camuy">Camuy</option>
<option value="Canóvanas">Canóvanas</option>
<option value="Carolina">Carolina</option>
<option value="Cataño">Cataño</option>
<option value="Cayey">Cayey</option>
<option value="Ceiba">Ceiba</option>
<option value="Ciales">Ciales</option>
<option value="Cidra">Cidra</option>
<option value="Coamo">Coamo</option>
<option value="Comerío">Comerío</option>
<option value="Corozal">Corozal</option>
<option value="Culebra">Culebra</option>
<option value="Dorado">Dorado</option>
<option value="Fajardo">Fajardo</option>
<option value="Florida">Florida</option>
<option value="Guánica">Guánica</option>
<option value="Guayama">Guayama</option>
<option value="Guayanilla">Guayanilla</option>
<option value="Guaynabo">Guaynabo</option>
<option value="Gurabo">Gurabo</option>
<option value="Hatillo">Hatillo</option>
<option value="Hormigueros">Hormigueros</option>
<option value="Isabela">Isabela</option>
<option value="Jayuya">Jayuya</option>
<option value="Juana Díaz">Juana Díaz</option>
<option value="Juncos">Juncos</option>
<option value="Lajas">Lajas</option>
<option value="Lares">Lares</option>
<option value="Las Marías">Las Marías</option>
<option value="Las Piedras">Las Piedras</option>
<option value="Loíza">Loíza</option>
<option value="Luquillo">Luquillo</option>
<option value="Manatí">Manatí</option>
<option value="Maricao">Maricao</option>
<option value="Maunabo">Maunabo</option>
<option value="Mayaguez">Mayaguez</option>
<option value="Moca">Moca</option>
<option value="Morovis">Morovois</option>
<option value="Naguabo">Naguabo</option>
<option value="Naranjito">Naranjito</option>
<option value="Orocovis">Orocovis</option>
<option value="Patillas">Patillas</option>
<option value="Peñuelas">Peñuelas</option>
<option value="Ponce">Ponce</option>
<option value="Quebradillas">Quebradillas</option>
<option value="Rincón">Rincón</option>
<option value="Rio Grande">Rio Grande</option>
<option value="Sabana Grande">Sabana Grande</option>
<option value="Salinas">Salinas</option>
<option value="San Germán">San Germán</option>
<option value="San Juan">San Juan</option>
<option value="San Lorenzo">San Lorenzo</option>
<option value="Santa Isabel">Santa Isabel</option>
<option value="Toa Alta">Toa Alta</option>
<option value="Toa Baja">Toa Baja</option>
<option value="Trujillo Alto">Trujillo Alto</option>
<option value="Utuado">Utuado</option>
<option value="Vega Alta">Vega Alta</option>
<option value="Vega Baja">Vega Baja</option>
<option value="Vieques">Vieques</option>
<option value="Villalba">Villalba</option>
<option value="Yabucoa">Yabucoa</option>
<option value="Yauco">Yauco</option>

<input type="submit" />

</form>

<?php

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

//connect database
include('connect.php');

$especialidad = trim(stripslashes($_POST['especialidad']));
$pueblo = trim(stripslashes($_POST['pueblo']));
if($especialidad != ""){
$query = "SELECT * FROM doctores WHERE `ESPECIALIDAD` LIKE '%$especialidad%'";
if($pueblo != ""){
$query .= "and `pueblo` = '$pueblo'";
}
$result = mysql_query($query) or die(mysql_error());
$num_rows = mysql_num_rows($result);

echo "$num_rows result found";
if($num_rows > 0){
echo "<table>";
echo "<tr> <th>Nombre</th> <th>Especialidad</th> <th>Dirección</th> <th>Pueblo</th> <th>País</th> <th>Código postal</th> <th>Teléfono</th> <th>Email</tr>";

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

echo "<tr><td>";
echo $row['NOMBRE'];
echo "</td><td>";
echo $row['ESPECIALIDAD'];
echo "</td><td>";
echo $row['DIRECCION'];
echo "</td><td>";
echo $row['PUEBLO'];
echo "</td><td>";
echo $row['PAIS'];
echo "</td><td>";
echo $row['CODIGO_POSTAL'];
echo "</td><td>";
echo $row['TELEFONO'];
echo "</td><td>";
echo $row['EMAIL'];
echo "</td></tr>";
}

echo "</table>";
}
}
}
?>

</body>
</html>

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.