Webpage stats

Junior WebHelper Joined: 15 Apr 2003 Posts: 35

Hi all,

I like the code at the bottom of the page:

Quote:

[ Page generation time: 0.491062 seconds ] :: [ 15 queries executed ]

How can I implement this for my site? I just want to use it to test how fast pages/queries are executed on my server.

Any pointers are much appreciated!

Cheers,

Anil

Team Member Joined: 06 Jan 2002 Posts: 2564

Hi GunstarHero!

This should answer your question:

http://www.phpbuilder.com/columns/akent20000926.php3

Posted: Wed May 07, 2003 3:07 pm (20 years, 11 months ago)

How about the [x queries executed] bit? That article doesn't show how to do that.
Also, how did you get all the other stats on the stats.php page (like top used smily etc (cos atm, I'm using the php_fetch_info script, but it doesn't show that stuff))? Smile

Team Member Joined: 06 Jan 2002 Posts: 2564

There's a very complete statistics script somewhere at phpBB.com and it includes a smilies stats section.

As to executed queries, either your database abstraction layer takes care of it, or you increment a variable everytime you run a query:

Code:

$i = !$i ? 0 : $i;
$i++;

[The database abstraction layer (at least phpBB's) will usually take care of this for you. If it doesn't, all you do is edit the function which runs the query and add a variable to count queries.]

Posted: Wed May 07, 2003 3:19 pm (20 years, 11 months ago)

OK, well I'll have to edit my page_footer file to show the page generation time, and find the SQL query thinggy Wink

Team Member Joined: 06 Jan 2002 Posts: 2564

SfCommand: for phpBB there is already a MOD:

http://www.phpbb.com/mods/downloads/uploads/generation_creation_1.0.0.txt

Junior WebHelper Joined: 15 Apr 2003 Posts: 35

cheers!

Anil