Problem med menu + MySQL.
Hej.Jeg har fundet en kode på nettet og rettet lidt i den.
Mit problem er, at selvom der bliver tilføjet links til databasen, bliver de ikke vist under menupunkterne. Håber det er noget i kan hjælpe med! Jeg har på fornemmelsen, at fejlen ligger i filen menu.php.
#menu.php#
<html>
<head>
<style type='text/css'>
a.top {color:black;font:bold 14px verdana;text-decoration:none;}
a.top:hover {color:yellowgreen;}
a.link {margin-left:2em;color:dimgray;font:13px verdana;text-decoration:none;}
a.link:hover {text-decoration:underline;}
</style>
</head>
<body>
<?php
function menuliste() {
include ("config.php");
$query1 = "select * from mkategori";
$result1 = mysql_query($query1);
while($row1 = mysql_fetch_array($result1))
{
$topkat = array($row1['mtopkategori']);
echo "<a class='top' href='?kategori=".$topkat[0]."'>".$topkat[0]."</a><br>";
if($_REQUEST['mtopkategori'] == '') {
}
elseif($_REQUEST['mtopkategori'] == $topkat[0])
{
$query2 = "select * from mlink where mtopkategori = '".$topkat[0]."'";
$result2 = mysql_query($query2);
while($row2 = mysql_fetch_array($result2))
{
$link = array($row2['mid'],$row2['mpunkt'],$row2['mlink']);
echo "<a class='link' target='_blank' href='http://".$link[2]."'>".$link[1]."</a><br>";
}
}
}
mysql_close();
}
menuliste();
?>
</body></html>
#addkategori.php#
<html><head></head><body>
<p align="center">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<tr>
<td bgcolor="#656565" width="100%" colspan="3"><p align="center"><b><font color="#ffffff">Tilføj Link</font></b></p></td>
</tr>
<tr>
<td width="3%"></td>
<td width="94%">
<br>
<p align="center">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber1">
<form action="addkategori-ok.php" method="post">
<tr>
<td>Menu kategori:</td>
<td><input type="text" name="mtopkategori"><font color="red">*</font></td>
</tr>
<tr>
<td></td>
<td><br><input type="submit" name="addkat" value="Tilføj Kategori"></td>
</tr>
</form>
</table>
</p>
</td>
<td width="3%"></td>
</tr>
</table>
</p>
<br>
</body></html>
#addkategori-ok#
<p align="center">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<tr>
<td bgcolor="#7a9294" width="100%" colspan="3"><p align="center"><b>Tilføj link</b></p></td>
</tr>
<tr>
<td width="3%"></td>
<td width="94%">
<br>
<?php
require("config.php");
$add = $_POST['addkat'];
if(empty($add)) {
?>
<br><a href="addkategori.php">Tilføj kategori</a>
<?php
} else {
$mtopkategori = $_POST['mtopkategori'];
if(empty($mtopkategori)) {
echo '<font color="red"><b>Fejl!</b></font><br>Feltet markeret med en <font color="red">*</font> <u>skal</u> udfyldes!<br><br>
<a href="addkategori.php"><b>Tilbage</b></a>';}
else {
mysql_connect($mysql_host, $mysql_user, $mysql_pw);
mysql_select_db($mysql_db);
mysql_query("insert into mkategori (mtopkategori) values ('$mtopkategori')")
or die(mysql_error());
print "Kategorien <b>\"$mtopkategori\"</b> er nu tilføjet til databasen.";
?>
<br>
Gå til <a href="menu.php"><b>Menu</b></a>
<?php
}
}
?>
</td>
<td width="3%"></td>
</tr>
</table>
</p>
<br>
#addmlink#
<html><head></head><body>
<p align="center">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<tr>
<td bgcolor="#656565" width="100%" colspan="3"><p align="center"><b><font color="#ffffff">Tilføj Link</font></b></p></td>
</tr>
<tr>
<td width="3%"></td>
<td width="94%">
<br>
<p align="center">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber1">
<form action="addmlink-ok.php" method="post">
<tr>
<td>Menu kategori:</td>
<td><input type="text" name="mtopkategori"><font color="red">*</font></td>
</tr>
<tr>
<td>Menu punkt:</td>
<td><input type="text" name="mpunkt"><font color="red">*</font></td>
</tr>
<tr>
<td>Menu link:</td>
<td><input type="text" name="mlink"><font color="red">*</font></td>
</tr>
<tr>
<td></td>
<td><br><input type="submit" name="add" value="Tilføj menu link"></td>
</tr>
</form>
</table>
</p>
</td>
<td width="3%"></td>
</tr>
</table>
</p>
<br>
</body></html>
#addmlink-ok.php#
<p align="center">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<tr>
<td bgcolor="#7a9294" width="100%" colspan="3"><p align="center"><b>Tilføj link</b></p></td>
</tr>
<tr>
<td width="3%"></td>
<td width="94%">
<br>
<?php
require("config.php");
$add = $_POST['add'];
if(empty($add)) {
?>
<br><a href="index.php?pageid=5">Tilføj menu link</a>
<?php
} else {
$mtopkategori = $_POST['mtopkategori'];
$mpunkt = $_POST['mpunkt'];
$mlink = $_POST['mlink'];
if(empty($mtopkategori) OR empty($mpunkt) OR empty($mlink)) {
echo '<font color="red"><b>Fejl!</b></font><br>Felterne markeret med en <font color="red">*</font> <u>skal</u> udfyldes!<br><br>
<a href="addmlink.php"><b>Tilbage</b></a>';}
else {
mysql_connect($mysql_host, $mysql_user, $mysql_pw);
mysql_select_db($mysql_db);
mysql_query("insert into mlink (mtopkategori, mpunkt, mlink) values ('$mtopkategori', '$mpunkt', '$mlink')")
or die(mysql_error());
print "Menu linket <b>\"$mpunkt\"</b> er nu tilføjet til databasen.";
?>
<br>
Gå til <a href="menu.php"><b>menu</b></a>
<?php
}
}
?>
</td>
<td width="3%"></td>
</tr>
</table>
</p>
<br>
