PageRenderTime 84ms CodeModel.GetById 14ms RepoModel.GetById 1ms app.codeStats 0ms

/da_catalog_titleRecord.php

https://github.com/jmjamison/da_catalog
PHP | 577 lines | 256 code | 169 blank | 152 comment | 33 complexity | 28ab4bfceca6ab3fa7fcbca258b66f1c MD5 | raw file
  1. <!DOCTYPE html>
  2. <?php include("../_includes/SSDA_LibraryTopPanel.php") ?>
  3. <title>Social Science Data Archive | UCLA Library</title>
  4. <?php include_once("../_includes/SSDA_LibrarySidePanel.php") ?>
  5. <div class="panel-pane pane-bean-text-block pane-bean-ssda-schedule-appointment">
  6. <div class="pane-content">
  7. <div class="entity entity-bean bean-text-block clearfix">
  8. <div class="content">
  9. <div class="field field--name-field-text-block field--type-text-long field--label-hidden"><div class="field__items"><div class="field__item even"><p>Have questions about your research? <a href="mailto:libbie@g.ucla.edu?subject=Research%20questions">We can help?</a></p>
  10. </div></div></div> </div>
  11. </div>
  12. </div>
  13. </div>
  14. </div>
  15. <div class="l-region l-region--main-column">
  16. <!-- data archive menubar - library in-house version -->
  17. <?php
  18. include("../_includes/SSDA_menubar_libraryInHouse.php");
  19. //
  20. // SSDA_menubar.php has the menu code for da_catalog, da_catalog_fielder(fielder collection) and 'archive reources'
  21. //
  22. ?>
  23. <!-- data archive google analytics tracking script -->
  24. <?php include_once("../_includes/analyticstracking.php") ?>
  25. <div class="l-region l-region--main">
  26. <div class="panel-pane pane-node-body">
  27. <div class="pane-content">
  28. <div class="field field--name-body field--type-text-with-summary field--label-hidden"><div class="field__items"><div class="field__item even">
  29. <!---------------------------------------------------------------------------------------------- -->
  30. <!--ssda page code goes here -->
  31. <!-- Scripts for title record menu bar -->
  32. <script type="text/javascript" src="scripts/jquery-latest.js"></script>
  33. <script type="text/javascript" src="scripts/jquery.tablesorter.js"></script>
  34. <script type="text/javascript" id="js">$(document).ready(function() {
  35. // call the tablesorter plugin
  36. $("table").tablesorter({
  37. // sort on the first column and third column, order asc
  38. sortList: [[0,0],[2,0]]
  39. });
  40. }); </script>
  41. <!-- share-this script -->
  42. <script type="text/javascript">var switchTo5x=true;</script><script type="text/javascript" src="http://w.sharethis.com/button/buttons.js"></script><script type="text/javascript">stLight.options({publisher:'605fb740-c736-4f2d-b087-bd8ffdb0078f'});</script>
  43. <?php
  44. //error_reporting(E_ALL);
  45. //ini_set('display_errors', 1);
  46. $currentHTTP = "http://data-archive.library.ucla.edu/da_catalog/";
  47. //SSDA_menubar.php has the menu code for da_catalog, da_catalog_fielder(fielder collection) and 'archive reources'
  48. include("../_includes/SSDA_librarydatabase.php"); //SSDA_menubar.php has the menu code for da_catalog, da_catalog_fielder(fielder collection) and 'archive reources'
  49. // class for database connections
  50. include "../_classes/class.Database.php";
  51. // for the record: I had been using both title AND the study number, although I'm not displaying the studynumber - to be sure I get the correct study
  52. // Last verion is only searching by studynumber. 151023
  53. $studynumber = htmlspecialchars($_GET['studynumber'], ENT_QUOTES);
  54. //echo $title . " " . $studynumber . "<br>";
  55. //echo $studynumber . "<br>";
  56. $queryBaseRecord = "SELECT title.*, picode.picode, picode.tisubsort, pifull.*, shcode.subjectcode, shfull.*, title.StudyNum, wwwlink_pi.wwwlink AS wwwlink_pi, wwwlink_pi.wwwtext AS wwwtext_pi, wwwlink_subject.wwwlink AS wwwlink_subject, wwwlink_subject.wwwtext AS wwwtext_subject, cite.cite, pifull.picode, shcode.subsort, picode.tisubsort FROM cite RIGHT JOIN ((((((title LEFT JOIN picode ON title.tisort = picode.tisort) LEFT JOIN pifull ON picode.picode = pifull.picode) LEFT JOIN shcode ON title.tisort = shcode.tisort) LEFT JOIN shfull ON shcode.subjectcode = shfull.subjectcode) LEFT JOIN wwwlink AS wwwlink_subject ON shfull.subjectcode = wwwlink_subject.subjectcode) LEFT JOIN wwwlink AS wwwlink_pi ON pifull.picode = wwwlink_pi.picode) ON cite.citenum = title.Cite WHERE title.StudyNum='" . $studynumber . "'";
  57. $queryDatasetRecords = "SELECT wwwlink.wwwlink, wwwlink.wwwtext, wwwlink.studynum, fileinfo.*, data_cite.cite AS datacite, fileinfo.Restricted AS restricted_file, fileinfo.StudyNum FROM cite AS data_cite RIGHT JOIN (wwwlink RIGHT JOIN fileinfo ON wwwlink.dtafile = fileinfo.DTAfile) ON data_cite.citenum = fileinfo.Cite WHERE fileinfo.StudyNum='" . $studynumber . "' AND (FileType = 'CD-Rom' OR FileType = 'SDA Online Analysis' OR FileType = 'Web Access') ORDER BY fileinfo.StudyPart";
  58. //echo $queryDatasetRecords . "<br>";
  59. // check, if NOT set
  60. if (empty($studynumber)) { // remove $title test, this will eventually be phased out as redundent - or !isset($_GET['title']) - jmj120409
  61. echo "<span style='margin-left: 0; text-align: center; background-color: powderblue;'><a href='da_catalog_titles.php'>Return to catalog.</a></span><br>";
  62. die ("Nothing selected.");
  63. }
  64. //echo $title<br>$studynumber<br>";
  65. // class.Database.php is the class to make PDO connections
  66. // initialize new db connection instance
  67. $db = new Database();
  68. // prepare query
  69. $db->prepareQuery($queryBaseRecord);
  70. // bind value studynumber
  71. $db->bind(":studynumber", $studynumber);
  72. // PDO - execute the query
  73. $result = $db->executeQuery();
  74. //$result = $db->resultset(); // execute the query
  75. if (!$result) {
  76. die ("Could not query the database: <br />");
  77. } // else { echo "Successfully queried the database.<br>"; } // for debugging
  78. //echo "<H2>$title&nbsp;&nbsp;($studynumber)</H2><br>";
  79. // complete record info
  80. $titleRecord = array(); // record - the title, sub# and restricted y/n
  81. // list of pi(s)
  82. $piList = array(); // list of pi(s)
  83. $piListFull = array();
  84. $subjectList = array(); // list of subjects
  85. //$fileInfo = array(); // file info -- move to part 2
  86. $usefulLinks = array(); // linklist
  87. //$linkListStudy = array();
  88. $linkListPI = array();
  89. $linkListSubject = array();
  90. $row_index = 0;
  91. while ($row = $db->getRow()) { // - 5 -
  92. // Non-PDO code ---------------------
  93. //while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
  94. $titleRecord[$row_index]["title"] = $row["Title"];
  95. $titleRecord[$row_index]["studyNum"] = $row[ "StudyNum" ];
  96. $titleRecord[$row_index]["restricted"] = $row[ "Restricted" ];
  97. $titleRecord[$row_index]["www"] = $row[ "WWW" ];
  98. $titleRecord[$row_index]["citation"] = $row[ "cite"];
  99. $titleRecord[$row_index]["dataverseDOI"] = $row[ "dataverseDOI"];
  100. //print_r($titleRecord);
  101. //
  102. //
  103. // links connected to the studynum, pi or subject
  104. // used to populate the "useful links" list
  105. if (!empty($row["wwwlink_studynum"])) {
  106. $linkListStudy[$row_index] = "<a href='http://" . $row["wwwlink_studynum"] . "'>" . $row["wwwtext_studynum"] . "</a>";
  107. }
  108. //
  109. // database wierdness note: in the wwwlink table the wwwtext field is often NOT filled in for the PI so pick up the pi directly
  110. // First grab the pi - just incase the wwwtext field is empty
  111. // Then check if the wwwtext field is really empty, if it isn't put in the wwwtext
  112. if (!empty($row["wwwlink_pi"])) {
  113. $linkListPI[$row_index] = "<a href='http://" . $row["wwwlink_pi"] . "'>" . $row["pi"] . "</a>";
  114. }
  115. if (!empty($row["wwwtext_pi"])) {
  116. $linkListPI[$row_index] = "<a href='http://" . $row["wwwlink_pi"] . "'>" . $row["wwwtext_pi"] . "</a>";
  117. }
  118. //
  119. //
  120. if (!empty($row["wwwlink_subject"])) {
  121. $linkListSubject[$row_index] = "<a href='http://" . $row["wwwlink_subject"] . "'>" . $row["wwwtext_subject"] . "</a>";
  122. }
  123. // old version
  124. $piList[$row_index] = $row[ "pi"];
  125. $piListFull[$row_index]["pi_tisubsort"] = $row[ "tisubsort"];
  126. $piListFull[$row_index]["pi"] = $row[ "pi"];
  127. //
  128. $subjectList[$row_index]["subsort"] = $row[ "subsort"];
  129. $subjectList[$row_index]["subject"] = $row[ "subject"];
  130. //
  131. $picode[$row_index] = $row["picode"];
  132. //
  133. $subjectcode[$row_index] = $row["subjectcode"];
  134. $row_index++;
  135. }
  136. // 150814jmj: SORT-REGULAR for array-to-string error
  137. $titleRecord = array_unique($titleRecord, SORT_REGULAR);
  138. sort($titleRecord);
  139. $titleRecordCount = count($titleRecord); // just to check
  140. //echo "record: $titleRecordCount<br>";
  141. //echo "For debugging purposes :";
  142. //($titleRecord);
  143. echo "<br>";
  144. $row_index = 0;
  145. if (!isset($titleRecord[$row_index]["title"])) { // remove $title test, this will eventually be phased out as redundent - or !isset($_GET['title']) - jmj120409
  146. echo "<span style='margin-left: 0; text-align: center; background-color: powderblue;'><a href='http://data-archive.library.ucla.edu/da_catalog'>No citations selected. Return to catalog.</a></span><br>";
  147. die ("No citations selected.");
  148. } else {
  149. $title = $titleRecord[$row_index]["title"]; // there is only going to be one title
  150. }
  151. //echo $title;
  152. $studyNum = $titleRecord[$row_index]["studyNum"]; // also only one study number per study
  153. $restricted = $titleRecord[$row_index]["restricted"]; // ristricted also won't change
  154. $www = $titleRecord[$row_index]["www"];
  155. $citation = $titleRecord[$row_index]["citation"];
  156. $dataverseDOI = $titleRecord[$row_index]["dataverseDOI"];
  157. //$piList = array_unique($piList); // toss out duplicates
  158. //sort($piList);
  159. //print_r($piList);
  160. $piTotal = count($piList);
  161. //echo "Total Principal Investigators: $piTotal<br>";
  162. //sort($piListFull);
  163. $piListFullCount = count($piListFull);
  164. $subjectListCount = count($subjectList);
  165. $piList_temp = array();
  166. for ($row_index = 0; $row_index < $piListFullCount; $row_index++) {
  167. $piList_temp[$row_index] = "(" . $piListFull[$row_index]["pi_tisubsort"] . ") " . $piListFull[$row_index]["pi"];
  168. }
  169. $piList_temp = array_unique($piList_temp);
  170. sort($piList_temp);
  171. //echo "<br>PiListFull_temp sorted: ";
  172. //cho "<br>";
  173. //print_r($piList_temp);
  174. //$subjectList = array_unique($subjectList); // toss out duplicates
  175. //sort($subjectList);
  176. $subjectListCount = count($subjectList);
  177. $subjectList_temp = array();
  178. for ($row_index = 0; $row_index < $subjectListCount; $row_index++) {
  179. $indexterm = $subjectList[$row_index]["subject"];
  180. $indexterm = "<a href='da_catalog_titlesByIndexTerm.php?indexTerm=" . $indexterm . "'>" . $indexterm . "</a>";
  181. $subjectList_temp[$row_index] = "(" . $subjectList[$row_index]["subsort"] . ") " . $indexterm;
  182. }
  183. $subjectList_temp = array_unique($subjectList_temp);
  184. $subjectList_tempCount = count($subjectList_temp);
  185. sort($subjectList_temp);
  186. $subjectList_temp = array_unique($subjectList_temp);
  187. $subjectList_tempCount = count($subjectList_temp);
  188. sort($subjectList_temp);
  189. //echo "<br>PiListFull_temp sorted: ";
  190. //echo "<br>";
  191. //print_r($subjectList_temp);
  192. echo "<H3>" . $title . " (" . $studynumber . ")</H3>";
  193. echo "<h5>Subjects: <h4>";
  194. if ($subjectList_tempCount < 2) { // only 1 pi/principal investigator
  195. $row_index=0;
  196. echo $subjectList_temp[$row_index];
  197. echo "<br>";
  198. } elseif ($subjectList_tempCount > 1) { // there is more than one pi name to print out
  199. for ($row_index = 0; $row_index < $subjectList_tempCount-1; $row_index++) {
  200. echo $subjectList_temp[$row_index] . ", ";
  201. }
  202. $lastSubject = $subjectList_temp[$subjectList_tempCount-1]; // last subject doesn't have a comma after it
  203. echo "$lastSubject";
  204. }
  205. echo "</h4></h5>";
  206. echo "<h5>Principal Investigator(s):&nbsp;<h4>";
  207. $piList_tempCount = count($piList_temp);
  208. if ($piList_tempCount < 2) { // only 1 pi/principal investigator
  209. $row_index=0;
  210. echo "$piList_temp[$row_index]</h4>";
  211. } elseif ($piList_tempCount > 1) { // there is more than one pi name to print out
  212. for ($row_index = 0; $row_index < $piList_tempCount-1; $row_index++) {
  213. echo $piList_temp[$row_index] . ", ";
  214. }
  215. $lastPi = $piList_temp[$piList_tempCount-1]; // last pi doesn't have a comma after it
  216. echo "$lastPi";
  217. }
  218. echo "</h4></h5>";
  219. if ($citation <> "") {
  220. echo "<h5>Study Citation:&nbsp;</h5>" . $citation . "<br>";
  221. }
  222. if ($dataverseDOI <> "") {
  223. echo "<h5>Download Here:&nbsp;<a href='" . $dataverseDOI . "'>" . $dataverseDOI . "</a></h5><br>";
  224. }
  225. //--------------------------------------------------------------------------------------------
  226. // Section for sharing links
  227. // 07/23/2011
  228. //
  229. //--------------------------------------------------------------------------------------------
  230. echo "<br>";
  231. echo "<div align='left' class='socialLinks' >";
  232. echo "<span class='st_twitter' ></span><span class='st_facebook' ></span><span class='st_email' ></span><span class='st_sharethis' ></span>";
  233. echo "</div>";
  234. //--------------------------------------------------------------------------------------------
  235. // now do the 2nd pass for datasets\
  236. //
  237. //
  238. //--------------------------------------------------------------------------------------------
  239. $fileInfo = array(); // file info
  240. //echo $query . "<br>";
  241. // prepare query
  242. $db->prepareQuery($queryDatasetRecords);
  243. // execute query
  244. // bind value studynumber
  245. $db->bind(":studynumber", $studynumber);
  246. // execute query
  247. $result = $db->executeQuery();
  248. //$result = $db->resultset(); // execute the query
  249. if (!$result) {
  250. die ("Could not query the database: <br />");
  251. } // else { echo "Successfully queried the database.<br>"; } // for debugging
  252. $row_index = 0;
  253. while ($row = $db->getRow()) { //
  254. // Non-PDO code ---------------------
  255. //while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
  256. $fileInfo[$row_index]["studypart"] = $row[ "StudyPart" ];
  257. $fileInfo[$row_index]["dsname"] = $row[ "Dsname" ];
  258. $fileInfo[$row_index]["filetype"] = $row[ "FileType" ];
  259. $fileInfo[$row_index]["note"] = $row[ "Note" ];
  260. //$fileInfo[$row_index]["reclen"] = $row[ "Reclen" ];
  261. //$fileInfo[$row_index]["filesize"] = $row[ "Fullsize" ];
  262. $fileInfo[$row_index]["dtafilenum"] = $row[ "DTAfile" ];
  263. // 12-17-09jmj added the reformated DTAfile field, now dtafilename
  264. $fileInfo[$row_index]["dtafilename"] = $row[ "dtafilename" ];
  265. $fileInfo[$row_index]["datacite"] = $row["datacite"];
  266. // links for the DATASETS
  267. // part of the file information
  268. //$fileInfo[$row_index]["wwwlink"] = $row["wwwlink"];
  269. //$fileInfo[$row_index]["wwwtext"] = $row["wwwtext"];
  270. $fileInfo[$row_index]["wwwlink"] = $row["wwwlink"];
  271. $fileInfo[$row_index]["wwwtext"] = $row["wwwtext"];
  272. //$fileInfo[$row_index]["restricted_file"] = $row["fileinfo.Restricted"];
  273. $fileInfo[$row_index]["restricted_file"] = $row["restricted_file"];
  274. // restricted on the dataset level
  275. $row_index++;
  276. }
  277. //echo "<br>";
  278. //print_r($fileInfo);
  279. //echo "<br>";
  280. $fileInfoCount = count($fileInfo);
  281. //echo "file row count: " . $fileInfoCount . "<br>";
  282. echo "<br>";
  283. if(count($fileInfo) >= 1) {
  284. //--------------------------------------------------------
  285. //echo "<br>";
  286. //echo "For material available to download from the Data Archve:<br>";
  287. // 20160502jmj: remove the download note since the Library site doesn't support downloads
  288. //echo "Click on the <b>File Name</b> to download an individual file.<br>";
  289. //echo "<div id='downloadallfiles' >";
  290. // 12-15-09jmj
  291. // if there is 1 or more - >= 1 - datasets that can be downloaded from the DATA ARCHIVE
  292. // after the dataset list is written out, javascript at the end of this section will write in thelines
  293. // commented out below
  294. // echo "To download an entire study choose: <A HREF='addfiles.php?file=&study=" . $studynumber . "&src=" . $studynumber . "'><img src='addall.gif'></a><br><br>";
  295. echo "</div><br>";
  296. echo "<div>Click category headers to sort.<br>";
  297. echo "<table id='datasetListForDownload' class='tablesorter'>";
  298. echo "<thead><tr>";
  299. echo "<th width=100 >File Type</th>";
  300. echo "<th width=180 >Note</th>";
  301. echo "<th width=180 >Download Site</th>";
  302. echo "<th >Dataset Citation</th>";
  303. echo "</tr></thead>";
  304. }
  305. // file info
  306. //print_r($fileInfo);
  307. // INFO NOTE:
  308. // ok, array_unique seems to not work too well with multi-dimensional arrays - see documentation on php site
  309. // since the $dsname is the unique thingie here, just test on that below while looping through the array
  310. //$fileInfo = array_unique($fileInfo);
  311. //print_r($fileInfo);
  312. //echo "<br>";
  313. //sort($fileInfo);
  314. //print_r($fileInfo);
  315. //echo "<br>";
  316. //$fileInfoCount = count($fileInfo); // just to check
  317. //echo "file information rows: $fileInfoCount<br>";
  318. $previousDtafilenum = null;
  319. // keep a count of data-archive-downloadable datasets, if >= 1 - at least 1 - write in the lines about Add All to the
  320. // div section div id=downloadallfiles
  321. // $da_downloadable is the counter variable
  322. // use javascript script = -----
  323. //
  324. for ($row_index = 0; $row_index < $fileInfoCount; $row_index++) {
  325. $studypart = $fileInfo[$row_index]["studypart"];
  326. $filetype = $fileInfo[$row_index]["filetype"];
  327. $note = $fileInfo[$row_index]["note"];
  328. $dsname = $fileInfo[$row_index]["dsname"];
  329. //if (empty($dsname)) { $dsname = ""; } // some ICPSR files don't use a dsname
  330. //$reclen = $fileInfo[$row_index]["reclen"];
  331. //$filesize = $fileInfo[$row_index]["filesize"];
  332. $dtafilenum = $fileInfo[$row_index]["dtafilenum"];
  333. // 12-17-09jmj added dtafilename, reformatedd DTAfile to dtafilename
  334. $dtafilename = $fileInfo[$row_index]["dtafilename"];
  335. //
  336. $datacite = $fileInfo[$row_index]["datacite"];
  337. $restricted_file = $fileInfo[$row_index]["restricted_file"]; // test for dataset level restricted file
  338. // it is unlikely a base record will be unrestricted and a dataset restricted but this tests for that contingency
  339. $wwwtext = $fileInfo[$row_index]["wwwtext"];
  340. $wwwlink = $fileInfo[$row_index]["wwwlink"];
  341. //if ($dsname != $previousDSname) {
  342. if ($dtafilenum != $previousDtafilenum) {
  343. echo "<TR>"; // beginning of the row
  344. // filetype
  345. if (stristr ($filetype, "ON CD-ROM")) { // datset on CD
  346. echo "<TD>" . $filetype . "</TD>";
  347. echo "<TD>$note: Please contact the Data Archives for data access assistance.</TD>";
  348. echo "<TD>&nbsp;</TD>";
  349. } elseif (stristr ($filetype, "SDA Online Analysis")) { // archive sda files (in-house); $filetype, $dsname, $note
  350. //20160219jmj: update the sda address to the current library site
  351. //$sda_onlineanalysis_link="http://zuma.sscnet.ucla.edu/issr/da/sdaweb/cgi-bin/hsda?harc";
  352. $sda_onlineanalysis_link="http://sda.library.ucla.edu/sdaweb/analysis/?dataset=";
  353. echo "<TD>" . $filetype . "</TD>"; // which would be 'SDA online analysis'
  354. echo "<TD>" . $note . " ** SDA</TD>"; // something like the year, description, etc : Codebook 1985-2001
  355. echo "<TD><a href='" . $sda_onlineanalysis_link . $dsname . "'>" . $filetype . " (" . $dsname . ") <a></TD>";
  356. } elseif (stristr ($filetype, "Web Access")) {
  357. if ((stristr($wwwtext, "ICPSR")) OR (stristr ($note, "ICPSR")) OR (stristr ($filetype, "ICPSR"))) {
  358. // the most likely place to mark ICPSR is 1) the wwwtext field, 2) the note and 3) occasionally the filetype
  359. // this is an ICPSR dataset with a persistent link
  360. // reevaluate this section
  361. echo "<TD>" . $filetype . "</TD>"; // which would be 'Web Access'
  362. echo "<TD>" . $note . "</TD>"; // something like the year, description, etc : Codebook 1985-2001
  363. //next, if the wwwlink has been left blank, build and fill in the persistant link
  364. // almost always this is the case where the ICPSRnnn number is in the wwwtext field and the wwwlink field is blank
  365. // download link section
  366. if (empty($wwwlink)) {
  367. //echo "wwwlink: " . $wwwlink . "<br>";
  368. $icpsrPersistentLink="http://dx.doi.org/10.3886/ICPSR0";
  369. //$icpsrStudynumber = substr($note, 5, strlen($note)-5);
  370. //$icpsrStudynumberLength = strlen($note)-5;
  371. $icpsrStudynumber = substr($wwwtext, 5, strlen($wwwtext)-5);
  372. $icpsrStudynumberLength = strlen($wwwtext)-5;
  373. echo "<TD><a href=" . $icpsrPersistentLink . $icpsrStudynumber .">" . $wwwtext . "</h3><a></TD>";
  374. //------------------------------------------------------------------
  375. // ELSE the link field - wwwtext_link - is NOT blank
  376. } else {// it's not blank
  377. //echo "<TD><a href=http://" . $wwwlink . "><h3>" . $wwwlink_text . "</h3><a></TD>";
  378. //echo "wwwlink: " . $wwwlink . "<br>";
  379. echo "<TD><a href='http://" . $wwwlink . "'>" . $wwwtext . "<a></TD>";
  380. }
  381. } else { // any other site than ICPSR, no persistent link
  382. echo "<TD>" . $filetype . "</TD>";
  383. echo "<TD>" . $note . "<TD>";
  384. if (!empty($wwwlink)) {
  385. //if (isset($wwwlink)) {
  386. echo " <a href=http://" . $wwwlink . " >" . $wwwtext . "</a></TD>";
  387. //echo "<a href=http://" . $wwwlink . " >" . $note . " " . $wwwtext . "</a></TD>";
  388. } else {
  389. echo $wwwtext . " Please contact the Data Archives for data access assistance.</td>";
  390. }
  391. //echo "<TD>&nbsp;</TD>";
  392. }
  393. }
  394. echo "<td align='left'>" . $datacite . "</td>";
  395. $previousDtafilenum = $dtafilenum;
  396. echo "</tr>"; // end of the row
  397. } // if-loop test for unique dsname
  398. } // for-loop for the entire file info array
  399. echo "</TABLE></DIV><br><br>";
  400. //-------------------------------------------------------------------------------------------------------------------
  401. // _destructor class closes connection
  402. // close the connection
  403. //$PDO_connection = null;
  404. ?>
  405. <!--end container -->
  406. <!---------------------------------------------------------------------------------------------- -->
  407. <?php include("../_includes/SSDA_LibraryBottomPanel.php") ?>
  408. </body></html>