big pagination problem in php

Posted on 16th Feb 2014 07:03 pm by admin

<?php

$connect = mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("guest") or die(mysql_error());

function bbcode($string)
{
if ($string) {
$bbcode_array = array('[b]', '[/b]', '[u]', '[/u]', '[i]', '[/i]', '[code]',
'[/code]', '[img]http://', '[/img]');
$bbcode_array_2 = array('<b>', '</b>', '<u>', '</u>', '<i>', '</i>',
'<center><div style="width:90%;padding:3px;background-color:#000099;color:#FFFFFF;border:2px solid;">',
'</div></center>', '<img src="', '">');

$new_string_2 = str_ireplace($bbcode_array, $bbcode_array_2, $string);

return $new_string_2;
}
}

echo "<h1>Guestbook</h1><hr />";

$queryget = mysql_query("SELECT * FROM guest ORDER BY id DESC") or die(mysql_error());

$querygetrownum = mysql_num_rows($queryget);

if ($querygetrownum == 0) {
echo "No posts have been made yet! Be the first!";
}

$per_page = 5;

$start = $_GET['start'];

$record_count = mysql_num_rows(mysql_query("SELECT * FROM guest"));

$max_pages = $record_count / $per_page;

if (!$start) {
$start = 0;

$get = mysql_query("SELECT * FROM guest ORDER BY id DESC LIMIT $start, $per_page");

while ($row2 = mysql_fetch_assoc($get)) {
$name2 = $row2['name'];
$email2 = $row2['email'];
$message2 = $row2['message'];
$date2 = $row2['date'];
$time2 = $row2['time'];
echo "<table><tr><td><b>Posted by: " . $name2 . "(" . $email2 . ") on " . $date2 .
" at " . $time2 . "</b></td></tr><tr><td>" . nl2br(bbcode(strip_tags($message2))) .
"</td></tr></table>";
echo "<hr />";
}
}
//setup prev and next variables
$prev = $start - $per_page;
$next = $start + $per_page;

//show prev button
if (!($start <= 0)){
echo "<a href='index.php?start=$prev'>Prev</a> ";
}else{
echo "&laquo; Prev";
}
//show page numbers

//set variable for first page
$i = 1;

for ($x = 0; $x < $record_count; $x = $x + $per_page) {
if ($start != $x){
echo " <a href='index.php?start=$x'>$i</a> ";
}else{
echo " <a href='index.php?start=$x'><b>$i</b></a> ";
}
$i++;
}

//show next button
if (!($start >= $record_count - $per_page)){
echo " <a href='index.php?start=$next'>Next</a>";
}else{
echo "Next &raquo;";
}
if ($_POST['submit']) {
$name = $_POST['name'];
$email = $_POST['email'];
$message = $_POST['message'];
$date = date("Y-m-d");
$time = date("H:i:s");

if ($name && $email && $message) {
$querypost = mysql_query("INSERT INTO guest VALUES('','" . $name . "','" . $email .
"','" . $message . "','" . $date . "','" . $time . "')");
echo "Please wait... <meta http-equiv='refresh' content='2'>";
} else {
echo "Please fill out all fields!";
}
}

echo "<hr />";

echo "
<form action='index.php' method='POST'>

<table width='100%'>

<tr>

<td width='7%' valign='top'>
Your Name:
</td>

<td valign='top'>
<input type='text' name='name' maxlength='25' />
</td>

</tr>

<tr>

<td valign='top'>
Your Email:
</td>

<td>
<input type='text' name='email' maxlength='25' />
</td>

</tr>

<tr>

<td valign='top'>
Your Message:
</td>

<td>
<textarea cols='20' rows='2' name='message' maxlength='250'></textarea>
<p><input type='submit' name='submit' value='Post' />
</td>

</tr>
</table>

</form>";

?>

<style type="text/css">
body{font-family:Arial;font-size:14px;background-image: url('./images/bg.png');color:#FFFF00;}h1{font-family:Arial;}hr{color:#FFFF00; }a{color:#FFFFFF;text-decoration:none;}a:hover{color:#FFFFFF;text-decoration:underline;}
</style>

i'm having a problem with the next row of results. They wont show...

Your Answer:

Login to answer

Other forums

PHP search multiple input field box help
I am having a problem with my search script. At current it will simply search by a selected date whi

get the country of visitor and display content based on that
Hello all,

I have seen that Google analytics can tell you where a visitor is coming from and

Motivational Posters
Hello,

I wonder how can i do them in php. Are there any sample codes that you can show me?

trouble printing an array....
I'm having some trouble printing out an array forwards. I'm figuring out the high and low of an arra

understanding functions and classes
Code: [Select]
class person {
var $name = "Jimmy Goe";

function get_nam

what business processes?
Hi,

A general question. What business processes (like OTC - Order to Cach, P2P, R2R etc)

Doubles are giving me problems
Ok so, first of all i made a double = 0.05, but when running the debugger it shows up as 0.04999. I

PHP webpage & array print issue
I have this code running, and it works perfectly … however, see my bottom bit about what I see

Issues: PHP Forms -Clearing
I've tried looking online before actually asking for help, but I've been looking for about the past

Contents of variable not echoing
Hey guys, hopefully this is an easy one...

In this line, the variables are not echoing out. T