<?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 "« 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 »";
}
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...
values not being entered into table
hi. I;ve created a form, so that when a user enters data into it, it gets added to a table in a database. the form submits some data to one table, and other data to another table. my problem is that
Best way to read this text file.
Hi.I am planning to make a small application in C# to convert the players from Football manager 2010 game into Fifa 10 game.I have this text file exported from
output printing as hexadecmal... XD
Everything works except the calcem call for the totusold and totuprice. The out put shows up as hex. Im not positive but i think i might have to use PBV or PBR?
SAP Business Suite
Hi all:
passthru() help
Hi everyone,I'm new to the forum and to PHP. I have some pretty good experience writing shell scripts, but beyond that, I'm not much of a programmer. That being said, here's what I'm trying to do:I'm
Undefined offset when using a flat file with pipe symbols
Hi, I've got a flat file/text file which I'm currently using as a member database for my site (not advisable I know.. but still learning here).In a section of code I need to separate the fields to
License Issue - service type user
Hi,
php file erros / need help please
HelloSomeone decoded a zend file for me.. after uploaded it on ftp i get some errors, i tryed to fix but (dont know if what it did is right, i dont have skills in php) now im stuck and i dont know
phpMailer not working ..........
HI,I was playing with the phpMailer script and tried to send a smiple mail using their test script from my site ..... it said "send again" but i am not getting mail ..........Does anybody
Getting Subdomain Name With PHP?
I want to grab the subdomain name with PHP so I can generate database queries.for example my subdomain is san-jose.mydomain.comHow would I go about grabbing the subdoman name with PHP? Thanks!