<?php

// Yahoo Yql Primer Tutorial - RJM Programming - 2014

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

if ($selname != "") {
 $pageContent = file_get_contents('http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20answers.search%20where%20query%3D%22' . $selname . '%22%20%20and%20type%3D%22resolved%22&format=json&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys&callback=',0,null,null);
 //$pageContent = file_get_contents('http://localhost:8888/yql.txt');
 $json_output = json_decode($pageContent); //  ,true);
 //echo $pageContent;
 //var_dump $json_output; //->results->Question[1]); 
        //$yql_query_url = 'http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20answers.search%20where%20query%3D%22' . $selname . '%22%20%20and%20type%3D%22resolved%22&format=json&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys&callback=';
        // Make call with cURL
        //$session = curl_init($yql_query_url);
        //curl_setopt($session, CURLOPT_RETURNTRANSFER,true);
        //$json = curl_exec($session);
        // Convert JSON to PHP object 
        //$phpObj =  json_decode($json);


        // Confirm that results were returned before parsing
        //$output="";
        if(!is_null($json_output->query->results)){
            foreach($json_output->query->results->Question as $event){
                //echo print_r($event);
                echo "<table border=1 cellpadding=5><tr><td><p style='border: red 2px solid; padding: 2 2 2 2;'>".$event->Subject."</p>";
                echo "<p padding: 2 2 2 2;'>".$event->Date."</p>";
                echo "<p style='border: yellow 1px solid; padding: 2 2 2 2;'>".$event->Content."</p>";
                echo "<p style='border: lightgreen 3px solid; padding: 2 2 2 2;'>".$event->ChosenAnswer."</p></td></tr></table>";
            }
        }
}
?> 

