如何实现树节点的增删改?
数据库为MySQL,数据表结构如下:
id type name parentid
1 0 service 0
101 82 data 0
102 82 card 101
103 82 search 101
104 82 web 102
105 83 task 103
parentid为0表示是顶级。用PHP该如何实现该数据表的配置页面呢?
回复讨论(解决方案)
你先想好展示的样式
你先想好展示的样式
样式不重要,能实现树节点的增删改就成。斑竹大人有推荐的插件咩?
你最好把样式显示出来,这样就知道节点怎么获取节点值,
思路是:点击节点,通过js把值传递到服务端,服务端操作数据库。
用ztree
数据量不大的话不建议用插件,以免造成项目结构混乱。核心是递归思想。
function dafenglei_arr($m,$id){ global $class_arr; global $classid; global $mysql; if($id=="") $id=0; $n = str_pad('',$m,'-',STR_PAD_RIGHT); $n = str_replace("-"," ",$n); for($i=0;$i<count($class_arr);$i++){ if($class_arr[$i][2]==$id){ echo "<tr>\n"; echo " <td>".$n."|----<a href=\"?action=edit&id=".$class_arr[$i][0]."\">".$class_arr[$i][1]."</a></td>\n"; echo " <td><div align=\"center\">".$class_arr[$i][3]."</div></td>\n"; echo " <td><div align=\"center\"><a href=\"?action=edit&id=".$class_arr[$i][0]."\">修改</a>"; echo " <a href=\"?action=del&id=".$class_arr[$i][0]."\">删除</a>"; echo "</div></td>\n"; echo " </tr>\n"; dafenglei_arr($m+1,$class_arr[$i][0]); } }}

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



When doing computer programming, sometimes it is necessary to find the minimum weight of a subtree originating from a specific node, provided that the subtree cannot contain nodes that are more than D units away from the specified node. This problem arises in various fields and applications, including graph theory, tree-based algorithms, and network optimization. A subtree is a subset of a larger tree structure, with the specified node serving as the root node of the subtree. A subtree contains all descendants of the root node and their connecting edges. A node's weight refers to a specific value assigned to that node, which can represent its importance, significance, or other relevant metrics. In this problem, the goal is to find the minimum weight among all nodes in a subtree while limiting the subtree to nodes that are at most D units away from the root node. In the following article, we will delve into the complexity of mining minimum weights from subtrees

How to implement the node copy and cut functions of mind maps through Vue and jsmind? Mind map is a common thinking tool that can help us organize our thoughts and sort out our thinking logic. The node copy and cut functions are commonly used operations in mind maps, which allow us to reuse existing nodes more conveniently and improve the efficiency of thinking organization. In this article, we will use the two tools Vue and jsmind to implement the node copy and cut functions of the mind map. First, we need to install Vue and jsmind and create

The methods for deleting nodes in js are: 1. The removeChild() method is used to remove the specified child node from the parent node. It requires two parameters. The first parameter is the child node to be deleted, and the second parameter is the parent node. Node; 2. The parentNode.removeChild() method can be called directly through the parent node to delete the child node; 3. The remove() method can directly delete the node without specifying the parent node; 4. The innerHTML attribute is used to delete the node. content.

C++ has a macro, which is defined as a piece of code or an expected value, and it will be reused whenever the user needs it. The Floyd-Walshall algorithm is the process of finding the shortest path between all pairs of vertices in a given weighted graph. The algorithm follows a dynamic programming approach to find the minimum weight graph. Let us understand the meaning of Floyd-Walshall algorithm through a diagram - take vertex 1 as the source and vertex 4 as the destination and find the shortest path between them. We have seen that there are two paths that can be connected to the target vertex 4. 1->4 – the edge has a weight of 51->8->3->4 – the edge weight (1+2+1) is 4. In the given graph I, we see the smallest edge connecting two vertices. So here the vertex

This article mainly introduces how to create, delete, append and replace element nodes in js. I hope it will be helpful to friends in need!

To check if a given path between two centers of a graph conforms to the shortest path, this can be calculated by comparing the entire edge weight along the given path to the shortest distance between combinations of the same centers using a reliable shortest path method, such as Dijkstra's calculation or Floyd−Warshall calculation. If all edge weights on a given path match the most limited deletion, then it represents the simplest path. Also: If the overall edge weight is more prominent than the shortest distance, it indicates that there is a short distance between the two centers in the graph. Methods Used Dijkstra's Algorithm Floyd−Warshall Algorithm with Edge Reversal Cost Greedy Algorithm Dijkstra's calculation may be a popular graph traversal calculation

Given n nodes, the task is to print the nth node at the end of the linked list. The program must not change the order of the nodes in the list, but should only print the nth node from the last node of the linked list. Example Input-:102030405060 N=3Output-:40 In the above example, starting from the first node, traverse to count-n nodes, that is, 10,2030,40,50,60, so the third to last node is 40. Instead of traversing the entire list so efficiently the approach you can follow - get a temporary pointer to, say, temp of node type set this temporary pointer to the first node that the head pointer points to set the counter to the one in the list

OpenAI is a node (although an important node) in the world of robot-robot dialogue, but it is not the center. ChatGPT has launched a Plugin mechanism, which is a very exciting development. Everyone unanimously commented that "an operating system was born." This statement is completely wrong. OpenAI is a node (although an important node) in the world of robot-robot dialogue, but it is not the center. I have always had a picture in my mind: a world where robots talk to robots. People chat with a robot and let the robot help the human complete tasks through its robot friends. ChatGPT Plugin perfectly demonstrates the world
