Using nested sets - Revision history

Cmb: Mariup, capitalization and spelling changes.

2022-10-17T23:40:09Z

Mariup, capitalization and spelling changes.

2016-06-21T00:47:20Z

added relevant sources of information

← Older revision		Revision as of 00:47, 21 June 2016
Line 298:		Line 298:
	<references/>		<references/>
	<noinclude>[[Category:Platform 11.1]][[Category:Development Tips and Tricks]]</noinclude>		<noinclude>[[Category:Platform 11.1]][[Category:Development Tips and Tricks]]</noinclude>

			==See Also==
			* [https://groups.google.com/forum/#!topic/joomla-dev-cms/pkHm7F5yer8 How are the "lft" and "rgt" fields calculated (google groups thread)]
			* [https://www.sitepoint.com/hierarchical-data-database/ Storing Hierarchical Data in a Database]

2015-06-08T12:12:35Z

Deleting a node: remove jrequest

← Older revision		Revision as of 12:12, 8 June 2015
Line 281:		Line 281:
	<source lang="php">		<source lang="php">
	// Determine the node id from the request.		// Determine the node id from the request.
	$node_id = ~~JRequest~~::~~getInt~~('id');		$node_id = JFactory::getApplication()->input->get('id');

	// Delete the node.		// Delete the node.

2015-03-03T14:55:53Z

Adding a root node

← Older revision		Revision as of 14:55, 3 March 2015
Line 63:		Line 63:
	* Add the root node to an empty table.		* Add the root node to an empty table.
	*		*
	* @return ~~integer~~ The id of the new root node.		* @return mixed The id of the new root node or false on error.
	*/		*/
	public function addRoot()		public function addRoot()
	{		{
	$db = JFactory::getDbo();		$db = JFactory::getDbo();
	$~~sql~~ = '~~INSERT INTO ckm_profiles~~'
	. ' ~~SET~~ parent_id = 0'		$query = $db->getQuery(true)
	. ', lft = 0'		->insert('#__profiles')
	. ', rgt = 1'		->set('parent_id = 0')
	. ', level = 0'		->set('lft = 0')
	. ', title = '.$db->quote('root')		->set('rgt = 1')
	. ', alias = '.$db->quote('root')		->set('level = 0')
	. ', access = 1'		->set('title = ' . $db->quote('root'))
	. ', path = '.$db->quote('')		->set('alias = ' . $db->quote('root'))
	;		->set('access = 1')
	$db->setQuery($~~sql~~);		->set('path = ' . $db->quote(''));
	$db->~~query~~();		$db->setQuery($query);

			if(!$db->execute())
			{
			return false;
			}

	return $db->insertid();		return $db->insertid();
	}		}
	</source>		</source>
	~~TODO: CHANGE THE ABOVE TO USE JDatabaseQuery.~~

	It is perfectly reasonable to store payload data in the root node. For example, you might like to store component configuration data in the payload column of the root node.		It is perfectly reasonable to store payload data in the root node. For example, you might like to store component configuration data in the payload column of the root node.

2014-10-27T17:05:18Z

Updated for code style.

2013-10-24T19:44:19Z

← Older revision		Revision as of 19:44, 24 October 2013
Line 1:		Line 1:
	Starting with version 11.1 the Joomla Platform now includes native support for storing and retrieving hierarchical information in the form of "nested sets" in database tables. This support is used in the implementation of menus and categories in the core Joomla CMS from version 1.6 onwards, but can of course be used in your own extensions too. This document assumes that you are already familiar with using the JTable, JDatabase and JDatabaseQuery classes to interact with a database, either the Joomla database itself, or some external database.		Starting with version 11.1 the Joomla Platform now includes native support for storing and retrieving hierarchical information in the form of "nested sets" in database tables. This support is used in the implementation of menus and categories in the core Joomla CMS from version 1.6 onwards, but can of course be used in your own extensions too. This document assumes that you are already familiar with using the [[:Category:JTable\|JTable]], [[:Category:JDatabase\|JDatabase]] and JDatabaseQuery classes to interact with a database, either the Joomla database itself, or some external database.

	==Introduction==		==Introduction==

2012-12-18T00:15:44Z

Reverted edits by Pemdas21 (talk) to last revision by Hutchy68

← Older revision		Revision as of 00:15, 18 December 2012
Line 276:		Line 276:
	==References==		==References==
	<references/>		<references/>
	<noinclude>[[Category:Platform 11.1]][[Category:Development Tips and Tricks]~~][http://www.evanpetersen.com/item/nested-sets.html An alternative view of Nested Sets~~]</noinclude>		<noinclude>[[Category:Platform 11.1]][[Category:Development Tips and Tricks]]</noinclude>

2012-12-17T15:15:01Z

References

← Older revision		Revision as of 15:15, 17 December 2012
Line 276:		Line 276:
	==References==		==References==
	<references/>		<references/>
	<noinclude>[[Category:Platform 11.1]][[Category:Development Tips and Tricks]][http://www.evanpetersen.com/item/nested-sets.html an alternative view of Nested Sets]</noinclude>		<noinclude>[[Category:Platform 11.1]][[Category:Development Tips and Tricks]][http://www.evanpetersen.com/item/nested-sets.html An alternative view of Nested Sets]</noinclude>

2012-12-17T15:13:40Z

References

← Older revision		Revision as of 15:13, 17 December 2012
Line 276:		Line 276:
	==References==		==References==
	<references/>		<references/>
	<noinclude>[[Category:Platform 11.1]][[Category:Development Tips and Tricks]]~~</noinclude>~~[http://www.evanpetersen.com/item/nested-sets.html an alternative view of Nested Sets]		<noinclude>[[Category:Platform 11.1]][[Category:Development Tips and Tricks]][http://www.evanpetersen.com/item/nested-sets.html an alternative view of Nested Sets]</noinclude>

2012-12-17T15:13:10Z

← Older revision		Revision as of 15:13, 17 December 2012
Line 276:		Line 276:
	==References==		==References==
	<references/>		<references/>
	<noinclude>[[Category:Platform 11.1]][[Category:Development Tips and Tricks]]</noinclude>		<noinclude>[[Category:Platform 11.1]][[Category:Development Tips and Tricks]]</noinclude>[http://www.evanpetersen.com/item/nested-sets.html an alternative view of Nested Sets]