PHP Classes

Adjacency Model: Create and manipulate adjacency lists in MySQL

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 58%Total: 1,339 All time: 2,891 This week: 455Up
Version License PHP version Categories
adjacency-model 1.1BSD License5.0Algorithms, PHP 5, Databases
Description 

Author

This class can be used to create and manipulate adjacency lists in MySQL.

It can perform several types of operations to store and retrieve information in a MySQL table of nodes of an adjacency list.

Currently it can: add nodes, retrieve the list of all nodes, get the children of a given node, change the parent of a node, and delete nodes.

Innovation Award
PHP Programming Innovation award nominee
May 2010
Number 3


Prize: One book of choice by Packt
Adjacency lists are data structures that define vertex points and edges that connect them.

This class provides a solution for manipulating and storing adjacency lists in a MySQL database.

Manuel Lemos
Picture of Peter Drinnan
Name: Peter Drinnan is available for providing paid consulting. Contact Peter Drinnan .
Classes: 3 packages by
Country: Canada Canada
Age: 58
All time rank: 72621 in Canada Canada
Week rank: 170 Up7 in Canada Canada Up
Innovation award
Innovation award
Nominee: 1x

  Files folder image Files (3)  
File Role Description
Accessible without login Plain text file adjacency_demo.sql Data Sample MySQL data table structure. Can be modified.
Accessible without login Plain text file example.php Example Examples of adding, appending, renesting and deleting nodes within an adjacency list.
Plain text file adjacency.class.php Class base class with all functions required for adding, removing and renesting ordered items.

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:1,339
This week:0
All time:2,891
This week:455Up
User Ratings User Comments (1)
 All time
Utility:83%StarStarStarStarStar
Consistency:83%StarStarStarStarStar
Documentation:-
Examples:83%StarStarStarStarStar
Tests:-
Videos:-
Overall:58%StarStarStar
Rank:1469
 
Thank you so much Petr, really; thank you
10 years ago (Davide Briscese)
70%StarStarStarStar