note 13636 deleted from ref.image by victor
| From: | victor@php.net | Date: | Mon, 09 Dec 2002 18:33:36 +0000 |
| Subject: | note 13636 deleted from ref.image by victor | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-40580@lists.php.net to get a copy of this message | ||
<html>
<head>
</head>
<body>
<?
// USING A DATABASE TO CREATE BARS OF RECORS GROUP BY FIELD PROMOCION
// DIAA = DATABASE TABLE / PROMOCION = FIELD FILLED WITH YEAR VALUE ( NUMERIC )
// USING ImageGif, ONLY AVAILABLE IN MY SERVER, YOU CAN USE PNG
// OPEN DATABASE
mysql_pconnect("localhost","user","password") or die("Unable to
connect to SQL server");
mysql_select_db("database") or die("Unable to select database");
// SELECT AND FILL VALUES
$varsqlstr = "SELECT * FROM DIAAA ORDER BY PROMOCION ";
$result = mysql_query($varsqlstr);
$row = mysql_fetch_array($result);
//INITIALIZE VARS
$CUENTA = 0;
$TOTAL = 0;
$PROMO = $row[PROMOCION];
// LOOP TO COUNT AND PRINT ( IF CONDITION )
for ($i = 1; $i <= (mysql_num_rows($result) + 1) ; $i++){
if ($PROMO == $row[PROMOCION]) {
$CUENTA = $CUENTA + 1;
$row = mysql_fetch_array($result);
} else {
$CUENTA2 = $CUENTA * 5;
$pic=ImageCreate(&$CUENTA2,10);
$col1=ImageColorAllocate($pic,200,200,200);
$col2=ImageColorAllocate($pic,0,127,192);
ImageFilledRectangle($pic,0,0,&$CUENTA2,10,$col2);
ImageGif($pic, $PROMO . ".gif");
ImageDestroy($pic);
echo '<img src="' . $PROMO . '.gif" border=2> <FONT
face=Arial size=2> ' . $CUENTA . ' Ptos. / Prom. ' . $PROMO .
'</FONT><BR>';
$TOTAL= $TOTAL + $CUENTA;
$CUENTA = 0;
$PROMO = $row[PROMOCION];
$CUENTA = $CUENTA + 1;
$row = mysql_fetch_array($result);
}
}
mysql_free_result($result);
?>
</body>
</html>