0
|
1 |
<?php
|
|
2 |
$mysql_server = "localhost";
|
|
3 |
$mysql_user = "lingvigilouser";
|
|
4 |
$mysql_password = "carrinclo";
|
|
5 |
$mysql_db = "lingvigilo";
|
|
6 |
$frazotablo = "frazoj_ru_ca";
|
|
7 |
|
|
8 |
function konekti()
|
|
9 |
{
|
|
10 |
global $mysql_server, $mysql_user, $mysql_password, $mysql_db;
|
|
11 |
$connexio = mysql_connect($mysql_server, $mysql_user, $mysql_password);
|
|
12 |
mysql_select_db($mysql_db, $connexio);
|
|
13 |
return $connexio;
|
|
14 |
}
|
|
15 |
|
|
16 |
|
|
17 |
function strtosql($cadena)
|
|
18 |
{
|
|
19 |
return ereg_replace("\'", "\'", $cadena);
|
|
20 |
}
|
|
21 |
|
|
22 |
|
|
23 |
function preni_frazojn($konekto,$fraztipo=0)
|
|
24 |
{
|
|
25 |
global $frazotablo;
|
|
26 |
$resultat = mysql_query(
|
|
27 |
"SELECT id,vorto,frazo,korekta,klarigo,korektisto FROM " .
|
|
28 |
$frazotablo . " WHERE korekta=" . $fraztipo . ";",
|
|
29 |
$konekto);
|
|
30 |
|
|
31 |
echo mysql_error();
|
|
32 |
|
|
33 |
while ($fila = mysql_fetch_row($resultat))
|
|
34 |
{
|
|
35 |
$frazoj[$fila[0]] = array(
|
|
36 |
"vorto" => $fila[1],
|
|
37 |
"frazo" => $fila[2],
|
|
38 |
"korekta" => $fila[3],
|
|
39 |
"klarigo" => $fila[4],
|
|
40 |
"korektisto" => $fila[5]);
|
|
41 |
}
|
|
42 |
|
|
43 |
if (!isset($frazoj))
|
|
44 |
$frazoj=0;
|
|
45 |
|
|
46 |
return $frazoj;
|
|
47 |
}
|
|
48 |
|
|
49 |
function teksto_korekto($korekteco)
|
|
50 |
{
|
|
51 |
switch($korekteco)
|
|
52 |
{
|
|
53 |
case 0: return "Ne korektita"; break;
|
|
54 |
case 1: return "Ĝusta"; break;
|
|
55 |
case 2: return "Malĝusta"; break;
|
|
56 |
case 3: return "Nekutima"; break;
|
|
57 |
}
|
|
58 |
}
|
|
59 |
?>
|