<?php

	require_once ("common.php");
	// retrieve starting letters from the $GET request
	$start = $_GET["input"];
	
	
	// generate SQL query
	$query = sprintf ("SELECT * FROM users WHERE name LIKE \"%s%%\"", $start);
	
	$result = mysql_query($query);
	
	
	if(mysql_num_rows($result)==0) {
		$suggestion["name"] = "No results found";
	    $suggestions[] = $suggestion;
	}
	
	// for each name in the table, create suggestions[].
	while ($row = mysql_fetch_array($result)) {
	  $suggestion = array();
	  $suggestion["name"] = $row["name"];
	  $suggestion["age"] = $row["age"];
	  $suggestion["city"] = $row["city"];
	  $suggestions[] = $suggestion; 
    }

    // output this after json encoding
    header("Content-type: text/plain");
    print(json_encode($suggestions));

?>