<?php
class codecs {
	static function records($sort_field='pk_codec', $sort_order='asc', $items_per_page=0, $page_number=1) {
    	$pdo = database::pdo();

		/* Calculate the $limit / $offset based on $items_per_page / $page_number */
		if ($items_per_page == 0) {
			$limit  = 9999;
			$offset = 0;
		} else {
			$limit  = $items_per_page;
			$offset = ($page_number-1) * $items_per_page;
		}

		/* Run the sql query */
		$query = $pdo->prepare('SELECT * FROM codecs LIMIT :limit OFFSET :offset');
		// TODO: Implemente sorting
		// $query = $pdo->prepare('SELECT * FROM codecs ORDER BY :sort_order :sort_field LIMIT :limit OFFSET :offset');
		// $query->bindParam(':sort_order', $sort_order, PDO::PARAM_STR);
		// $query->bindParam(':sort_field', $sort_field, PDO::PARAM_STR);
		$query->bindParam(':limit'     , $limit     , PDO::PARAM_INT);
		$query->bindParam(':offset'    , $offset    , PDO::PARAM_INT);
		$query->execute();
		if ($query->errorCode() != '00000') {
			$error = $query->errorInfo();
			throw new Exception($error[2]);
		}

		while($row = $query->fetch(PDO::FETCH_ASSOC)) {
			$ret[$row['pk_codec']] = $row;
		}

		return $ret;
	}
}