PHP Link script
Hej.. Jeg har siddet og lavet et lille simpelt linkscipt... Men det virker ikke optimalt.. Når jeg tilføjer et link er det som den tilføjer en tom linje, det samme sker når jeg opdatere siden (F5)... I kan selv prøve og se det... http://vodskov.org/php/links2.php (Som i kan se er der en masse tomme linjer inden i den stiplede ramme...(det er mit første php arbejde)
Her er kildekoderne: (der er to sider, tilføj links er en side i iframe)
links.php:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
background-color: #CCCCCC;
border: thin dashed #000000;
}
body,td,th {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
}
.border {
border: thin dashed #000000;
}
a:link {
color: #000000;
text-decoration: none;
}
a:visited {
text-decoration: none;
color: #000000;
}
a:hover {
text-decoration: underline;
color: #000000;
}
a:active {
text-decoration: none;
color: #000000;
}
-->
</style></head>
<body>
<table width="626" border="0" align="center" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="626" height="512" valign="top" bgcolor="#FFFFFF"><div align="center">
<p><strong>Links</strong></p>
<table width="458" border="0" class="border">
<tr>
<td width="173"><strong>Adresse:</strong></td>
<td width="171"><strong>Beskrivelse:</strong></td>
</tr>
<tr>
<td><?php
$conn = mysql_connect("localhost", "vodskov_org", "wodskov");
mysql_select_db("vodskov_org");
$resultat = mysql_query("select url from Links");
while ($raekke = mysql_fetch_array($resultat)) {
extract($raekke);
echo "<a href=//$url>$url</a><br />";
}
mysql_close($conn);
?></td>
<td><?php
$conn = mysql_connect("localhost", "vodskov_org", "wodskov");
mysql_select_db("vodskov_org");
$resultat = mysql_query("select beskrivelse from Links");
while ($raekke = mysql_fetch_array($resultat)) {
extract($raekke);
echo "$beskrivelse<br />";
}
mysql_close($conn);
?></td>
</tr>
</table>
<br>
<table width="458" border="0">
<tr>
<td width="448"><iframe name="body" width="455" height="" align="left" marginwidth="0" marginheight="0" border="0" frameborder="0" src="addlink.php"></iframe></td>
</tr>
</table>
<p> </p>
<p> </p>
</div></td>
</tr>
</table>
</body>
</html>
------------------------------------------------------
addlink.php
------------------------------------------------------
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body,td,th {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
}
-->
</style></head>
<body>
<?php
$conn = mysql_connect("localhost", "vodskov_org", "wodskov");
mysql_select_db("vodskov_org");
$tabel = "Links";
$url = $_REQUEST["url"];
$beskrivelse = $_REQUEST["beskrivelse"];
$insertSQL = "insert into $tabel (url, beskrivelse)
values ('$url', '$beskrivelse')";
mysql_query($insertSQL);
mysql_close($conn);
?>
<form action="addlink.php" method=post>
URL:
<input type="text" name="url">
<p> Beskrivelse:
<input type="text" name="beskrivelse">
<p>
<input name="submit" type=submit value="Tilføj Link" align="center">
</form>
</body>
</html>
MVH RENE
