Beispiel #1
0
     $shapeDims .= " mm";
 }
 $shapeDims .= "</span></div>";
 //$shapeDims.= "</div>";
 echo $shapeDims;
 $id_seal = $row['id_seal'];
 // call seal description function to make list of associated seal descriptions
 $query12 = "SELECT * FROM sealdescription_view WHERE id_seal = {$id}";
 $query12result = mysqli_query($link, $query12);
 $count1 = mysqli_num_rows($query12result);
 $duplicate = $id;
 if ($count1 > 0) {
     //echo "<div class='separator_2'>Other Descriptions</div>";
     echo "<div class='separator_2'>Descriptions</div>";
     $duplicate = $id;
     sealdescription($query12result, $address, $duplicate);
 }
 // list of associated seal impressions
 $query10 = "SELECT * FROM shelfmark_view WHERE id_seal = {$id}";
 $query10result = mysqli_query($link, $query10);
 $count2 = mysqli_num_rows($query10result);
 echo '<div class="separator_2">Examples</div>';
 $rowcount = 1;
 $addAsCard = "<input type='checkbox' onchange='cardMe(\$(this), false, false);' />";
 if ($count2 < 5) {
     $addAsCard = "";
     echo '<div class="theCards_body indent2">';
 } else {
     echo '<div class="tableWrap"><table class="metaTable indent2"><thead><th>&#x2714;</th><th>#</th><th>Nature</th><th>Position</th><th>Dated</th><th>Item</th><th>Image</th></thead>' . '<tbody>';
 }
 while ($row = mysqli_fetch_array($query10result)) {
Beispiel #2
0
 echo "<br> Permalink: http://digisig.org/entity/" . $id;
 echo '<table border = 1><tr><td>Shape</td><td>Height</td><td>Width</td></tr>';
 // note that a seal can have two faces but I am going to assume that the double side ones are the same
 $row = pg_fetch_array($query8result);
 $value3 = $row[shape];
 $value4 = $row[face_vertical];
 $value5 = $row[face_horizontal];
 echo '<td>' . $value3 . '</td>';
 echo '<td>' . $value4 . '</td>';
 echo '<td>' . $value5 . '</td></tr>';
 $id_seal = $row[id];
 echo "</table><br>";
 // call seal description function to make list of associated seal descriptions
 $query12 = "SELECT * FROM sealdescription_view WHERE id_seal = {$id}";
 $query12result = pg_query($query12);
 sealdescription($query12result, $address);
 // list of associated seal impressions
 $query10 = "SELECT * FROM shelfmark_view WHERE id_seal = {$id}";
 $query10result = pg_query($query10);
 echo '<table border = 1><tr><td>Examples</td></tr><tr><td></td><td>';
 $rowcount = 1;
 while ($row = pg_fetch_array($query10result)) {
     $value1 = $row[nature];
     $value2 = $row[number];
     $value3 = $row[position_latin];
     $value4 = $row[shape];
     $value5 = $row[shelfmark];
     $value6 = $row[id_item];
     $value7 = $row[representation_filename];
     $value8 = $row[name_first] . " " . $row[name_last];
     $value9 = $row[repository_startdate];