<?php

define("JAPANESE_DICTIONARY_TABLE", "");
define("DB_SERVER_ADDRESS", "");
define("DB_USERNAME", "");
define("DB_PASSWORD", "");
define("DB_NAME", "");
        
$dbh=mysql_connect(DB_SERVER_ADDRESS, DB_USERNAME, DB_PASSWORD, true, 131072) or die ('I cannot connect to the database because: '.mysql_error());
mysql_select_db(DB_NAME, $dbh) or die("Could not select database " . DB_NAME);
mysql_query("SET NAMES `utf8`");


function output_translations(&$results){
		$output_array = array();
		while ($result = mysql_fetch_row($results)){
			$output_array[] = $result;
		}
		echo "showdata(" . json_encode($output_array) . ");";
		
}
	
function output_no_results($word){
		echo "showdata(" . json_encode(output_no_words($word)) . ");";
}
	
function output_no_words($word){
		return array(array("Sorry, no results for $word", "So sorry..."));
}
	
function translate_word($word){
		$encoding = mb_detect_encoding($word, "JIS, EUC-JP, UTF-8");
		if ($encoding != "UTF-8") $word = mb_convert_encoding($word, "UTF-8", $encoding);
		$word = mysql_real_escape_string($word);
		$query = "SELECT * FROM `" . JAPANESE_DICTIONARY_TABLE . "` WHERE `japanese` = '$word'";
		$results = mysql_query($query) or die(mysql_error());
		if (mysql_num_rows($results) > 0){
			return output_translations($results);
		}
		else{
			return output_no_results($word);
		}
}
	
	
function handle_input(){
		if (isset($_GET['word'])){
			translate_word($_GET['word']);
			return true;
		}
		else{
			return false;
		}
}


if (!handle_input()){
		// Do something interesting, like output all of a user's words or something.
}
?>