Pages help again...

[nezbo]

hi all

 

I have nearly finished the code and i cant seem to get it to display the <prev 1 2 3 4 etc.. on the pages after the first page.

 

e.g.

 

I click on next and it works fine but there is nothing there to click on the next page(s)... there is 5 pages on the first page that can be clicked on but nothing on the rest of the pages, all the data is there but no <prev 1 2 3 4 5 next>

 

Any ideas ?

 

$display = 10;

if (isset($_GET['np']))
{
	$num_pages = $_GET['np'];
}
else
{
	$query =  "SELECT COUNT(*) FROM job WHERE Completed='Yes' ORDER BY JobID DESC" or die("oh dear" . mysql_error());
	$result = mysql_query($query);
	$row2 = mysql_fetch_array($result, MYSQL_NUM);
	$num_records = $row2[0];
}

if ($num_records > $display) 
{
	$num_pages = ceil ($num_records/$display);
}
else
{
	$num_pages = 1;
}

if (isset($_GET["s"]))
{
	$start = $_GET["s"];
}
else
{
	$start = 0;
}

$completedJobs = "SELECT * FROM job WHERE Completed='Yes' ORDER BY JobID DESC LIMIT $start, $display" or die("crap!!!" . mysql_error());

$result2 = mysql_query($completedJobs);



echo "<table border=1 align = center width=90%><tr>";
echo "<tr><td colspan=10 align=center><h2>Check Jobs</h2><tr><td>";
echo "
<tr bgcolor = #acacac>
<td>Call ID
<td>PCIU Number
<td>Reported By
<td>Passed To
<td>Job Completed
<td>Problem Discription
<td>Outcome
<td>Date
<td>Time
<td>Site Name";

$bgcolour = "#ffffff";
while ($row = mysql_fetch_array($result2, MYSQL_ASSOC))
{

	if ($bgcolour == "#ffffff")
	{	
		echo "<tr bgcolor = #ffffff>
			<td><a href=editJob.php?job_identifier=$row[JobID] >$row[JobID] </a></td>
			<td align=left>$row[PCIUno]</td>
			<td align=left>$row[RepBy]</td>
			<td align=left>$row[PassedTo]</td>
			<td align=left>$row[Completed]</td>
			<td align=left>$row[Problem]</td>
			<td align=left>$row[OutCome]</td>
			<td align=left>$row[callDate]</td>
			<td align=left>$row[callTime]</td> 
			<td align=left>$row[site]</td>
		</tr>";
		$bgcolour = "#ececec";
	}
	else
	{	
		echo "<tr bgcolor = #ececec>
			<td><a href=editJob.php?job_identifier=$row[JobID] >$row[JobID] </a></td>
			<td align=left>$row[PCIUno]</td>
			<td align=left>$row[RepBy]</td>
			<td align=left>$row[PassedTo]</td>
			<td align=left>$row[Completed]</td>
			<td align=left>$row[Problem]</td>
			<td align=left>$row[OutCome]</td>
			<td align=left>$row[callDate]</td>
			<td align=left>$row[callTime]</td> 
			<td align=left>$row[site]</td>
		</tr>";
		$bgcolour = "#ffffff";
	}
}
if ($num_pages > 1)
{
	echo "<br /><p>";
	$current_page = ($start/$display) + 1;

	if ($current_page != 1) 
		{
			echo "<a href=\"checkCompletedJobs.php?s=" . ($start - $display) . "&np=" . $num_pages . "\">Previous</a> ";
		}

	for ($i = 1; $i <= $num_pages; $i++)
		{
			if($i != $current_page)
				{
						echo "<a href=\"checkCompletedJobs.php?s=" . ($display * ($i - 1)) . "&np=" . $num_pages . "\">" . $i . "</a> ";
				}
				else
				{
					echo $i . "";
				}
		}
		if ($current_page != $num_pages)
			{
				echo "<a href=\"checkCompletedJobs.php?s=" . ($start + $display) . "&np=" . $num_pages . "\">Next</a>";
			}

}

[BillyBoB]

if you would like i have developed a pagination function which is really easy to insert into your coding. there is a lot of lines with it but it does work in every situation. if you would like it just ask i will monitor this post.

[Yesideez]

I take it that script I posted yesterday was a bit much?

[BillyBoB]

Yesideez what do you mean?

 

if you have aim mine is: BillyBoB66969

 

this is the only way i will post it so i can keep it a little more private

 

[Yesideez]

I posted a complete script yesterday which had dynamic pageinating functions and an index along with "Next" and "Previous" to almost the exact same question yesterday.

 

I'm thinking my script was a little too much.

[BillyBoB]

ok well i will just go ahead and post the code and how to use it:

 

