???? ?? ?? ?? ??
???? ?? ???? ??? ??? ????? ???? ?? ???????. ???? ????? ???? ??? ???????.
?? ???? cate.html ??? ??????. ?? ??? ???? ????? ??? ????? ?? ???? ???????.
????? cate.html?? "??? ??" ???? ???? cateadd.php ??? ???? ???? ?? ???? ?????. ??? html ???? ?? ?????? ?????.
"?? ????"?? ????? ???? ?????. ??? ??? ???? ??? ???? html?? ?????? ???? ??? ???? ???. ???.
?? ?? ??:
<?php function getList($pid=0,&$result=array(),$spac=0) { global $link; $spac +=8; $sql = "select * from cate where pid = $pid"; $res = mysqli_query($link,$sql); while($rows=mysqli_fetch_array($res)) { $rows["cate_name"] = str_repeat(' ',$spac).'--'.$rows["cate_name"]; $result[] = $rows; getList($rows['id'],$result,$spac); } return $result; } $rs=getList(); ?>
?? ?? ??:
<div class="form-group"> <div class="label"> <label>上級(jí)分類:</label> </div> <div class="field"> <select name="pid" class="input w50"> <option value="">請(qǐng)選擇分類</option> <?php foreach($rs as $key => $val){?> <option value="<?php echo $val['id'];?>"><?php echo $val["cate_name"]?></option> <?php }?> </select> <div class="tips">不選擇上級(jí)分類默認(rèn)為一級(jí)分類</div> </div> </div>
?? ?? SQL ?? ?? cate ???? ???? ?????. ??? ?? ?? pid, ?? ?? cate_name ? ?? ?? ??? ?????. ????? ???? cate.php ???? ?? ???? ?? ?????.
<?php if($_POST) { $pid = isset($_POST['pid'])?$_POST['pid']:""; $cate_name=isset($_POST['cate_name'])?$_POST['cate_name']:""; $rank=isset($_POST['rank'])?$_POST['rank']:""; if($pid && $cate_name && $rank) { $sql = "insert into cate(pid,cate_name,rank)values('".$pid."','".$cate_name."','".$rank."')"; $rel = mysqli_query($link,$sql); if($rel) { echo "<script language=javascript>alert('添加成功!');window.location='cate.php'</script>"; } }else{ echo "<script>alert('添加失敗,請(qǐng)重新添加');</script>"; } } ?>