public static function selectCountryNameEnBySn($countrySn)
{
self::initDB();
$sql = "SELECT countryNameEn FROM trans_countries_standard where countrySn='{$countrySn}'";
$query = self::$dbConn->query($sql);
if ($query) {
$ret = self::$dbConn->fetch_array($query);
return $ret;
} else {
self::$errCode = "003";
self::$errMsg = "die";
return false;
}
}
public function act_getCountryNameEnBySn($countrySn)
{
global $memc_obj;
$cacheName = md5("trans_countries_sn" . $countrySn);
$countryinfo = $memc_obj->get_extral($cacheName);
if ($countryinfo) {
return $countryinfo;
} else {
$lists = openapiModel::selectCountryNameEnBySn($countrySn);
$isok = $memc_obj->set_extral($cacheName, serialize($lists['countrySn']));
if (!$isok) {
self::$errCode = 305;
self::$errMsg = 'memcache缓存国家简称和英文对照出错!';
return false;
}
return $lists['countrySn'];
}
}
