search
HomeBackend DevelopmentPHP Tutorialphp 遍历树,子节点可以有多个父节点,请各位大神指点

本帖最后由 asmd1234567 于 2013-09-12 11:56:42 编辑

php 遍历 多个父节点

我希望展示父子关系,一个父节点可以有多个子节点,一个子节点可以有多个父节点,由于一直运行不通过,也不知道自己写的函数是不是正确的,不好意思啊
 $result = array(); /*Parse error: syntax error, unexpected '=', expecting ',' or ';' *//*我本来希望这个是个全局的数组,但是上网查了一下,发现现在不可以了,不知道各位大神有没有什么好的方法,小弟在此谢过啦*/$result[0] = mysql_query("select cID,number,isbasicpart from relationship  where pID='{$id}'");/*cID为子节点号,isbasicpart为是否为叶节点,number为父子间的数量*/echo "<table cellpadding='0' cellspacing='0' border='0'>"; echo "<tr> <td> {$id}";$i=0; 	function buildtree($i){	 while($row = mysql_fetch_array($result[$i])){ if($row['isbasicpart']==1)  echo "<td>'--'<td>{$row['cID']}<td>'('<td> {$row['number']}<td>')'</tr>";else  { echo "<td>'--'<td>{$row['cID']}<td>'('<td> {$row['number']}<td>')'";           $i=$i+1;$sql="select cID,number,isbasicpart from relationship  where pID='{$row['cID']}'"; $result[$i]=mysql_query($sql); buildtree($i);}} echo '</table>';} buildtree(0);}

回复讨论(解决方案)

一个父节点可以有多个子节点,一个子节点可以有多个父节点
这不叫树,叫网啊

你这个是多对多。。。。

这个代码自己看这不晕吗?

13 行处加上 global $result;
函数里面多个 td 标记未封闭
函数会有多个 table 闭标记产生,但只有一个 table 开标记

一个父节点可以有多个子节点,一个子节点可以有多个父节点
这不叫树,叫网啊


感谢提醒:)

你这个是多对多。。。。

感谢提醒:)

13 行处加上 global $result;
函数里面多个 td 标记未封闭
函数会有多个 table 闭标记产生,但只有一个 table 开标记

非常非常感谢,虽然还有问题,但是离目标更近了一步。我是刚开始学php语言,楼上说我写的代码不是很好,我想请问一下是不是考虑问题的思路不对呢,还是代码写的不规范。我觉得有时候想不出什么好算法,这是因为编程少么。是不是要多看书,经典的算法是不是要背下来呢?再次感谢您的回答,谢谢!

你是递归查询,本身没有问题
注意查询键是否正确就可以了

你用表格输出结果,如果标记不配套,正确的查询结果也会产生混乱的结果
建议先不要表格,先把数据弄对了

多看 (源代码,这个关键是看设计思路,至于算法上,基础web上通常需求不多,不过深入还是好的,能写出比较酷的代码,重要的还是设计框架和模式) 多写 (参照看的好的源代码的设计思路和代码规范)

然后就是没事看看书 , 多方面的 ,这样知识没有短板,就能逐渐有自己的知识体系

你是递归查询,本身没有问题
注意查询键是否正确就可以了

你用表格输出结果,如果标记不配套,正确的查询结果也会产生混乱的结果
建议先不要表格,先把数据弄对了

非常感谢!

多看 (源代码,这个关键是看设计思路,至于算法上,基础web上通常需求不多,不过深入还是好的,能写出比较酷的代码,重要的还是设计框架和模式) 多写 (参照看的好的源代码的设计思路和代码规范)

然后就是没事看看书 , 多方面的 ,这样知识没有短板,就能逐渐有自己的知识体系


非常感谢,会努力的,也祝你更好:)

多看 (源代码,这个关键是看设计思路,至于算法上,基础web上通常需求不多,不过深入还是好的,能写出比较酷的代码,重要的还是设计框架和模式) 多写 (参照看的好的源代码的设计思路和代码规范)

