Paging i gæstebog + andre små spørgsmål
Hello eksperter!www.vokadin.dk/test/yeah/
Nogle der vil lave følgende ting:
1. Lave sådan at den viser 20 poster pr. side
2. Få dato og tid til at fungere så den viser 24/12-2005 18:45
3. Få den til at smide en tilbage til index.php efter man har skrevet i gæstebogen
Alle får points, og gerne flere :)
På forhånd tak!
-Nico
INDEX.PHP:
<? include "config.php"; ?>
<p><font size="2" face="Verdana">Vis Forum - <a href="tilfoej.php">Tilføj Indlæg</a></font></p>
<hr color="#000000">
<? $res_tagwall = mysql_query("SELECT * FROM tagwall order by id DESC");
while ($row_tagwall = mysql_fetch_array($res_tagwall)){
?>
<div align="left">
<table border="0" width="262" height="14" cellspacing="0" cellpadding="0">
<tr>
<td width="262" height="1"><font size="2" face="Verdana"><i>Navn</i> : <b><?=$row_tagwall[navn]?></b></font></td>
</tr>
<tr>
<td width="262" height="1"><font size="2" face="Verdana"><i>Dato</i> : <b><?=$row_tagwall[dato]?></b></font></td>
</tr>
<tr>
<td width="262" height="1"><font size="2" face="Verdana"><i>Hjemmeside</i> : <b><a href="http://<?=$row_tagwall[url]?>.dk" target="_blank"><?=$row_tagwall[url]?></a></b></font></td>
</tr>
<tr>
<td width="262" height="14"><font size="2" face="Verdana"><i>Besked</i> :</font></td>
</tr>
<tr>
<td width="262" height="4"><font size="2" face="Verdana"><b><?=$row_tagwall[txt]?></b></font></td>
</tr>
</table>
</div><br>
<?
}
?>
TILFOEJ.PHP:
<? include "config.php"; ?>
<?
if ($_POST["action"] == "update")
{
$navn = ($_POST["navn"]);
$url = ($_POST["url"]);
$txt = ($_POST["txt"]);
$id = ($_POST["id"]);
$dato_array = getdate();
$dato = $dato_array["mday"] . "/" . $dato_array["mon"] . "-" . $dato_array["year"];
$ip = getenv('REMOTE_ADDR');
$sql = "INSERT INTO tagwall SET navn = '$navn', ip = '$ip', url = '$url', dato = '$dato', id = '$id', txt = '$txt'";
mysql_query($sql) or die(mysql_error());
header("location: index.php");
}
?>
<p>
<font size="2" face="Verdana"><a href="index.php">Vis Forum</a> - Tilføj Indlæg</font></p>
<hr color="#000000">
<p></p>
<form action="tilfoej.php?m=saadan" method="post">
<input type="hidden" name="action" value="update">
<div align="left">
<table border="0" width="376" height="1" cellspacing="0" cellpadding="0">
<tr>
<td width="125" height="1"><font size="2" face="Verdana">Navn:</font></td>
<td width="216" height="1"><font size="2" face="Verdana">
<input type="text" name="navn" size="20" style="background-color: #FFFFFF; color: #000000; font-size: 13 px; font-family: Verdana; font-weight: bold; border: 1 solid #000000"> </font>
</td>
</tr>
<tr>
<td width="125" height="24"><font size="2" face="Verdana">Hjemmeside:</font></td>
<td width="216" height="24"><font size="2" face="Verdana">
http://<input type="text" name="url" size="20" style="background-color: #FFFFFF; color: #000000; font-size: 13 px; font-family: Verdana; font-weight: bold; border: 1 solid #000000"></font>
</td>
</tr>
<tr>
<td width="125" height="11"><font size="2" face="Verdana">Besked:</font></td>
<td width="216" height="11"><font size="2" face="Verdana">
<textarea rows="2" name="txt" cols="20" style="background-color: #FFFFFF; color: #000000; font-size: 13 px; font-family: Verdana; font-weight: bold; border: 1 solid #000000"></textarea></font>
</td>
</tr>
<tr>
<td width="125" height="1"><font size="2" face="Verdana">Bekræft:</font></td>
<td width="216" height="1"><font size="2" face="Verdana"><input type="submit" name="update" value="ROCK'N'ROLL" style="background-color: #FFFFFF; color: #000000; font-size: 13 px; font-family: Verdana; border: 1 solid #000000"></font></td>
</tr>
</table>
</div>
</form>
CONFIG.PHP:
<?
$dbhost = "localhost"; // ADRESSEN TIL MYSQL
$database = "vokadin_dk"; // DATABASENS NAVN
$dbuser = "vokadin_dk"; // BRUGER
$dbpass = "XXXXXXXX"; // KODE
?>
<?
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($database);
?>
