LASUCA/controls-web
3
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
controls-web/controls-rework/overviews/jpowered/demo/examples/csvfile.htm
Rucus 782d203799 add all files
2026-02-17 09:29:34 -06:00

207 lines
8.1 KiB
HTML
Raw Permalink Blame History

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>Advanced Graphs and Charts for PHP</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel=STYLESHEET type="text/css" href="../../images/960.css" />
<link rel=STYLESHEET type="text/css" href="../../images/jpprodstyle.css" />
</head>
<body>
<!-- Title area -->
<div class='container_12 header'>
<div class='grid_4'>
<a href='http://www.jpowered.com'><img style='border-width: 0px;' src='../../images/jpowered.gif' width='270' height='60' align='left' alt='JPowered.com' /></a>
</div>
<div class='grid_8 omega product_title'>
<h1>Advanced Graphs and Charts for PHP</h1>
</div>
</div>
<!-- top menu bar -->
<div class='container_12'>
<div class='grid_12 innm'>
<ul>
<li> <a href="http://www.jpowered.com/php-scripts/adv-graph-chart/">Graph Home</a> </li>
<li> <a href="http://www.jpowered.com/php-scripts/adv-graph-chart/buy-now.htm" title="Pricing Options and obtaining License keys">Pricing / License Options</a> </li>
<li> <a href="http://www.jpowered.com/php-scripts/adv-graph-chart/demos/" title="View the Online Demos here">Online Demos</a> </li>
<li> <a href="../../documentation/index.htm">Documentation</a> </li>
<li> <a href="http://www.jpowered.com/php-scripts/adv-graph-chart/tutorials/" title="Online Tutorials">Tutorials</a> </li>
</ul>
</div>
</div>
<!-- main content -->
<div class='container_12 main_content'>
<div class='grid_9'>
<h2>Database Interface Script</h2>
<p>Here the graphing software is instructed to dynamically read data from a CSV file.</p>
<p>This method allows you to graph data dynamically straight from a CSV file.</p>
<img src="../../graph/vertical-cylinder-graph.php?
data=../demo/examples/data/csvdataScript.php&
config=../demo/examples/data/csvConfig.php"
width="700"
height="400" />
<p>The graph above is produced using the "Data Interface Script" method with the following IMG tag:-</p>
<textarea class="jpcodeblock" style="width: 600px;">
<img src="../../graph/vertical-cylinder-graph.php?
data=../demo/examples/data/csvdataScript.php&
config=../demo/examples/data/csvConfig.php"
width="700"
height="400" />
</textarea>
<p>The graph data is produced by the interface script and read by the graphing software at runtime:-</p>
<textarea class="jpcodeblock" style="width: 600px;">
./jpowered/demo/examples/data/csvdataScript.php
/*
* read the csv file
*/
$csvdata = file('csvData.csv');
$first = TRUE;
$dataCount = 1;
/*
* process each row of the
* csv file
*/
foreach ($csvdata as $datarow)
{
if ($first) // ignore the first header row
{
$first = FALSE;
}
else
{
/*
* extract the temperature value
* from each row and write out
* the data parameter
*/
$dataelements = explode(',',$datarow);
if (isset($dataelements[1]))
{
$dataelements[1] = (float)$dataelements[1];
print 'data'. $dataCount .'series1: ' . $dataelements[1] . PHP_EOL;
$dataCount++;
}
}
}
</textarea>
<p>With this method the graphing software calls the interface script at runtime and reads the output of the script
in the same way that it would read the data from a flat file. This method allows data to be dynamically produced
and plotted in real-time.</p>
<p>The settings and styles are set from the information contained in the file:-</p>
<textarea class="jpcodeblock" style="width: 600px;">
./jpowered/demo/examples/data/csvConfig.php
</textarea>
<p>If the graph above does not display then see the <a href="../../documentation/troubleShooting.htm">Troubleshooting guide</a> for details on how to resolve the problem.</p>
<p>If the graph above does display but no data is shown then the most likely cause is that the graph is having trouble
connecting to the database server. Ensure that the '<a href='../../sampleApplication/index.php'>Sample Application</a>' has been set up
with the correct DB User credentials.</p>
<p>If you have not yet set up the Sample Application then
you can do so <a href='../../sampleApplication/index.php'>here</a>.</p>
<p>&nbsp;</p>
</div>
<div class='grid_3'>
<p><a href="../../index.htm">Package Index</a></p>
<p><a href="../../documentation/index.htm">Documentation</a></p>
<p><a href="../../documentation/troubleShooting.htm">Troubleshooting Guide</a></p>
<p><a href="http://www.jpowered.com/support.htm">Support</a></p>
<h4>Examples</h4>
<ul>
<li><a href='../examples/dataFiles.htm'>Graphing Data from files</a></li>
<li><a href='../examples/scripts.htm'>Data from external scripts</a></li>
<li><a href='../examples/datafunction.htm'>Custom data function</a></li>
<li><a href='../examples/requestParams.htm'>Utilising request parameters</a></li>
<li><a href='../examples/database.htm'>Plotting data from a database</a></li>
<li><a href='../examples/interface.htm'>Database interface scripts</a></li>
<li><a href='../examples/multiScales.htm'>Multiple Scales, text and images</a></li>
<li><a href='../examples/csvfile.htm'>Graphing CSV files</a></li>
</ul>
<h4>Basic Chart Styles</h4>
<ul>
<li><a href="../../demo/piechart/index.htm">Pie Charts</a></li>
<li><a href="../../demo/xyscatter/index.htm">X-Y Scatter Graphs</a></li>
<li><a href="../../demo/bubblechart/index.htm">Bubble Charts</a></li>
<li><a href="../../demo/areagraph/index.htm">Area Graphs</a></li>
<li><a href="../../demo/linegraph/index.htm">Line Graphs</a></li>
</ul>
<h4>Bar Graphs</h4>
<ul>
<li><a href="../../demo/vbar/index.htm">Vertical Bar Graphs</a></li>
<li><a href="../../demo/svbar/index.htm">Stacked Vertical Bar Graphs</a></li>
<li><a href="../../demo/hbar/index.htm">Horizontal Bar Graphs</a></li>
<li><a href="../../demo/shbar/index.htm">Stacked Horizontal Bar Graphs</a></li>
</ul>
<h4>Cylinder Charts</h4>
<ul>
<li><a href="../../demo/cylinder-Vbar/index.htm">Vertical Cylinder Graphs</a></li>
<li><a href="../../demo/cylinder-SVbar/index.htm">Stacked Vertical Cylinder Graphs</a></li>
<li><a href="../../demo/cylinder-Hbar/index.htm">Horizontal Cylinder Graphs</a></li>
<li><a href="../../demo/cylinder-SHbar/index.htm">Stacked Horizontal Cylinder Graphs</a></li>
</ul>
<h4>Combination Charts</h4>
<ul>
<li><a href="../../demo/combi-Area-SVbar/index.htm">Area and Stacked Vertical Bar Graph</a></li>
<li><a href="../../demo/combi-Area-Vbar/index.htm">Area and Vertical Bar Graph</a></li>
<li><a href="../../demo/combi-Line-SVbar/index.htm">Line and Stacked Vertical Bar Graph</a></li>
<li><a href="../../demo/combi-Line-Vbar/index.htm">Line and Vertical Bar Graph</a></li>
</ul>
<p>&nbsp;</p>
</div>
</div>
<div class='footer'>
<!-- bottom menu bar -->
<div class='container_12'>
<div class='grid_12 innm'>
<ul>
<li> <a href="http://www.jpowered.com/php-scripts/adv-graph-chart/">Graph Home</a> </li>
<li> <a href="http://www.jpowered.com/php-scripts/adv-graph-chart/buy-now.htm" title="Pricing Options and obtaining License keys">Pricing / License Options</a> </li>
<li> <a href="http://www.jpowered.com/php-scripts/adv-graph-chart/demos/" title="View the Online Demos here">Online Demos</a> </li>
<li> <a href="../../documentation/index.htm">Documentation</a> </li>
<li> <a href="http://www.jpowered.com/php-scripts/adv-graph-chart/tutorials/" title="Online Tutorials">Tutorials</a> </li>
</ul>
</div>
</div>
<!-- footer -->
<div class='container_12'>
<div class="grid_12 mc">[<a href="http://www.jpowered.com/"> JPowered.com </a>] [<a href="http://www.jpowered.com/products.htm" title="More software components for web applications"> More Products </a>] [<a href="http://www.jpowered.com/support.htm" title="For Help and Support, contact us here">Support </a>]</div>
<div class="grid_12 cprt">Copyright &copy; 2011 - 2014 Neutron Solutions Limited - All rights reserved.</div>
</div>
</div>
</body>
</html>
Reference in New Issue View Git Blame Copy Permalink