Jump to content

Non Programmer requesting Pagination Help

raymond22

By raymond22
in PHP Coding Help

 Share

Recommended Posts

raymond22 Newbie

raymond22

Posted
Posted

Hi all. 

 

I have been trying something for 2 days, having no success and was hoping someone could help.  I know this is a long post but it's mostly just php code below. 

 

I'm trying to do "pagination" for a script that I came across.  First of all.. I am not a programmer in any way.  I didn't even know what pagination was until 2 days ago when I was trying to explain what I wanted in a forum and was educated.  So.. off to Google I went.  I found all kinds of "free pagination" script articles with "how-to's".  Well.. I think you need to at least have an idea of how to program becuase I've tried 4 now and failed every time.  Or... maybe I'm just the world's worst at understanding programming concepts (very possible).  I really have spent just hours and hours trying to make pagination happen.. to no avail. 

 

So.. if you know an easier way, please share!  Or.. If you care to read on and help with the pagination script I've been trying to make work, that would be awesome.  Either way, I would be most grateful! 

 

Here's what I got and what I've tried..

 

My index.php page:

 

<?php 
include_once('inc_dbcon.php'); 
require_once('admin/config.php');
require_once($languageFile);

// Preview descrition length in characters
$previewLength = 240;

// check to see if in admin mode and validate key
global $keyOut;
$keyOut = "";
if (isset($_GET["k"]))
if($_GET["k"] == $key){ // Key comes from admin/password.php file
	$keyOut = "&k=" . $key;
}

global $category;
$category = "%";
if (isset($_GET["category"]))
$category = mysql_real_escape_string($_GET["category"]);

$msg = "";
if (isset($_GET["msg"]))
$msg = mysql_real_escape_string($_GET["msg"]);

// SEARCH CODE START
$searchQuery = "";
if (isset($_GET["q"]))
$searchQuery = mysql_real_escape_string($_GET["q"]);

if ($searchQuery != "") 
{
$query_Recordset1 = "SELECT postId,category,title,description,isAvailable,description,price,confirmPassword,category,imgURL,imgURLThumb,DATE_FORMAT(timeStamp,'%b %d, %Y %l:%i %p') AS timeStamp1 FROM md_postings WHERE isConfirmed = '1' AND title like '%$searchQuery%' OR description like '%searchQuery%' ORDER BY `timeStamp` DESC";
} else {

$query_Recordset1 = "SELECT postId,category,title,description,isAvailable,description,price,confirmPassword,category,imgURL,imgURLThumb,DATE_FORMAT(timeStamp,'%b %d, %Y %l:%i %p') AS timeStamp1 FROM md_postings WHERE isConfirmed = '1' AND category like '$category' ORDER BY `timeStamp` DESC";
}
// SEARCH CODE END - see also line 113 below

$maxRows_Recordset1 = 100;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
  $pageNum_Recordset1 = mysql_real_escape_string($_GET['pageNum_Recordset1']);
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1);
if (!$Recordset1){    
	print("It appears we have a problem: " . mysql_error());    
	exit();  
}
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
if (isset($_GET['totalRows_Recordset1'])) {
  $totalRows_Recordset1 = mysql_real_escape_string($_GET['totalRows_Recordset1']);
} else {
  $all_Recordset1 = mysql_query($query_Recordset1);
  $totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
$queryString_Recordset1 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_Recordset1") == false && 
        stristr($param, "totalRows_Recordset1") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_Recordset1 = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="md_style.css" rel="stylesheet" type="text/css" />
<script language="JavaScript">
function doFilter(dis)
{
window.location.href = "index.php?category=<?php echo $category ?>&type=" + dis.value + "<?php echo $keyOut;?>"
}	
</script>
</head>
<body>
<?php include_once("inc_navigation.php") ;?>
<div id="md_container">

<?php 
if ($msg == "deleted")	
	print("<br clear='all' /> <div class='md_msg' style='margin-top:-10px;'>" . STR_DELETED ."</div>"); 
?>
<br clear="all" />	
<div id='md_listingBox'>
<?php
if($totalRows_Recordset1 < 1)
{
// SEARCH START new Code - added IF statement to support search
if ($searchQuery != "")
echo "<p><br /><br /><br />" . STR_NORESULTS . "<b>" . $searchQuery ."</b></p>";
else
	echo "<p><br /><br /><br />" . STR_NOITEMS . "</p>";
// SEARCH END NEW CODE
} else {

do { 
  	 $img = "/images/gift_light.gif' title='This is a gift!'";
 $type = $row_Recordset1['type'];
 $isAvailable = $row_Recordset1['isAvailable'];
     $isAvailableClass = ($isAvailable == 0) ? 'md_taken' : ''; 
 $thumbnail = ' ';
 if (strlen($row_Recordset1['imgURLThumb']) > 3){
 	$thumbnail = "<a href='viewItem.php?id=" . $row_Recordset1['postId'] . "' class='md_recordLink " . $isAvailableClass . "'>";
	$thumbnail .= "<img src='" . $row_Recordset1['imgURLThumb'] . "' class='md_thumbnail' border='0'></a>";
}
?>
<table width="100%" border="0" cellpadding="4" class="md_listingTable">
  <tr>
    <td width="54" align="center"><?php echo $thumbnail; ?></td>
    <td valign="top">
    <div class='md_date'><?php echo $row_Recordset1['timeStamp1'];?></div> 
    <a href="viewItem.php?id=<?php echo $row_Recordset1['postId'] . $keyOut;?>" 
    class='md_recordLink<?php echo $isAvailableClass; ?>'><?php echo stripslashes($row_Recordset1['title']); ?></a> 
    &#8212; $<?php echo $row_Recordset1['price']; ?> <br />
    <?php echo stripslashes(substr($row_Recordset1['description'],0,$previewLength)); ?>...
    </td>
  </tr>
</table>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); 
} // end else clause
?>

</div>
</div>
<?php include_once("inc_footer.php");?>
</body>
</html>
<?php 	mysql_close($dbConn); ?>

 

Here's the inc_dbcon.php file that it calls to connect:

<?php

// Change these to be for your database
$dbhostname = "localhost";
$dbname     = "justtes1_123";
$dbusername = "justtes1_12";
$dbpassword = "abc12";		

if(!$dbConn = mysql_connect($dbhostname, $dbusername, $dbpassword))
die('I could not connect to the database. Clease check the inc_dbcon file and make sure everything is correct.');
if(!mysql_select_db($dbname, $dbConn))
die('I could not select the database. Check the inc_dbcon file and make sure everything is correct.');
?>

 

I've trying to use the pagination script from:  http://www.phpeasycode.com/pagination/

 

Here's the "usage example" that is in the pagination script:

<?php

$rpp = 10; // results per page
$adjacents = 4;

$page = intval($_GET["page"]);
if($page<=0) $page = 1;

$reload = $_SERVER['PHP_SELF'];

// connect to your DB:
$link_id = mysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error());
mysql_select_db($dbname, $link_id);

