|
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 ?> |