Så får i hele koden... Men der er altså ikke mere der har med selvom submit-delen at gøre:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>AAGIF.DK</title>
<link rel="stylesheet" type="text/css" href="style.css">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
</head>
<body>
<center>
<?
function convert_links($str)
{return preg_replace("/((http|https|ftp)+(s)?:(\/\/)([\w]+(.[\w]+))([\w\-\.,@?^=%&:;\/~\+#]*[\w\-\@?^=%&:;\/~\+#])?)/i", "<a href=\"\\0\" class=\"gbook\">\\0</a>", $str);};
include('top.php'); ?>
<table cellpadding="0" cellspacing="0" height="450" width="800" style="border-left: solid 1 BLACK; border-right: solid 1 BLACK">
<tr>
<td valign="top">
<table width="200" height="100%">
<tr>
<td valign="top">
<? include('menu.php');?>
</td>
</tr>
</table>
</td>
<td valign="top">
<table background="Verticalline.gif" cellpadding="0" cellspacing="0" width="18" height="100%" style="border-left: solid 1 BLACK; border-right: solid 1 BLACK;">
<tr>
<td valign="top" align="center" class="menu"></td>
</tr>
</table>
</td>
<td valign="top">
<table cellpadding="5" cellspacing="5">
<tr>
<td width="500"><h1>:Gæstebog:<hr width="100%" align="left" size="2" noshade></h1>
<table cellpadding="10">
<tr>
<td valign="top">
<?
$db = mysql_connect("localhost","******","******");
mysql_select_db("******", $db);
if(isset($_POST['skriv'])){
$query = "SELECT * FROM users WHERE username = $_POST['username'] AND password = $_POST['password']";
$result = mysql_query($query, $db) or die('error making query');
$affected_rows = mysql_num_rows($result);
if($affected_rows == 1) {
echo "Så er der fundet en række.<br><br>";
$dato_array = getdate();
$dato = $dato_array["mday"]."/".$dato_array["mon"]."-".$dato_array["year"];
$navn = $_POST["navn"];
$email = $_POST["email"];
$besked = convert_links($_POST["besked"]);
if(mysql_query("INSERT INTO gbog (navn, email, dato, besked) VALUES ('$navn', '$email', '$dato', '$besked')")) {
echo "Og INSERT virkede også fint."; }
else { echo "Desværre mislykkedes INSERT i tabellen."; }
}
?>
<table>
<?
$pagesize = 10;
if (empty($_GET[start])) {
$start = 0;
} else {
if (is_numeric($_GET[start])) {
$start = $_GET[start];
} else {
$start = 0;
}
}
$foresp = mysql_query("SELECT navn, email, dato, besked FROM gbog ORDER BY nr DESC LIMIT $start,$pagesize");
while($data = mysql_fetch_row($foresp)){
echo "<tr><td valign=top width=30% style='border-right: 1 solid BLACK'>";
echo "Skrevet af: <a href=\"mailto:$data[1]\">$data[0]</a>";
echo "<br>$data[2]";
echo "</td><td valign=top width=70% style='border-left: 1 solid BLACK'>$data[3]</td></tr>";
}
$pages = ceil(mysql_num_rows(mysql_query("SELECT nr from gbog"))/$pagesize);
for ($i = 1; $i <= $pages; $i++) {
$startnow = $pagesize*$i;
$startnow = $startnow-$pagesize;
if ($startnow == $start) {
$sidehtml .= "<a href='gbook.php?start=$startnow'><b>[$i]</b></a>";
}else{
$sidehtml .= "<a href='gbook.php?start=$startnow'>[$i]</a>";
}
}?>
</table><br><br>
<? echo "Gå til side: ".$sidehtml;
?>
<br><br><br>
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<input type="hidden" name="skriv" value="1">
Navn:<input type="text" name="username"><br>
Password: <input type="password" name="password"><br>
E-mail:<input type="text" name="email"><br>
<textarea name="besked" cols="30" rows="5"></textarea><br>
<input type="submit" value="send">
</form><br><br>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<? include('buttom.php'); ?>
</center>
</body>
</html>
