Countries

A set of countries and their relationships. More...

Classes
class	Countries
	Facade class for countries. More...
class	DAOContinents
	Model class for continetns. More...
class	DAOCountries
	Model class for countries. More...
class	DAOCountries2countriesgroups
	Model class for assigning countries to groups. More...
class	DAOCountriesgroups
	Model class for country groups. More...
class	DAOCountriestranslations
	Model class for translation of country names. More...
Functions
	countries_load_translations ($languages)
	Load translation for countries.

---

Detailed Description

A set of countries and their relationships.

Usage

This module offers the following models:

• countries: All countries that are listed in ISO 3166: http://www.iso.org/iso/english_country_names_and_code_elements
• continents: All continents. Each country is assigend to one continent
• countriesgroups: Groups of countries, currently implemented are European Union, Dependend Territories and Sovereign States.
• countriestranslations: Translation of country names is done using DB, not files. Currently, only German translations are maintained (based upon http://www.auswaertiges-amt.de/diplo/de/Infoservice/Terminologie/Staatennamen.pdf)

The ID space of countriesgroups is divided into three segments:

• 1-99: Reserved for use by this module
• 100-999: Reserved for use by other contributions.
• 1000-: May be used by applications. Autoincrement pointer is set to 1000, so your application can insert groups without setting a fixed ID

---

Function Documentation

countries_load_translations

(

$

languages

)

Load translation for countries.

This is an example of how to use DB based translations

Author:

Gerd Riesselmann

Definition at line 10 of file countries.translations.php.

                                                 {
        $ret = array(
                'Africa' => array(
                        'de' => 'Afrika'
                ),
                'Antartica' => array(
                        'de' => 'Antarktis'
                ),
                'Asia' => array(
                        'de' => 'Asien'
                ),
                'Europe' => array(
                        'de' => 'Europa'
                ),
                'North America' => array(
                        'de' => 'Nordamerika'
                ),
                'Oceania' => array(
                        'de' => 'Ozeanien'
                ),
                'South America' => array(
                        'de' => 'Südamerika'
                ),
                'European Union' => array(
                        'de' => 'Europäische Union'
                ),
                'NONE' => array(
                        'en' => 'None',
                        'de' => 'Kein'
                ),
                'GEOGRAPHICAL' => array(
                        'en' => 'Geographical',
                        'de' => 'Geografisch'
                ),
                'POLITICAL' => array(
                        'en' => 'Political',
                        'de' => 'Politisch'
                ),
                'CULTURAL' => array(
                        'en' => 'Cutural',
                        'de' => 'Kulturell'
                )
        );
        // Load translations for countries
        Load::models('countries', 'countriestranslations');
        $dao_c = new DAOCountries();
        $dao_t = new DAOCountriestranslations();
        $dao_t->add_where('lang', DBWhere::OP_IN, $languages);
        $dao_c->join($dao_t);
        
        $query = $dao_c->create_select_query();
        $query->set_fields(array('countries.name' => 'source', 'countriestranslations.lang' => 'lang', 'countriestranslations.name' => 'translation'));
        
        $countries = array();
        $result = DB::query($query->get_sql(), $dao_c->get_table_driver());
        while($data = $result->fetch()) {
                $countries[$data['source']][$data['lang']] = $data['translation'];
        }
        
        $ret = array_merge($ret, $countries);
        return $ret;
}