Learn VBA & Macros in 1 Week!

PHP - Generate Tree Directory For Fancytree

Full Excel VBA Course - Beginner to Expert

Generate Tree Directory For Fancytree	View Content

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

Full Excel VBA Course - Beginner to Expert

Jquery Directory Tree Check Box Delete Form

Similar Tutorials

View Content

[/b]Hi people I'm having problem with inplementing a check box delete form in the jquery directory tree ....Realy I need help with this ! I am using
the php code below....

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
            <html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en-US">
            <head>
            <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
            <title>jQuery Drop Down Menu</title>

            
            <link rel="stylesheet" href="stylee.css" />

            </head>
            <body>

            
            <div id="jQ-menu">

            <?php
            error_reporting(0);
               $path = "store/".$diro."/";

               function createDir($path = '.')
               {
                  if ($handle = opendir($path))
                  {
                     echo "<ul>";

                     while (false !== ($file = readdir($handle)))
                     {
                        if (is_dir($path.$file) && $file != '.' && $file !='..')
                           printSubDir($file, $path, $queue);
                        else if ($file != '.' && $file !='..')
                           $queue[] = $file;
                     }

                     printQueue($queue, $path);
                     echo "</ul>";
                  }
               }

               function printQueue($queue, $path)
               {
                  foreach ($queue as $file)
                  {
                     printFile($file, $path);
                  }
               }
               echo"<form action='osnovni_dokumenti.php?id=" . $data['ideo']. "' method='POST'>";
               function printFile($file, $path)
               {

                  echo "<li><input type='checkbox' name='del[]' value='$file'/><a href=\"".$path.$file."\"><img src='slike_izgled/file.png'> $file</a></li>";

               }

               function printSubDir($dir, $path)
               {
                  echo "<li><img src='slike_izgled/directory.png' width='20' height='20'> <span class=\"toggle\">$dir</span>";
                  createDir($path.$dir."/");
                  echo "</li>";
               }

               createDir($path);
               echo"<p align='center'><input type='submit' name='filedel' value='Delete'></p>
               </form>";






            ?>

            </div>
            


            
            <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.2.6/jquery.min.js"></script>

            
            <script type="text/javascript" src="jquery.color.js"></script>

            
            <script type="text/javascript" src="jMenu.js"></script>

            </body>
            </html>
if(isset($_POST['filedel'])) {



                              $id = $_POST[del];
                              $count = count($id);



                              for ($i=0; $i<$count; $i++){


                              $files = $_POST['del'];


                              echo"$files.$count";
                           }







}

Auto Generate Xml From Image Directory

Similar Tutorials

View Content

Hello,

I'm a complete PHP newb. I'm curious whether PHP is even the best solution for my problem.
I'm trying to automatically generate an xml file with the following structu

Code: [Select]
<?xml version="1.0" encoding="UTF-8"?>
<portfolio>

<categories>
<category id="film">Films</category>
<category id="photo">Photography</category>
<category id="graphic">Graphic Design</category>
<category id="web">Web Design</category>

</categories>

<items>
<item>
<thumbnail>img/photo/003_small.jpg</thumbnail>
<preview>img/photo/003.jpg</preview>
<category>photo,film</category>
<description>Description goes here.</description>
</item>
<item>
<thumbnail>img/photo/003_small.jpg</thumbnail>
<preview>img/photo/003.jpg</preview>
<category>film</category>
<description>Description goes here.</description>
</item>
<item>
<thumbnail>img/photo/003_small.jpg</thumbnail>
<preview>img/photo/003.jpg</preview>
<category>graphic,photo</category>
<description>Description goes here.</description>
</item>
</items>
</portfolio>
(You can ignore the description as I can put that in manually after the fact)
There are lots of images and I just know that theres a way to fascilitate a script for this repetitive task to read a directory of a folder named "img" - see that there are a few folders named "photo" "film" and "graphic" etc, pull the images out of them in their corresponding categories etc.
I just need the initial generated script with thumbnails and all the attributes, I can do the final tweeks afterward.

