<?
include "../dbconnect.php";
$do = $_GET['do'];
if($do == "neu"){
$titel = $_POST['titel'];
$head = $_POST['head'];
if($head != 0){
$eingabe = mysql_query("SELECT * FROM tree where id = '$head'");
$zeile = mysql_fetch_array($eingabe);
$lft = $zeile['lft'];
$rgt = $zeile['rgt'];
mysql_query("UPDATE tree SET rgt=rgt+2 WHERE rgt >= '$rgt'");
mysql_query("UPDATE tree SET lft=lft+2 WHERE lft > '$rgt'");
mysql_query("INSERT INTO tree (name,lft,rgt) VALUES ('$titel', '$rgt', '$rgt' +1)");
}else{
$numresult = mysql_query("SELECT * FROM tree");
$rows = mysql_num_rows($numresult);
if($rows == 0){
mysql_query("INSERT INTO tree (name,lft,rgt) VALUES ('$titel',1,2)"); //Wenn also noch überhaupt kein Eintrag da ist
}else{
//wenn schon ein Eintrag da ist, dann zweiten Zweig eröffnen, aber wie?
}
}
}
?>
Neuer Link<br><br><br>

<form action="menu_neu.php?do=neu" method="post" name="link">
<table>
<tr>
<td><b>Name:</b></td>
<td><input class="input" type="text" name="titel" SIZE=40 MAXLENGTH=50></td>
</tr>
<tr>
<td><b>übergeordnet:</b></td>
<td>
 <select name="head">
 <option selected value="0">keine</option>
<?
 $result = mysql_query("SELECT n.id,n.name,
        COUNT(*)-1 AS level
   FROM tree AS n,
        tree AS p
  WHERE n.lft BETWEEN p.lft AND p.rgt
GROUP BY n.lft
ORDER BY n.lft;");
while ($line = mysql_fetch_array($result)) {
$ebene = $line['level'];
$id = $line['id'];
$name = $line['name'];
for ($i = 1; $i <= $ebene; $i++) {
$name = "-".$name."";
}
echo "<option value=\"$id\">$name</option>";
}
mysql_free_result($result);
?>
 </select>
</td>
</tr>
<tr><td colspan="2" align="center"><input class="input" type="submit" name="submit" value="Link erstellen"></td></tr>
</table>
</form>