Mam GuestBook, chcem vsak premennu post po odoslani odstranit, aby sa po refreshi zase neodoslala. Druha vec je ze mam spravenu ochranu if !empty, lenze ak dam medzeri do spravy tak ich odosle,prosim poradte dakujem.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Simple GuestBook</title>
<link href="style.css" rel="stylesheet" type="text/css" media="screen" />
<style type="text/css">
a {text-decoration: none; color: green;}
a:hover {text-decoration: underline; color: silver; position: relative; margin-left: auto; margin-right: auto;}
body{background-color: #020202; color: #f2f2f2;}
</style>
</head>
<body>
<center><a href="#" onClick="document.getElementById('forms').style.display='block'">Pridať príspevok</a>
<div id="forms" style="display: none">
<form method="POST" action="index.php">
Meno: <input type="text" name="autor" /><br /><br />
Správa: <textarea name="text" cols="50" rows="10" /></textarea><br /><br />
<input type="submit" />
</form>
</div>
</center>
<?php
/*
CREATE TABLE `gb`.`g_book` (
`id` INT NOT NULL AUTO_INCREMENT ,
`autor` TINYTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`text` TINYTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`ip` TINYTEXT NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci
*/
$autor = htmlspecialchars($_POST['autor']);
$text = htmlspecialchars($_POST['text']);
$pripoj = mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("gb");
if(!empty($_POST['autor']) and $_POST['text']){
$sql = mysql_query("INSERT INTO g_book(autor, text) VALUES('$autor', '$text')");
if($sql){
echo "<center>Správa odoslaná.</center>";
}
}
else{echo "<center>Nemôžete odoslať prázdnu správu.</center>";}
$sql = mysql_query("SELECT * FROM g_book ORDER BY id DESC");
while($vypis = mysql_fetch_array($sql)){
?>
<?php
include ('wrap.php');
echo "<b>" . $vypis['autor'] . "</b>" . "<br />" . " " . $vypis['text'] . "</div>"; }
?>
<br />
<center>© | Ján Šoltés | haxerko | 2009 | GNU licence</center>
</body>
</html>
