PHP - Recursive Function For Multidimensional Arrayunpack

Hi there,

I have written a recursive function that basically generates a tree structure for my site pages (kind of like a sitemap). It all worked fine until yesterday, I started getting error messages telling me that I have exhausted the amount of memory available.

There are only about 30 pages in the site (parent, child, sub-child etc), so I dont think that I should be using up that much memory. This was my first attempt at a recursive function so I am pretty sure that it may not have been optimised properly.

If anyone could take a look and offer any feed back that would be great. (written in codeigniter framework)

       function getAllPages() {
      
      $this->tmp_arr = array();
      
      $this->buildPageStructure(0, 0);
      
      return $this->tmp_arr;
      
   }
   
   
   
   function buildPageStructure($parent_id, $counter) {
   
      $CI = & get_instance();
      
      $query = $CI->db->query("SELECT page_id, title, page_url, status FROM pages WHERE parent_page='$parent_id' ORDER BY sort_order ASC");
      
      $counter++;
      
      if($query->num_rows() > 0) {
      
         foreach($query->result() as $row) {
            
            $new_arr = new Page();
            
            $new_arr->page_id = $row->page_id;
            $new_arr->title = $row->title;
            $new_arr->level = $counter;
            $new_arr->page_url = $row->page_url;
            $new_arr->status = $row->status;
            
            $this->tmp_arr[] = $new_arr;
                        
            $this->buildPageStructure($row->page_id, $counter);            
            
                     
         }
         

      }
   
   }

Cheers

Jon

i have the below script but it doesn't work it just refreshes the page anyone know what is wrong

Code: [Select]
<?php
$path = "../../gallery/gallery_files/gallery/";
if(isset($_POST['file']) && is_array($_POST['file']))
{
foreach($_POST['file'] as $file)
{

$dirname = $path; 

//Recursive Delete Function

function DELETE_RECURSIVE_DIRS($dirname)
{ // recursive function to delete
  // all subdirectories and contents: 
  if(is_dir($dirname))$dir_handle=opendir($dirname); 
  while($file=readdir($dir_handle)) 
  {                                                      
    if($file!="." && $file!="..") 
    { 
      if(!is_dir($dirname."/".$file))unlink ($dirname."/".$file); 
      else DELETE_RECURSIVE_DIRS($dirname."/".$file); 
    } 
  } 
  closedir($dir_handle); 
  rmdir($dirname); 
  return true; 
}

}
}
?>

Hey there

I just started out with PHP so it might be a trivial problem. I want to populate an array with values by a recursive function but i don't get it the way i want it to have.

Target array (written in python syntax):

myArray = { 
	key : [
		[a1, a2, a3, a4], 
		[b1, b2, b3 ,b4]
	],
	key2 : [
		[c1, c2, c3, c4], 
		[d1, d2, d3, d4]
	]
}

So far i created a recursive function to collect all data i need for the array but i don't get the right syntax to achieve my target array.

What i have so far is following code (snippet):

