<?php
if($mode == ""){
?>
<?php
$connection = mysql_connect("host","brugernavn","password");
mysql_select_db("database", $connection);
?>
<html>
<head>
<title>Linksystem by Kasper Jensen</title>
</head>
<body link="black" vlink="black" alink="black">
<font size="1" color="#000000" face="Verdana">
<center><b><a href="linksystem.php?mode=tilfoj">Tilføj link</a>-
Der er i øjeblikket <?
$result = mysql_query("SELECT * FROM linksystem");
echo mysql_num_rows($result);
?>
link(s) i databasen
</font>
</b></center>
<BR><BR>
<div align="left">
<table border="0" cellpadding="0" cellspacing="0" style="border: 1 solid #000000" bgcolor="#006699" width="200" height="10">
<tr>
<td width="522" height="10">
<font size="2" color="#FFFFFF" face="Verdana">
<b>Links</b>
</font>
</td>
</tr>
</table>
<?php
$result = mysql_query("select * from linksystem order by id desc");
//Henter alt fra tabellen linksystem og sorterer efter id, desc skriver den nyeste øverst, dette kan uskiftes med asc så bliver det den ældste det står øverst øverst
while($row = mysql_fetch_array($result)) {
echo "<a href=\"linksystem.php?mode=vis&id=$row[id]\">$row[titlen]</a><br>";
}
?>
</div>
</body>
</html>
<?php
}
?>
<?php
function vis($id)
{
$connection = mysql_connect("host","user","pass");
mysql_select_db("database", $connection);
$res = mysql_query("select * from linksystem WHERE id = '$id'");
//Henter alt fra tabellen linksystem og sorterer efter id, desc skriver den nyeste øverst, dette kan uskiftes med asc så bliver det den ældste det står øverst øverst
while($row = mysql_fetch_array($res)) {
echo "<font size=2 color=000000 face=Verdana>";
echo "Titlen : <b>$row[titlen]</b><br>";
echo "URL : <a href=\"$row[url]\" target=\"none\"><b>$row[url]</b></a><br>";
echo "Tilføjet den : <b>$row[dato]</b><br>";
echo "Beskrivelse:<br><br>";
echo "$row[beskrivelse]";
}
}
if($mode == "vis" && $id){
echo vis($id);
}
?>
<?php
if($mode == "tilfoj"){
?>
<?php
$connection = mysql_connect("host","user","pass");
mysql_select_db("database", $connection);
$maaneder = array("januar","februar","marts","april","maj","juni","juli","august","september","oktober","november","december");
$tid = $ugedage[date(w)]."".date(j).". ".$maaneder[date(m) - 1]." @ ".date("H:i:s");
if($titlen && $url && $beskriv) {
mysql_query("insert into linksystem(id,titlen,url,beskrivelse,dato,ip)
values ('','$titlen','$url','$beskriv','$tid','$REMOTE_ADDR')");
echo "<h1><font color=\"#000000\" face=\"Verdana\"> Novra, dit link blev pluget ind uden problemer :o) </font>";
echo "<meta http-equiv=\"refresh\" content=\"3; URL=linksystem.php\">";
}
?>
<html>
<head>
<title>Untitled</title>
</head>
<body>
<form action="linksystem.php?mode=tilfoj" method="post">
<table border="0" align="center">
<tr><td width=65><font size=2 face=Verdana color=#000000><b>Titlen :</td><td><input type=text size=30 name=titlen style="border: 1 solid #000000"></td></tr>
<tr><td width=65><font size=2 face=Verdana color=#000000><b>URL :</td><td><input type=text size=30 name=url value=http:// style="border: 1 solid #000000"></td></tr>
<tr>
<td><b>Beskrivelse:</b></td>
<td align="center"><textarea name="beskriv" cols="50" rows="8" style="border: 1 solid #000000"></textarea></td>
</tr>
<tr>
<td colspan="2" align="right"><input type="submit" name="Submit" value="Send" style="border: 1 solid #000000"> <input type="reset" name="Submit2" value="Reset" style="border: 1 solid #000000"></td>
</tr>
</table>
</form>
</body>
</html>
<?php
}
?>
