Newbie With Pagination Help

djdvine · April 7, 2008

All, I am a newbie to PHP / MYSQL and for 2 months I have been trying to figure out how to paginate my new movie database I created. I have been able to figure it out when I don't have a "SUBMIT" button on a form (to search for certain criteria), but when the user enters a search term and hits "Next" on the hyperlink to go to the next page of results, it comes up blank. I believe the search term isn't carrying over for some reason.

Below is my code, and I have taken off all of the pagination code I had, so I won't confuse anyone. Can someone PLEASE input the correct code in the correct spots so I can paginate the results? (10 items per page will be fine). Thanks in advance, this is KILLING ME!

(Im using this for my personal movie database website http://daveallen33.com/movies/query.php)

//BEGIN CODE//

</FORM>

echo"<input type=submit name=submit value=submit>";

echo "</FORM>";

$cast = $_GET['cast'];

if ($_GET['cast'] =="")

{

echo "you did not enter any value in the search box";

exit();

}

//MY SEARCH QUERY//

if($cast != ""){

$query = "SELECT * FROM MAIN WHERE

CAST LIKE \"%$cast%\" ORDER BY TITLE";

$result = mysqli_query($cxn,$query)

or die ("NO YOU IDIOT");

$nrows = mysqli_num_rows($result);

echo "Actor Only</CENTER> ";

if ($nrows >0){

echo "<center><img src=images/newang.jpg border=1> ";

echo "So, You Want To See $cast ? Here Are $nrows of Dave's Movies to Choose From:</center> ";

echo "<center><a href=\"http://www.imdb.com/find?s=all&q=$cast\" target=_blank>See $cast's Other Movies</a></center> ";

}

else

{

echo "<center><img src=images/thebotch.jpg border=2> ";

echo "Your Search For $cast Came Up Empty, Try Again...JackAss!</center> ";

}

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

$movie_id = $row['MOVIE_ID'];

$cover_art= $row['COVER_ART'];

$title= $row['TITLE'];

$genre= $row['GENRE'];

$year= $row['YEAR'];

$length= $row['LENGTH'];

$cast= $row['CAST'];

$review= $row['REVIEW'];

$director= $row['DIRECTOR'];

$summary= $row['SUMMARY'];

echo "<table>

<tr><td bgcolor=#660033>$title ($year) <a href=trailers/movie_trailers/$movie_id.html><img align=left src=images/CoverArt/$cover_art border=3 alt=\"$title\"></a>

$genre Film Directed by $director, and $length Long

SUMMARY: $summary

CAST: $cast

</td></tr>

</tr></td></table>";

}

?>

Again, thanks, if you have any questions, please feel free to email me

netphreak · April 7, 2008

Not 100% certain, but I believe you must have a submit button to handle post data. You can't send any form data with a hyperlink, even if you use $_GET.

Try styling your submit button instead With CSS you can make it look just as you want.

BillyBoB · April 7, 2008

Please do your research before posting.

If you need a pagination function I created one a while back that you could use if you would like.

Just hit me up on AIM: BillyBoB66969 or MSN: [email protected]

djdvine · April 7, 2008

Not 100% certain, but I believe you must have a submit button to handle post data. You can't send any form data with a hyperlink, even if you use $_GET.

Try styling your submit button instead With CSS you can make it look just as you want.

Forgive my ignorance, as I'm new to this, but I do have a submit button, it was the first line of code. Once the user hits the submit button, it executes the search. It's that search I'm trying to paginate. I'm not very confident with CSS just yet, I need to stick with HTML for now.

Thanks...

djdvine · April 7, 2008

Please do your research before posting.

If you need a pagination function I created one a while back that you could use if you would like.

Just hit me up on AIM: BillyBoB66969 or MSN: [email protected]

Thanks for the reply, trust me, I have done tons of research on this subject. I just havent been able to find the right answer. I guess what I'm looking for is someone that knows what they are talking about to say "At Line 10, enter "blah blah blah"

Sorry if I'm making this more difficult than it is....

BillyBoB · April 7, 2008

djdvine I wasn't speaking toward you on that one it was toward netphreak because his statement was very wrong..

just incase you want the function:

<?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>");
}
}
?>

In order to make it work:

Put this at the top before you are going to list the info make sure you edit correctly.

This query is the one that you use to display the info below it. In your case the movies.

<?php
$h = 0;
$paquery = mysql_query("SELECT * FROM table");
while($painfo = mysql_fetch_array($paquery)) {
$h++;
}
if($_GET['pg']) {
$pg = $_GET['pg'] * 20;
$low = $pg - 20;
$query = mysql_query("SELECT * FROM table LIMIT $low,20");
}else{
$query = mysql_query("SELECT * FROM table LIMIT 20");
}
$i = 0;
?>

Put this wherever you need to have the pages show up.

Edit the members.php? to whatever your pagename is and the 20 is the limit per page edit as above also. (you need not worry about the $h or the $_get[pg] as long as you don't edit them above.

<?php
if(!$_POST[submitquery]){
pagination($h,$_GET['pg'],"members.php?",20);
}
?>

djdvine · April 7, 2008

djdvine I wasn't speaking toward you on that one it was toward netphreak because his statement was very wrong..

Oh, ok, thanks for the clarification.

djdvine · April 7, 2008

Thanks for the code...I'll see what I can do with it...I'll let ya know..

netphreak · April 7, 2008

And I am sorry if I were wrong. Just trying to help. That's why I also wrote that I'm not sure about this. So it's not called a statement then?

I'm no professional. Sorry, I will not post my believes in here again.

djdvine · April 7, 2008

And I am sorry if I were wrong. Just trying to help. That's why I also wrote that I'm not sure about this. So it's not called a statement then?

I'm no professional. Sorry, I will not post my believes in here again.

No Prob Netphreak...I don't think we'd be on this board if we all weren't trying to get help from somewhere. I don't think anyone can be the total expert on this stuff. So...feel free to post your beliefs whenever you like, it's America baby!

Sign In

Newbie With Pagination Help

Recommended Posts

djdvine

Link to comment

Share on other sites

netphreak

Link to comment

Share on other sites

BillyBoB

Link to comment

Share on other sites

djdvine

Link to comment

Share on other sites

djdvine

Link to comment

Share on other sites

BillyBoB

Link to comment

Share on other sites

djdvine

Link to comment

Share on other sites

djdvine

Link to comment

Share on other sites

netphreak

Link to comment

Share on other sites

djdvine

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information