然后就是没事看看书 , 多方面的 ,这样知识没有短板,就能逐渐有自己的知识体系

还想再问一句,上哪里找优秀的源代码呢?有没有什么好的书或网站呢,或者某牛人的代码很好?

一个父节点可以有多个子节点,一个子节点可以有多个父节点
这不叫树,叫网啊 这个回答经典,哪有lz这样子的树啊!你的数据结构没有搞清楚,怎么循环输出啊!

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
11 Best PHP URL Shortener Scripts (Free and Premium)11 Best PHP URL Shortener Scripts (Free and Premium)Mar 03, 2025 am 10:49 AM

Long URLs, often cluttered with keywords and tracking parameters, can deter visitors. A URL shortening script offers a solution, creating concise links ideal for social media and other platforms. These scripts are valuable for individual websites a

Working with Flash Session Data in LaravelWorking with Flash Session Data in LaravelMar 12, 2025 pm 05:08 PM

Laravel simplifies handling temporary session data using its intuitive flash methods. This is perfect for displaying brief messages, alerts, or notifications within your application. Data persists only for the subsequent request by default: $request-

Build a React App With a Laravel Back End: Part 2, ReactBuild a React App With a Laravel Back End: Part 2, ReactMar 04, 2025 am 09:33 AM

This is the second and final part of the series on building a React application with a Laravel back-end. In the first part of the series, we created a RESTful API using Laravel for a basic product-listing application. In this tutorial, we will be dev

Simplified HTTP Response Mocking in Laravel TestsSimplified HTTP Response Mocking in Laravel TestsMar 12, 2025 pm 05:09 PM

Laravel provides concise HTTP response simulation syntax, simplifying HTTP interaction testing. This approach significantly reduces code redundancy while making your test simulation more intuitive. The basic implementation provides a variety of response type shortcuts: use Illuminate\Support\Facades\Http; Http::fake([ 'google.com' => 'Hello World', 'github.com' => ['foo' => 'bar'], 'forge.laravel.com' =>

cURL in PHP: How to Use the PHP cURL Extension in REST APIscURL in PHP: How to Use the PHP cURL Extension in REST APIsMar 14, 2025 am 11:42 AM

The PHP Client URL (cURL) extension is a powerful tool for developers, enabling seamless interaction with remote servers and REST APIs. By leveraging libcurl, a well-respected multi-protocol file transfer library, PHP cURL facilitates efficient execution of various network protocols, including HTTP, HTTPS, and FTP. This extension offers granular control over HTTP requests, supports multiple concurrent operations, and provides built-in security features.

12 Best PHP Chat Scripts on CodeCanyon12 Best PHP Chat Scripts on CodeCanyonMar 13, 2025 pm 12:08 PM

Do you want to provide real-time, instant solutions to your customers' most pressing problems? Live chat lets you have real-time conversations with customers and resolve their problems instantly. It allows you to provide faster service to your custom

Announcement of 2025 PHP Situation SurveyAnnouncement of 2025 PHP Situation SurveyMar 03, 2025 pm 04:20 PM

The 2025 PHP Landscape Survey investigates current PHP development trends. It explores framework usage, deployment methods, and challenges, aiming to provide insights for developers and businesses. The survey anticipates growth in modern PHP versio

Notifications in LaravelNotifications in LaravelMar 04, 2025 am 09:22 AM

In this article, we're going to explore the notification system in the Laravel web framework. The notification system in Laravel allows you to send notifications to users over different channels. Today, we'll discuss how you can send notifications ov

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
1 months agoBy尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

SublimeText3 Linux new version

SublimeText3 Linux new version

SublimeText3 Linux latest version

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

PhpStorm Mac version

PhpStorm Mac version

The latest (2018.2.1) professional PHP integrated development tool

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools