jacala >> når vi arbejder for point skal koden postes herinde for alles fordel :)
Min mySQL database ser sådan ud...
CREATE TABLE linkdb (
ID int(10) unsigned NOT NULL auto_increment,
URL varchar(64) NOT NULL,
Title varchar(64) NOT NULL,
Email varchar(64) NOT NULL,
PRIMARY KEY (ID)
);
Koden således :
<?php
# Connect to the Database
mysql_pconnect(\"localhost\",\"root\",\"\");
mysql_select_db(\"LinkDB\");
# How many links allowed ?
$LinkAllow = 50;
# Check for values to add the database
if ($URL && $Title && $Email) {
mysql_query(\"INSERT INTO LinkDB (URL, Title, Email) VALUES (\'$URL\', \'$Title\', \'$Email\')\") or die(mysql_error());
# Check for excessive links in database
$sql = mysql_query(\"SELECT * FROM LinkDB ORDER BY ID DESC\");
if (mysql_num_rows($sql) > $LinkAllow) {
# Whoops, got too many, delete one
$foo = mysql_fetch_array($sql);
$LowerLimit = $foo[\"ID\"]-$LinkAllow;
while ($foo = mysql_fetch_array($sql)) {
if ($foo[\"ID\"] <= $LowerLimit) {
$DeleteID = $foo[\"ID\"];
mysql_query(\"DELETE FROM LinkDB WHERE ID=$DeleteID\");
# send the email notification
@mail($foo[\"Email\"], \"Expired link : \".$foo[\"Title\"], \"Your link : \".$foo[\"Title\"].\" [\".$foo[\"URL\"].\"] has expired\",\"From: webmaster@your.domain\\nReply-To: webmaster@your.domain\\nX-Mailer: LJWeb Mailer (
www.ljweb.com)\");
}
}
}
}
?>
<FORM ACTION=\"<?php echo $PHP_SELF; ?>\" METHOD=\"post\">
<TABLE BORDER=0 ALIGN=CENTER>
<TR><TD>Sidens adresse<TD><INPUT TYPE=\"text\" NAME=\"URL\" VALUE=\"<?php echo $URL; ?>\" size=\"40\">
<TR><TD>Sidens titel<TD><INPUT TYPE=\"text\" NAME=\"Title\" VALUE=\"<?php echo $Title; ?>\" SIZE=\"40\">
<TR><TD>E-mail<TD><INPUT TYPE=\"text\" NAME=\"Email\" VALUE=\"<?php echo $Email; ?>\" SIZE=\"40\">
<TR><TD><TD><INPUT TYPE=\"submit\" VALUE=\"- Tilføj -\">
</TABLE>
</FORM>
<BR>
OBS: Du skal kun skrive din e-mail adresse hvis du ønsker at få en e-mail når dit link er blevet slettet
<BR><BR>
<HR WIDTH=\"100%\" SIZE=\"1\" COLOR=\"#C0C0C0\" NOSHADE>
<BR><BR>
<?php
$sql = mysql_query(\"SELECT * FROM LinkDB\");
if (mysql_num_rows($sql)) {
while ($foo = mysql_fetch_array($sql)) {
$i++;
echo $i.\": <A HREF=\\\"\".$foo[\"URL\"].\"\\\" TARGET=\\\"_blank\\\">\".$foo[\"Title\"].\"</A><BR>\\n\";
}
}
?>
Du vil sikkert ændre email informationerne til noget mere fornuftigt
/ Lars
www.ljweb.com
