jeg har en gammel gæstebog liggende, her kommer et paste af den :
<?
$host = \"db_host\";
$login = \"username\";
$password = \"password\";
$database = \"db_navn\";
mysql_connect($host,$login,$password) or die(\"Unable to connect to database\");
mysql_select_db($database) or die(\"Unable to select database\");
$dagnavn = array(\'søndag\',\'mandag\',\'tirsdag\',\'onsdag\',\'torsdag\',\'fredag\',\'lørdag\');
$maanednavn = array(\'Januar\',\'Februar\',\'Marts\',\'April\',\'Maj\',\'Juni\',\'Juli\',\'August\',\'September\',\'Oktober\',\'November\',\'December\');
function removehtml($htmlvar) {
$var_html = eregi_replace(\"(<([^>]+)>)\",\"\",$htmlvar);
return $var_html;
}
if ($action == \"save\") {
$navn = removehtml($navn);
$email = removehtml($email);
$web = removehtml($web);
$web = eregi_replace(\"^\\.\",\"\",$web);
$letter = removehtml($letter);
if (!(eregi(\"^([a-z0-9]\\.)*[a-z0.9]+\\.[a-z]{2,3}$\",$web))) {
$web = \"\";
}
if (!($navn == \"\" || $letter == \"\")) {
$q = mysql_query(\"insert into wizbook (navn,email,web,letter,dato) values(\'$navn\',\'$email\',\'$web\',\'$letter\',\'$tid\')\");
header(\'Location: index.php3\');
}
}
$q = mysql_query(\"select * from wizbook\");
$poster = mysql_numrows($q);
echo \"<html>\\n<head>\\n<title>wizBOOK på PHPwiz.dk</title>\\n<link rel=\\\"stylesheet\\\" href=\\\"phpwiz-style.css\\\">\\n</head>\\n<body>\\n\";
echo \"<div class=\\\"mainoverskrift\\\">wizBOOK på PHPwiz.dk</div>\\n<hr>\\n\";
echo \"<table align=\\\"left\\\" width=\\\"70%\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" border=\\\"0\\\">\\n\";
echo \"<tr>\\n\";
echo \"<td align=\\\"left\\\" class=\\\"skrift\\\" width=\\\"25%\\\"><a class=\\\"forlink\\\" href=\\\"index.php3\\\"><- Forsiden</a></td>\";
echo \"<td align=\\\"center\\\" class=\\\"skrift\\\" width=\\\"25%\\\"><strong>\".$poster.\" indlæg</strong> - \";
echo \"<a class=\\\"forlink\\\" href=\\\"\".basename($PHP_SELF).\"\\\"><strong>Læs</strong></a> - \";
echo \"<a class=\\\"forlink\\\" align=\\\"right\\\" href=\\\"\".basename($PHP_SELF).\"?action=write\\\"><strong>Skriv</strong></a>\\n\";
echo \"</td>\\n\";
echo \"</tr>\\n\";
echo \"</table><p>\";
if (!($action == \"write\")) {
$q = mysql_query(\"select * from wizbook order by dato desc\");
echo \"<table width=\\\"70%\\\" align=\\\"center\\\" cellspacing=\\\"2\\\" cellpadding=\\\"2\\\" border=\\\"0\\\">\\n\";
while ($r = mysql_fetch_array($q)) {
if (!(eregi(\"^[_a-z0-9-]+(\\.[_a-z0-9-]+)*(@[a-z0-9-]+\\.)([a-z0-9-]+)+$\",$r[email]))) {
echo \"<tr>\\n\";
echo \"<td width=10% class=\\\"link\\\">Navn : </td><td class=\\\"linkg\\\">\".$r[navn].\"</td>\\n\";
echo \"</tr>\\n\";
}
else {
echo \"<tr>\\n\";
echo \"<td width=10% class=\\\"link\\\">Navn : </td><td class=\\\"linkg\\\"><a class=\\\"forlink\\\" href=\\\"mailto:\".$r[email].\"\\\">\".$r[navn].\"</a></td>\\n\";
echo \"</tr>\\n\";
}
echo \"<tr>\\n\";
$dagn = ucfirst($dagnavn[date(\"w\",$r[dato])]);
$dag = date(\"j\",$r[dato]);
$maaned = eregi_replace(\"^0\",\"\",date(\"m\",$r[dato]));
$year = date(\"Y\",$r[dato]);
echo \"<td class=\\\"link\\\">Dato: </td><td class=\\\"linkg\\\">\".$dagn.\" d. \".$dag.\"/\".$maaned.\"-\".$year.\", kl. \".date(\"H:i\",$r[dato]).\"</td>\\n\";
echo \"</tr>\\n\";
if ($r[web]) {
$web = eregi_replace(\"^
http://\",\"\",$r[web]);
echo \"<tr>\\n\";
echo \"<td class=\\\"link\\\">Web: </td><td class=\\\"linkg\\\"><a class=\\\"forlink\\\" href=\\\"
http://\".$web.\"\\\"</a>\".$web.\"</td>\\n\"; echo \"</tr>\\n\";
}
echo \"<tr>\\n\";
echo \"<td valign=\\\"top\\\" class=\\\"link\\\">Indlæg: </td><td valign=\\\"top\\\" width=\\\"60%\\\" class=\\\"linkg\\\">\".$r[letter].\"</td>\\n\";
echo \"</tr>\\n\";
echo \"<tr><td> </td><td> </td></tr>\";
}
echo \"</table>\\n\";
}
?>
<?
if ($action == \"write\") {
?>
<br>
<br>
<form action=\"wizbook.php3?action=save\" method=\"post\">
<div align=\"left\">
<table width=\"40%\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">
<tr><td class=\"input\">NAVN : </td><td><input class=\"areas\" type=\"text\" name=\"navn\"></td></tr>
<tr><td class=\"input\">EMAIL : </td><td><input class=\"areas\" type=\"text\" name=\"email\"></td></tr>
<tr><td class=\"input\">URL : </td><td><input class=\"areas\" type=\"text\" name=\"web\"></td></tr>
<tr><td class=\"input\" valign=\"top\">INDLÆG : </td><td><textarea class=\"areas\" cols=\"40\" rows=\"10\" name=\"letter\"></textarea></tr>
<tr><td colspan=\"2\"> </td></tr>
<tr><td align=\"center\" colspan=\"2\"><input class=\"knap\" type=\"submit\" value=\"Gem indlæg\"> <input class=\"knap\" type=\"reset\" value=\"Slet indlæg\"></td></tr>
<input type=\"hidden\" name=\"tid\" value=\"<? echo time(); ?>\">
</table>
</form>
<?
}
?>
</body>
</html>