2. PHPRunner General questions
  3. [SOLVED]  Change language in snippet
This topic is locked
[SOLVED]

 Change language in snippet

 		9/5/2013 3:52:31 AM
PHPRunner General questions
S
 sickacid author

Hi, i've this snippet to do a dropdown, but the value I get of month in DATE_FORMAT(Dataconsegna,'%d.%M') function is in English, I need to change it in Italian. how can i do?
global $conn;
$str = "";

$str.= "<select name=\"JobDropDown\" id=\"JobDropDown\"><option value=\"\">Seleziona un giro</option>";
//select values from database

$strSQL = "select IdConsegna, concat(IdConsegna,' - ',DATE_FORMAT(Dataconsegna,'%d.%M'),' - ', Ciclo,' - ',Giro) as Giro from vista_tabellaconsegne where Dataconsegna > (curdate() - interval 10 day)";

$rs = db_query($strSQL,$conn);

while ($data = db_fetch_array($rs))

$str.="<option value=\"".$data["IdConsegna"]."\">".$data["Giro"]."</option>";

$str.="</select>";

echo $str;
C
 		cgphp 9/5/2013

You have to translate them when you fetch the records. This is not possible in MySQL.
S
 		sickacid author 9/5/2013

I've done:
$str.="<option value=\"".$data["IdConsegna"]."\">".$data["Giro"]."</option>";

$str.="</select>";

$str = str_replace("September", "SETTEMBRE", $str);

$str = str_replace("August", "AGOSTO", $str);

$str = str_replace("October", "OTTOBRE", $str);

...

echo $str;