Jump to content


Photo

count & show amount of records of a mysql table via php


  • Please log in to reply
2 replies to this topic

#1 gf05856

gf05856
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 29 August 2006 - 09:16 PM

Dear,

I am looking for a php script that gives me the following output based on the amount of records in a particular mysql table:

Fixed output table with 2 columns, 1 column with the numbers 2, 4, 8, 16, 32 .... 1.073.741.824 and a second column that should be filled out with a color based on the amount of records in the mysql table ...

Like you see below there are 7 records in the database ( the | should be replaced by a color).  If you have any ideas on how to visualise this in a better way, then please be my guest! Also the total amount should be show as an amount like .... Total users: 123456

I probably should also consider the fact that when I have 10.000 hits a day on this site that this script is not run 10.000 times back and forward to the database ... but once a day ... and stored.

records    column to fill up

2            |||||||||||||||
4            |||||||||||||||
8            |||||||||||||
16
32
64
128
256
512
1.024
2.048
4.096
8.192
........

#2 hitman6003

hitman6003
  • Members
  • PipPipPip
  • Advanced Member
  • 1,807 posts

Posted 29 August 2006 - 09:29 PM

<?php
$query = "SELECT COUNT(*) FROM table";

$result = mysql_query($query) or die(mysql_error());
$count = mysql_result($result, 0);

echo '
	<table border="1">
		<tr>
			<th>Number</th>
			<th>&nbsp;</th>
		</tr>';
for ($i = 1; $i <= 10; $i++) {
	$n = pow(2, $i);

	echo '
		<tr>
			<td>' . $n . '</td>';
	
	if ($count >= $n) {
		echo '
			<td style="background-color: red;">&nbsp;</td>';
	} else {
		echo '
			<td>&nbsp;</td>';
	}
	
	echo '
		</tr>';
}

echo '
	</table>';
?>


#3 gf05856

gf05856
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 29 August 2006 - 09:55 PM

Thanks,

It works very nicely.

I can certainly use it as a basis and adjust it to my needs.

For writing this myself ... it would have taken me .... 1.073.741.824 seconds

Thanks again.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users