Can we speak English here? I can if it is easier for you to understand me (as you can see I am American XD)
We'll do this like this: YOURSITE.com/pagina1.php?lang=it&let=a
(lang options are it,en,fer).
That URL (with this script) will give you ALL words beginning with the Letter "A" in the Italian Language that are in the database.
pagina1.php
Codice PHP:
<?php
/**
* Script da Dennis M.
*
*/
// l'informazione del database
$db = mysql_connect("localhost","USER","PASS");
mysql_select_db("dict");
// se non si definire poi usi la lingua italiana e la lettera "a"
if(!isset($_GET['lang']) OR strtolower($_GET['lang']) != "en" AND strtolower($_GET['lang']) != "fer"){
$_GET['lang'] = "it";
}
if(!isset($_GET['let'])){
$_GET['let'] = "a";
}
// per processare i variabili
if($_GET['lang'] == "it"){
$query = mysql_query("SELECT * FROM words WHERE ITA LIKE '".mysql_escape_string($_GET['let'])."%' ORDER BY ITA ASC");
print "Tutte le parole si iniziando con \"".strtoupper($_GET['let'])."\":
";
$messaggio = "<a href=\"pagina2.php?lang=".$_GET['lang']."&parola=".stripslashes($row['ITA'])."\">".stripslashes($row['ITA'])."</a>
";
} else if($_GET['lang'] == "en"){
$query = mysql_query("SELECT * FROM words WHERE ENG LIKE '".mysql_escape_string($_GET['let'])."%' ORDER BY ENG ASC");
print "All words beginning with \"".strtoupper($_GET['let'])."\":
";
$messaggio = "<a href=\"pagina2.php?lang=".$_GET['lang']."&parola=".stripslashes($row['ENG'])."\">".stripslashes($row['ENG'])."</a>
";
} else {
$query = mysql_query("SELECT * FROM words WHERE FER LIKE '".mysql_escape_string($_GET['let'])."%' ORDER BY FER ASC");
print "Tutte le parole si inizando con \"".strtoupper($_GET['let'])."\": (nel ferentino)
";
$messaggio = "<a href=\"pagina2.php?lang=".$_GET['lang']."&parola=".stripslashes($row['ENG'])."\">".stripslashes($row['FER'])."</a>
";
}
// Adesso monstriamo a tutto
while($row = mysql_fetch_array($query)){
if($_GET['lang'] == "it"){
print "<a href=\"pagina2.php?lang=".$_GET['lang']."&parola=".stripslashes($row['ITA'])."\">".stripslashes($row['ITA'])."</a>
";
} else if($_GET['lang'] == "en"){
print "<a href=\"pagina2.php?lang=".$_GET['lang']."&parola=".stripslashes($row['ENG'])."\">".stripslashes($row['ENG'])."</a>
";
} else {
print "<a href=\"pagina2.php?lang=".$_GET['lang']."&parola=".stripslashes($row['ENG'])."\">".stripslashes($row['FER'])."</a>
";
}
}
// finito :)
mysql_close($db);
?>
That processes all the informazione. Now, to see the translations, we're going to use a second page:
pagina2.php
Codice PHP:
<?php
/**
* Script da Dennis M.
*
*/
// l'informazione del database
$db = mysql_connect("localhost","USER","PASS");
mysql_select_db("dict");
// ancora deviamo si processare
if(!isset($_GET['lang']) OR $_GET['lang'] != "en" AND $_GET['lang'] != "fer"){
$_GET['lang'] = "it";
}
// per processare i variabili
if($_GET['lang'] == "it"){
$query = mysql_query("SELECT * FROM words WHERE ITA='".mysql_escape_string($_GET['parola'])."'");
$noparola = "La parola non esista.";
} else if($_GET['lang'] == "en"){
$query = mysql_query("SELECT * FROM words WHERE ENG='".mysql_escape_string($_GET['parola'])."'");
$noparola = "The word does no exist.";
} else {
$query = mysql_query("SELECT * FROM words WHERE FER='".mysql_escape_string($_GET['parola'])."'");
$noparola = "La parola non esista. (nel ferentino)";
}
// i errori
if(!isset($_GET['parola'])){
print $noparola;
exit;
}
if(mysql_num_rows($query) == 0){
print $noparola;
exit;
}
// possiamo si guardare la pagina adesso :)
while($row = mysql_fetch_array($query)){
print "\"".$_GET['parola']."\" [i](".strtoupper($_GET['lang']).")[/i]<hr>";
if($_GET['lang'] != "it"){
print "[b]Italiano:[/b] ".stripslashes($row['ITA'])."
";
}
if($_GET['lang'] != "en"){
print "[b]English:[/b] ".stripslashes($row['ENG'])."
";
}
if($_GET['lang'] != "fer"){
print "[b]Ferentino:[/b] ".stripslashes($row['FER'])."
";
}
}
// Finito :)
mysql_close($db);
?>
cioè che hai un bisogno?
Ciao,
Dennis
Rispondi quotando
