PHP - Rearrange Tree Structure

yeah...

in norway, we use dd.mm.yyyy, but mysql date uses yyyy.mm.dd..

Is there any php lines i can use to rearrange the input dates?

And also, rearrange the date when i query the mysql for the dates?

Hi,

I wrote a piece of code for doing a recursive printing of all the leaf nodes.

But it is not moving beyond one or two levels.

Here is the code:

$root = array(
"paa" => array (
"adi1" => array (
"cir1" => array (
"aka",
"ra", "vinodh","dkido"
),

"cir2" => array (
   "muta",
"la"
),

"cir3" => array (
"ezut",
"telAm"
),

"cir4" => array (
"ati"
)
),

"adi2" => array (

"cir1" => array (
"paka",
"vaV"
),

"cir2" => array (
"mutaR",
"RE"
),

"cir3" => array (
"ula",
"ku"
)
)
                )
            );

function traverse($ar)
{

foreach($ar as $key=>$value)

          {

echo "inside loop of ".$key."<br/>";

if(is_array($value))
{
    return traverse($value);
}

else

{
     echo $key."==>".$value."<br/>";
}

   }


}

traverse($root);


The output I get is:

inside loop of paa
inside loop of adi1
inside loop of cir1
inside loop of 0
0==>aka
inside loop of 1
1==>ra
inside loop of 2
2==>vinodh
inside loop of 3
3==>dkido

It does not seem to visit the other nodes.

Anything I missed here ?

V

Hey guys i need to create a genealogy tree view in PHP and i have no idea on how to get started ... Is there existing class's for that out there? Any recomandations on the "how to"? Maby flash/xml is better? ... I am lost ...

Hi guys

I need help writing a php script

I have a table 'categories'

with fields
'id' 'cat_name' 'parent_id'

the 'parent_id' is just an the id field..

I want to create a way to have unlimited sub categories

so I can have

categorie -> sub-categories
categories  -> sub-categories  -> sub-categories
categories -> products

Can somebody please have a look at this.  The Problem I am having is that only 1 entry for each month goes into the tree and for the life of me I can't figure out why.

Code: [Select]
$queryyp = "SELECT YEAR(date) as year, MONTHNAME(date) as month, title FROM monsterpost ORDER BY date DESC"; // query to get the rows you want in the order that you want them, with the year and monthname specifically selected as well
$resultyp = mysql_query($queryyp);
$last_heading = null; // remember the last heading (initialize to null)
while($rowyp = mysql_fetch_assoc($resultyp)){
$new_heading = $rowyp['year']; // get the column in the data that represents the heading
$new_subheading = $rowyp['month']; // get the column in the data that represents the subheading
if($last_heading != $new_heading){
// heading changed or is the first one
$last_heading = $new_heading; // remember the new heading
$last_subheading = null; // (re)initialize the subheading
// start a new section, output the heading here...
echo "<ol class=\"tree\"><li><label for=\"folder1\">{$rowyp['year']}</label> <input type=\"checkbox\" id=\"folder1\" /></li></ol>";
}
// subheading under each heading
if($last_subheading != $new_subheading){
// subheading changed or is the first one
$last_subheading = $new_subheading; // remember the new subheading
// start a new section, output the subheading here...
    echo "<ol><li><label for=\"subfolder1\">{$rowyp['month']}</label> <input type=\"checkbox\" id=\"subfolder1\" />";

}
// output each piece of data under a heading here...
echo "<ol><li class=\"file\">{$rowyp['title']}</li></ol></li></ol></li></ol>";
}

hi all.

I am working on a MLM project in which i have more than 30,000 members followed by the root member,i have to store member automatically in binary tree form like

1 is root
2 is child of 1
3 is child of 1

Then 4 is child of 2
5 is child of 2

and so on ......

i have to design database for that.

please help

I am trying to display binary tree  level wise. Breadth-first tree traversal can be used in it.Can anyone point me towards its logic or point me towards a good tutorial.

Hello everybody,

i am working on n level category tree structure, for your information the category tree structure image is attached with this post.