This is for http://www.zoomrix.com/#portfolio

This is the code that I'm working from right now (gathered from a few sources)

Code: [Select]
<?php
$path_to_image_dir = 'images2'; // relative path to your image directory

$xml_string = <<<XML
<?xml version="1.0" encoding="UTF-8"?>
<items>
</items>
XML;

$xml_generator = new SimpleXMLElement($xml_string);

if ( $handle = opendir( $path_to_image_dir ) )
{
while (false !== ($file = readdir($handle)))
{
if ( is_file($path_to_image_dir.'/'.$file) )
{
$item = $xml_generator->addChild('item');
$item->addChild('thumbnail', $path_to_image_dir.'/thumbs/'.$file);
$item->addChild('preview', $path_to_image_dir.'/'.$file);
$item->addChild('category', 'photo');
$item->addChild('description', ' ');
}
}
closedir($handle);
}

header("Content-Type: text/xml");

echo $xml_generator->asXML();
?>(The above code could be ran he http://www.zoomrix.com/index5.php )

I just can't figure out how to include the <portfolio> and <category> tags, or how to reference a file structure to input for the category child (depending on what folder an image is in).
All the help would be greatly appreciated, even if you point me to the right tutorial.

Thanks,

GeorgeKotelnikov
www.zoomrix.com

Searching Through And Listing A Remote Directory (directory Listings Enabled)

Similar Tutorials

View Content

Hi guys,

I've been working on a script for a while now,
and I'm sure it doesn't look great and all, and it's probably really messed up..
But right now I've finally got it working!
There's only 1 thing I'd really like to add..
Searching through & listing of remote directories!
The directories I'm trying to list have directory listings enabled,
and I think it *should* be possible.
I just have no clue how.

Here's my current code in a beautiful mix of HTML and PHP:

<?
$border_size = "0";

function returner($what) {
$what=explode("/",$what);
$tps=count($what);
$what=$what[$tps-1];
return $what;
}

$page_url= "";
$home_url=returner(__FILE__);
if(isset($_GET['q'])) {
$qtext=$_GET['q'];
} else {
$qtext="";
}
function getdirsize($directory, $format=FALSE) {
$size = 0;
if(substr($directory,-1) == '/') {
$directory = substr($directory,0,-1);
}
if(!file_exists($directory) || !is_dir($directory) || !is_readable($directory)) {
return -1;
}
if($handle = opendir($directory)) {
while(($file = readdir($handle)) !== false) {
$path = $directory.'/'.$file;
if($file != '.' && $file != '..') {
if(is_file($path)) {
$size += filesize($path);
}
elseif(is_dir($path)) {
$handlesize = getdirsize($path);
if($handlesize >= 0) {
$size += $handlesize;
} else {
return -1;
}
}
}
}
closedir($handle);
}
if($format == TRUE) {
if($size / 1048576 > 1) {
return round($size / 1048576, 1).' MB';
}
elseif($size / 1024 > 1) {
return round($size / 1024, 1).' KB';
} else {
return round($size, 1).' bytes';
}
} else {
return $size;
}
}

if(isset($_GET['type'])){
  $type=$_GET['type'];
} else {
  $type="new";
}

$textures=0;
$models=0;
$avatars=0;
$seqs=0;
$sounds=0;

foreach (glob("textures/*.jpg") as $texture){
$textures++;
}
foreach (glob("models/*.zip") as $model){
$models++;
}
foreach (glob("avatars/*.zip") as $avatar){
$avatars++;
}
foreach (glob("seqs/*.zip") as $seq){
$seqs++;
}
foreach (glob("sounds/*.zip") as $sound){
$sounds++;
}
?>
<!DOCTYPE html>
<html>
<head>
<title>ObjectPath Search</title>
<style type="text/css">
#wrapper {
width: 850px;
margin: 30px auto 30px auto;
padding: 10px;
}

body
{
color:#C6C6C6;
background:#1E1E1E;
/* margin:0; padding:0; */
overflow-x:hidden;
}

