<?php

// Yahoo Yql Social Mention Search 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']);
$bcolours = array("white", "pink", "aqua", "lime", "silver", "lightyellow", "cyan", "fuchsia", "orange", "lightblue", "lightgreen", "lightgray");

if ($selname != "") {
 $pageContent = file_get_contents("https://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20socialmention.search%20where%20q%3D'".$selname."'%20and%20t%3D'microblogs'&format=json&diagnostics=true&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys&callback=");

 $json_output = json_decode($pageContent);  
 
 // Confirm that results were returned before parsing
 if (!is_null($json_output->query->results)) {
            //echo "yessir";
			date_default_timezone_set('Australia/Sydney');
			$date = date('d/m/Y h:i:s a', time());            
			echo "<!doctype HTML><html><head><link href='//www.rjmprogramming.com.au/PHP/emboss_h1.css' rel='stylesheet' type='text/css'></head><body align='center' style='background-color:yellow;'><h1 align='center'>" . urldecode($selname) . " ... Social Mentions ... " . $date . " AEST</h1><br><div align='center'>";
            foreach($json_output->query->results->item as $event){
                //echo "yes";
                echo "<div align='center' style='background-color:" . $bcolours[rand(0,(sizeof($bcolours)-1))], ";'><table border=1 cellspacing=5 cellpadding=5><tr><td><p style='border: red 2px solid; padding: 8 8 8 8;'><a target=_blank title='New Window' href='".$event->link."' title='" . $event->title . "'>".$event->title."&nbsp;";
                if (str_replace("null", "", $event->image) != "") echo "<img src='".$event->image."' title='" . $event->title . "' />";
                echo "</a></p>";
                echo "<p padding: 8 8 8 8;'><a target=_blank title='New Window' href='".$event->userlink."'>".$event->user."&nbsp;<img src='".$event->favicon."' title='" . $event->source . "' /></a>&nbsp;";
                if (str_replace("null", "", $event->userimage) != "") echo "<img src='".$event->userimage."' title='" . $event->user . "' />";
                echo "</a></p>";
                echo "<p padding: 8 8 8 8;'>".date('d/m/Y h:i:s a', $event->timestamp)." AEST</p>";
                echo "<p style='border: lightgreen 4px solid; padding: 8 8 8 8;'>" . str_replace("null", "", $event->description) . "</p></td></tr></table></div>";
            }
 			echo "</div></body></html>";
 }

}
?> 

