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

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

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

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

    38 }

    38 }

    39 

    39 

    40 pg_free_result($rq);

    40 pg_free_result($rq);

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

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

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

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

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

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

    45     $rq = pg_query($sql);

    45     $rq = pg_query($sql);

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

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

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

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

    50     }

    50     }

    51 

    51 

    52     pg_free_result($rq);

    52     pg_free_result($rq);

    53 }

    53 }

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

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

    56 $rq  = pg_query($sql);

    56 $rq  = pg_query($sql);

    57 

    57 

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

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

    59 pg_free_result($rq);

    59 pg_free_result($rq);

    61 echo json_encode($resobj);

    61 echo json_encode($resobj);

    62 

    62 

    63 ?>

    63 ?>