#tabs {
font: 85% "Trebuchet MS", sans-serif;
}

.left {
float: left;
}

.right {
float: right;
}

a:link, a:visited, a:active {
color: #3DB015;
text-decoration: none;
}

a:hover {
color: #00E0FF;
}

h2 {
color: #3DB015;
padding-bottom: 0.2em;
font-size: 110%;
}
ul#icon {margin: 0; padding: 0;}
ul#icon li {margin: 1px; position: relative; padding: 1px 0; cursor: pointer; float: left;  list-style: none;}
ul#icon span.ui-icon {float: left; margin: 0 1px;}
</style>
<link type="text/css" href="http://objects.jk-hosting.com/search/css/black-tie/jquery-ui-1.8.2.custom.css" rel="stylesheet" />
<script type="text/javascript" src="http://objects.jk-hosting.com/search/js/jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="http://objects.jk-hosting.com/search/js/jquery-ui-1.8.2.custom.min.js"></script>
<script type="text/javascript">
function formHandler(form){
var URL = document.form.site.options[document.form.site.selectedIndex].value;
window.location.href = URL;
};

$(function(){
// Tabs
$('#tabs').tabs();
});
</script>
</head>
<body>
<div id="wrapper">
<div id="tabs"> 
<ul>
<li><a href="#tab-search">Search</a></li>
<li><a href="#tab-list">List Objects</a></li>
<li><a href="#tab-info">OP info</a></li>
</ul>

<div id="tab-search">
Please enter a string to search for, and choose a folder to search in. <br /><br />
<form name="Search">
<input type='hidden' value='search' name='type'>
<input value='<? print $qtext; ?>' type='text' name='q'>
<select name='map'>
<option selected='selected' value='models'>Models</option>
<option value='avatars'>Avatars</option>
<option value='textures'>Textures</option>
<option value='seqs'>Seqs</option>
<option value='sounds'>Sounds</option></select> <input type='submit' value='Search'>
</form>
</div> 

<div id="tab-list">
Please pick a folder to browse. <br /><br />
<form name="form">
<select name="site" onChange="javascript:formHandler()">
<option value="#">Look in folder...</option>
<option value="<? print $page_url; ?>?type=list&map=models">Models</option>
<option value="<? print $page_url; ?>?type=list&map=avatars">Avatars</option>
<option value="<? print $page_url; ?>?type=list&map=textures">Textures</option>
<option value="<? print $page_url; ?>?type=list&map=seqs">Seqs</option>
<option value="<? print $page_url; ?>?type=list&map=sounds">Sounds</option>
</select>
</form>
</div> 

<div id="tab-info">
The OP currently contains: <br /><br />
<table>
<tr><td><b><? echo $models; ?></b></td> <td>Models</td></tr>
<tr><td><b><? echo $avatars; ?></b></td> <td>Avatars</td></tr>
<tr><td><b><? echo $textures; ?></b></td> <td>Textures</td></tr>
<tr><td><b><? echo $seqs; ?></b></td> <td>Seqs</td></tr>
<tr><td><b><? echo $sounds; ?></b></td> <td>Sounds</td></tr>
</table>
</div> 
</div> 
</div>



