Linksystem funktioner !
Hejsa jeg har et link system hvor jeg godt vil ha bygget noget til det jeg vil ha bygget til er:Når en bruger tilføjer et link skal det sendes til en side først hvor det skal godkendes !
koderne:
addlink.inc.php:
<?php
include("webvars.inc.php");
$link = mysql_connect($hostname, $user, $password);
mysql_select_db($database);
$query = ("CREATE TABLE IF NOT EXISTS links (
id int(11) NOT NULL auto_increment,
host varchar(255) default NULL,
ip varchar(15) default NULL,
time varchar(255) NOT NULL default '',
title varchar(100) NOT NULL default '',
url varchar(75) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;");
mysql_query($query) or die("MySQL Error: " . mysql_error());
$ip = $_SERVER["REMOTE_ADDR"];
$host = gethostbyaddr($ip);
list($utime, $time) = explode(" ", microtime());
$title = htmlentities($_POST["title"], ENT_QUOTES);
$url = htmlentities($_POST["url"], ENT_QUOTES);
if ($title && $url) {
if (mysql_result(mysql_query("SELECT COUNT(*) FROM links WHERE url='$url'"),0) == 1) {
echo 'Linket er i databasen!';
} else {
$query = ("INSERT INTO links (id, host, ip, time, title, url) VALUES(NULL, '$host', '$ip', '$time', '$title', '$url');");
mysql_query($query) or die("MySQL Error: " . mysql_error());
$time = date("l d F Y @ H:i", $time);
$headers = "From: user@domain.com"; // your email
$message = "Host: " . $host . "\nIP: " . $ip . "\nTime: " . $time . "\nTitle: " . $title . "\nURL: " . $url;
$subject = "Link added on Domain.com"; // your webpage
$to = " user@domain.com"; // your email
mail($to, $subject, $message, $headers);
header("Location: links.php");
}
}
?>
links.php:
<? include('ipbann.php') ?>
<body bgcolor="#003366" text="#FFCC00" link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF">
<form action="addlink.inc.php" method="post">
<table>
<tr>
<td>Title : </td>
<td><input maxlength="100" name="title" type="text" /></td>
<td> *</td>
</tr>
<tr>
<td>URL : </td>
<td><input maxlength="75" name="url" type="text" value="http://" /></td>
<td> *</td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="Tilføj" /><input type="reset" value="Blank" /></td>
<td></td>
</tr>
<tr>
<td colspan="3"> </td>
</tr>
<tr>
<td colspan="3">* = Skal udfyldes.</td>
</tr>
<a href="linksne.php">Klik Her for at se de andre links</a>
linksne.php:
<? include('ipbann.php') ?>
<body bgcolor="#003366" text="#FFCC00" link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF">
<tr>
</tr>
</table>
</form>
<?php
include("webvars.inc.php");
$link = mysql_connect($hostname, $user, $password);
mysql_select_db($database);
$query = ("SELECT id, time, title, url FROM links ORDER BY title ASC;");
$result = mysql_query($query) or die("MySQL Error: " . mysql_error());
mysql_close($link);
while ($row = mysql_fetch_array($result)) {
list($utime, $time) = explode(" ", microtime());
if ($time - $row["time"] <= 7 * 24 * 60 * 60) {
$new = " NEW!";
}
else {
$new = "";
}
$row["time"] = date("l d F Y @ H:i", $row["time"]);
print("<a href=\"" . $row["url"] . "\" title=\"Added: " . $row["time"] . "\">" . $row["title"] . "</a>" . $new . "<br />\n");
}
?>
<p> </p>
<a href="links.php">Klik Her for at tilføje et link</a>
webvars.inc.php:
<?php
$hostname = "******"; // din MySQL server addresse
$user = "******"; // dit MySQL navn
$password = "******"; // din MySQL kode
$database = "*****"; // din MySQL database
?>
i kan se det på www.Scouit.1go.dk/linksys/
og jeg skal os bruge en slet funktion har prøvet og få en til at lave en før men kan ik få koden til at slette se selv www.Scouit.1go.dk/linksys/slet.php
koden
slet.php:
<?php
include("webvars.inc.php");
$link = mysql_connect($hostname, $user, $password);
mysql_select_db($database);
if (isset($_GET['deleteLink'])) {
mysql_query("delete from links where id = '$deleteLink'");
}
echo '<ul>';
$res = mysql_query("SELECT * FROM links ORDER BY title ");
while ($row = mysql_fetch_array($res)) {
echo'<li><font face="Verdana" size="2"> '.$row['title'].' - [<a href="?deleteLink='.$row['id'].'"
onClick="if(confirm(\'Sikker på du vil slette dette link?\'))this.href=\'?deleteLink='.$row['id'].'\'; else this.href=\'#\'">Slet</a>]</font><br></li>';
}
echo '</ul>';
?>
i behøves ikke lave det der slet dims ! det kun hvis i vil !
