getAnnotationValues.php
No OneTemporary
Actions

Subscribers

None

File Metadata

	<?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) . "]";