function get_data($main_dir, $items=[], $myArray=[], $depth=0) {
	global $items;
	if ($myArray == NULL && depth == 0) {
		$myArray = array();
	}
	$depth++;
	$dirHandle = opendir($main_dir);
	
	while ($file = readdir($dirHandle)){
		if(is_dir($main_dir.$file) && $file != "." && $file != "..") {
			$new_dir = $main_dir.$file."/";
			$items = get_data($new_dir, $items, $myArray, $depth);
			$myArray = $items[1]
			$items = $items[0]
		}
		else {
			splitted_dir = preg_split("/\//", $main_dir);
			key = splitted_dir[2];
			file_information = read_out_file($main_dir.$file);
			information_1 = file_information[0];
			information_2 = file_information[1];

			myArray = array_merge($myArray, array($key, array($key, $information_1, $information_2, $main_dir, $file))
		}
	}
}

The array contains all informations i need but the structure of it is not useable.

Current output:

Array ( 
	[0] => key1 
	[1] => Array ( 
		[0] => key1 
		[1] => information_1 
		[2] => information_2 
		[3] => ./path/ 
		[4] => filename ) 
	[2] => key1 
	[3] => Array ( 
		[0] => key1 
		[1] => information_1
		[2] => information_2
		[3] => ./path/ 
		[4] => filename ) 
	[4] => key1 
	[5] => Array ( 
		[0] => key1 
		[1] => information_1
		[2] => information_2 
		[3] => ./path/ 
		[4] => filename ) 
	[6] => key2 
	[7] => Array ( 
		[0] => key2 
		[1] => information_1
		[2] => information_2
		[3] => ./path/ 
		[4] => filename ) 
	[8] => key2 
	[9] => Array ( 
		[0] => key2 
		[1] => information_1 
		[2] => information_2 
		[3] => ./path/ 
		[4] => filename ) 
) 1 

## IDK why this "1" at the end gets printed out... 

But what i want to get is this:

Array (
    [key1] => Array (
        Array (
            [0] => key1 
            [1] => information_1 
            [2] => information_2 
            [3] => ./path/ 
            [4] => filename ) 
        )
        Array (
            [0] => key1 
            [1] => information_1 
            [2] => information_2 
            [3] => ./path/ 
            [4] => filename ) 
        )
    )
    [key2] => Array (
        Array (
            [0] => key2 
            [1] => information_1 
            [2] => information_2 
            [3] => ./path/ 
            [4] => filename ) 
        )
        Array (
            [0] => key2 
            [1] => information_1 
            [2] => information_2 
            [3] => ./path/ 
            [4] => filename ) 
        )
    )
)

 

At the end i want to sort the output by alphabetic order of the keys which i should achieve with sort() i guess?

 

Greetings

Edited August 10, 2019 by Sandy_85

Hi,

I am trying to recursively build another array based on the one I get back from our CRM api.  The array I get back looks like this:

Code: [Select]
[1] => stdClass Object
        (
            [description] => Description Text
            [label] => Product
            [name] => Product
            [sobject] => KnowledgeArticleVersion
            [topCategories] => stdClass Object
                (
                    [childCategories] => Array
                        (
                            [0] => stdClass Object
                                (
                                    [childCategories] => Array
                                        (
                                            [0] => stdClass Object
                                                (
                                                    [childCategories] => Array
                                                        (
                                                            [0] => stdClass Object
                                                                (
                                                                    [label] => Apple
                                                                    [name] => Apple
                                                                )

                                                            [1] => stdClass Object
                                                                (
                                                                    [label] => Orange
                                                                    [name] => Orange
                                                                )

                                                            [2] => stdClass Object
                                                                (
                                                                    [label] => lemon
                                                                    [name] => lemon
                                                                )

                                                        )

                                                    [label] => Templates
                                                    [name] => Templates
                                                )

                                            [1] => stdClass Object
                                                (
                                                    [label] => Connector
                                                    [name] => Connector
                                                )

                                            [2] => stdClass Object
                                                (
                                                    [label] => AeroView
                                                    [name] => AeroView
                                                )

                                        )

                                    [label] => AeroWare
                                    [name] => AeroWare
                                )

                            [1] => stdClass Object
                                (
                                    [label] => BackOffice
                                    [name] => BackOffice
                                )

                            [2] => stdClass Object
                                (
                                    [label] => OutWare
                                    [name] => OutWare
                                )

                            [3] => stdClass Object
                                (
                                    [childCategories] => Array
                                        (
                                            [0] => stdClass Object
                                                (
                                                    [label] => ERA
                                                    [name] => ERA
                                                )

                                            [1] => stdClass Object
                                                (
                                                    [label] => Kairos
                                                    [name] => Kairos
                                                )

                                        )

                                    [label] => InWare
                                    [name] => InWare
                                )

                        )

                    [label] => All
                    [name] => All
                )

        )

The child categories could be any level deep.  I would like put it in an array something like this:
Code: [Select]
Array
(
    [label] => Cat 1
    [level] => 0
    [children] => Array
        (
            [label] => Sub Cat 1
            [level] => 1
            [children] => Array
                (
                    [label] => Sub Sub Cat 1
                    [level] => 2
                )

        )

)

I have tried so many things but I just can't get it right.  Any assistance would be greatly appreciated.

Thanks
Peter

Hey all! 

