<?php
/**
 * Created by PhpStorm.
 * User: aleksandarhristov
 * Date: 29.01.15
 * Time: 09:54
 */

//function that returns all the pages in the database in an array
function get_pages()
{
	global $db;
	$pages = $db->query("SELECT * FROM pages");

	$db_page_title=array();

	$i=0;
	while ($row=$pages->fetchArray())
	{
		$db_page_title[$i] = $row[1];
		$i++;
	}

	return $db_page_title;
}

//function that returns all the sections in the database in an array in format "page: section"
function get_sections()
{
	global $db;
	$pages = $db->query("SELECT * FROM sections");
	$page_section=array();

	$i=0;
	while ($row=$pages->fetchArray())
	{
		$db_section_title = $row[2];
		$db_page_id = $row[1];
		$db_page_title = $db->querySingle("SELECT title FROM pages WHERE id = '$db_page_id'");

		$page_section[$i]=$db_page_title.": ".$db_section_title;

		$i++;
	}

	return $page_section;
}

//function that returns the current page as string; needed in the admin sidebar wrapper template to give the active class and color the active page <li>
function current_page()
{
	global $current_page;
	if(strpos($current_page, "create") !== false)
	{
		$current_page = "create";
	}
	else if(strpos($current_page, "edit") !== false)
	{
		$current_page = "edit";
	}
	else
	{
		$current_page = "remove";
	}

	return $current_page;
}

?>