<?php
	header("Content-Type: text/html; charset=ISO-8859-1");
	include("utility.php");
	
	$q = 0;
	if (isset($_GET["q"]))
	{
		$q = strtolower($_GET["q"]);
	}
	if (isset($_GET["t"]))
	{
		$table = strtolower($_GET["t"]);
	}
	if (isset($_GET["id"]))
	{
		$id = strtolower($_GET["id"]);
	}
	if (!$q) return;
	
	$arr = array();
	
	$handle = new DBAccess();
	$link = $handle->openConnection();
	switch($table)
	{
		case "comuni":
			$query = "SELECT concat(Comune, ' (', Provincia, ')') valore, CodCom id FROM " . $table;
			break;
		case "provincia":
		case "nazione":
			$query = "SELECT Nome valore, Sigla id FROM " . $table;
			break;
		case "artista":
			$query = "SELECT e.Nome valore, e.ID id FROM realta e INNER JOIN tipo_realta te ON e.IDTipo = te.ID WHERE te.IsArtista = 1 AND e.Attivo = 1 ORDER BY e.Nome";
			break;
		case "luogo":
			$query = "SELECT concat(e.Nome, ' (', e.IDProvincia, ')') valore, e.ID id FROM realta e INNER JOIN tipo_realta te ON e.IDTipo = te.ID WHERE te.IsLuogo = 1 AND e.Attivo = 1 ORDER BY e.Nome";
			break;
		case "organizzatore":
			$query = "SELECT e.Nome valore, e.ID id FROM realta e INNER JOIN tipo_realta te ON e.IDTipo = te.ID WHERE te.IsArtista = 0 AND e.Attivo = 1 ORDER BY e.Nome";
			break;
		case "realta":
			$query = "SELECT e.Nome valore, e.ID id FROM realta e WHERE e.Attivo = 1 ORDER BY e.Nome";
			break;
	}

	$res = $handle->getRecordset($query);
	$num_row = mysql_num_rows($res);
	if ($num_row > 0)
	{
		while($row = mysql_fetch_assoc($res))
		{
			$arr[$row['valore']] = $row['id'];
		}
	}

	foreach ($arr as $key=>$value) 
	{
		if (strpos(strtolower($key), $q) !== false) 
		{
			echo "$key|$value\n";
		}
	}

?>