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