public static function getCountryByName($name)
{
if (empty($name)) {
return false;
}
$name = JString::strtolower(JString::trim($name));
if (empty(self::$countries)) {
$db = JFactory::getDbo();
$db->setQuery('select country_name, id from #__djc2_countries order by country_name asc');
self::$countries = $db->loadObjectList('country_name');
}
if (isset(self::$countries[$name])) {
return self::$countries[$name]->id;
}
$db->setQuery('select lower(country_name) as country_name, id from #__djc2_countries where lower(country_name) like' . $db->quote('%' . $db->escape($name) . '%') . ' LIMIT 1');
$result = $db->loadObject();
if (!empty($result)) {
self::$countries[$name] = $result;
return self::$countries[$name]->id;
}
return false;
}