<?
if($type=="search" || $type=="list") {
$M=$_GET['map'];
if($type=="search") {
$Q=$_GET['q'];
$empty="Nothing found with <b>\"" . $Q . "\"</b> in it's name.<br />\nPlease make a more general search query, or try a different folder.\n\n";
} else {
$Q="";
$empty='This folder is empty';
}
if($M=="textures") {
$ext="jpg";
} else {
$ext="zip";
}
$i=0;
print "<hr>\n";
$endfile=array();
$endsize=array();
$endsize2=array();
    foreach (glob($M."/*".$Q."*.".$ext) as $filename) {
$filename = explode(".", $filename);
$filename=$filename[0];
$filename = explode("/", $filename);
$filename=$filename[1];
$i++;
$endfile[$i]=$filename;
if($ext=="jpg") {
$endfile[$i]="<a name='".$endfile[$i]."' href='".$pageurl."?type=view&name=".$endfile[$i]."&folder=".$M."&from=".$type."&addon=".$Q."'>".$endfile[$i]."</a>";
}
$endsize[$i]=$size;
$endsize2[$i]=$size2;
}
if($i != 1) {
print "<b>".$i."</b> items were found.\n<hr>\n";
} else {
print "<b>".$i."</b> item was found.\n<hr>\n";
}
    echo("<table width='100%' border='" . $border_size . "' cellspacing='0' cellpadding='0' >\n");
if($i!=0) {
for ($t = 1; $t < $i; $t++) {
$thumbfile = $M."/".$endfile[$t].'.jpg';
if(file_exists($thumbfile)) {
$thumbnail = "<a name='".$endfile[$t]."' href='".$page_url."?type=view&name=".$endfile[$t]."&folder=".$M."&from=".$type."&addon=".$Q."'><ul id='icon'><li class='ui-state-default ui-corner-all' title='".$endfile[$t]."'><span class='ui-icon ui-icon-image'></span></li></ul></a>";
} else {
$thumbnail = "";
}
if($t=="1") {
echo("<tr><td width='10%'>Number</td><td width='3%'><ul id='icon'><li class='ui-state-default ui-corner-all' title='".$endfile[$t]."'><span class='ui-icon ui-icon-image'></span></li></ul></td><td width='60%'>Name</td></tr>\n");
}
echo("<tr><td>" . $t . "</td><td>".$thumbnail."</td><td>" . $endfile[$t] . "</td></tr>\n");
flush();
}
$thumbfile = $M."/".$endfile[$t].'.jpg';
if(file_exists($thumbfile)) {
$thumbnail = "<a name='".$endfile[$t]."' href='".$page_url."?type=view&name=".$endfile[$t]."&folder=".$M."&from=".$type."&addon=".$Q."'><ul id='icon'><li class='ui-state-default ui-corner-all' title='".$endfile[$t]."'><span class='ui-icon ui-icon-image'></span></li></ul></a>";
} else {
$thumbnail = "";
}
echo("<tr><td>" . $t . "</td><td>".$thumbnail."</td><td>" . $endfile[$t] . "</td></tr>\n");
}
print "</table>\n";
if($i=="0") {
print $empty;
}
} elseif($type=="view") {
$filename=$_GET['name'];
$folder=$_GET['folder'];

if($_GET['from']=="list"){
$addon="?type=list&map=".$folder."#".$filename;
}

if($_GET['from']=="search"){
$addon="?type=search&q=".$filename."&map=".$folder."#".$filename;
}
print"<center><a href='".$home_url."'>Home</a></center>";
print "<hr>\n<center><img src='".$folder."/".$filename.".jpg'></img></center>\n<hr>\n<br />\n<a href='".$page_url."".$addon."'>Previous Page</a>\n";
}
$htmlshow="";
if($_GET['type']=="returnOPfile") {
if(isset($_GET['split'])) {
$splitter=$_GET['split'];
} else {
$splitter=" | ";
}
if(isset($_GET['html'])) {
$htmlshow="<br />";
}
foreach (glob("textures/*.jpg") as $texture){
if(isset($_GET['size'])) {
$size=$splitter.filesize($texture);
}
    $texture = explode("/", $texture);
$texture=$texture[1];
print "textures".$splitter.$texture.$size."\n".$htmlshow;
}

foreach (glob("models/*.zip") as $model){
if(isset($_GET['size'])) {
$size=$splitter.filesize($model);
}
    $model = explode("/", $model);
$model=$model[1];
print "models".$splitter.$model.$size."\n".$htmlshow;
}

foreach (glob("avatars/*.zip") as $avatar){
if(isset($_GET['size'])) {
$size=$splitter.filesize($avatar);
}
    $avatar = explode("/", $avatar);
$avatar=$avatar[1];
print "avatars".$splitter.$avatar.$size."\n".$htmlshow;
}

foreach (glob("seqs/*.zip") as $seq){
if(isset($_GET['size'])) {
$size=$splitter.filesize($seq);
}
    $seq = explode("/", $seq);
$seq=$seq[1];
print "seqs".$splitter.$seq.$size."\n".$htmlshow;
}
    foreach (glob("sounds/*.zip") as $sound){
if(isset($_GET['size'])) {
$size=$splitter.filesize($sound);
}
      $sound = explode("/", $sound);
$sound=$sound[1];
print "sounds".$splitter.$sound.$size."\n".$htmlshow;
}
}
?>



