<?php

$dbconn = pg_connect("host=localhost port=5432 dbname=smsgate user=smsgate password=smsgate");

$key = pg_escape_string($_GET["key"]);

$query = "SELECT * FROM sms WHERE meta->>'key'='$key'";


$result = pg_query($query) or die('Query failed: ' . pg_last_error());


$response = array();

while ($line = pg_fetch_array($result, null, PGSQL_ASSOC)) {
    $meta = json_decode($line["meta"]);
    $response[] = $meta;
}

echo json_encode($response);

?>