Adjacency Model: Create and manipulate adjacency lists in MySQL

Recommend this page to a friend!

Download .zip

Info

View files (3)

Download .zip

Reputation

Support forum (1)

Blog

Links

Last Updated		Ratings				Unique User Downloads		Download Rankings
2010-05-21 (6 years ago)		Not enough user ratings				Total: 1,239 This week: 1		All time: 2,982 This week: 1,047

Version		License		PHP version		Categories
`adjacency-model` 1.1		BSD License		5.0		Algorithms, 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

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

Peter Drinnan

Name:	Peter Drinnan `<contact>`
Classes:	3 packages by Peter Drinnan
Country:	Canada

Innovation award

Nominee: 1x

Files

File	Role	Description
`adjacency_demo.sql`	Data	Sample MySQL data table structure. Can be modified.
`example.php`	Example	Examples of adding, appending, renesting and deleting nodes within an adjacency list.
`adjacency.class.php`	Class	base class with all functions required for adding, removing and renesting ordered items.