1 |
6daefa8c
|
Petr Lukašík
|
<HTML>
|
2 |
|
|
<HEAD>
|
3 |
|
|
<META content=text/html;charset=utf-8 http-equiv=Content-Type>
|
4 |
|
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
|
5 |
|
|
<TITLE>Tabulky zpracovane v ramci projektu OB Graphemic Analyses</TITLE>
|
6 |
|
|
</HEAD>
|
7 |
|
|
<BODY>
|
8 |
|
|
|
9 |
|
|
<h2><center><strong><u> Prehled zpracovanych tabulek</u></strong></center></h2>
|
10 |
|
|
<br>
|
11 |
|
|
<?
|
12 |
|
|
@$spojeni = Pg_Connect("user=vviewer dbname=klinopis");
|
13 |
|
|
if (! $spojeni)
|
14 |
|
|
{
|
15 |
|
|
echo ("<br>Nepodarilo se pripojit k datab?zi.<BR>\n");
|
16 |
|
|
exit;
|
17 |
|
|
}
|
18 |
|
|
?>
|
19 |
|
|
|
20 |
|
|
<table border=1>
|
21 |
|
|
<tr>
|
22 |
|
|
<td><center><strong> edition
|
23 |
|
|
</font></strong></center></td>
|
24 |
|
|
<td><center><strong> year
|
25 |
|
|
</font></strong></center></td>
|
26 |
|
|
<td><center><strong> month
|
27 |
|
|
</font></strong></center></td>
|
28 |
|
|
<td><center><strong> day
|
29 |
|
|
</font></strong></center></td>
|
30 |
|
|
<td><center><strong> location
|
31 |
|
|
</font></strong></center></td>
|
32 |
|
|
<td><center><strong> text type
|
33 |
|
|
</font></strong></center></td>
|
34 |
|
|
<td><center><strong> notes
|
35 |
|
|
</font></strong></center></td>
|
36 |
|
|
<td><center><strong> datum
|
37 |
|
|
</font></strong></center></td>
|
38 |
|
|
<td><center><strong> is entry OK?
|
39 |
|
|
</font></strong></center></td>
|
40 |
|
|
<td><center><strong> delete
|
41 |
|
|
</font></strong></center></td>
|
42 |
|
|
<td><center><strong> edit
|
43 |
|
|
</font></strong></center></td>
|
44 |
|
|
|
45 |
|
|
</tr>
|
46 |
|
|
|
47 |
|
|
<?
|
48 |
|
|
$polozky="edition, year, month, day, location, textype, notes, datum, readycuneig";
|
49 |
|
|
$vysledek = Pg_Exec ($spojeni, "SELECT $polozky FROM cuneig ORDER BY datum");
|
50 |
|
|
$pocet = Pg_NumRows ($vysledek);
|
51 |
|
|
|
52 |
|
|
for ($i=0; $i < $pocet; $i++)
|
53 |
|
|
{
|
54 |
|
|
list ($edition, $year, $month, $day, $location, $textype, $notes, $datum, $readycuneig) = Pg_Fetch_Array ($vysledek, $i);
|
55 |
|
|
echo ("<tr><center><td> $edition </td>".
|
56 |
|
|
"<td> $year </td>".
|
57 |
|
|
"<td> $month </td>".
|
58 |
|
|
"<td> $day </td>".
|
59 |
|
|
"<td> $location </td>".
|
60 |
|
|
"<td> $textype </td>".
|
61 |
|
|
"<td> $notes </td>".
|
62 |
|
|
"<td> $datum </td>".
|
63 |
|
|
"<td> $readycuneig </td>".
|
64 |
|
|
"<td> <a href=\"./tools/novadata/inputcuneigd.php?koho=$edition\">delete</a> </td>".
|
65 |
|
|
"<td> <a href=\"../tools/novadata/inputcuneii1.php?co=$edition\">edit</a> ".
|
66 |
|
|
"</td></tr>\n");
|
67 |
|
|
}
|
68 |
|
|
Pg_FreeResult ($vysledek);
|
69 |
|
|
Pg_Close ($spojeni);
|
70 |
|
|
?>
|
71 |
|
|
|
72 |
|
|
</table>
|
73 |
|
|
<br>
|
74 |
|
|
</font>
|
75 |
|
|
</BODY>
|
76 |
|
|
</HTML>
|
77 |
|
|
|
78 |
|
|
|
79 |
|
|
|
80 |
|
|
|