selve gben er her for at læse gben
http://tomas.hlidar.dk/php/gb/laes.php for og skrive i den
http://tomas.hlidar.dk/php/gb/skriv.phpDet er code for laes.php :
<html>
<title>Gæstebog</title>
<body bgcolor="#FFFFFF">
<?php
$db = mysql_connect("localhost", "root");
mysql_select_db("gaestebog",$db);
$result = mysql_query("SELECT * FROM indlaeg",$db);
while ($myrow = mysql_fetch_row($result)) {
?>
Navn: <? echo $myrow[1] ?>
<br>
Email: <? echo $myrow[2] ?>
<br>
Besked:
<?
$text = htmlspecialchars($myrow['3']);
$text = str_replace(":D", "<img src=\"smilie/icon_biggrin.gif\">", $text);
$text = str_replace(":S", "<img src=\"smilie/icon_confused.gif\">", $text);
$text = str_replace(":8", "<img src=\"smilie/icon_cool.gif\">", $text);
$text = str_replace(":'(", "<img src=\"smilie/icon_cry.gif\">", $text);
$text = str_replace(":¨", "<img src=\"smilie/icon_eek.gif\">", $text);
$text = str_replace(":e", "<img src=\"smilie/icon_evil.gif\">", $text);
$text = str_replace("!", "<img src=\"smilie/icon_exclaim.gif\">", $text);
$text = str_replace(":i", "<img src=\"smilie/icon_idea.gif\">", $text);
$text = str_replace(":l", "<img src=\"smilie/icon_lol.gif\">", $text);
$text = str_replace(":[", "<img src=\"smilie/icon_mad.gif\">", $text);
$text = str_replace(":|", "<img src=\"smilie/icon_neutral.gif\">", $text);
$text = str_replace("?", "<img src=\"smilie/icon_question.gif\">", $text);
$text = str_replace(":r", "<img src=\"smilie/icon_razz.gif\">", $text);
$text = str_replace(":f", "<img src=\"smilie/icon_redface.gif\">", $text);
$text = str_replace(":re", "<img src=\"smilie/icon_rolleyes.gif\">", $text);
$text = str_replace(":(", "<img src=\"smilie/icon_sad.gif\">", $text);
$text = str_replace(":)", "<img src=\"smilie/icon_smile.gif\">", $text);
$text = str_replace(":O", "<img src=\"smilie/icon_surprised.gif\">", $text);
$text = str_replace(":tw", "<img src=\"smilie/icon_twisted.gif\">", $text);
$text = str_replace(";)", "<img src=\"smilie/icon_wink.gif\">", $text);
$text = nl2br($text);
echo $text;
?>
<hr>
<?
}
?>
</body>
</html>