Recently, a project required us to build an application that could handle the sale of products in different currencies (an international e-commerce store). To accomplish this, we built a MySQL table to store currencies and their conversion rates against the USD. Then we built a cron-tab job (a task that is run at a set time interval in perpetuity) to update the database table conversion rates every 24 hours.
The first step to building this system was to put together a PHP array of ISO currency code’s to build the table rows from.
After looking around for a big, I found that there are a lot of currency code lists. Unfortunately for me, I couldn’t find any that were reasonably formatted and definitely none that were already PHP snippets.
$currencies = array(
array('Dirham', 'aed'),
array('Afghani', 'afa'),
array('Lek', 'all'),
array('Dram', 'amd'),
array('Guilder', 'ang'),
array('Netherlands Antilles Guilder', 'ang'),
array('New Kwanza', 'aon'),
array('Peso', 'arp'),
array('Schilling', 'ats'),
array('Australian Dollar', 'aud'),
array('Dollar', 'aud'),
array('Florin', 'awf'),
array('Manat', 'azm'),
array('Convertible Mark', 'bak'),
array('Dollar', 'bbd'),
array('Taka', 'bdt'),
array('Franc', 'bef'),
array('Lev', 'bgl'),
array('Dinar', 'bhd'),
array('Burundi Franc', 'bif'),
array('Dollar', 'bmd'),
array('Dollar', 'bnd'),
array('Boliviano', 'bob'),
array('Brazilian Real', 'brl'),
array('Dollar', 'bsd'),
array('Rupee', 'btr'),
array('Pula', 'bwp'),
array('Ruble', 'byr'),
array('Dollar', 'bzd'),
array('Dollar', 'cad'),
array('Congolese Franc', 'cdf'),
array('Franc', 'chf'),
array('Swiss Franc', 'chf'),
array('Peso', 'clp'),
array('Yuan Renminbi', 'cny'),
array('Peso', 'cop'),
array('Colon', 'crc'),
array('Peso', 'cup'),
array('Escudo', 'cve'),
array('Pound', 'cyp'),
array('Koruna', 'czk'),
array('Deutsche Mark', 'dem'),
array('Franc', 'djf'),
array('Krone', 'dkk'),
array('Peso', 'dop'),
array('Algerian Dinar', 'dzd'),
array('Sucre', 'ecs'),
array('Kroon', 'eek'),
array('Pound', 'egp'),
array('Nakfa', 'ern'),
array('Peseta', 'esp'),
array('Birr', 'etb'),
array('Euro', 'eur'),
array('Markka', 'fim'),
array('Dollar', 'fjd'),
array('Pound', 'fkp'),
array('Franc', 'frf'),
array('British Pounds', 'gbp'),
array('Lari', 'gel'),
array('Cedi', 'ghc'),
array('Pound', 'gip'),
array('Dalasi', 'gmd'),
array('Franc', 'gnf'),
array('Drachma', 'grd'),
array('Quetzal', 'gtq'),
array('Dollar', 'gyd'),
array('Dollar', 'hkd'),
array('Lempira', 'hnl'),
array('Kuna', 'hrk'),
array('Gourde', 'htg'),
array('Forint', 'huf'),
array('Rupiah', 'idr'),
array('Punt', 'iep'),
array('Punt', 'iep'),
array('Shekel', 'ils'),
array('Rupee', 'inr'),
array('Dinar', 'iqd'),
array('Rial', 'irr'),
array('Krona', 'isk'),
array('Lira', 'itl'),
array('Dollar', 'jmd'),
array('Dinar', 'jod'),
array('Yen', 'jpy'),
array('Shilling', 'kes'),
array('Som', 'kgs'),
array('Riel', 'khr'),
array('Franc', 'kmf'),
array('Won', 'kpw'),
array('Won', 'krw'),
array('Dinar', 'kwd'),
array('Dollar', 'kyd'),
array('Tenge', 'kzt'),
array('Kip', 'lak'),
array('Pound', 'lbp'),
array('Rupee', 'lkr'),
array('Dollar', 'lrd'),
array('Loti', 'lsl'),
array('Lita', 'ltl'),
array('Franc', 'luf'),
array('Lat', 'lvl'),
array('Dinar', 'lyd'),
array('Dirham', 'mad'),
array('Moroccan Dirham', 'mad'),
array('Leu', 'mdl'),
array('Malagasy Franc', 'mgf'),
array('Denar', 'mkd'),
array('Kyat', 'mmk'),
array('Tugrik', 'mnt'),
array('Pataca', 'mop'),
array('Ouguiya', 'mro'),
array('Lira', 'mtl'),
array('Rupee', 'mur'),
array('Rufiyaa', 'mvr'),
array('Kwacha', 'mwk'),
array('Peso', 'mxp'),
array('Ringgit', 'myr'),
array('Metical', 'mzm'),
array('Dollar', 'nad'),
array('Naira', 'ngn'),
array('Cordoba Oro', 'nio'),
array('Guilder', 'nlg'),
array('Krone', 'nok'),
array('Nepalese Rupee', 'npr'),
array('Dollar', 'nzd'),
array('Sul Rial', 'omr'),
array('Balboa', 'pab'),
array('Nuevo Sol', 'pen'),
array('Kina', 'pgk'),
array('Peso', 'php'),
array('Rupee', 'pkr'),
array('Zloty', 'plz'),
array('Escudo', 'pte'),
array('Guarani', 'pyg'),
array('Rial', 'qar'),
array('Leu', 'rol'),
array('Ruble', 'rur'),
array('Rwanda Franc', 'rwf'),
array('Riyal', 'sar'),
array('Dollar', 'sbd'),
array('Luigino', 'sbl'),
array('Rupee', 'scr'),
array('Dinar', 'sdd'),
array('Krona', 'sek'),
array('Dollar', 'sgd'),
array('Pound', 'shp'),
array('Tolar', 'sit'),
array('Koruna', 'skk'),
array('Leone', 'sll'),
array('Shilling', 'sos'),
array('Guilder', 'srg'),
array('Dobra', 'std'),
array('Pound', 'syp'),
array('Lilangeni', 'szl'),
array('Baht', 'thb'),
array('Somoni', 'tjs'),
array('Manat', 'tmm'),
array('Dinar', 'tnd'),
array('Pa\'anga', 'top'),
array('Lira', 'trl'),
array('Dollar', 'ttd'),
array('Dollar', 'twd'),
array('Shilling', 'tzs'),
array('Hryvnia', 'uah'),
array('Shilling', 'ugx'),
array('US Dollar', 'usd'),
array('Peso', 'uyu'),
array('Som', 'uzs'),
array('Bolivar', 'veb'),
array('Dong', 'vnd'),
array('Vatu', 'vuv'),
array('Tala', 'wst'),
array('CFA Franc', 'xaf'),
array('Ounces', 'xag'),
array('Ounces', 'xau'),
array('Dollar', 'xcd'),
array('Special Drawing Right', 'xdr'),
array('Ounces', 'xpd'),
array('Ounces', 'xpt'),
array('Rial', 'yer'),
array('New Dinar', 'yun'),
array('Rand', 'zar'),
array('South African Rand', 'zar'),
array('South African Rand', 'zar'),
array('Kwacha', 'zmk'),
array('Zimbabwe Dollar', 'zwd')
);