Online PHP editor | output for JsDFE

<?php $username = 'test'; $translateWord = 'How are you'; $words = explode(' ', $translateWord); $list = implode(',', array_map(function ($word) { return "'" . strtolower(trim($word)) . "'"; }, $words)); $query = "SELECT LOWER(English) AS English, LOWER(Translation) AS Translation FROM $username WHERE LOWER(English) IN ($list)"; // query table // $result = $connection->query($query); // $rows = $result->fetch_all(); // simulated result $rows = array(array('English' => 'how', 'Translation' => 'como'), array('English' => 'are', 'Translation' => 'son'), array('English' => 'you', 'Translation' => 'tu')); $translation = array(); foreach ($words as $word) { if (($key = array_search(strtolower($word), array_column($rows, 'English'))) !== false) { // match case of result if (strtoupper($word) == $word) { $translation[] = strtoupper($rows[$key]['Translation']); } elseif (ucfirst($word) == $word) { $translation[] = ucfirst($rows[$key]['Translation']); } else { $translation[] = $rows[$key]['Translation']; } } else { // no match, leave alone $translation[] = $word; } } echo $translateWord . " => " . implode(' ', $translation);