</body>
</html>

So right now my question to you PHP freaks is,
can you please help me edit my script so I can search through a remote directory?

*This* is one of the directories I wish to be able to search through & list..

Thanks in advance.

Edit;
It might help if you know what the site currently looks like.
*Click*

Delete Files From Directory / Sub-directory

Similar Tutorials

View Content

i have made an delete files script which works for only one directory but not sub directory so i want to delete files of same extention from directory and subdirectory.

My current code is

Code: [Select]

<?

$dir = 'hmm/';

function scanr($dir){

$arr = glob($dir.'/*.jpg');
foreach($arr as $vv){

//check if $vv is a file
if(is_file($vv)){

//if file, get the filename
$vx=explode('/',$vv);
$file=$vx[count($vx)-1];

// if no extension delete the file
unlink($vv);
// print the deletion message
echo $vv." deleted!<br>";}else{
// if $vv is a dir then scan it again for files
scanr($vv);
}}
}

scanr($dir);
?>

Echo Directory And Sub Directory's

Similar Tutorials

View Content

I'm trying to echo the directory and sub directory only. I am not looking to show the files contained - only folders.

Tree Menu

Similar Tutorials

View Content

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>";
}

Binary Tree

Similar Tutorials

View Content

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

Tree Recursion

Similar Tutorials

View Content

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

Categories Tree

Similar Tutorials

View Content

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

Genealogy Tree

Similar Tutorials

View Content

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 ...

Php Category Tree Question

Similar Tutorials

View Content

N Level Tree Traversing

Similar Tutorials

View Content

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

Counting Binary Tree

Similar Tutorials

View Content

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.

Mlm-display Binary Tree

Similar Tutorials

View Content

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]

Displaying Binary Tree

Similar Tutorials

View Content

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 ?

Binary Tree Traversals

Similar Tutorials

View Content

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.

Rearrange Tree Structure

Similar Tutorials

View Content

Hey guys, I have a bunch of categories and products in a tree format. For several reasons I need to restructure them from the tree format into a flattened format.

I have 2 arrays, one full of categories, the other products. Each category and product has an ID, and a reference to it's parent's ID. The top level categories reference to 0.

What I need is to have the categories output like thus:

Top Level Categories:
Category 1
Category 2

Category 1
Sub category 1
Sub category 2

Category 2
Sub category 3
Sub category 4

Sub category 1
Product 1
Product 2

Sub category 2
Product 3
Product 4

Sub category 3
Product 5
Product 6

Sub category 4
Product 7
Product 8

There could be an unlimited number of sub categories within categories before we get to products, so this needs to be done through a function, however I cannot for the life of me think how to do this. Initially I thought about using 2 arrays, a buffer of categories outputted, and a queue of categories to be outputted, but quickly realised that when I go more than 2 layers deep I can't keep track of the queue's properly.

Script To Display Array As A Tree

Similar Tutorials

View Content

Hello

I have an array that I would like to display as a family tree... and am looking for an example script that will allow me to do this.

I want to be able to create X number of generations and fill the boxes with data from my array....

So, if I want 5 generations I want to generate a tree with 63 elements or boxes

Any help would be appreciated

Thanks

Adding A Node - Balanced B - Tree

Similar Tutorials

View Content

I would like to adding a node to a tree. I want it to be a balanced b-tree. The logic/algorithm i can think of is

