A minimal server-side sample with a database -
<?php
include 'includevars.php';
//this file is only utilized by Roku Interface on back end of server using a GET request.
if ($_SERVER["REQUEST_METHOD"] == "GET")
{
$con=@new mysqli($sitename,$masteraccessname,$masteraccesspw,$databasename);
if (mysqli_connect_errno())
{
exit("Unable to connect to database.");
}
// read the post from ROKU
$value2 = urldecode(stripslashes($_GET["Term"])); //search term
if($value2=="")
{
$_xml="<?xml version=\"1.0\" encoding=\"UTF-8\"?>".chr(13);
$_xml.="<feed>".chr(13);
$_xml.="<item>".chr(13);
$_xml.="<thumbnail>".$rootdir."Empty.jpg</thumbnail>".chr(13);
$_xml.="<title>Placeholder</title>".chr(13);
$_xml.="<streamUrl>".$baseserverip."Empty.mp4</streamUrl>".chr(13);
$_xml.="</item>".chr(13);
$_xml.="</feed>".chr(13);
echo $_xml;
exit();
}
if (strlen($value2)>2)
{
$sql="SELECT * FROM ".$maindbname." WHERE title LIKE '%".$value2."%' OR description LIKE '%".$value2."%' ORDER BY title"; //Do search query
}
else
{
$sql="SELECT * FROM ".$maindbname." WHERE title LIKE '".$value2."%' ORDER BY title"; //Do search query based on first letters of filename
}
$res=mysqli_query($con, $sql)
or die("Error: ".mysqli_error($con));
if (mysqli_num_rows($res)==0) //no shows
{
$_xml="<?xml version=\"1.0\" encoding=\"UTF-8\"?>".chr(13);
$_xml.="<feed>".chr(13);
$_xml.="<item>".chr(13);
$_xml.="<thumbnail>".$rootdir."Empty.jpg</thumbnail>".chr(13);
$_xml.="<title>Placeholder</title>".chr(13);
$_xml.="<streamUrl>".$baseserverip."Empty.mp4</streamUrl>".chr(13);
$_xml.="</item>".chr(13);
$_xml.="</feed>".chr(13);
echo $_xml;
}
else
{
$mx=0;
while ($info=mysqli_fetch_array($res,MYSQLI_NUM))
{
$title[$mx]=$info[0]; //title
$thumbnail[$mx]=$info[1]; //thumbnail
$streamurl[$mx]=$info[2]; //streamurl
$mx++;
}
$_xml="<?xml version=\"1.0\" encoding=\"UTF-8\"?>".chr(13);
$_xml.="<feed>".chr(13);
For ($i=0;$i<$mx;$i++)
{
$_xml.="<item>".chr(13);
$_xml.="<title>".$title[$i]."</title>".chr(13);
$_xml.="<thumbnail>".$thumbnail[$i]."</thumbnail>".chr(13);
$_xml.="<streamUrl>".$streamurl[$i]."</streamUrl>".chr(13);
$_xml.="</item>".chr(13);
}
$_xml.="</feed>".chr(13);
echo $_xml;
}
mysqli_close($con);
}
?>