|
1
|
<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>List of OB signs in the scope of OB Graphemic Analyses Project</TITLE>
|
|
6
|
</HEAD>
|
|
7
|
<BODY>
|
|
8
|
|
|
9
|
<h2><center><strong><u> List of OB cuneiform signs with readings graf02 <u></strong></center></h2>
|
|
10
|
<br>
|
|
11
|
<?
|
|
12
|
@$spojeni = Pg_Connect("user=dbowner dbname=klinopis");
|
|
13
|
if (! $spojeni)
|
|
14
|
{
|
|
15
|
echo ("<br>Nepodarilo se pripojit k datab?zi.<BR>\n");
|
|
16
|
exit;
|
|
17
|
}
|
|
18
|
?>
|
|
19
|
|
|
20
|
<FONT FACE='Arial Unicode MS' SIZE=3><BR>
|
|
21
|
<table border=1>
|
|
22
|
<tr>
|
|
23
|
<td><center><strong> number
|
|
24
|
</font></strong></center></td>
|
|
25
|
<td><center><strong> abbreviation of an edition
|
|
26
|
</font></strong></center></td>
|
|
27
|
<td><center><strong> number in an edition
|
|
28
|
</font></strong></center></td>
|
|
29
|
<td><center><strong> date - year
|
|
30
|
</font></strong></center></td>
|
|
31
|
<td><center><strong> date - month
|
|
32
|
</font></strong></center></td>
|
|
33
|
<td><center><strong> date - day
|
|
34
|
</font></strong></center></td>
|
|
35
|
<td><center><strong> ancient place
|
|
36
|
</font></strong></center></td>
|
|
37
|
<td><center><strong> document type
|
|
38
|
</font></strong></center></td>
|
|
39
|
<td><center><strong> transliteration
|
|
40
|
</font></strong></center></td>
|
|
41
|
<td><center><strong> ancient ruler
|
|
42
|
</font></strong></center></td>
|
|
43
|
<td><center><strong> ancient year
|
|
44
|
</font></strong></center></td>
|
|
45
|
</tr>
|
|
46
|
</FONT>
|
|
47
|
<?
|
|
48
|
$polozky="number, editionabbreviation, editionnumber, dateyear, datemonth, dateday, ancientplace, documenttype, transliteration, ancientruler, ancientyear, OID";
|
|
49
|
$vysledek = Pg_Exec ($spojeni, "SELECT $polozky FROM graf02 ORDER BY OID;");
|
|
50
|
$pocet = Pg_NumRows ($vysledek);
|
|
51
|
|
|
52
|
for ($i=0; $i < $pocet; $i++)
|
|
53
|
{
|
|
54
|
list ($number, $editionabbreviation, $editionnumber, $dateyear, $datemonth, $dateday, $ancientplace, $documenttype, $transliteration, $ancientruler, $ancientyear, $OID) = Pg_Fetch_Array ($vysledek, $i);
|
|
55
|
echo ("<tr><center><td> $number </td>".
|
|
56
|
"<td> $editionabbreviation </td>".
|
|
57
|
"<td> $editionnumber1 </td>".
|
|
58
|
"<td> $editionnumber2 </td>".
|
|
59
|
"<td> $dateyear </td>".
|
|
60
|
"<td> $datemonth </td>".
|
|
61
|
"<td> $dateday </td>".
|
|
62
|
"<td> $ancientplace </td>".
|
|
63
|
"<td> $documenttype </td>".
|
|
64
|
"<td> $transliteration </td>".
|
|
65
|
"<td> $ancientruler </td>".
|
|
66
|
"<td> $ancientyear </td>".
|
|
67
|
"</tr>\n");
|
|
68
|
}
|
|
69
|
Pg_FreeResult ($vysledek);
|
|
70
|
Pg_Close ($spojeni);
|
|
71
|
?>
|
|
72
|
|
|
73
|
</table>
|
|
74
|
<br>
|
|
75
|
</FONT>
|
|
76
|
</BODY>
|
|
77
|
</HTML>
|