PHP - Simple Php Pagination Help

I am trying to add a simple pagination to my page. I know there are tons of tutorials out there for this. Well I have taken one of them and used my own queries with it.    Below is the code. The records do show up. The only problem is that all the records(from mysql table) show up, as oppose to limiting them per page.   Can you take a look at it and tell me what I might be doing wrong?

try {

            // Find out how many items are in the table
            $total = DB::getInstance()->query("SELECT COUNT(*) FROM records");


            // How many items to list per page
            $limit = 20;

            // How many pages will there be
            $pages = ceil($total / $limit);

            // What page are we currently on?
            $page = min($pages, filter_input(INPUT_GET, 'page', FILTER_VALIDATE_INT, array(
                'options' => array(
                    'default'   => 1,
                    'min_range' => 1,
                ),
            )));

            // Calculate the offset for the query
            $offset = ($page - 1)  * $limit;

            // Some information to display to the user
            $start = $offset + 1;
            $end = min(($offset + $limit), $total);


            // Prepare the paged query
            $stmt = DB::getInstance()->query("SELECT images.*, records.* FROM records
            LEFT JOIN images ON records.user_id = images.user_id
            ORDER BY record_id LIMIT {$limit} OFFSET {$offset}");

            if($stmt->count()) {

                // Display the results
                foreach($stmt->results() as $row) {

                    $thumb_img  =   escape($row->thumb_path);
                    $title  =   trim($row->title);
                    ?>
                      <div class="item">
                        <?php echo $thumb_img; ?>
                        <?php echo $title; ?>
                      </div>
                    <?php
                }
            } else {
                echo '<p>No results could be displayed.</p>';
            }

            // The "back" link
            $prevlink = ($page > 1) ? '<a href="?page=1" title="First page">&laquo;</a> <a href="?page=' . ($page - 1) . '" title="Previous page">&lsaquo;</a>' : '<span class="disabled">&laquo;</span> <span class="disabled">&lsaquo;</span>';

            // The "forward" link
            $nextlink = ($page < $pages) ? '<a href="?page=' . ($page + 1) . '" title="Next page">&rsaquo;</a> <a href="?page=' . $pages . '" title="Last page">&raquo;</a>' : '<span class="disabled">&rsaquo;</span> <span class="disabled">&raquo;</span>';

            // Display the paging information
            echo '<div id="paging"><p>', $prevlink, ' Page ', $page, ' of ', $pages, ' pages, displaying ', $start, '-', $end, ' of ', $total, ' results ', $nextlink, ' </p></div>';


    } catch (Exception $e) {
        echo '<p>', $e->getMessage(), '</p>';
    }
    ?>

I messed around with a simple pagination script I found online. I'm still diving in and breaking it down to try and understand it better but I also was planning to have a "next" and "previous" link instead of just echoing out page numbers.

I know I'll have to come up with some $pg+1 or $pg-1 function but how do I find out what $pg is currently on?

function showSubmissions(){

$max = 9; // number of news entries per page
$pg = $_GET['pg'];

if(empty($pg))
{
$pg = 1;
}

$limits = ($pg - 1) * $max; 

//view all the news articles in rows
$q = mysql_query("SELECT * FROM submissions WHERE approved='YES' ORDER BY postdate DESC LIMIT " . $limits . ", $max") or die(mysql_error());
//the total rows in the table
$totalres = mysql_result(mysql_query("SELECT COUNT(id) AS tot FROM submissions"), 0);
//the total number of pages (calculated result), math stuff...
$totalpages = ceil($totalres / $max); 



// BEGIN PAGINATION
print '
<div class="paginationList">
<ul class="pgList">
<li><img src="images/icon_prevresult.png" title="" alt="" /></li>';

for($i = 1; $i <= $totalpages; $i++)
{ 
//this is the pagination link
print '<li><a href="submissions.php?pg=' . $i . '">' . $i . ' </a></li>';
}


print '
<li><img src="images/icon_nextresult.png" title="" alt="" /></li>
</ul>
</div>';
// END PAGINATION


// PRINT RESULTS
while($row = mysql_fetch_array($q))
{
$id = $row['id'];
$name = stripslashes($row['name']);
$email = $row['email'];

print '
<div class="sub-thumb-wrapper">
<div class="sub-thumb-user">
<div class="ps-name"><p class="sub-label">NAME:</p><a href="mailto:' . $email . '">' . $name . '</a></div>
</div>
</div>' . "\n";
}
// END PRINT RESULTS

}

Hi everyone,

I'm trying to select either a class or an id using PHP Simple HTML DOM Parser with absolutely no luck.  My example is very simple and seems to comply to the examples given in the manual(http://simplehtmldom.sourceforge.net/manual.htm) but it just wont work, it's driving me up the wall.

Here is my example: http://schulnetz.nibis.de/db/schulen/schule.php?schulnr=94468&lschb=

I think the HTML is invalid: i cannot parse it.

Well i need more examples - probly i have overseen something!

If anybody has a working example of Simple-html-dom-parser...i would be happy.
The examples on the developersite are not very helpful.

your dilbertone

Code: [Select]
<?php
$title="Search";
$metakeywords="search, find";
$metadescription="Search for your love!";
include ('header.php');

$getpage=clean_up($_GET['page']);
$getpage = abs((int) ($getpage));


echo '
<table width="100%"><tr><td valign="top" class="content">
            <form action="index.php?action=search" method="post">

                  <b>Seeking Gender</b>
                  <select name="gender">
                    <option value="">Either</option>
                    <option value="Male">Male</option>
                    <option value="Female">Female</option>
                  </select>
<hr>
                  <b>Smoke?</b>
                  <select name="smoke">
                    <option value="">Doesn\'t matter</option>
                    <option value="Yes">Yes</option>
                    <option value="No">No</option>
                  </select>
<hr>

                  <b>Drink?</b>
                  <select name="drink">
                    <option value="">Doesn\'t matter</option>
                    <option value="Yes">Yes</option>
                    <option value="No">No</option>
                  </select>


<hr>

                  <b>Body Type </b>
                  <select name="bodytype">
                    <option value="">Doesn\'t matter</option>
<option value="Slim / Slender">Slim / Slender</option>
<option value="Athletic">Athletic</option>
<option value="Average">Average</option>
<option value="Some extra baggage">Some extra baggage</option>
<option value="Body builder">Body builder</option>
                  </select>


</td><td valign="top" class="content">

                  <b>First Name</b>
<input type="text" name="first" size="17"><br> <b>Last Name</b><input type="text" name="last" size="17">

<hr>


<b>Sexual orientation</b>
               <select class="orientation" name="orientation">
               <option value="">Any</option>
<option value="Bi">Bi</option>
<option value="Gay/Lesbian">Gay/Lesbian</option>
<option value="Straight">Straight</option>
                  </select>

<hr>

                  <b>Age Range</b>
                  <select class="date" name="age_from">';


$years = range( 16, 100 );

foreach( $years as $v ) {
     echo "<option value=\"$v\">$v</option>\n";
}
echo '
                  </select>
 to 
                  <select class="date" name="age_to">';

$yyears = range( 17, 100 );

foreach( $yyears as $v ) {
     echo "<option value=\"$v\">$v</option>\n";
}
echo '</select>

</td><td valign="top" class="content">

<b>Religion</b>
               <select name="religious">
               <option value="">Any</option>
<option value="Agnostic">Agnostic</option>
<option value="Atheist">Atheist</option>
<option value="Buddhist">Buddhist</option>
<option value="Catholic">Catholic</option>
<option value="Christian">Christian</option>
<option value="Hindu">Hindu</option>
<option value="Jewish">Jewish</option>
<option value="Mormon">Mormon</option>
<option value="Muslim">Muslim</option>
<option value="Other">Other</option>
<option value="Protestant">Protestant</option>
<option value="Satanist">Satanist</option>
<option value="Scientologist">Scientologist</option>
<option value="Taoist">Taoist</option>
<option value="Wiccan">Wiccan</option>
                  </select>

<hr>



<b>Ethnicity</b>
               <select name="ethnicity">
               <option value="">Any</option>
<option value="Asian">Asian</option>
<option value="Black / African descent">Black / African descent</option>
<option value="East Indian">East Indian</option>
<option value="Latino / Hispanic">Latino / Hispanic</option>
<option value="Middle Eastern">Middle Eastern</option>
<option value="Native American">Native American</option>
<option value="Pacific Islander">Pacific Islander</option>
<option value="White / Caucasian">White / Caucasian</option>
<option value="Other">Other</option>
                  </select>

<hr>


<b>Children</b>
               <select name="children">
               <option value="">Doesn\'t matter</option>
<option value="I don\'t want kids">I don\'t want kids</option>
<option value="Love kids, but not for me">Love kids, but not for me</option>
<option value="Undecided">Undecided</option>
<option value="Someday">Someday</option>
<option value="Expecting">Expecting</option>
<option value="Proud parent">Proud parent</option>
                  </select>

<hr>


<b>Education</b>
               <select name="education">
               <option value="">Doesn\'t matter</option>
<option value="High school">High school</option>
<option value="Some college">Some college</option>
<option value="In college">In college</option>
<option value="College graduate">College graduate</option>
<option value="Grad / professional school">Grad / professional school</option>
<option value="Post grad">Post grad</option>
                  </select>

                  <br><input type="submit" name="submit" value="Search" /></form>
</td></tr></table>';

if($_POST['submit'] || $_GET['page'] > "0"){
$first = clean_up($_POST['first']);
$last = clean_up($_POST['last']);
$smoke = clean_up($_POST['smoke']);
$drink = clean_up($_POST['drink']);
$gender = clean_up($_POST['gender']);
$age_from = clean_up($_POST['age_from']);
$age_to = clean_up($_POST['age_to']);
$orientation = clean_up($_POST['orientation']);
$religious = clean_up($_POST['religious']);
$ethnicity = clean_up($_POST['ethnicity']);
$bodytype = clean_up($_POST['bodytype']);
$children = clean_up($_POST['children']);
$education = clean_up($_POST['education']);

if(!$_GET['page']){
if(!$first == ""){ setcookie("first", $first, time()+3600); }
if(!$last == ""){ setcookie("last", $last, time()+3600); }
if(!$smoke == ""){ setcookie("smoke", $smoke, time()+3600); }
if(!$drink == ""){ setcookie("drink", $drink, time()+3600); }
if(!$gender == ""){ setcookie("gender", $gender, time()+3600); }
if(!$age_from == ""){ setcookie("age_from", "$age_from", time()+3600); }
if(!$age_to == ""){ setcookie("age_to", "$age_to", time()+3600); }
if(!$orientation == ""){ setcookie("orientation", $orientation, time()+3600); }
if(!$religious == ""){ setcookie("religious", $religious, time()+3600); }
if(!$ethnicity == ""){ setcookie("ethnicity", $ethnicity, time()+3600); }
if(!$bodytype == ""){ setcookie("bodytype", $bodytype, time()+3600); }
if(!$children == ""){ setcookie("children", $children, time()+3600); }
if(!$education == ""){ setcookie("education", $education, time()+3600); }
}



$qquery = "SELECT `id`, `first`, `last`, `avatar`, `gender`, `about`, 
( (DATE_FORMAT(CURDATE(),'%Y') - DATE_FORMAT(`bdate`, '%Y') ) - ( DATE_FORMAT(CURDATE(), '00-%m-%d') < DATE_FORMAT( `bdate`, '00-%m-%d')) ) AS age
FROM `users`
WHERE ( (DATE_FORMAT(CURDATE(),'%Y') - DATE_FORMAT(`bdate`, '%Y') ) - ( DATE_FORMAT(CURDATE(), '00-%m-%d') < DATE_FORMAT( `bdate`, '00-%m-%d')) ) BETWEEN $age_from AND $age_to";

// if any of the options that are stored in the `users` table are selected, add AND to the query string,
//and store each needed part in an array, $users_criteria
if( $gender != "" || $first != "" || $last != "" ) {
$qquery .= ' AND ';
$users_criteria = array();
if( !empty($gender) ) {
$users_criteria[] = "`gender` = '$gender'";
}
if( !empty($first) ) {
$users_criteria[] = "`first` LIKE '%$first%'";
}
if( !empty($last) ) {
$users_criteria[] = "`last` LIKE '%$last%'";
}
$qquery .= implode( ' AND ', $users_criteria ); // implode the array, separating each part with AND, and append to query string
}

// Same process as above, but for results that come from `questions` table
if( $smoke != '' || $drink != '' || $orientation != '' || $religious != '' || $ethnicity != '' || $bodytype != '' ) {
$qquery .= ' AND id IN( SELECT `userid` FROM `questions` WHERE ';
$questions_criteria = array();
if( !empty($smoke) ) {
$questions_criteria[] = "`smoke` = '$smoke'";
}
if( !empty($drink) ) {
$questions_criteria[] = "`drink` = '$drink'";
}
if( !empty($orientation) ) {
$questions_criteria[] = "`orientation` = '$orientation'";
}
if( !empty($religious) ) {
$questions_criteria[] = "`religious` = '$religious'";
}
if( !empty($ethnicity) ) {
$questions_criteria[] = "`ethnicity` = '$ethnicity'";
}
if( !empty($bodytype) ) {
$questions_criteria[] = "`body_type` = '$bodytype'";
}
if( !empty($children) ) {
$questions_criteria[] = "`children` = '$children'";
}
if( !empty($education) ) {
$questions_criteria[] = "`education` = '$education'";
}
$qquery .= implode( ' AND ', $questions_criteria );
$qquery .= ' )';
}
$total = mysql_num_rows(mysql_query($qquery));

$page_count = ceil($total / 2);

$page = 1;
if (isset($getpage) && $getpage >= 1 && $getpage <= $page_count) {
    $page = (int)$getpage;
}
$skip = ($page - 1) * 2;

$query = "SELECT `id`, `first`, `last`, `avatar`, `gender`, `about`, 
( (DATE_FORMAT(CURDATE(),'%Y') - DATE_FORMAT(`bdate`, '%Y') ) - ( DATE_FORMAT(CURDATE(), '00-%m-%d') < DATE_FORMAT( `bdate`, '00-%m-%d')) ) AS age
FROM `users`
WHERE ( (DATE_FORMAT(CURDATE(),'%Y') - DATE_FORMAT(`bdate`, '%Y') ) - ( DATE_FORMAT(CURDATE(), '00-%m-%d') < DATE_FORMAT( `bdate`, '00-%m-%d')) ) BETWEEN $age_from AND $age_to";

// if any of the options that are stored in the `users` table are selected, add AND to the query string,
//and store each needed part in an array, $users_criteria
if( $gender != "" || $first != "" || $last != "" ) {
$query .= ' AND ';
$users_criteria = array();
if( !empty($gender) ) {
$users_criteria[] = "`gender` = '$gender'";
}
if( !empty($first) ) {
$users_criteria[] = "`first` LIKE '%$first%'";
}
if( !empty($last) ) {
$users_criteria[] = "`last` LIKE '%$last%'";
}
$query .= implode( ' AND ', $users_criteria ); // implode the array, separating each part with AND, and append to query string
}

// Same process as above, but for results that come from `questions` table
if( $smoke != '' || $drink != '' || $orientation != '' || $religious != '' || $ethnicity != '' || $bodytype != '' ) {
$query .= ' AND id IN( SELECT `userid` FROM `questions` WHERE ';
$questions_criteria = array();
if( !empty($smoke) ) {
$questions_criteria[] = "`smoke` = '$smoke'";
}
if( !empty($drink) ) {
$questions_criteria[] = "`drink` = '$drink'";
}
if( !empty($orientation) ) {
$questions_criteria[] = "`orientation` = '$orientation'";
}
if( !empty($religious) ) {
$questions_criteria[] = "`religious` = '$religious'";
}
if( !empty($ethnicity) ) {
$questions_criteria[] = "`ethnicity` = '$ethnicity'";
}
if( !empty($bodytype) ) {
$questions_criteria[] = "`body_type` = '$bodytype'";
}
if( !empty($children) ) {
$questions_criteria[] = "`children` = '$children'";
}
if( !empty($education) ) {
$questions_criteria[] = "`education` = '$education'";
}
$query .= implode( ' AND ', $questions_criteria );
$query .= ' LIMIT $skip, 2 )';
}


echo "<table width='100%' align='center'>";

if( $result = mysql_query( $query ) ) {
if( mysql_num_rows($result) > 0 ) {
while( $rr3 = mysql_fetch_assoc($result) ) {
$user=clean_up($rr3[id]);
$first=clean_up($rr3[first]);
$last=clean_up($rr3[last]);
$avatar=clean_up($rr3['avatar']);
$about=clean_up($rr3[about]);

echo "<tr><td valign='top' width='140' class='content'><center><img src='avatars/thumb/$avatar' /><br><a href='index.php?action=profile&id=$user'> $first $last</a></center></td><td class='content' valign='top'>".limitdesc($about)."</td></tr>";
}
} else {
echo '<tr><td colspan="2">Sorry, your search returned no results.</td></tr>';
}
} else {
echo '<tr><td colspan="2">We\'re sorry, there has been an error processing your request. Please try later.</td></tr>';
}
echo "</table>";


echo "<div class='content'><center>";

if($getpage == 0 || $getpage == 1){}else{
  $plink = $getpage - 1;
  echo "&nbsp; &nbsp; &nbsp; <a href='index.php?action=search&page=$plink'>Previous</a> &nbsp; &nbsp; &nbsp; ";
}

echo "<select id='ddp' onchange='document.location=(ddp.value)'>
<option value=''>Page #</option>";
for ($i = 1; $i <= $page_count; ++$i){
    echo ' <option value="index.php?action=search&page=' . $i . '">' . $i . '</option>';
} 
echo "</select>";

if($getpage == $page_count){}else{
if($page_count>1){
if($getpage == 0){
  echo " &nbsp; &nbsp; &nbsp; <a href='index.php?action=search&page=2'>Next</a> &nbsp; &nbsp; &nbsp; ";
}else{
  $nlink = $getpage + 1;
  echo " &nbsp; &nbsp; &nbsp; <a href='index.php?action=search&page=$nlink'>Next</a> &nbsp; &nbsp; &nbsp; ";
}
}
}
echo "</center></div>";

}

include ('footer.php'); ?>

I keep getting these errors:
Code: [Select]
Warning: Cannot modify header information - headers already sent by (output started at /home/gamersgo/public_html/datingsnap.com/header.php:4) in /home/gamersgo/public_html/datingsnap.com/pages/search.php on line 182

Warning: Cannot modify header information - headers already sent by (output started at /home/gamersgo/public_html/datingsnap.com/header.php:4) in /home/gamersgo/public_html/datingsnap.com/pages/search.php on line 183

the errors are coming from the setcookie lines. any idea why its spitting out that?

and when I search, the results don't come out to two results per page. so the pagination isn't working right and i am getting those errors. any ideas?

I can't get my head around it, no matter how many tutorials I read..
So would anyone be able to put this code into a pagination of 3 per page?

Many Thanks

Code: [Select]
<?php
if(!$_GET['id']) {
$query = "SELECT * FROM news where published = '1' ORDER by id DESC";
$result = mysql_query($query) or die(mysql_error());
$news = mysql_fetch_assoc($result);
?>
<?php do { ?>
<table width="590" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td colspan="2"><h2><? echo $news['title']; ?></h2></td>
  </tr>
  <tr>
    <td width="398"><? echo $news['story']; ?></td>
    <td width="192"><img src="<? echo $news['image']; ?>" alt="<? echo $news['shortstory']; ?>" width="192" height="108" /></td>
  </tr>
  <tr>
    <td colspan="2"><i><br />
    Posted by <? echo $news['author']; ?> on <? echo $news['date']; ?></i></td>
  </tr>
</table><br />
<?php } while ($news = mysql_fetch_assoc($result)); 
}
?>