signups.inc

不错的东西

<fieldset>
<legend>Signup Report</legend>
<?php
$query = $sql->query("SELECT MONTH(a.date) AS month, COUNT(a.id) AS signups FROM accounts AS a LEFT JOIN packages AS b ON (a.package = b.id) WHERE b.pkg_type = '1' GROUP BY MONTH(a.date)");
while($data = mysql_fetch_assoc($query))
{
	$accounts[$data['month']]['free'] = $data['signups'];
}

$query = $sql->query("SELECT MONTH(a.date) AS month, COUNT(a.id) AS signups FROM accounts AS a LEFT JOIN packages AS b ON (a.package = b.id) WHERE b.pkg_type IN ('2', '3') GROUP BY MONTH(a.date)");
while($data = mysql_fetch_assoc($query))
{
	$accounts[$data['month']]['paid'] = $data['signups'];
}

?>

<table width="20%">
<tr style="font-weight: bold;">
	<td>Month</td>
	<td align="center">Free</td>
	<td align="center">Paid</td>
</tr>

<?php
for($i = 1; $i < 13; $i++)
{
	?>

	<tr<?=($i == date("n")) ? " style=\"font-weight: bold;\"" : NULL?>>
	<td><?=date("F", mktime(0, 0, 0, $i, 1, date("Y")))?></td>
	<td align="center"><?=(isset($accounts[$i]['free'])) ? $accounts[$i]['free'] : 0?></td>
	<td align="center"><?=(isset($accounts[$i]['paid'])) ? $accounts[$i]['paid'] : 0?></td>
	</tr>

	<?php
}
?>
</table>
</fieldset>