Archivee for the 'SQL' Category

Google Charts API with PHP

Ludwig Pettersson has written a class that allows you to conveniently create charts with PHP and Google Charts API.
Google Charts is a simple API that lets you create various types of charts. To create a chart, you just need to call a URL with specific parameters and you receive an image back.

This is greatly simplified with a PHP class.


$data = array(
'IE7' => 22,
'IE6' => 30.7,
'IE5' => 1.7,
'Firefox' => 36.5,
'Mozilla' => 1.1,
'Safari' => 2,
'Opera' => 1.4,
);

$chart = new googChart();
$chart->setChartAttrs( array(
'type' => 'pie',
'data' => $data,
'size' => array( 300, 200 )
));
echo $chart;

Die Ausgabe:
Chart

Calculating Distance with SQL

It sometimes makes work a bit easier when you calculate certain operations directly with SQL.
A practical example is the calculation of distances. In some projects I calculated this with PHP.

It can also be done directly with SQL
SELECT *, SQRT(POW(L2.lat - L1.lat, 2) + POW(L2.lng - L1.lng, 2)) AS Distance

Via