Tijden veranderen
link trading
hier is het script waar de links komen te staan;
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
<?php
//sql connectie includen
include ("connect.php");
//Plaats link pagina//
if (isset($plaatslink)) {
//Als formuliertje is ingevuld
if ($_POST['submit']) {
if ($naam !="" AND $email !="" AND $url!="")
{
$naam = addslashes($_POST['naam']);
$email = addslashes($_POST['email']);
$url = addslashes($_POST['url']);
$cat = addslashes($_POST['cat']);
$insert = "INSERT INTO links_url (id, naam, url, sort, cat, email, status) VALUES ('', '$naam', '$url', '0', '$cat', '$email', 'wachtrij')";
mysql_query ($insert) or die(mysql_error());
echo "Bedankt voor het aanmelden van je link.<br>Na goedkeuring van de webmaster zal deze op de website worden gezet.";
}
else { echo "U heeft één van de benodigde velden niet ingevuld!<br><a href='javascript:window.history.go(-1)'>Klik hier om terug te keren</a>";}
}
//formulier invullen
else { echo "<table width=\"450\"><tr><td width=\"125\" valign=\"top\"><b>Naam website</b> *</td><form action=\"$PHP_SELF?plaatslink\" method=post><td width=\"325\"><input name=\"naam\" type=\"text\" size=\"60\" maxlength=\"200\"></td></tr>
<tr><td width=\"125\" valign=\"top\"><b>Url website</b> *</td><td width=\"325\"><input name=\"url\" type=\"text\" size=\"60\" maxlength=\"200\"></td></tr>
<tr><td width=\"125\" valign=\"top\"><b>Email-adres</b> *</td><td width=\"325\"><input name=\"email\" type=\"text\" size=\"60\" maxlength=\"200\"></td></tr>
<tr><td width=\"125\" valign=\"top\"><b>Categorie</b> *</td><td width=\"325\"><select name='cat'><option></option>";
$gbc_query = "SELECT * FROM links_cat ORDER BY sort";
$gbc_exec = mysql_query($gbc_query);
while ($gbc_result = mysql_fetch_array($gbc_exec)) {
$gbc_id = $gbc_result["id"];
$gbc_naam = $gbc_result["naam"];
echo "<option value=\"".$gbc_id."\">".$gbc_naam."</option>"; }
echo "</select></td></tr><tr><td width=\"125\"></td><td width=\"325\"><input name=\"submit\" type=\"submit\" value=\"Verzend\"></td></form></tr></table>";
}}
//Laat links zien pagina//
else {
//categorieen selecteren
$gbc_query = "SELECT * FROM links_cat ORDER BY sort";
$gbc_exec = mysql_query($gbc_query);
while ($gbc_result = mysql_fetch_array($gbc_exec)) {
$gbc_id = $gbc_result["id"];
$gbc_naam = $gbc_result["naam"];
echo "<table width=450 style='border-style: solid; border-color: #CCCCCC; border-width: 1;' cellpadding=0 cellspacing=0 align=center><tr><td> <b>".$gbc_naam."</b></td><td align=right><a href='$PHP_SELF?plaatslink='>Plaats jouw link</a> </td></tr></table><br><table width=450 style='border-style: solid; border-color: #CCCCCC; border-width: 1;' cellpadding=0 cellspacing=0 align=center>";
//bijbehorende links selecteren
$gbu_query = "SELECT * FROM links_url WHERE cat='$gbc_id' AND status != 'wachtrij' ORDER BY naam DESC";
$gbu_exec = mysql_query($gbu_query);
while ($gbu_result = mysql_fetch_array($gbu_exec)) {
$gbu_naam = $gbu_result["naam"];
$gbu_url = $gbu_result["url"];
$gbu_status = $gbu_result["status"];
echo "<tr><td> <a href=\"".$gbu_url."\" title=\"".$gbu_naam."\" target=\"_blank\">".$gbu_naam."</a></td></tr>"; }
//tabel afsluiten en link naar plaats-pagina
echo "</table><br>"; }}
?>
//sql connectie includen
include ("connect.php");
//Plaats link pagina//
if (isset($plaatslink)) {
//Als formuliertje is ingevuld
if ($_POST['submit']) {
if ($naam !="" AND $email !="" AND $url!="")
{
$naam = addslashes($_POST['naam']);
$email = addslashes($_POST['email']);
$url = addslashes($_POST['url']);
$cat = addslashes($_POST['cat']);
$insert = "INSERT INTO links_url (id, naam, url, sort, cat, email, status) VALUES ('', '$naam', '$url', '0', '$cat', '$email', 'wachtrij')";
mysql_query ($insert) or die(mysql_error());
echo "Bedankt voor het aanmelden van je link.<br>Na goedkeuring van de webmaster zal deze op de website worden gezet.";
}
else { echo "U heeft één van de benodigde velden niet ingevuld!<br><a href='javascript:window.history.go(-1)'>Klik hier om terug te keren</a>";}
}
//formulier invullen
else { echo "<table width=\"450\"><tr><td width=\"125\" valign=\"top\"><b>Naam website</b> *</td><form action=\"$PHP_SELF?plaatslink\" method=post><td width=\"325\"><input name=\"naam\" type=\"text\" size=\"60\" maxlength=\"200\"></td></tr>
<tr><td width=\"125\" valign=\"top\"><b>Url website</b> *</td><td width=\"325\"><input name=\"url\" type=\"text\" size=\"60\" maxlength=\"200\"></td></tr>
<tr><td width=\"125\" valign=\"top\"><b>Email-adres</b> *</td><td width=\"325\"><input name=\"email\" type=\"text\" size=\"60\" maxlength=\"200\"></td></tr>
<tr><td width=\"125\" valign=\"top\"><b>Categorie</b> *</td><td width=\"325\"><select name='cat'><option></option>";
$gbc_query = "SELECT * FROM links_cat ORDER BY sort";
$gbc_exec = mysql_query($gbc_query);
while ($gbc_result = mysql_fetch_array($gbc_exec)) {
$gbc_id = $gbc_result["id"];
$gbc_naam = $gbc_result["naam"];
echo "<option value=\"".$gbc_id."\">".$gbc_naam."</option>"; }
echo "</select></td></tr><tr><td width=\"125\"></td><td width=\"325\"><input name=\"submit\" type=\"submit\" value=\"Verzend\"></td></form></tr></table>";
}}
//Laat links zien pagina//
else {
//categorieen selecteren
$gbc_query = "SELECT * FROM links_cat ORDER BY sort";
$gbc_exec = mysql_query($gbc_query);
while ($gbc_result = mysql_fetch_array($gbc_exec)) {
$gbc_id = $gbc_result["id"];
$gbc_naam = $gbc_result["naam"];
echo "<table width=450 style='border-style: solid; border-color: #CCCCCC; border-width: 1;' cellpadding=0 cellspacing=0 align=center><tr><td> <b>".$gbc_naam."</b></td><td align=right><a href='$PHP_SELF?plaatslink='>Plaats jouw link</a> </td></tr></table><br><table width=450 style='border-style: solid; border-color: #CCCCCC; border-width: 1;' cellpadding=0 cellspacing=0 align=center>";
//bijbehorende links selecteren
$gbu_query = "SELECT * FROM links_url WHERE cat='$gbc_id' AND status != 'wachtrij' ORDER BY naam DESC";
$gbu_exec = mysql_query($gbu_query);
while ($gbu_result = mysql_fetch_array($gbu_exec)) {
$gbu_naam = $gbu_result["naam"];
$gbu_url = $gbu_result["url"];
$gbu_status = $gbu_result["status"];
echo "<tr><td> <a href=\"".$gbu_url."\" title=\"".$gbu_naam."\" target=\"_blank\">".$gbu_naam."</a></td></tr>"; }
//tabel afsluiten en link naar plaats-pagina
echo "</table><br>"; }}
?>
weet meschien iemand waar de fout licht??
alvast bedankt
Ik heb je script niet echt goed gelezen maar check even op de punten waar je de links uit de database haalt en de punten waar je die vervolgens weer naar het scherm schrijft(echo).