-
Notifications
You must be signed in to change notification settings - Fork 0
/
dbstats.php
55 lines (45 loc) · 2.57 KB
/
dbstats.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
<?
define('PAGETITLE','Address Book - Stats');
include('site_header.php');
if ($functen['stats']!=1) {fdisabled(); die();}
echo '<center>'.'<h1>'.'Stats'.'</h1>'.'</center>';
$qdb="SELECT COUNT(*) AS c FROM `".$db_table1_name."`;";
$dbo=dbx_query($dbx,$dbxcon,$qdb,$db_name);
$row=dbx_fetch_array($dbx,$dbo);
echo 'Total entries'.': '.$row['c']."<br /><br />";
$cfk='name';
# $qdb="SELECT MIN(LENGTH(".$cfk.")) AS d FROM `".$db_table1_name."`;"; # Get lenght only, without the value
$qdb="SELECT ".$cfk." FROM `".$db_table1_name."` WHERE LENGTH(".$cfk.") IN (SELECT MIN(LENGTH(".$cfk.")) FROM `".$db_table1_name."`);";
$dbo=dbx_query($dbx,$dbxcon,$qdb,$db_name);
$row=dbx_fetch_array($dbx,$dbo);
echo 'Shortest Name'.': '.$row[$cfk].' ('.strlen($row[$cfk]).' '.'characters'.')'."<br /><br />";
$cfk='name';
# $qdb="SELECT MAX(LENGTH(".$cfk.")) AS d FROM `".$db_table1_name."`;"; # Get lenght only, without the value
$qdb="SELECT ".$cfk." FROM `".$db_table1_name."` WHERE LENGTH(".$cfk.") IN (SELECT MAX(LENGTH(".$cfk.")) FROM `".$db_table1_name."`);";
$dbo=dbx_query($dbx,$dbxcon,$qdb,$db_name);
$row=dbx_fetch_array($dbx,$dbo);
echo 'Longest Name'.': '.$row[$cfk].' ('.strlen($row[$cfk]).' '.'characters'.')'."<br /><br />";
$cfk='lname';
# $qdb="SELECT MIN(LENGTH(".$cfk.")) AS d FROM `".$db_table1_name."`;"; # Get lenght only, without the value
$qdb="SELECT ".$cfk." FROM `".$db_table1_name."` WHERE LENGTH(".$cfk.") IN (SELECT MIN(LENGTH(".$cfk.")) FROM `".$db_table1_name."`);";
$dbo=dbx_query($dbx,$dbxcon,$qdb,$db_name);
$row=dbx_fetch_array($dbx,$dbo);
echo 'Shortest Last Name'.': '.$row[$cfk].' ('.strlen($row[$cfk]).' '.'characters'.')'."<br /><br />";
$cfk='lname';
# $qdb="SELECT MAX(LENGTH(".$cfk.")) AS d FROM `".$db_table1_name."`;"; # Get lenght only, without the value
$qdb="SELECT ".$cfk." FROM `".$db_table1_name."` WHERE LENGTH(".$cfk.") IN (SELECT MAX(LENGTH(".$cfk.")) FROM `".$db_table1_name."`);";
$dbo=dbx_query($dbx,$dbxcon,$qdb,$db_name);
$row=dbx_fetch_array($dbx,$dbo);
echo 'Longest Last Name'.': '.$row[$cfk].' ('.strlen($row[$cfk]).' '.'characters'.')'."<br /><br />";
$cfk='bday';
$qdb="SELECT MIN(".$cfk.") AS d FROM `".$db_table1_name."`;";
$dbo=dbx_query($dbx,$dbxcon,$qdb,$db_name);
$row=dbx_fetch_array($dbx,$dbo);
echo 'Oldest Birthday'.': '.dateread($row['d'])."<br /><br />";
$cfk='bday';
$qdb="SELECT MAX(".$cfk.") AS d FROM `".$db_table1_name."`;";
$dbo=dbx_query($dbx,$dbxcon,$qdb,$db_name);
$row=dbx_fetch_array($dbx,$dbo);
echo 'Earliest Birthday'.': '.dateread($row['d'])."<br /><br />";
include('site_footer.php');
?>