help retrieiving results and doing pagination
Posted on
16th Feb 2014 07:03 pm by
admin
Having some trouble trying to get the results to show on more than just one page.
What is happening is that when i input a subject or zip code, i get results and links on the bottom to show the number of pages, but when i click on them it gives me a broken link error
Here is the code that i have at the top of my html code before the <html> tag begins
Code: if(!isset($_GET['resultsPage'])){
$resultsPage = 1;
} else {
$resultsPage = $_GET['resultsPage'];
}
// Define the number of results per page
$max_results = 9;
// Figure out the limit for the query based
$from = (($resultsPage * $max_results) - $max_results);
that is whats supposed to get the pages, and the number of search results
here is t he code i have inside my <body> tag that echoes the results and builds the links for the pages
Code: // perform the search
$subject = $_POST['subject'];
$location = $_POST['location'];
$sql = "SELECT * FROM tutorProfiles WHERE MATCH(subject, location) AGAINST('$subject*' '$location*' IN BOOLEAN MODE) LIMIT $from, $max_results";
$result = mysql_query($sql) or die("Problem, with Query:".mysql_error());
// Get number of articles, assign value to a variable
$count = mysql_num_rows($result);
echo "<h3>Search Results</h3>";
echo "<p class='resultspara'>There is a total of $count results found on our database.</p>";
$TableRows = mysql_num_rows($result);
$i = 0;
while ($i <$TableRows)
{
//Add resulting tablerow to relvant variable
$tutorId = mysql_result($result, $i, "id");
$first = mysql_result($result, $i, "first");
$school = mysql_result($result, $i, "school");
$degree = mysql_result($result, $i, "degree");
$class = mysql_result($result, $i, "class");
echo"
<div id='profileBox'>
<div id='badgeImg'>
<img src='images/imgBG.png' name='imgBadge' width='76' height='70' align='left' id='imgBadge' />
<h2>$first</h2>
<p>$school<br />
$degree - $class
</p>
</div>
<div id='profleBtn'>
<a href='profile.php?id=$tutorId'><img src='images/linkBtn.png' alt='view Profile' width='150' height='30' border='0' /></a>
</div>
</div>";
// loop through all results and indent number on each loop
$i ++;
} // close while loop
//Beggin Pagination
// Figure out the total number of results in DB:
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM tutorProfiles"),0);
// Figure out the total number of pages. Always round up using ceil()
$total_newspage = ceil($total_results / $max_results);
echo "<p style="clear:both;" align="center">n";
// Build Previous Link
if($resultsPage > 1)
{
$prev = ($resultsPage - 1);
echo "<a href="results.php.php?resultsPage=$prev">Previous</a>n ";
}
for($p = 1; $p <= $total_newspage; $p++)
{
if(($resultsPage) == $p)
{
echo "$pn ";
} else {
echo "<a href="result.php?resultsPage=$i">$p</a>n ";
}
}
// Build Next Link
if($resultsPage < $total_newspage)
{
$next = ($resultsPage + 1);
echo "<a href="results.php?resultsPage=$next">Next</a>n";
}
echo "</p>n";
//End pagination Script
Anyway if someone could take a look at the code when i would gladly appreciate it
Thanks in advance
125 
50 
Other php-forum
using file_get_contents??
okay how would i create a script using file_get_contents() in php have it grab search pages 1-20 and
retrieving more than one max key from an array?
so i have an array of 20 numerical values (0-100) that i need to order from highest to lowest and th
uploading video files into mysql in php
hi,
I have the video files which i have to upload into mysql db. along with creating thumbnails f
NOOB needs help with upload file
The intent of this form is to create a folder for a client and upload an image into another folder '
problems with search form numerical "between" sending by php
I am trying to display the results of a search, on a sql database, on a web page. I set up html &quo
question about stripslashes and real_escape_string
im cleaning up an old app that I wrote fixing some of the vulernabilities from attacks.
I hav
Help on Order Entry Form/System Where is best to begin.
I have a dilema and a very short amount of time at this point and I'm looking for some help on decid
how to remove in php string display
My code is
$message="We're looking at developing our website.";
$body= "My mess
Alterar a hora do servidor
Se alguém souber, ajude-me a adicionar 6 horas, obrigado
<tr>
&
Getting a variable to work in function params
I have this fuction which is inside a class:
Code: public static function generateEmbedCode($
