<?php

	header('Content-type: application/json');

	$sort = null;
	$dir = 'asc';
	$sort_dir = SORT_ASC;

	if (strlen($_GET['sort']) > 0) {
		$sort = $_GET['sort'];
	}
	if ((strlen($_GET['dir']) > 0) && ($_GET['dir'] == 'desc')) {
		$dir = 'desc';
		$sort_dir = SORT_DESC;
	} else {
		$dir = 'asc';
		$sort_dir = SORT_ASC;
	}

	returnData($sort, $dir, $sort_dir);

	function returnData($sort, $dir, $sort_dir) {

		$allRecords = initArray();
		echo $allRecords;

		if(!is_null($sort)) {

			foreach ($allRecords as $key => $row) {
				$sortByCol[$key] = $row[$sort];
			}

			if(count($sortByCol) > 0) {
				array_multisort($sortByCol, $sort_dir, $allRecords);
			}

		}

		$data = array();
		$lastIndex = count($allRecords);
		for ($i=0; $i < $lastIndex; $i++) {
			$data[] = $allRecords[$i];
		}

		$returnValue = array(
			"sort" => $sort,
			"dir" => $dir,
			"records" => $data
		);

		require_once('JSON.php');

		$json = new Services_JSON();
		echo json_encode($returnValue);

	}

	function live(){

		$username="root";
		$password="";
		$database="marketwatch";

		mysql_connect('localhost', $username, $password);
		mysql_select_db($database) or die("Unable to select database");

		$sql="SELECT * FROM mw";
		$result = mysql_query($sql);

		$encodable = array();
		while ($obj = mysql_fetch_object($result)) {
			$encodable[] = $obj;
		}

		return $encodable;

	}

	function initArray() {

		return array(live());

	}

?>