How to write this output to mysql using php

[keith23]

Hi all. i got this recursive php function but do not know how to write its output to mysql database. could any one show me how i can write it to mysql database.I run it and it outputs all the file name and info with in root folder and sub folder.Thanks

<?php

/*------------------------------------------------------------------------------
|
|                             PHParadise source code
|
|-------------------------------------------------------------------------------
|
| file:             recursive directory listing
| category:         directories
|
| last modified:    Mon, 20 Jun 2005 16:40:33 GMT
| downloaded:       Wed, 08 Feb 2006 22:18:25 GMT as PHP file
|
| code URL:
| [URL unfurl="true"]http://www.phparadise.de/php-code/directories/recursive-directory-listing/[/URL]
|
| description:
| a function to scan directories recursively and save the result to an array with
| informations like level, path, name and file informations. you can optionally
| set a filter to return only files wich match the filter as extension.
|
------------------------------------------------------------------------------*/


/*
scan_directory_recursively( directory to scan, filter )
expects path to directory and optional an extension to filter
of course PHP has to have the permissions to read the directory
you specify and all files and folders inside this directory
*/
function scan_directory_recursively($directory, $filter=FALSE)
{
	// if the path has a slash at the end we remove it here
	if(substr($directory,-1) == '/')
	{
		$directory = substr($directory,0,-1);
	}
	// if the path is not valid or is not a directory ...
	if(!file_exists($directory) || !is_dir($directory))
	{
		// ... we return false and exit the function
		return FALSE;
	// ... else if the path is readable
	}elseif(is_readable($directory))
	{
		// we open the directory
		$directory_list = opendir($directory);
		// and scan through the items inside
		while (FALSE !== ($file = readdir($directory_list)))
		{
			// if the filepointer is not the current directory
			// or the parent directory
			if($file != '.' && $file != '..')
			{
				// we build the new path to scan
				$path = $directory.'/'.$file;
				// if the path is readable
				if(is_readable($path))
				{
					// we split the new path by directories
					$subdirectories = explode('/',$path);
					// if the new path is a directory
					if(is_dir($path))
					{
						// add the directory details to the file list
						$directory_tree[] = array(
							'path'    => $path,
							'name'    => end($subdirectories),
							'kind'    => 'directory',
							// we scan the new path by calling this function
							'content' => scan_directory_recursively($path, $filter));
					// if the new path is a file
					}elseif(is_file($path))
					{
						// get the file extension by taking everything after the last dot
						$extension = end(explode('.',end($subdirectories)));
						// if there is no filter set or the filter is set and matches
						if($filter === FALSE || $filter == $extension)
						{
							// add the file details to the file list
							$directory_tree[] = array(
								'path'      => $path,
								'name'      => end($subdirectories),
								'extension' => $extension,
								'size'      => filesize($path),
								'kind'      => 'file');
						}
					}
				}
			}
		}
		// close the directory
		closedir($directory_list); 
		// return file list
		return $directory_tree;
	// if the path is not readable ...
	}else{
		// ... we return false
		return FALSE;	
	}
}
// to use this function to get all files and directories in an array, write:
// $filestructure = scan_directory_recursively('path/to/directory');
// to use this function to scan a directory and filter the results, write:
// $fileselection = scan_directory_recursively('directory', 'extension');
// example 
echo '<pre>';
print_r(scan_directory_recursively('.'));
echo '</pre>';
?>