/**
* Gets a verb entry from the database using either Kanji, Hiragana or Romaji
*
* @param $verb
* @return array
*/
public static function getVerb($verb)
{
if (!Analyzer::hasJapaneseLetters($verb)) {
$hepburn = new Kana();
$verb = $hepburn->transliterate($verb);
}
$sql = 'SELECT * FROM verbs WHERE kanji = :kanji OR kana = :kana';
$uri = 'sqlite:' . __DIR__ . DIRECTORY_SEPARATOR . 'verbs.db';
$connection = new PDO($uri);
$connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$connection->setAttribute(PDO::ATTR_CASE, PDO::CASE_LOWER);
$statement = $connection->prepare($sql);
$statement->execute(array(':kanji' => $verb, ':kana' => $verb));
$results = $statement->fetchAll(PDO::FETCH_ASSOC);
return $results;
}
