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

User information
Hi All,
By using t-code SUIM we get all the user details,if suppose we donot have permission t

for some reason mysql query not working, not inserting, please check it out
This code is not inserting anything into my db, don't know why, the $_SESSION variable does contain

Save username into DB
OkaY so I got my blog to actually save the posts and whatever, all I need now is for it to keep the

session variable problem
Session variable is not working in Fire fox i am getting null value but it is working fine in IE.

restricting another login once you logout
Hello,

how can I restrict a page from login authenticating against info in a MySQL DB for a s

MII Netweaver Server stopped due to CPIC connection Problem
Dear Experts,
We have SAP XMII 12.0 setup running on Netweaver 2004s,7.0, Java Stack only.

Access database inside of a validation class
Hello,

For quite some time, I have been using functions to validate form input and access the

PHP Error
On my .php page I have a drop down box that has several names in it. When a user clicks the name &am

search query in mysql in php problem
my search query wont work, i know, that my codes are correct.please help

Code: [Select]&l

Mysql query, two times?
Hello to all,

I'm new to php coding and i like it alot. I need help with some noob stuff.