<?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;
}

//function that returns all the sections that belong to a specific page
function page_sections($page)
{
	global $db;

	$page_id = $db->querySingle("SELECT id FROM pages WHERE title='$page'");

	$query = $db->query("SELECT * FROM sections WHERE page_id = '$page_id'");

	$sections = array();
	$i=0;

	while ($row=$query->fetchArray())
	{
		$sections[$i] = $row[2];
		$i++;
	}
	return $sections;

}