// select appropriate results from DB:
$sql = "SELECT * FROM table_name WHERE table_field LIKE '%search string%' ORDER BY field_name";
$result = mysql_query($sql, $link_id);

// count total number of appropriate listings:
$tcount = mysql_num_rows($result);

// count number of pages:
$tpages = ($tcount) ? ceil($tcount/$rpp) : 1; // total pages, last page number

$count = 0;
$i = ($page-1)*$rpp;
while(($count<$rpp) && ($i<$tcount)) {
    mysql_data_seek($result,$i);
    $query = mysql_fetch_array($result);

    // output each row:
    echo "<p>" . $query['table_field_1'] . ", " . $query['table_field_2'] . "</p>\n";

    $i++;
    $count++;
}

// call pagination function:
include("paginate.php");
echo paginate_three($reload, $page, $tpages, $adjacents);
?>

 

The pagination script also comes with a demo.php.  I uploaded that and it works just great.  But.. when I try to incorporate the above usage into my index.php, I fail miserably. 

So.. If you prefer, I can copy index.php with what I've tried.. which is apparently very wrong.  The page I tried it in is here:  http://justtesting.freehosting.com/indexPaginate.php

 

So.. if anyone is able to tell me how they'd incorporate the usage script into the index.php, that would solve my 2 day dilemna and I would be eternally grateful. 

 

If you want to login to my test version (feel free to edit as this is purely a test site), it's here: 

 

http://justtesting.freehosting.com/

ftp host:  62.75.203.94

FTP Username: justtes1

FTP Password: JpxF34j80h

 

A HUGE thanks for anyone who can help!  I have tried everything for hours and hours.. 

Pandemikk Newbie

Pandemikk

Posted
Posted

 

After reading the article, you should have tried a few examples

 

He's not a coder. He already has a pagination script set up. Again, read the thread before you reply.

 

@OP, I don't think anyone's going to come near this topic. You posted a shitload of code but hardly any of it was relevant. You need to shorten the code to the bare essentials (queries, necessary php, etc).

raymond22 Newbie

raymond22

Posted
  • Author
Posted

 

After reading the article, you should have tried a few examples

 

He's not a coder. He already has a pagination script set up. Again, read the thread before you reply.

 

@OP, I don't think anyone's going to come near this topic. You posted a shitload of code but hardly any of it was relevant. You need to shorten the code to the bare essentials (queries, necessary php, etc).

 

Thanks Pandemikk.  I wondered if that was the issue.  I did have someone pm me that he would do this for $100 so I'll likely just go that route to get it done at this point.  Money talks I guess.  :)

voip03 Member

voip03

Posted
Posted

 

After reading the article, you should have tried a few examples

 

He's not a coder. He already has a pagination script set up. Again, read the thread before you reply.

 

@OP, I don't think anyone's going to come near this topic. You posted a shitload of code but hardly any of it was relevant. You need to shorten the code to the bare essentials (queries, necessary php, etc).

THANK YOU

Jeffro Regular Member

Jeffro

Posted
Posted

 

After reading the article, you should have tried a few examples

 

He's not a coder. He already has a pagination script set up. Again, read the thread before you reply.

 

@OP, I don't think anyone's going to come near this topic. You posted a shitload of code but hardly any of it was relevant. You need to shorten the code to the bare essentials (queries, necessary php, etc).

THANK YOU

 

lol.. had to get that last word in?  come on man.. OP was just very new to this stuff.  I have personally always loved this forum because despite my lack of programming skills, everyone is always over the top in being helpful.  better to not say anything if you're just going to be negative with every post. 

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.