dtree using php

kidgeek_dfw

*EDIT

Please see the bottom for simpler question on function array...

I'm trying to use dtree with php....
see: http://www.destroydrop.com
This is a free js...

I'm don't know if I'm tired or what but I'm racking my brain trying to figure this out...

Basically dtree is like a js windows explorer menu for your web site... I want to allow users to add, modify and delete folders...
Storing the "Folder Path/File Path", "Name", etc.. in mysql...
I'd also like for them to be able to move the folder/files to a different path (change its order)...

This is an example of the output I need:
d.add(1,0,'Node 1','http://mydomain.com','Node 1','_parent','images/folder.gif');

1 is the id
0 is the parent id

Here's a better example:

d.add(1,0,'Node 1','http://mydomain.com','Node 1','parent','images/folder.gif');
d.add(2,0,'Node 2','http://mydomain.com','Node 2','parent','images/folder.gif');
d.add(3,2,'Node 3','http://mydomain.com','Node 3','parent','images/folder.gif');
d.add(4,2,'Node 4','http://mydomain.com','Node 4','parent','images/folder.gif');
d.add(5,0,'Node 5','http://mydomain.com','Node 5','parent','images/folder.gif');
d.add(6,5,'Node 6','http://mydomain.com','Node 6','parent','images/folder.gif');
d.add(7,5,'Node 7','http://mydomain.com','Node 7','_parent','images/folder.gif');

so for the above examples I think I would need to store the path for how they are built.... The above examples would have a path like this:
/home/Node 1/
/home/Node 2/
/home/Node 2/Node 3/
/home/Node 2/Node 4/
/home/Node 5/
/home/Node 5/Node 6/
/home/Node 5/Node 7/

This way the user could change the position of the path...
So I need to find a way to maybe write a function that would give an $id and a $parent_id on output...

I'm open to any suggestions here...

[edit]

ok since there are no suggestions yet, how about this...

/home/Node 1/
/home/Node 2/
/home/Node 2/Node 3/
/home/Node 2/Node 4/
/home/Node 5/
/home/Node 5/Node 6/
/home/Node 5/Node 7/

How can I echo back from the arrays above...
(which are stored in mysql)

Each gets a id and a parent id...

So
echo $i.$pid;

How do I assign both Node 3 and Node 4 to the parent Node 2 (pid = 2)?

And then moving on How do I assign Node 6 and Node 7 to Node 5 (pid = 5);

I would think there is a function that could do this quickly....

ZibingsCoder

If your database has a 'parentId' field in it for each entry, then this is something that's as easy as making it do something like...

//assume we're looping through mysql_fetch_array() results
echo ( "d.add({$row['id']},{$row['parentId']},'{$row['name']}','{$row['url']}','{$row['title']}','{$row['target']}','{$row['icon']}');" );

Again...lets see your database layout, and we may see our problem/solution there.

kidgeek_dfw

Thanks for the response...

I thought about this earlier...
once I got coding I realized that I needed to have the path in alphabetic order... and it needed to be dynamic as users are constantly updating...

So it has to be sorted by the path ie. /home/node 1/ node 2/

This is the test function I came up with so far...
I'm real close here...

function dtreeDir($path) {

$path = explode("/", $path);
$cnt = count($path);

$folder = array();

foreach($path as $value) {
	$folder[] = next($path);
	}
	echo $folder[1].",".$folder[2]."<br>";

}

$sql = "SELECT id, path, name FROM test ORDER BY path";

$result = @($sql,$connection) or die("Couldn't execute query login.");

while ($row = mysql_fetch_array($result)) {
$id = $row['id'];
$path = $row['path'];
$name = $row['name'];

dtreeDir($path);

}

returns this:

node 1,
node 2,
node 2,node 3
node 2,node 4
node 5,
node 5,node 6
node 5,node 7

I'm real close...

I have to give each node an id number, that's easy...

I need to assign the second field a parent id.
If there is nothing there in the second field then its a 0, that's easy...

What's hard is assigning a parent id for "node 3 and node 4" and "node 6 and node 7"

Any ideas?

kidgeek_dfw

I'm up to this so far...

function dtreeDir($path, $idx) {

$path = explode("/", $path);

$folder = array();

foreach($path as $value) {
	$folder[] = next($path);
	}
	// echo $folder[1]." & ".$folder[2]."<br>";

	if (!$folder[2]) {
	                $pid = '0';
		} else {
                                            }

	echo $idx.",".$pid."<br>";

}

returns:

1,0
2,0
3,
4,
5,0
6,
7,

kidgeek_dfw

ok mission accomplished!!!

all that is involved now is making the correct echo for the d.add....

anyway just in case anyone is wondering this is how you get back the id and pid...

It may be ugly but it works...
If someone wants to optimize/clean this up for me feel free...
For now I'm tired and its done...

function dtreeDir($path, $idx, $tmpid, $tmpfolder) {

$path = explode("/", $path);

$folder = array();

foreach($path as $value) {
	$folder[] = next($path);
	}
	// echo $folder[1]." & ".$folder[2]."<br>";
	if (!$folder[2]) {
		$pid = '0';
		} else {
		$pid = $tmpid;
		}
	echo $idx.",".$pid."<br>";

	if ($folder[1] != $tmpfolder) {
	global $tmpfolder;
	$tmpfolder = $folder[1];
	global $tmpid;
	$tmpid = $idx;
	}

}