<?php
function pagination($h,$get,$page,$z) {
$g = ceil($h/$z);
$d = 0;
$u = 0;
$o = 0;
if($g>1) {
	while($d!=$g) {
		$d++;
		if($get) {
			if($get==$g){
				$c = $get - 4;
				if($c!=0) {
					$o = 1;
				}
				if($o==0) {
					$d = $get - 3;
					$o = 1;
				}
				if($d==$get) {
					echo("<b>[$d]</b>");
					echo(" ");
				}else{
					$c = $get - 4;
					if($c!=0) {
						echo("<a href=\"$page&pg=$d\">$d</a>");
						echo(" ");
					}else{
						if($u==0) {
							echo("<a href=\"$page&pg=1\">1</a>");
							echo(" ... ");
							$u = 1;
						}else{
							echo("<a href=\"$page&pg=$d\">$d</a>");
							echo(" ");
						}
					}
				}
			}else{
				if($d==$get) {
					echo("<b>[$d]</b>");
					echo(" ");
				}else{
					if($get==1) {
						if($d<4) {
							echo("<a href=\"$page&pg=$d\">$d</a>");
							echo(" ");
						}else{
							echo("... <a href=\"$page&pg=$g\">$g</a>");
							$d = $g;
						}
					}else{
						$a = $get - 4;
						$b = $get + 2;
						if($a>0) {
							if($d==$get) {
								echo("<b>[$d]</b>");
								echo(" ");
							}else{
								if($u==0) {
									echo("<a href=\"$page&pg=1\">1</a>");
									echo(" ... ");
									$u = 1;
								}else{
									if($o==0) {
										$d = $get - 2;
										$o = 1;
									}
									if($get+3==$d) {
										if($b<$g-1) {
											echo(" ... ");
											echo("<a href=\"$page&pg=$g\">$g</a>");
											$d = $g;
										}else{
											echo("<a href=\"$page&pg=$d\">$d</a>");
											echo(" ");
										}
									}else{
										echo("<a href=\"$page&pg=$d\">$d</a>");
										echo(" ");
									}
								}
							}
						}else{
							if($get+3==$d) {
								if($b<$g-1) {
									echo(" ... ");
									echo("<a href=\"$page&pg=$g\">$g</a>");
									$d = $g;
								}else{
									echo("<a href=\"$page&pg=$d\">$d</a>");
									echo(" ");
								}
							}else{
								echo("<a href=\"$page&pg=$d\">$d</a>");
								echo(" ");
							}
						}
					}
				}
			}
		}else{
			if($d==1) {
				echo("<b>[$d]</b>");
				echo(" ");
			}else{
				if($d<4) {
					echo("<a href=\"$page&pg=$d\">$d</a>");
					echo(" ");
				}else{
					echo("... <a href=\"$page&pg=$g\">$g</a>");
					$d = $g;
				}
			}
		}
	}
}else{
	echo("<b>[1]</b>");
}
}
?>

 

this is quite a big function but it is very effective.

 

to use it you must have this at the begining of the page or require_once from a functions.php page

 

<?php
pagination($h,$_GET['pg'],"yourpage.php?",5);
?>

ok the $h has to be how many rows you have exaple(this isnt good coding just a ex.) while("SELECT * FROM info") { $h++; }

the $_GET['pg'] is the page number you are on i would keep this system on a GET cmd of pg

the page is the page which can include other GET cmds like action=view you would enter yourpage.php?action=view and so on

the 5 is the intraval like how many you want on a page this was an extra addition to the code so that i could use it on multiple sites.

 

If you would like any more info on this please just ask PM me maybe

[nezbo]

hehe, i had allready done most of the code to get it to this stage, but i was in 2 minds wether to use your code...

 

I take it that script I posted yesterday was a bit much?

[BillyBoB]

so what does this mean can i ask which you decided to go with?

[nezbo]

I think i am going to stick with my orginal code...

 

so dose any one know how to get it to work?

 

 

so what does this mean can i ask which you decided to go with?

[BillyBoB]

ok in order for me to really help i would need to see this script in action can you hook me up with a link to where you have it?

[sasa]

change name 'no problem' to 'no_problem'

[nezbo]

Cool

 

Here is the web link

 

 

http://www.eastlancsmedicalservices.co.uk/checkCompletedJobs.php

 

ok in order for me to really help i would need to see this script in action can you hook me up with a link to where you have it?

[nezbo]

sorry i dont get it ???  ???

 

change name 'no problem' to 'no_problem'

[BillyBoB]

i dont see how the code you gave us can make that links code

the np= isnt in your code at all....

[nezbo]

the code i sent you is only making the main body of the script i am including hedders and footers etc...

 

so the code is the table and the numbers etc...

 

i dont see how the code you gave us can make that links code

the no problem= isnt in your code at all....

[sasa]

remove np=7 from your link, you calculate from s in which page you are

 

i see in your page that you don't use no problem (it is no problem, i think)

name with space is not regular from form field, convert space to '_'

[nezbo]

im easly confused and that has done the trick  :'(

 

 

 

 

remove no problem=7 from your link, you calculate from s in which page you are

 

i see in your page that you don't use no problem (it is no problem, i think)

name with space is not regular from form field, convert space to '_'

[sasa]

is it work now?

 

[nezbo]

It's still not working :'(

 

is it work now?

 

[sasa]

remove part np=blah from your link

 

try use link http://www.eastlancsmedicalservices.co.uk/checkCompletedJobs.php?s=10

[BillyBoB]

all of the pages work without the np=blah except they have a 7 infront of the Previous

[nezbo]

 

It seams to be working now yippee.

 

i thought you was just bullying my with the "no Problem" thing but it turns out i was just confused and you are all genouses

 

Cheers

 

all of the pages work without the no problem=blah except they have a 7 infront of the Previous

[sasa]

i see that you remove 7 in front

 

this forum convert'np' to np

if confused me

[BillyBoB]

please mark this as solved