Pages Database Statistics

[+Morrigan 1,636]

It would be awesome (and I know a mod could make it and I may just code it myself if necessary) if there was a 'statistics' widget for pages databases. Basically like other statistics widgets where if gives you the number of records (using the databases record lingo) number of comments and latest record.

[+hawksfan 37]

Bumping this to the top...

Were you ever able to find or create a solution for this?

[+Morrigan 1,636]

I have not but it's on my to-do list.

[PersonalMode 22]

I Try to find this to. Add number of records in a database.

I try this but ... no....

{number=$stats"['total_database']"}

 

[+PedroNL 36]

+1

[PersonalMode 22]

I used a "barbaric" method to display the number

Create a Custom PHP block with this code

$link = mysql_connect("localhost", "user", "pass");
mysql_select_db("base", $link);

$res = mysql_query("SELECT COUNT(1) FROM database-table", $link);
$row = mysql_fetch_row($res);
echo $row[];

And I add the block at the place to show number

 

If someone have better idea.

[+ibaker 78]

Has anyone been able to create a Statistics block for a database page?

[+Morrigan 1,636]

Wow! Talk about a blast from the past... Holy hell.

I gave up and just decided it wasn't worth it. Plus I no longer use comments as much as I use reviews.