list files and folders: list files and folders in a directory

This class can manipulate and search files and directories.

It can create directories, read and write, as well and delete files and folders recursively using PHP iterator classes.

The class can also search for files inside given directories recursively using regular expressions to filter the file names.

This package implements SPL iterators to find files with different criteria.

It can take a path a directory to traverse to start finding files.

There are additional iterator classes to sort files by name, sort by type, sort by last access time, sort by last change time, to filter files with a given file name extension, filter only files or only directories, and to limit the number of found files, or limit by directory depth or file size.

This class can access MySQL databases and execute common queries. Currently it can:

- Connect to a given MySQL host and access a given database
- List all tables in the accessible databases
- Get the columns of a given table
- Compose and execute SELECT queries to a given table getting specific fields by a given sorting order returning the results into a single array
- Search for given table records that match given conditions
- Insert table records with given field values
- Update table records with given field values and conditions
- Delete table records that match a condition
- Create table records for a new user with a password
- Authenticate a given user with a password in the users table
- Change a given user password in the users table
- Update or delete given user records in the users table
- Read the text contents of files in the format CSV, PDF or Microsoft Word
- Write plain text or CSV files
- Rename or delete files
- Get the list of files from a directory
- Etc..

This class can be used to retrieve information about files and directories.

It can:

- Retrieve an array with the list files in a given directory with several details like the file names, file sizes, last access date, last modified date, etc.
- Optionally traverse the given directory recursively to list files contained in sub-directories
- Filter the listing by file name extension, MIME type, last modified and last accessed dates.
- Filter a listing with additional criteria to create a more restricted listing
- Sort the retrieved listing
- Determine the most recently changed file
- Calculate the size of the files in a given directory listing
- Retrieve the size, last modified and last access data, permissions, owner and MIME type of a file in in a human readable format