Projekt

Obecné

Profil

Stáhnout (2.52 KB) Statistiky
| Větev: | Tag: | Revize:
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>&nbsp; $number </td>".
56
          "<td>&nbsp; $editionabbreviation </td>".
57
          "<td>&nbsp; $editionnumber1 </td>".
58
          "<td>&nbsp; $editionnumber2 </td>".
59
          "<td>&nbsp; $dateyear </td>".
60
          "<td>&nbsp; $datemonth </td>".
61
          "<td>&nbsp; $dateday </td>".
62
          "<td>&nbsp; $ancientplace </td>".
63
          "<td>&nbsp; $documenttype </td>".
64
          "<td>&nbsp; $transliteration </td>".
65
          "<td>&nbsp; $ancientruler </td>".
66
          "<td>&nbsp; $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>
(8-8/31)