<?php
function get_categories() {
    global $mysqli;
    $query = 'SELECT * FROM category
              ORDER BY category_id';
    $result = $mysqli->query($query);
	$categories = array();
	while ( $row = $result->fetch_object() ) {
	   array_push($categories, $row);;
	}
    return $categories;
}

function get_category_name($category_id) {
	global $mysqli;
	$query = "SELECT name FROM category
			  WHERE category_id = $category_id";
	$result = $mysqli->query($query);
	$categoryName = '';
	$row = $result->fetch_object();
	if ($row->name == "") $categoryName = 'Category unknown';
	else {
		$categoryName =  $row->name;
	}
	$result->free();
	return $categoryName;
}
?>