How to show numbers of sql queries tables on the footer

unicornio · Involved Joined: Aug 13, 2009 Posts: 432

Does anyone know what is the code to get the numbers of tables from PHPmyadmin

I tried but it gives me 0

Shocked

Raven · Posted: Wed Sep 30, 2009 5:11 pm

The number of queries or the number of tables?

unicornio · Involved Joined: Aug 13, 2009 Posts: 432

Yeah I wanna show the number of tables on the footer. Thanks in advance

unicornio · Involved Joined: Aug 13, 2009 Posts: 432

bump

xGSTQ · Involved Joined: Feb 03, 2006 Posts: 267 Location: UK

well im not sure of the process to add the sql queries in total, that's a nuke evolution feature by default and not ravens nuke, in fact im not sure its possible to do with ravens nuke, but ill show you how to add the time load in seconds instead ! lol

in your theme.php find functionfooter() {

add to the globals

$total_time and $start_time

now add this code

Code:

$mtime = microtime();
$mtime = explode(" ",$mtime);
$mtime = $mtime[1] + $mtime[0];
$end_time = $mtime;
$total_time = ($end_time - $start_time);
$total_time = "".substr($total_time,0,5)." "._SECONDS."";

now if you want to call the page load in seconds simply add

Page Generation: $total_time to your theme footer

That will display Page Generation: 0.088 Seconds counting the time to load the page !

Have fun

Palbin · Posted: Mon Oct 05, 2009 7:38 am

We have added some logic to display "ALL" queries at the bottom of the page when enabled for admins only. I know that is not what you want.

Why do you want to see the number of tables queried?

xGSTQ · Involved Joined: Feb 03, 2006 Posts: 267 Location: UK

What is "apge" bud

I can only presume he has seen the feature in Nuke Evolution and wants to replicate it... it is rather mundane though I agree, I cant see the point for it either.

Palbin · Posted: Mon Oct 05, 2009 8:43 am

xGSTQ wrote:

What is "apge" bud

I can only presume he has seen the feature in Nuke Evolution and wants to replicate it... it is rather mundane though I agree, I cant see the point for it either.

It was supposed to be "page" Wink

(corrected)

unicornio · Involved Joined: Aug 13, 2009 Posts: 432

Palbin. I just want to know know what kind of codes I have to use to show the numbers of tables from phpMyadmin. I would like to know. Just simple.

Thank xGSTQ but I know already that one. Thanks anyway. I want to get the numbers of my tables on the botton.

??

duck · Involved Joined: Jul 03, 2006 Posts: 267

Here you can copy and paste this function where you may need it (ie mainfile.php or in your theme.php) and then call and echo its results:

Code:

function tablecount(){
global $db, $dbname;
if(!empty($dbname)){
   $sql = "SHOW TABLES FROM $dbname";
   $result = $db->sql_query($sql);
   $numtables = $db->sql_numrows($result);
   $db->sql_freeresult($result);
   return $numtables;
}
}

unicornio · Involved Joined: Aug 13, 2009 Posts: 432

Thanks for your help duck but what u mean to call an echo, from where?

Raven · Posted: Tue Oct 06, 2009 12:41 am

His function returns the number of tables in $numtables. So you would call the function like: $numtables = tablecount($dbname);

Then to display it on your page you would echo the response: echo $numtables;

$numtables = tablecount($dbname);
echo $numtables;

Or you could just do: echo tablecount($dbname);

unicornio · Involved Joined: Aug 13, 2009 Posts: 432

Thanks Raven for taking the time but I am a little confused with that. Can you be a little more specific but I tried but it doesnt show on the footer.

I dont know if I have to use this function on mainfile or in footer.php.
Shocked

How could be done if I wanna use it on footer instead of mainfile.php

xGSTQ · Involved Joined: Feb 03, 2006 Posts: 267 Location: UK

I would place it in your theme.php and call it in the function themefooter()

Were presuming since you knew how to add the time that you would be able to add this one as well, that's why they haven't explained it so well... all it is is a simple print to screen now, duck has done the hard part of connecting with the DB

zip up your theme.php or have another go, its not actually as hard as you think

duck · Involved Joined: Jul 03, 2006 Posts: 267

Sorry as xGSTQ said I assumed you would be familiar and comfortable enough with adding functions since you'd seem to have done it before.

You could modify the function itself to straight echo out results but i thought writing it this way is a little more versatile in case later you'd like to do something with the results like manipulate the number etc.

Anyway as xGSTQ said you could paste this in your theme.php file for your theme or even in your mainfile.php or custom_mainfile for that matter.

To make things simple I would say paste it right before the closing PHP tag. ?>

Now in your footer.php (or theme.php if your footer function is echoed there) you would add the call function and echo as Raven pointed out. Do note I have modified the function slightly for you so as to not have to send the dbname when calling. So use the updated function instead. then where you want the table count to show add the following lines like so:

Code:

echo "Total Tables in DB = ".tablecount();