Вроде чуть чуть разобрался..Есть класс для построения GOOGLE CHARTS:
| Код |
<?php
#
# Chart
#
# Copyright (c) 2008 Ludwig Pettersson
# Permission is hereby granted, free of charge, to any person obtaining a copy
# of this software and associated documentation files (the "Software"), to deal
# in the Software without restriction, including without limitation the rights
# to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
# copies of the Software, and to permit persons to whom the Software is
# furnished to do so, subject to the following conditions:
# The above copyright notice and this permission notice shall be included in
# all copies or substantial portions of the Software.
# THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
# IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
# FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
# AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
# LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
# OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
# THE SOFTWARE.
class GoogChart
{
// Constants
const BASE = 'http://chart.apis.google.com/chart?';
// Variables
protected $types = array(
'pie' => 'p',
'line' => 'lc',
'sparkline' => 'ls',
'bar-horizontal' => 'bhg',
'bar-vertical' => 'bvg',
);
protected $type;
protected $title;
protected $data = array();
protected $size = array();
protected $color = array();
protected $fill = array();
protected $labelsXY = false;
protected $legend;
protected $useLegend = true;
protected $background = 'a,s,ffffff';
protected $query = array();
// debug
public $debug = array();
// Return string
public function __toString()
{
return $this->display();
}
/** Create chart
*/
protected function display()
{
// Create query
$this->query = array(
'cht' => $this->types[strtolower($this->type)], // Type
'chtt' => $this->title, // Title
'chd' => 't:'.$this->data['values'], // Data
'chl' => $this->data['names'], // Data labels
'chdl' => ( ($this->useLegend) && (is_array($this->legend)) ) ? implode('|',$this->legend) : null, // Data legend
'chs' => $this->size[0].'x'.$this->size[1], // Size
'chco' => preg_replace( '/[#]+/', '', implode(',',$this->color)), // Color ( Remove # from string )
'chm' => preg_replace( '/[#]+/', '', implode('|',$this->fill)), // Fill ( Remove # from string )
'chxt' => ( $this->labelsXY == true) ? 'x,y' : null, // X & Y axis labels
'chf' => preg_replace( '/[#]+/', '', $this->background), // Background color ( Remove # from string )
);
// Return chart
return $this->img(
GoogChart::BASE.http_build_query($this->query),
$this->title
);
}
/** Set attributes
*/
public function setChartAttrs( $attrs )
{
// debug
$this->debug[] = $attrs;
foreach( $attrs as $key => $value )
{
$this->{"set$key"}($value);
}
}
/** Set type
*/
protected function setType( $type )
{
$this->type = $type;
}
/** Set title
*/
protected function setTitle( $title )
{
$this->title = $title;
}
/** Set data
*/
protected function setData( $data )
{
// Clear any previous data
unset( $this->data );
// Check if multiple data
if( is_array(reset($data)) )
{
/** Multiple sets of data
*/
foreach( $data as $key => $value )
{
// Add data values
$this->data['values'][] = implode( ',', $value );
// Add data names
$this->data['names'] = implode( '|', array_keys( $value ) );
}
/** Implode data correctly
*/
$this->data['values'] = implode('|', $this->data['values']);
/** Create legend
*/
$this->legend = array_keys( $data );
}
else
{
/** Single set of data
*/
// Add data values
$this->data['values'] = implode( ',', $data );
// Add data names
$this->data['names'] = implode( '|', array_keys( $data ) );
}
}
/** Set legend
*/
protected function setLegend( $legend )
{
$this->useLegend = $legend;
}
/** Set size
*/
protected function setSize( $width, $height = null )
{
// check if width contains multiple params
if(is_array( $width ) )
{
$this->size = $width;
}
else
{
// set each individually
$this->size[] = $width;
$this->size[] = $height;
}
}
/** Set color
*/
protected function setColor( $color )
{
$this->color = $color;
}
/** Set labels
*/
protected function setLabelsXY( $labels )
{
$this->labelsXY = $labels;
}
/** Set fill
*/
protected function setFill( $fill )
{
// Fill must have atleast 4 parameters
if( count( $fill ) < 4 )
{
// Add remaining params
$count = count( $fill );
for( $i = 0; $i < $count; ++$i )
$fill[$i] = 'b,'.$fill[$i].','.$i.','.($i+1).',0';
}
$this->fill = $fill;
}
/** Set background
*/
protected function setBackground( $background )
{
$this->background = 'bg,s,'.$background;
}
/** Create img html tag
*/
protected function img( $url, $alt = null )
{
return sprintf('<img src="%s" alt="%s" style="width:%spx;height:%spx;" />', $url, $alt, $this->size[0], $this->size[1]);
}
}
|
На основе примера пробую сделать свой чарт..Данные выдергиваю из базы и вставляю в чарт
| Код |
<div style="margin: 0 auto;display:block;width:100%;">
<?php
$host="localhost";
$username="root";
$pass="";
$db_name="quote";
//connect
$con =mysql_connect("$host","$username","$pass") or die("Не удалось приконнектиться к серверу");
mysql_select_db("$db_name") or die ("Нет коннекта к таблицы");
$result = mysql_query("SELECT * FROM quote.iv limit 5");
/** Include class */
include( 'GoogChart.class.php' );
/** Create chart */
$chart = new GoogChart();
/*
Example 1
Pie chart
*/
// Set graph data
while($row = mysql_fetch_array($result))
{
$data = array($row['time'] => $row['price']);
echo $row['time'].' '.$row['price'].' <br/>';
}
mysql_close($con);
$data = array('IE7' => 22,
'IE6' => 30.7,
'IE5' => 1.7,
'Firefox' => 36.5,
'Mozilla' => 1.1,
'Safari' => 2,
'Opera' => 1.4,);
// Set graph colors
$color = array(
'#99C754',
'#54C7C5',
'#999999',
);
/* # Chart 1 # */
echo '<h2>Pie chart</h2>';
$chart->setChartAttrs( array(
'type' => 'pie',
'title' => 'Implied Volatility',
'data' => $data,
'size' => array( 600, 400 ),
'color' => $color
));
// Print chart
echo $chart;
?>
</div>
|
Но у меня логическая ошибка в том месте где я задаю array :
| Код |
while($row = mysql_fetch_array($result))
{
$data = array($row['time'] => $row['price']);
echo $row['time'].' '.$row['price'].' <br/>';
}
|
ЧАрт получается в виде только одной точки..Кто нить может помочь в чем причина?
|
)