I'm writing a simple script to scan a local directory named 'files' and all sub directories of 'files', adding each file to a database in the same table. To do this, I'm using scandir on the current working directory/files to start, and iterating over each file in a loop, but if the file is a directory, I append the directory name to the  cwd/files and call scandir on that, creating a list of files in the subfolder, and then I call my addFiles() function recursively, with this as the argument.

As of now, it just stops at the second call to addFiles. It adds all the top level files fine, stops there. That's where all my print_r() lines have gotten me. 

Here's my code...

<!--
To change this template, choose Tools | Templates
and open the template in the editor.
-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
    <head>
        <title></title>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    </head>
    <body>
        <?php
        include 'DBConnect.php';

        $db = new DBConnect() or die("Can't connect to DB");
        $conn = $db->getConn();
        mysql_select_db('download', $conn) or die("Can't select DB");
        $dir = getcwd();
        $dir = $dir . '\files' . "\\";
        $fid = 1;
        $dir = addslashes($dir);
        $files = scandir($dir);
        echo $fid . "  ";
        echo $dir;

        function addFiles($files) {
            global $dir;
            global $conn;
            global $fid;
            unset($files[0]);
            unset($files[1]);
            print_r($files);
            foreach ($files as $aFile) {
                if (is_file($dir.$aFile)) {
                    echo "<li> $aFile </li>";
                    $query = "INSERT INTO files (file_id, file_path, file_name) values ($fid, '$dir', '$aFile')";
                    mysql_query($query, $conn) or die("Something wrong with query");
                    $fid = $fid + 1;
                } else if (is_dir($dir.$aFile)) {
                    $fid = $fid + 1;
                    $aDir = $dir . $aFile . "\\";
                    echo $dir;
                    addFiles(scandir($dir.$aFile));
                }
            }
        }

        
        addFiles($files);
        ?>

    </body>
</html>



Thanks in advance for any ideas. Also, if I'm approaching this problem completely wrong, let me know! I just came up with this and I feel like it should work...

I need to create a function that lists subfolders of a given folder, that contain at least one .txt file.
I found the following function, which displays a list of file that match a pattern in a directory tree:

function find($dir, $pattern){
$dir = escapeshellcmd($dir);  
$files = glob("$dir/$pattern");  
foreach (glob("$dir/{.[^.]*,*}", GLOB_BRACE|GLOB_ONLYDIR) as $sub_dir) //look in subdirectories
{
$arr   = find($sub_dir, $pattern); //recursive call
$files = array_merge($files, $arr); // merge array with files from subdirectory  
}  
return $files;  
}  
$txtFiles=find("project/sys","*.txt");
foreach ($txtFiles as $txtFile)
{
echo '<h2>'.$txtFile.'</h2>'; //display all text files
}


My question is, how do I change the function to return only folders that contain at least one text file. But, the functions should look inside child folders of "project/sys" and list a child folder only once if that folder or any of its child folders contain at least one text file.

I'll give an example of the output I'm looking for:
Folder list
project/sys/diagram
project/sys/bin
project/sys/scripts
project/sys/styles
project/sys/meta

The above folders may not contain a text file directly, but their children folders do. However, I'm not interested in their children folder and I want to list the above level folder only once for each folder.

Thanks in advance

I'm trying to return to array of letters that bruteForce finally decides upon. However, I can't seem to pass the array to librarySolve.

I'm feeling dumb, any help?

Code: [Select]
function librarySolve($string){
$temp = $this->bruteForce($string, FALSE, 0);
return $temp;
}

function bruteForce($string, $state, $trys){
$base = $string;
$state = $state;
$new_letters = array();

if($trys <= 6000){
$this->new_letters = $this->generateRandomCipher();
$string = preg_replace('/[^a-zA-Z0-9-\s]/', '', $string);

for($a=0;$a<=strlen($string);$a++){
$letter = substr($string, $a, 1);
$pattern = "/[A-Z]/";

if(preg_match($pattern, $letter)!=0){
$new_letter = $this->new_letters[$letter];
} else if(preg_match($pattern, $letter)==0) {
$new_letter = $letter;
}
$decipher .= $new_letter;
}

$word_array = explode(" ", $decipher);

$count = 0;
for($a=0;$a<count($word_array);$a++){
$do = $this->checkWord($word_array[$a]);
if(!empty($do)){
$count++;
}
}

if($count>=2){ $state = TRUE; } else { $state = FALSE; }

if($state==TRUE){
return $this->new_letters;
} else {
$trys++;
$this->bruteForce($base, $state, $trys);
}
}
}

