query = 'SELECT CLICK_X, CLICK_Y FROM CLICKS WHERE CLICK_Y BETWEEN %d AND %d';
$heatmap->maxQuery = 'SELECT MAX(CLICK_Y) FROM CLICKS';
$heatmap->database = 'test';
$heatmap->user = 'test';
$heatmap->password = 'test';
/** Fichiers temporaires / Temporary files */
$heatmap->cache = '.';
/** Fichiers générés / Generated files */
$heatmap->path = '.';
/** Fichier final / Final file */
$heatmap->file = 'resultfromdb-%d.png';
/**
* On force la hauteur finale (attention à la consommation mémoire dans ce cas !)
* Forcing final height (take care of the memory consumption in such case!)
**/
$images = $heatmap->generate(200, 100);
echo 'Résultats/Results: ';
if ($images === false)
{
echo 'error: '.$heatmap->error;
}
else
{
echo '';
print_r($images);
echo '
';
echo '
';
for ($i = 0; $i < $images['count']; $i++)
{
echo '
Image ', $i, '
';
}
echo '
';
}
?>