<?php

$page = isset($_POST['page']) ? $_POST['page'] : 1;

$rp = isset($_POST['rp']) ? $_POST['rp'] : 10;

$sortname = isset($_POST['sortname']) ? $_POST['sortname'] : 'name';

$sortorder = isset($_POST['sortorder']) ? $_POST['sortorder'] : 'desc';

$query = isset($_POST['query']) ? $_POST['query'] : false;

$qtype = isset($_POST['qtype']) ? $_POST['qtype'] : false;



/* -- To use the SQL, remove this block

$usingSQL = true;

function runSQL($rsql) {



	$db['default']['hostname'] = "localhost";

	$db['default']['username'] = '';

	$db['default']['password'] = "";

	$db['default']['database'] = "";



	$db['live']['hostname'] = 'localhost';

	$db['live']['username'] = '';

	$db['live']['password'] = '';

	$db['live']['database'] = '';



	$active_group = 'default';



	$base_url = "http://".$_SERVER['HTTP_HOST'];

	$base_url .= str_replace(basename($_SERVER['SCRIPT_NAME']),"",$_SERVER['SCRIPT_NAME']);



	$connect = mysql_connect($db[$active_group]['hostname'],$db[$active_group]['username'],$db[$active_group]['password']) or die ("Error: could not connect to database");

	$db = mysql_select_db($db[$active_group]['database']);



	$result = mysql_query($rsql) or die ('test');

	return $result;

	mysql_close($connect);

}



function countRec($fname,$tname) {

	$sql = "SELECT count($fname) FROM $tname ";

	$result = runSQL($sql);

	while ($row = mysql_fetch_array($result)) {

		return $row[0];

	}

}

$page = $_POST['page'];

$rp = $_POST['rp'];

$sortname = $_POST['sortname'];

$sortorder = $_POST['sortorder'];



if (!$sortname) $sortname = 'name';

if (!$sortorder) $sortorder = 'desc';



$sort = "ORDER BY $sortname $sortorder";



if (!$page) $page = 1;

if (!$rp) $rp = 10;



$start = (($page-1) * $rp);



$limit = "LIMIT $start, $rp";

$where = "";

if ($query) $where = " WHERE $qtype LIKE '%".mysql_real_escape_string($query)."%' ";



$sql = "SELECT iso,name,printable_name,iso3,numcode FROM country $where $sort $limit";

$result = runSQL($sql);



$total = countRec('iso','country');

$rows = array();

while ($row = mysql_fetch_array($result)) {

	$rows[] = $row;

}

*/

if(!isset($usingSQL)){

	include dirname(__FILE__).'/countryArray.inc.php';

	if($qtype && $query){

		$query = strtolower(trim($query));

		foreach($rows AS $key => $row){

			if(strpos(strtolower($row[$qtype]),$query) === false){

				unset($rows[$key]);

			}

		}

	}

	//Make PHP handle the sorting

	$sortArray = array();

	foreach($rows AS $key => $row){

		$sortArray[$key] = $row[$sortname];

	}

	$sortMethod = SORT_ASC;

	if($sortorder == 'desc'){

		$sortMethod = SORT_DESC;

	}

	array_multisort($sortArray, $sortMethod, $rows);

	$total = count($rows);

	$rows = array_slice($rows,($page-1)*$rp,$rp);

}



header("Content-type: text/xml");

$xml = "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";

$xml .= "<rows>";

$xml .= "<page>$page</page>";

$xml .= "<total>$total</total>";

foreach($rows AS $row){

	$xml .= "<row id='".$row['iso']."'>";

	$xml .= "<cell><![CDATA[".$row['iso']."]]></cell>";

	$xml .= "<cell><![CDATA[".utf8_encode($row['name'])."]]></cell>";

	//$xml .= "<cell><![CDATA[".print_r($_POST,true)."]]></cell>";

	$xml .= "<cell><![CDATA[".utf8_encode($row['printable_name'])."]]></cell>";

	$xml .= "<cell><![CDATA[".utf8_encode($row['iso3'])."]]></cell>";

	$xml .= "<cell><![CDATA[".utf8_encode($row['numcode'])."]]></cell>";

	$xml .= "</row>";

}



$xml .= "</rows>";

echo $xml;