Oki, here goes:
*BEMÆRK* - kør kun run_once.php én gang !!
Der er nok nogle småfejl som altid, men prøv at starte med at køre run_once.php og se om den giver nogen fejl...
\' functions.php
<?
function connect() {
$conn = mysql_connect(\"xxxx\",\"xxxx\",\"xxxx\");
mysql_select_db(\"xxxx\",$conn);
}
function add_url($tekst,$beskriv,$url) {
echo \"Link: $tekst($url)($beskriv) add\'ed to database\";
$sql=\"INSERT INTO my_table (tekst,beskrivelse,url,clicks) VALUES (\'$tekst\',\'$beskrivelse\',\'$url\',0)\";
mysql_query($sql);
}
function show_urls() {
$sql=\"SELECT * FROM my_table ORDER BY clicks DESC\";
$result=mysql_query($sql);
while($row=mysql_fetch_row($result)) {
$id=$row[0];
$tekst=$row[1];
$beskriv=$row[2];
$clicks=$row[4];
echo \"<tr><td><a href=\'redirect.php?id=$id\'>$tekst</a></td><td>$beskriv</td><td>$clicks</td></tr>\";
}
}
?>
\' EOF
\' run_once.php
<?
include(\"functions.php\");
connect();
$sql=\"DELETE * FROM my_table\";
mysql_query($sql);
print mysql_error();
$sql=\"ALTER TABLE my_table ADD tekst varchar(255) AFTER ID\";
mysql_query($sql);
print mysql_error();
$sql=\"ALTER TABLE my_table ADD beskrivelse varchar(255) AFTER tekst\";
mysql_query($sql);
print mysq_error();
?>
\' EOF
\' add_url.php
<? include(\"functions.php\");
connect();
?>
<html>
<body>
<h1>Add URL</h1>
<form action=\"add_url.php?action=add\" method=\"post\">
Link-tekst:<input type=text name=tekst>
<br>
Url:<input type=text name=url>
<br>
Beskrivelse:<input type=text name=beskriv>
<br>
<input type=submit value=\" OK \">
</form>
<br>
<? if ($action==\"add\")
{
add_url($tekst,$beskriv,$url);
}
?>
</body>
</html>
\' EOF
\' show_url
<?
include(\"functions.php\");
connect();
?>
<html>
<body>
<h1>Links in database:</h1>
<table>
<?
$sql=\"SELECT * FROM my_table ORDER BY ID\";
$result=mysql_query($sql);
echo \"<tr><td>ID</td><td>Text</td><td>Beskrivelse</td><td>Url</td><td>Clicks</td><tr>\";
while ($row=mysql_fetch_row($result)) {
echo \"<tr>\"
for ($i=0;$i<5;$i++) {
echo \"<td>\" . $row[$i] . \"</td>\";
}
echo \"</tr>\";
}
?>
</table>
</body>
</html>
\' EOF
\' redirect.php
<?
include(\"functions.php\");
connect();
$sql=\"SELECT url,clicks FROM my_table WHERE ID=$id\";
$row=mysql_fetch_row(mysql_query($sql));
$clicks=$row[1];
$url=$row[0];
$clicks++;
$sql=\"UPDATE my_table SET clicks=$clicks WHERE ID=$id\";
mysql_query($sql);
$header=\"Location: \" . $url;
header($header);
exit;
?>
\' EOF
\' links.php (eller hvad du nu vil kalde den)
<? include(\"functions.php\");
connect();
?>
<!-- din alm html-kode -->
<table>
<tr><td> </td><td>Beskrivelse</td><td>Antal Hits</td><tr>
<? show_urls(); ?>
</table>
<!-- din alm html-kode -->
\' EOF
Ny bruger
Nybegynder
Opret
Preview