Code: [Select]
<?php
function add_node($root, $node) // Where $root is the parent to which node should be added and $node is the node that is to be added.
{
     Traverse the tree level wise, level 1 being the lchild and rchild of $root and calculate the number of node in that level
     if(number of nodes in a level < 2[sup]$level[/sup])  // Since number of nodes a level can accommodate  = 2[sup]$level[/sup]
     {
          Add node in that level where ever it gets an empty spot.
     }
}
?>

Tree table:-
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;
Is their any better logic to do so ?

Iteration Over Json Response Dom Tree

Similar Tutorials

View Content

Evening everyone and Merry X-Mas (Happy Holidays) or whatever fits you best....   I have been trying over and over for about 12 hours to figure out how to get data from a specific JSON response and assign the specific values to a new array key/value pair. The various ways I have tried to figure this out are numerous so i'm going to avoid the runnig list of "I trieid this...and this...and this... etc etc." just understand I have reached a dead end point where I need help badly. Here is what our end goal is: "The company" is a "service industry" provider (plumbing, electrical etc. etc.) who wants to dispatch its technicians to new jobs based on which technician has the shortest travel time from any existing address where they already have a scheduled appointment that day and has available time in there schedule. Thus the dispatching system when a new service call is entered is going to give "recommended" technicians (up to 4) to be assigned the new service call based on the above mentioned criteria. (Efficient routing to save company gas cost) 1.) We have a "New service" street address assigned to the $to variable: $to = "4813 River Basin Dr S, Jacksonville FL 32207";
2.) We will have "records" array which containes a series of records, each record consists of a ticket# a technician id# and a street address: $records = array(
array("DV1012","30453423","9890 Hutchinson Park Dr Jacksonville, FL 32225"),
array("DB3434","30404041","821 Orange Ave Crescent City, FL 32112"),
array("DB3434","30605060","1972 Wells Road, Orange Park FL 32073"),
array("DB4578","30605060","2 Independent Drive, Jacksonville FL 32202"),
array("DB7841","30605060","5000 Norwood Avenue, Jacksonville FL 32208"),
array("DB3235","30605060","9501 Arlington Expressway, Jacksonville FL 32225"),
array("DB7894","30605060","Massey Avenue, Jacksonville, FL 32227"),
array("DB2020","30121212","11200 Central Pkwy Jacksonville, FL 32224")
                ); 3.) We are going to prepare the records array for submission to Google's Distance Matrix API by URL encoding each array value into a single variable and then submit it: foreach ($records as $key => $value) {$from = $from.urlencode($value[2])."|";} $to = urlencode($to);
$data = file_get_contents("//maps.googleapis.com/maps/api/distancematrix/json?origins=$from&destinations=$to&language=en-EN&units=imperial&mode=driving&sensor=false");
$res=json_decode($data) or die("Error: Cannot read object");
You may look at the ACTUAL live Google response from this he http://tiny.cc/i6eerx (We have applied <pre> and var_dump($res) to the output) We are looking to get the following information back: The distance and travel time between the "New Service" address ($to) and each of the address' in the $records array ($from), now once that information is returned from Google (JSON response) we need to parse the response and narrow it down to 4 or less (Based on the 4 lowest drive times) to form a new array which ends like this: $results = array(
array("DV1012","30453423","2.3 Miles","8 mins"),
array("DB3434","30404041","2.8 Miles","9 mins"),
array("DB3434","30605060","4.6 Miles","13.8 mins"),
array("DB4578","30605060","5.7 Miles","15.2 min")
                ); OUR PROBLEM: Everything up until the the Google API response is fine, but iterating over the multidimensional arrays within multidimensional arrays of the JSON response is just not coming together in my head (or 2 dozen code attempts). I am able to ECHO an individual value like ( echo $res->rows[0]->elements[0]->distance->text; ) but this has no value for the end result i need to get to. My last thoughts and efforts was that that I was going to have to embed foreach statements within foreach statements to drill down through the various arrays but that hasn't worked very well and it seems like it shouldn't be how it has to be done. I would appreciate any help in showing me how the iteration code should be written and any explanation about the code so i can wrap my head around it.