1 <?php

     2 

     3 header('Content-type: application/json');

     4 

     5 require('connect.inc.php');

     6 

     7 $label = (isset($_REQUEST['label']) ? $_REQUEST['label'] : NULL);

     8 $max_tag_order = (isset($_REQUEST['mto']) ? pg_escape_string($_REQUEST['mto']) : 12);

     9 $content_count = (isset($_REQUEST['contentcount']) ? pg_escape_string($_REQUEST['contentcount']) : 10);

    10 

    11 $resobj = array("requested_label" => $label);

    12 

    13 $label = pg_escape_string($label);

    14 

    15 $rq = pg_query("SELECT id FROM hdabo_tag WHERE label ILIKE '$label'");

    16 $ids = array();

    17 while($ligne = pg_fetch_row($rq)) {

    18     $ids[] = $ligne[0];

    19 }

    20 

    21 pg_free_result($rq);

    22 

    23 $sql = "SELECT COUNT(DISTINCT datasheet_id) FROM hdabo_taggedsheet WHERE tag_id IN (" . join(",", $ids) . ")";

    24 

    25 $rq = pg_query($sql);

    26 

    27 if ($ligne = pg_fetch_row($rq)) {

    28     $resobj["content_count"] = $ligne[0];

    29 }

    30 

    31 $sql = "SELECT MAX(dbpedia_uri), MAX(wikipedia_url) FROM hdabo_tag WHERE id IN (" . join(",", $ids) . ")";

    32 

    33 $rq = pg_query($sql);

    34 

    35 if ($ligne = pg_fetch_row($rq)) {

    36     $resobj["dbpedia_uri"] = $ligne[0];

    37     $resobj["wikipedia_url"] = $ligne[1];

    38 }

    39 

    40 pg_free_result($rq);

    41 

    42 if (isset($resobj["dbpedia_uri"]) and $resobj["dbpedia_uri"]) {

    43     $uri = $resobj["dbpedia_uri"];

    44     $sql = "SELECT abstract, label, thumbnail FROM dbpedia_fields WHERE dbpedia_uri = '$uri'";

    45     $rq = pg_query($sql);

    46     if ($ligne = pg_fetch_row($rq)) {

    47         $resobj["abstract"] = $ligne[0];

    48         $resobj["dbpedia_label"] = $ligne[1];

    49         $resobj["thumbnail"] = $ligne[2];

    50     }

    51 

    52     pg_free_result($rq);

    53 }

    54 

    55 $sql = "SELECT * FROM hdaviz_simple_tag_links WHERE subject ILIKE '$label' OR object ILIKE '$label'";

    56 $rq  = pg_query($sql);

    57 

    58 $resobj["links"] = pg_fetch_all($rq);

    59 pg_free_result($rq);

    60 

    61 echo json_encode($resobj);

    62 

    63 ?>