Country Select Menu

**lshore** · 07/10/2009, 20:21

I wondered if anyone had done any work creating a specific Country Select Menu for the form entry. (A lot of typing is required to do this manually obviously.) I used the html option to create a field but when using this method, the data is not returned in the notification e-mail. I thought it might be possible to use the select menu (DB) option to pull out the country names but I'm not sure how to properly insert data to the database. Any help welcomed. Thanks in advance

**spirelli** · 07/13/2009, 12:56

As far as I know there is nothing included in TL or any extension. There was talk about it at the old forum a while ago:
http://www.typolight.org/forum/message/38157.html

**ramjet** · 07/14/2009, 00:38

Good old Andreas wrote an extension for it....
http://www.typolight.org/extension-l...000009.en.html

**lshore** · 07/14/2009, 18:47

As you say Good old Andreas - I'll check it out straightaway.

Checked out fine: Many thanks

**ramjet** · 09/22/2009, 13:12

Andreas, I'm hoping you might update your countryselect extension (I've made it easy for you!)
This will add the ability to use it in the backend using

'inputType' => 'countryselect',

Add a CountrySelectMenu.php file

Code:

<?php if (!defined('TL_ROOT')) die('You can not access this file directly!');

/**
 * TYPOlight webCMS
 * Copyright (C) 2005 Leo Feyer
 *
 * This program is free software: you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public
 * License as published by the Free Software Foundation, either
 * version 2.1 of the License, or (at your option) any later version.
 * 
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
 * Lesser General Public License for more details.
 * 
 * You should have received a copy of the GNU Lesser General Public
 * License along with this program. If not, please visit the Free
 * Software Foundation website at http://www.gnu.org/licenses/.
 *
 * PHP version 5
 * @copyright  Andreas Schempp 2009
 * @author     Andreas Schempp <andreas@schempp.ch
 * @license    LGPL
 */


class CountrySelectMenu extends SelectMenu
{

	public function __set($strKey, $varValue)
	{
		switch ($strKey)
		{			
			case 'options':
				break;
				
			default:
				parent::__set($strKey, $varValue);
				break;
		}
	}
	
	
	public function generate()
	{
		$arrOptions = array(array('label'=>'-', 'value'=>''));
		$arrCountries = $this->getCountries();
		
		foreach( $arrCountries as $short => $name )
		{
			$arrOptions[] = array('label'=>$name, 'value'=>$short);
		}
		
		$this->arrOptions = $arrOptions;
		
		return parent::generate();
	}

}

And in the config.php add

Code:

/**
 * Backend form fields
 */
$GLOBALS['BE_FFL']['countryselect'] = 'CountrySelectMenu';

I'd rather you update yours if its not a hassle, rather than have two extensions in there.
Cheers, murray

**ramjet** · 09/22/2009, 13:20

While I'm at it, I get 'nz' (or any two letter code) returned from a table to $country in a php file.
Can anyone help me with code to get $country to be 'New Zealand' ?
I guess I use $this->getCountries() somehow, and match the two letter code, and draw out the long name.... but I'm a bit stuck.
Cheers.

**ramjet** · 09/23/2009, 01:36

Got it...

Code:

//Do database call
$objJobs = $this->Database->execute("SELECT * FROM blah blah blah");

//get the countries array from Typolight ONCE outside of while loop
                               $arrCountries = $this->getCountries();

//loop thru Database records returned
		while ($objJobs->next())
		{
		$job_id = $objJobs->id;
		$job_category = $objJobs->job_category;
		$job_country = $objJobs->job_country;

//TURN $job_country from 2 letter code to full name for display		
                                $job_country = $arrCountries[$job_country];

.....

PS: Tom, Maybe this thread should be moved to "General" Extensions...its in EFG for some reason (sorry)