<?php
$LocaleMechanism = 'SQL';
$nativeLocale = 'en_US';
include 'cnx_i18n.inc.php';
include_once 'rfc1766.class.php';
$oRfc1766 = new rfc1766_class;
$_SESSION['oRfc1766'] = $oRfc1766;
include_once 'i18n.class.php';
$oI18N = new I18N_class;
include_once 'langTable.class.php';
// The following parameters must be provided to the class:
// host name, user, password, database name and table name.
// Modify the file cnx_i18n.inc.php.
$oLang = new LangTable_class($host,$user,$password,$db,$table);
$_SESSION['oLang'] = $oLang;
$oLang->OpenDb();
if(!$oLang->TableExists())
$oLang->CreateTable();
if(isset($_POST['locale'])){
setcookie('ex_SQL-locale',$_POST['locale'],time()+2592000); // This expiration time is 30 days.
$locale = $_POST['locale'];
}elseif (isset($_COOKIE['ex_SQL-locale']))
$locale = $_COOKIE['ex_SQL-locale'];
else
$locale = $nativeLocale;
eval ($oI18N->XL('ExampleSQL', '$example', $locale));
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?=$example?></title>
</head>
<body>
<?
eval ($oI18N->XL('SelectLang', '$selectLang', $locale));
eval ($oI18N->XL('Submit', '$submitCap', $locale));
?>
<h2><?=$example?></h2>
<form name="example" method="post" enctype="multipart/form-data" action="example_SQL.php">
<? $language = $oI18N->GetLocales(); ?>
<?=$selectLang?>
<select name="locale" tabindex="1">
<?
foreach($language as $code => $name){
if($code == $locale)
print "<option selected=\"true\" value=\"$code\">$name</option>";
else
print "<option value=\"$code\">$name</option>";
}
?>
</select><br />
<input name="submit" type="submit" value="<?=$submitCap?>" tabindex="2" />
</form>
</body>
</html>
|