getAnnotationValues.php
d844b406bd1dmaster

getAnnotationValues.php
View Options

			<?php

			$conn = pg_connect("host=localhost port=5432 dbname=i2b2 user=postgres password=admin");

			if (!$conn) {
			echo "Error while connecting to the postgres database";
			exit;
			}

			// get the row which contains all the values of the passed annotation
			$query = "SELECT annotation_values FROM shrine_ont.genomic_annotations_metadata WHERE annotation_id='". htmlspecialchars($_GET["annotation_name"]) . "'";
			$result = pg_query($conn, $query);
			if (!$result) {
			echo "An error occurred.\n";
			exit;
			}

			while ($row = pg_fetch_row($result)) {
			echo "$row[0]";
			}