Download the PHP package rundiz/nested-set without Composer
On this page you can find all versions of the php package rundiz/nested-set. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download rundiz/nested-set
More information about rundiz/nested-set
Files in rundiz/nested-set
Package nested-set
Short Description class library for CRUD the nested set data such as category tree.
License MIT
Informations about the package nested-set
NestedSet
The PHP nested set model for create/read/update/delete the tree data structure (hierarchy).
A class that help you to query complex data of nested set.
Example
Install
I recommend you to install this library via Composer and use Composer autoload for easily include the file. If you are not using Composer, you have to manually include the file by yourself.
Please make sure that the path to files are correct.
If you want to make sure or see how class is working please following the step below, otherwise skip this step.
Import tests/common/test-database-structure.sql file to the database.
Connect to DB
This class is using PDO class. Please connect to PDO and send the \PDO
object to the class constructor.
Insert the data
Before insert, you can get new position of that taxonomy level using getNewPosition()
method.
Everytime you insert the data, you have to run rebuild()
method to generate level, left, right data. The incorrect level, left, right data can cause incorrect listing.
Update the data
To update the data, you don't need new position for this but you have to run rebuild()
method every time.
Check parent under children
If you want to change the parent of selected item, you can check first that the new parent of selected item is under children of selected item or not.
You can use isParentUnderMyChildren()
method to check this and false
means correct parent (new parent is not children of editing item).
To continue on this please use the data in demo-data.sql file.
Read the data
To read the selected item data with its children, you can use getTaxonomyWithChildren()
method.
To read the selected item data with its parent in a line until root item, you can use getTaxonomyWithParents()
method.
List the items
You can list the items by use listTaxonomy()
method for nested array data or use listTaxonomyFlatten()
for flatten data.
Both methods parameters are same.
Delete an item
You can choose how to delete an item.
- Delete selected item and ALL of its children.
- Delete selected item and pull up its children to the current parent.
Every time you deleted, you have to run the rebuild()
method to correct level, left, right data.
Delete selected item and ALL of its children.
Delete selected item and pull up its children to the current parent.
For more example including complex conditions which is new feature since v 1.x, please take a look in tests/phpunit folder or the API document in .wiki/apidoc folder.