<?php

// Yahoo Yql (UK Government) Member Search Tutorial - RJM Programming - 2014

$selname = "";
$mname = "members";
if (isset($_POST['selname'])) $selname = str_replace(" ","%20",$_POST['selname']);
if (isset($_GET['selname'])) $selname = str_replace(" ","%20",$_GET['selname']);
if (isset($_POST['selcon'])) $selname = str_replace(" ","%20",$_POST['selcon']);
if (isset($_GET['selcon'])) $selname = str_replace(" ","%20",$_GET['selcon']);
if (isset($_POST['selcon'])) $mname = "constituencies";
if (isset($_GET['selcon'])) $mname = "constituencies";

if ($selname != "") {
 $pageContent = file_get_contents("http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20ukparliament.commons.".$mname."%20where%20query%3D'" . $selname . "'&format=json&diagnostics=true&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys&callback=");
 $json_output = json_decode($pageContent);  // .true

        // Confirm that results were returned before parsing
        if(!is_null($json_output->query->results)){
            $i = 0;
            $j = 0;
            for ($i=0; $i<$json_output->query->count; $i++) {
              $j = 0;
              $flp = "";
              foreach($json_output->query->results->constituency[$i] as $event){
                if ($j == 0) {
                  $flp = " for " . $event;
                } else if ($j == 1) {
                  $flp = $event . $flp;
                } else if ($j == 2) {
                  echo "<table border=1 cellpadding=5><tr><td><p style='border: red 2px solid; padding: 2 2 2 2;'>".str_replace(" for ", ", " . $event . " for ", $flp)." "."</p>";
                } else if ($j == 3) {
                  echo "<p style='border: lightgreen 3px solid; padding: 2 2 2 2;'><a target=_blank title='Member Biography Url' href='".$event."'>".$event."</a>";
                } else if ($j == 4 && str_replace("http:","",$event) != "") {
                  echo "<p style='border: lightgreen 3px solid; padding: 2 2 2 2;'><a target=_blank title='Member Website' href='".$event."'>".$event."</a></p></td></tr></table>";
                } else if ($j == 4) {
                  echo "</p></td></tr></table>";
                }
                $j++;
              }
            }
        }
}
?> 