Let's consider, each of the category have hundreds( n level ) of category in each, i want to traverse each category without using recursive functions, reason being recursive functions are very slow,  is there any way to do this??

Thanks,
phpeid

Hey guys,
i am a college student and working on a project of mlm ad want to display the binary income tree,and also calculate the income that is given to each node.
Please see the attachments for the binary tree structure and database table structure.
Thanks.

[attachment deleted by admin]

I am trying to count left node of a binary tree.I made a function but my result is always 3 .

Code:-

Code: [Select]
<?php
  include'config.php';  // Connect database

  function leftcount($node)   //Function to calculate leftcount
  {
    $sql = "SELECT lchild,rchild FROM tree WHERE parent = '$node'";
    $execsql = mysql_query($sql);
    $array = mysql_fetch_array($execsql);
    
    if(!empty($array['lchild']))
    {
      $count++;
      leftcount($array['lchild']);  
    } 
    if(!empty($array['rchild']))
    {
       $count++;
       leftcount($array['rchild']); 
    }
    
    $totalcount = 1 + $count;
    return $totalcount;
    
  }
  
  $parent = "2";
  $left = leftcount($parent);
  echo $left;
  
?>
Can someone please point the error in my logic ? I searched google but i only got scripts with classes and i don't want to use classes.

This is my first try to display binary tree so please go easy on me.
I am trying to display binary tree using array. The values are stored in mysql.

Structure of mysql-
Code: [Select]
CREATE TABLE IF NOT EXISTS `tree` (
  `parent` int(7) NOT NULL,
  `rchild` int(7) NOT NULL,
  `lchild` int(7) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Display should look like
Code: [Select]
                    1
              ______|______
             |             |
             2             3
                     ______|______
                    |             |
                    4              5   


My Code till now-
Code: [Select]
<?php
 include 'connection.php';
 $rsearch = "SELECT rchild FROM tree WHERE parent='".$parent."'";
 $lsearch = "SELECT lchild FROM tree WHERE parent='".$parent."'";
    
  $rexec = mysql_query($rsearch);
  $lexec = mysql_query($lsearch);
  
  while($rrow = mysql_fetch_assoc($rexec)) // Putting right branch in an array first
{
    $rtree[$i][0] = $rrow['parent'] ; 
    $rtree[$i][1] = $rrow['lchild'] ;
    $rtree[$i][2] = $rrow['rchild'] ;
    $i++;
}
while($lrow = mysql_fetch_assoc($lexec)) // Putting left branch in an array 
{
    $ltree[$j][0] = $lrow['parent'] ; 
    $ltree[$j][1] = $lrow['lchild'] ;
    $ltree[$j][2] = $lrow['rchild'] ;
    $j++;
}

function displaytree($parent,$array)
{
   // Im stuck here. Can someone please help me with it
}
?>
I am stuck at displaying the tree function. Can someone please point me in the right direction ?

hi guys.

i want to implement a referral system. a member can only refer using a form in the memebers area. on the referral form, i have a hidden field which is his referral id and a unique code (md5 generated link) and a field for the email address he wants to refer. once he sends the mail, a referal link (md5 generated, for uniqueness and to curb cheating) is sent to the email so that once he clicks, it takes him/her to the registration area.


on my database table

referrer_uid - the unique id of person referring someone
referred_uid - the unique id of person being referred
ref_code - the md5 generated code which is used on the link sent
referred_email - the email address of the person being referred
status - once a member sends a refer link, status is set to Referal sent
date_referred - the date the refering took place
date_accepted - the day the referred was accepted (i dont want this to change on clicking a referal link or registration cos not everyone gets accepted to avoid spurious referals)


my question is how do i create a traversal tree with this. i read about traversal tree on sitepoint but when i tried to implement the examples, it didnt work for me and i noticed it was an old post.

note: i intend giving points based on the child/tree and it could be as deep as possible. also if my method is wrong, ideas are higly appreciated.

thanks
 

Hello, I am currently working on a multi level marketing system requiring  a lot of special features than the regular. It has 7 different levels with which you have move to the next level as your downlines qualify for the previous levels respectively. I am quite stuck on the tree structure. Here is how the plan details

**1st stage** is 3 direct downlines only 

**2nd stage** 9 people from the direct 3 should qualify for 1st stage making total of  30, that mean 3 from 1st leg,3 from 2nd leg ,3 from 3 leg 

**stage 3** ,9 people from the 30 should qualify for 2nd stage and it should fall on the direct 3
That means 3 from 1st leg ,3 from 2nd leg, 3 from 3rd leg that means the **direct 3** it self then 2,2 members from them again so each will get 3 from it side to make the person qualify so in total 
9x30+30 making 300

**Stage 3** 
12 people from the 300 who has qualify for **stage 3**
4 from 1st leg ,4 from 2nd leg 4 from 3rd leg 
This people should include the direct 3 before the person can qualify
So it continues

I need help with these first three functions and I will work the rest out. Building a separate tree view for each of the stages. Thanks

Hello,

I am using Fancytree, I want to generate a file / folder tree but excluding all folders that are not from the current user.

Example:
BOLD= FOLDER

I want to create a tree structure with the user "Peter"

[Tree]
├─PERSONNAL (take)
│ ├─PAN (not take)
│ │   └─GAMES (not take)
│ │      └─list (not take)
│ └─PETER (take)
│      └─GUITAR (take)
│           └─tabs (take)
└─TEAM (take)
     ├─CONTACT (take)
     │      └─phone (take)
     └─INFORMATION (take)
             └─technique (take)

I have several problems:
1) I don't understand the "listFolders" function, I can't give it a parameter (like $ name_user) otherwise it doesn't work.
2) the lines >> print_r ('TAKE THIS'. $ Dir); << show what I want to take, but it is "foreach" which does not work
3) my code is duplicated because I can't create a function inside a function ...

