<?php
/* Description :
[[importerisocountrycode]] Script php d'importation de fichier pays iso
Auteur : Fred Radeff
Url : http://www.akademia.ch 
*/
/*ici on l'utilise pour convertir des libelles dans limesurvey*/
#ecrit dans database
include("connect.php"); //fichier de connection a MySQL voir infra
$db=connect_db();
$db_name=db_name();
mysql_select_db($db_name,$db);
 
//table a convertir
$table2convert="lime_labels";
//champs iso dans table_a_convertir
$table_a_convertirISO="code";
//champs libelle dans table_a_convertir
$table_a_convertirLib="title";
 
 
//requete initiale tous les pays en anglais
$laTable="unige_countryisoen";
 
$sql="
SELECT *
FROM `$laTable` ORDER BY 'iso'";
#echo $sql; exit; //tests
$result = mysql_query($sql);
if ($result) { //ok
echo "
OK, with sql:
<pre>
$sql
</pre>
";
 
echo "<pre>";
 
		$i=0;
		while ($i < mysql_num_rows($result)) { //on parcourt les resultats
			$iso_code=mysql_result($result,$i,'iso');
			$englishlib=mysql_result($result,$i,'lib');
		//calcul requete conversion
		$sqlConvert="UPDATE " .$table2convert ." SET " .$table_a_convertirLib ." = \"" .$englishlib ."\" WHERE " .$table2convert ."." .$table_a_convertirISO ." = '" .$iso_code."';";
                //attention aux astuces genre Côte d'Ivoire!! (vieux problème de l'apostrophe!)
		//echo $sqlConvert ."\n"; //tests
			$sqlConvertDo=mysql_query($sqlConvert);
			if(!$sqlConvertDo) {
			echo "<p>Problem with SQL:" .$sqlConvert;
			echo "<br>MySQL Err No:" .mysql_error() ."</p>";
			}
		$i++;
		}
 
echo "</pre>";
 
 
 
 
} else { //probleme avec requete initiale
echo "<p>Problem!, MySQL Err No:" .mysql_error();
}
 
?>

connect.php

<?php
$login="limesurvey";                              // user name for you database
$pass="";                                   // pass word to the database if you dont have a password 
						//set up leave it as ""
$database_name="limesurvey";                     //name of the database //PROD
$database_name="limesurveyB";                     //name of the database //TEST

/* Don't change anything below this line                                                        */                                                   



function connect_db()
	{
	global $pass,$login;
	$db=mysql_connect("localhost",$login,$pass);
		
	return $db;
	
	}

function db_name()
	{
	global $database_name;
	$db_name=$database_name;
	
	return $db_name;
	
	}

?>

importerisocountrycode.php.gz Une version plus complete pour limesurvey, attention, obsolète, à corriger avec

isocountrycodes //[[fradeff@akademia.ch|Fred Radeff]] 2009/06/24 08:54//