Hi there, hope one of you can help me with a problem im just having.

Ok, lets start with the explanation what i want to to:
I'd like to collect headlines from a html site, and get the test results in an array, so that the array structure represents the dom-levels of the site.

Small Example:
<h1>test1.1<h1/>
<h2>test2.1</h2>
<h2>test2.2</h2>
<h3>test3</h3>
<h1>test1.2<h1/>
Shoul end in a array structure like:

Code: [Select]
array('level 1' => array (
            'sibble1' => array (
                'headline' => 'test1.1',
                'level2' => array(
                    'sibble1' => array (
                        'headline' => 'test2.1',
                        'level3' => array(), // empty data, needs to be processed anyway to find gaps, to maybe a h4 headline would be existing
                    ),
                    'sibble2' => array (
                        'headline' => 'test2.2',
                        'level3' => array (
                            'sibble1' => array (
                                'headline' => 'test3.1',
                                'level4' => array(), // empty data, needs to be processed anyway to find gaps, to maybe a h4 headline would be existing
                            ),
                        ),
                    ),
                ),
            ),
            'sibble2' => array (
                'headline' => 'test1.1',
                'level2' => array(),
             ),
        ),
);

So i hope out of this example you can see what i want to do. level represents the healdine level 1-9, sibblin is as name for the childs on the headline level.

Ok, so to extract the herefore needed data out of the html, i build a class with a recursive function, that filters the html by a regex from one headline to the next, first iteratin all childs, if there are no more childs i go tho ne nextsibbling element.

as an running example code look he

Code: [Select]
<?php

class Application_Model_DomParser {

    const PREG_MATCH_ONE_ELEMENT_TO_MUCH_LENGTH = 4;

    private $slicedFields = array();

    public function __construct() {
    }

    public function sliceFirstSectionToDataFields($level = 1, $haystack) {

        preg_match_all("#(.*?)<h$level>(.*?)</h$level>(.*?)(<h$level>|$)#s", $haystack, $data);

        // prepare the chunkData
        $pageText = '';
        if (isset($data[1][0])) {
            $pageText = $data[1][0];
        }
        $headline = '';
        if (isset($data[2][0])) {
            $headline = $data[2][0];
        }
        $dataToProcessNextLevel ='';
        if (isset($data[3][0])) {
            $dataToProcessNextLevel = $data[3][0];
        }
        // @todo dirty warnings compression, search why warning occures
        @$posOfNextChild = strlen($data[0][0]) - self::PREG_MATCH_ONE_ELEMENT_TO_MUCH_LENGTH;


// from here goes the debug...
echo $headline ."::" .strlen($dataToProcessNextLevel). "<br>";


        if (strlen($dataToProcessNextLevel) <= self::PREG_MATCH_ONE_ELEMENT_TO_MUCH_LENGTH) {
            if ($level < 9) {
                $dataToProcessNextLevel = $haystack;
            }
            else {
                return;
            }
        }
        //recursive check for next level in $dataToProcessNextLevel
        $nextLevel = $level + 1;
        $this->sliceFirstSectionToDataFields($nextLevel, $dataToProcessNextLevel);


        $haystack = substr($haystack, $posOfNextChild);
        // slized To The End
        if (self::PREG_MATCH_ONE_ELEMENT_TO_MUCH_LENGTH == strlen($haystack)) {
//            die("slized To The End");
            return;
        }

        // recursive check for other childs in actuall level...
        $this->sliceFirstSectionToDataFields($level, $haystack);
    }
}


