Access of Remote Data

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...