Data for Chart is retrieved from Remote Site Database
Notes:We will retrieve data from remote MySql Datenbases. Remote site has php-RGraph installed and is using php-RGraph's MySql interface.
{rgraph height="350" width="600"
data="url" url="http://www.oberquembach.de/templates/system/getJsonDatafromDB.php" debug="0" type="Bar" tooltip="#label#<br>#val# Hits" title="Most read at oberquembach.de" xaxisLabelsAngle="20" marginBottom="105" truncate_label="18,..." variant="3d" tooltipsPositionStatic="0" variantThreedOffsety="10" variantThreedOffsetx="15"}sample006{/rgraph}
*** php-rgraph - invalid/missing parameter:
- "http://www.oberquembach.de/index.php?option=com_ajax&plugin=jphpx&group=system&format=raw&id=11" -
- no valid data from: "http://www.oberquembach.de/index.php?option=com_ajax&plugin=jphpx&group=system&format=raw&id=11"
Access to remote MySql Database is done with a tiny PHP-Script, which will be triggered for execution via parameter data="url" and "url". It uses php-RGraph's Version 2 interfaces (via "rgraph_chart.php").
Here you have this PHP-Script - "getJsonDatafromDB.php", which has been installed in directory "../templates/system" on remote site (www.oberquembach.de):
<?php
defined('_JEXEC') or die('Restricted access');
$lib = JPATH_ROOT . "/php-apps/RGraph/lib/rgraph_chart.php";
require_once ($lib);
use phpRGraph\rgraph_chart;
$db_config_file = $_SERVER["DOCUMENT_ROOT"] . "/configuration.php";
$sql="Select title, hits From j25_content Order By hits Desc Limit 10";
$dbdata = rgraph_chart::getDataFromDB($db_config_file, $sql);
$data = array("labels"=>$dbdata[0], "data"=>$dbdata[1]);
echo json_encode($data);
?>
Important: If you want to test this sample via copy/paste, ensure that you paste with option "paste as plain text" otherwise imbedded html-codes may invalidate your input.
go back...