$htmlString = 'test<h1>headkline1.1</h1>
<p>test test</p>
<h2>headline 2.1</h2>test test
<h2>headline 2.2</h2>
<p>tes test test</p>
<h3>headline 3.1</h3>test
<h3>headline 3.2</h3>test
<h2>headline 2.3</h2>
<p>&nbsp;</p>
<p>test</p>
<h1>headline 1.2</h1>
<h2>headline 2.4</h2>
<p>11111111111112222222222222222222222</p>
<p>&nbsp;ewfwrefg upowmdg w3q09umq09wrt n3q089ty 3q0898943ty -98 41</p>
<h3>headline 3.3</h3>
<p>test</p>
<p>test</p>
<p>test</p>
<h1>1.3 testtest</h1>
<p>test</p>
<h3>head 3.4</h3>
<p>sadfsadfsadf asdfsda f sdaas saf saddas</p>
<h3>head 3.4</h3>
<h3>test 1.3</h3>
<p>test;</p>
';

$model = new Application_Model_DomParser();
$result = $model->sliceFirstSectionToDataFields(1, $this->htmlString);


So letting this piece of code run, you can se via the debug echo, every headline is found, even in the right order of its occurence.

My problem now is dont get it how to return the extracted values, and collect them to get a result as my above shown structure shows.

So i spent ours to solve this problem but didnt come to a result.

I know its a hard problem, and to help me takes time, cause its a complex situation.

Allthough i hope someone knows a anser. I need this problem solved, to get my mind rested!

Thanks, and greetings
Selma

Something bothers me:
I am writing a PHP code to implement "step by step" form. In order to do that, I copied a method which looks like:

Program name: doit.php :

if (!isset($_SESSION['para_stage'])) { ... first time to the code .... initialize variables ...display first form which calls doit.php when submit.....}
else {already been to this code, variables are initialized, do what you have to do and recall doit.php ....}

It works fine, but: isn't there a problem with calling the same program again and again from itself? isn;t it like a recursive, which means the stack will be used until overflow?

Hello,   Here is my code:

<?php

require 'vendor/autoload.php';

$client = new Elasticsearch/Client();

$root = realpath('~/elkdata/for_elk_test_2014_11_24/Agencies');

$iter = new RecursiveIteratorIterator(
		new RecursiveDirectoryIterator($root, RecursiveDirectoryIterator::SKIP_DOTS),
		RecursiveIteratorIterator::SELF_FIRST,
		RecursiveIteratorIterator::CATCH_GET_CHILD);
		
$paths = array($root);
foreach ($iter as $path => $dir) {
	if ($dir -> isDir()) {
		$paths[] = $path;
		}
	}

//Create the index and mappings
$mapping['index'] = 'rvuehistoricaldocuments2009-2013'; //mapping code
$mapping['body'] = array (
	'mappings' => array (
		'documents' => array (
			'_source' => array (
				'enabled' => true
			),
			'properties' => array(
				'doc_name' => array(
					'type' => 'string',
					'analyzer' => 'standard'
				),
				'description' => array(
					'type' => 'string'
				)
			)
		)
	)
);

$client ->indices()->create($mapping)


//Now index the documents

for ($i = 0; $i <= count($paths); $i++) {
	$params ['body'][] = array(
		'index' => array(
		'type' => 'documents'
		'body' => array(
			'foo' => 'bar' //Document body goes here
			
			)
		)
	);
	
	//Every 1000 documents stop and send the bulk request.
	
	if($1 % 1000) {
		$responses = $client->bulk($params);
	
	// erase the old bulk request
	$params = array();
	
	// unset the bulk response when you are done to save memory
	unset($responses);
	}
}
?>

I am looking to index a large amount of documents using elastic search and php. I have a very complex directory filled with other directories that i need to index into an array. I wanted to see if my code looked right, and if not what am I doing wrong?    Thanks, Austin Harmon

I'm really fond of your coding and need some help too I'm also trying to make a tree and save it in an xml file such that parent_id of one node is inserted in as pages key to the father node.By running this query
$sql = "Select * from category order by parent_id ASC";
I'm getting the following result.
Array
(
    => Array
        (
            [category_id] => 2
            [parent_id] => 0
            [category_name] => Clothes
        )

    [1] => Array
        (
            [category_id] => 5
            [parent_id] => 1
            [category_name] => T-shirts
        )

    [2] => Array
        (
            [category_id] => 6
            [parent_id] => 1
            [category_name] => Cotton-Shirts
        )

    [3] => Array
        (
            [category_id] => 1
            [parent_id] => 2
            [category_name] => Upper
        )

    [4] => Array
        (
            [category_id] => 4
            [parent_id] => 2
            [category_name] => Lower
        )

    [5] => Array
        (
            [category_id] => 3
            [parent_id] => 4
            [category_name] => Pants
        )

)
 
