Share default-all APP with SMS.


share the default-all app by sending an SMS message
default-all https://jschmidt-systemberatung.de/index.php?option=com_content&view=article&id=295&Itemid=198&lang=en

 

 

Share Content

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

Visitors

Today: 2
Yesterday: 18
This Week: 150
Last Week: 279
This Month: 751
Last Month: 685
This Year: 4,599
Last Year: 24,211
0261403
Germany 32.9% Germany
USA 21.4% USA
France 3.3% France
Italy 2.7% Italy
Indonesia 2.0% Indonesia
Poland 2.0% Poland
Netherlands 1.8% Netherlands

Total:

209

Countries

Weather

Weather in Ashburn

May 23rd, 2025 - 20:35
Clear Sky
14°C 13°C min 15°C max
5:50 20:22
Feels Like Temperature:  13°C
;
Humidity:   59%
Wind: 24.1 km/h W
Pressure:   1,015 hPa
Visibility:   not obstructed
We use cookies

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.