just_a_check.php
No OneTemporary
Actions

Subscribers

None

File Metadata

	<?php

	include 'sqlConnection.php';

	$query =
	"SELECT variant_annotations
	FROM genomic_annotations
	WHERE variant_id = -8935125523235860480";

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

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