My code is as follows but not executing correctly
function searchTree($arr,$node,$i){
      if(!in_array($node['parent_id'],$arr[$i])) {
         $stmt =  '<pages_'.$i.'>';
         $stmt .=$node;
         $stmt .='</pages_'.$i.'>';
         return $stmt;}
      else{
         //print_r($returnTree);
         print_r ($arr[$i]);//['category_id'];
         $returnTree = ($arr[$i]['category_id']==$node['parent_id'])?
          searchTree($arr,$node,$i++): searchTree($arr,'',$i++);
      }
}
   $i=0;
   foreach($links as $link){
$myArr = searchTree($links,$link,$i);}

The result should be as follows:
<page_1>
        <label>Clothes</label>
        <uri>#</uri>
<pages>

        <page_1_1>
                   <label>Upper</label>
                   <uri>#</uri>
                   <pages>
                              <label>T-Shirt</label>
                              <uri>#</uri>
                              <page_1_1>
                                    <page_1_1_1>
<label>Short Sleaves</label>
<uri>#</uri>
</page_1_1_1>
<page_1_1_2><label>Long Sleaves</label><uri>#</uri>
</page_1_1_2></page_1_1></page_1>
<page_1_2>
                   <label>Lower</label>
                   <uri>#</uri>
                   <pages>....</page_1_2>

Hopefully you can unsderstand this problem. Please help me.

Code: [Select]
        public function getBonusChildren($userID)
        {
if($userID != NULL)
{
$sql = 'SELECT COUNT(*) AS count, userID FROM jos_backoffice_users WHERE parentID= ' . $userID . ';';
$stmt = conn::getInstance()->prepare($sql);
$stmt->execute();
                $obj = $stmt->fetchAll(PDO::FETCH_ASSOC);
if(is_object($obj))
{
$obj->count += $this->getBonusChildren($obj->userID);
}
}
                return $obj->count;
}
I get no error.  It just always return null.   How can I get this done?

If i have a list of categories like:
1. Billboards and advertisement section
  1(a)City Clock
    1(a)(i)Application fee  (has columns for approved price and proposed price)
    1(a)(ii)Advertisement Per year (has columns for approved price and proposed price)

  1(b)Billboards
    1(b)(i)Application fee for construction (has columns for approved price and proposed price)
    1(b)(ii)Charge per year without advertisement (has columns for approved price and proposed price)

  1(c)Something here.....
    1(c)(i) something here...(has columns for approved price and proposed price)
    1(c)(ii)something here...(has columns for approved price and proposed price)
    1(c)(iii) something here... (has columns for approved price and proposed price)
     e.t.c

THEN SOME CATEGORIES LOOK LIKE:category 2
2. Category name
  2(a)something here..(has columns for approved price and proposed price)
  2(b)something here..
    2(b)(i)something here..(has columns for approved price and proposed price)
    2(b)(ii)something here..(has columns for approved price and proposed price)



NOW: i have categories without sub categories and others with sub-sub categories , a main category doesn't does have a column for prices ( or lets just say other columns) , a sub category WITHOUT its sub category will have columns for prices, if a sub category has its sub category, then its subcategory should have columns for prices (this is where my problem is - how do i handle such a situation in php Mysql?? )

Dear all,

Hello, i'm a newbie programmer. I want to implement the concept about recursive descent parser for natural language (english). The concept was found in http://nltk.sourceforge.net/doc/en/ch07.html#rdparser. But my problem is, how to implementation the concept/theory to PHP code ? Anyone would to help me to give the advice or tutorial or maybe anyone has to make script before?

Thank you very much in advance.

Hello Community, maybe I'm a little bit over-worked, but I'm stucked in a problem with recursive database queries.

I have a DB table with from/to relations. Here is an excerpt for only one relation (from rel_item_id_from=3 to rel_item_id_to=3):

rel_id	rel_item_id_from	rel_item_id_to
1		52					3
2		3					17

My question is: How can I get a recursive solution to get the upward and downward children? It is also possible to have multiple relations (1:n or n:m).

Thanks for your assistance - OLK