Here is my code:

<?php
$name_user = 'Peter'; // actualy not user :-( 
print_r(listFolders());

function listFolders($dir = __DIR__ . '/datausers') {
    $dh = scandir($dir);
    $name_user = "Peter";
    $return = [];

    if (strpos($dir, "/datausers/PERSONNAL") !== false){ // PERSONNAL found !
        if ($dir === __DIR__ . '/datausers/PERSONNAL') {  
            print_r($dir);
            echo '</br>';

            foreach ($dh as $item) {
                if ($item != '.' && $item != '..') {
                    if (is_dir($dir . '/' . $item)) { // it's a folder
                        $return[] = array(
                            'title' => $item,
                            'folder' => true,
                            'expanded'=> true,
                            'children' => listFolders($dir . '/' . $item, $key)
                        );
                    } else { // it's a file
                        $return[] = [
                            'title' => $item,
                        ];
                    }
                }
            }
        }
        if (strpos($dir, "/datausers/PERSONNAL/" . $name_user) !== false){ // Peter found
            print_r($dir);
            echo '</br>';

            foreach ($dh as $item) {
                if ($item != '.' && $item != '..') {
                    if (is_dir($dir . '/' . $item)) { // it's a folder
                        $return[] = array(
                            'title' => $item,
                            'folder' => true,
                            'expanded'=> true,
                            'children' => listFolders($dir . '/' . $item, $key)
                        );
                    } else { // it's a file
                        $return[] = [
                            'title' => $item,
                        ];
                    }
                }
            }
        }
    } 
    else {
        print_r($dir);
        echo '</br>';

        foreach ($dh as $item) {
            if ($item != '.' && $item != '..') {
                if (is_dir($dir . '/' . $item)) { // it's a folder
                    $return[] = array(
                        'title' => $item,
                        'folder' => true,
                        'expanded'=> true,
                        'children' => listFolders($dir . '/' . $item, $key)
                    );
                } else { // it's a file
                    $return[] = [
                        'title' => $item,
                    ];
                }
            }
        }
    }
    return $return;
}
?>

Please help me I'm desperate ...

Edited July 6 by ScottMeyer