getAnnotationValues.php
4e1fb30d2923master

getAnnotationValues.php
View Options

			<?php

			// case insensitive with regex
			//select annotation_value
			//from <annotation_name>
			//where annotation_value ~* '.a1.'
			//LIMIT 20

			include 'sqlConnection.php';

			// get the row which contains all the values of the passed annotation
			$query =
			"SELECT annotation_value
			FROM " . $_GET["annotation_name"] ."
			WHERE annotation_value ~* '." . $_GET["annotation_value"] .".'
			LIMIT " . $_GET["limit"];

			$result = pg_query($conn, $query);
			if (!$result) {
			echo "An error occurred while querying the database.\n";
			exit;
			}

			// In json format return the list of annotation names
			$annotationList = "";
			while ($row = pg_fetch_row($result)) {
			$annotationList .= "\"$row[0]\",";
			}
			// drop the last comma and concatenate in json format
			echo "[" . substr($annotationList, 0, -1) . "]";