How to show numbers of sql queries tables on the footer

Posted: Wed Sep 30, 2009 4:21 pm

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

I tried but it gives me 0

Shocked

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

The number of queries or the number of tables?

Posted: Thu Oct 01, 2009 12:11 am

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

Posted: Sat Oct 03, 2009 10:44 am

bump

Involved Joined: Feb 03, 2006 Posts: 269

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

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?

Posted: Mon Oct 05, 2009 7:41 am

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.

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)

Posted: Mon Oct 05, 2009 11:43 am

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.

??

Involved Joined: Jul 03, 2006 Posts: 273

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;


   }


}

Posted: Mon Oct 05, 2009 11:57 pm

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

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);

Posted: Tue Oct 06, 2009 1:58 am

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

Posted: Tue Oct 06, 2009 2:24 am

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

Posted: Tue Oct 06, 2009 9:58 am

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();