/* rptWriterListFields.php - 06/03/04 - \prgs\masterdb - Displays list of fields for a table
Summary:
Directory:
Input Files:
Output Files:
Preliminaries:
Next steps:
Notes:
To list all fields in admin.fldlst:
/new/rptWriterListTables.php?db=bmf&getFlds=1
Parameters: db = databasename
getFlds = populate table with field names for each table?
*/
session_start();
// $field1 = 'orgname'; // name of field to get focus. Put this line before:
require_once('Bootstrap.php');
$bootstrap = Bootstrap::create();
$pageHdg = 'NCCS Data Web: List Tables';
include($bootstrap->libraryDirectory.'settings.php');
require($bootstrap->libraryDirectory.'proclib.php');
include($bootstrap->libraryDirectory.'head.php');
include($bootstrap->libraryDirectory.'datacon.php');
include($bootstrap->libraryDirectory.'htmLawed.php');
$smallBanner = 1;
include($bootstrap->libraryDirectory.'head2.php');
// DISABLE THIS PROGRAM
if (checkUserAccessRights($gUser, 'SUPER', 1) == 0 or 1) {
return;
}
$db2 = paramOk($_GET['db'],40,'qt');
$sort = paramOk($_GET['sort'],40,'qt');
if (! isset($getFlds)){
$getFlds = paramOk($_GET['getFlds'],1,'qt');
}
$q = 'show databases';
$result = runSql($q);
echo "
Click on a database below to list tables:
\n";
while ($row = mysql_fetch_row($result)) {
$j++;
$k = $row[0];
echo "$k - \n";
}
echo "
";
if ( strlen($db2)>1){
// $query = "select * from $table LIMIT 1";
// mysql_query("use $db2");
mysql_select_db($db2);
$query = 'show table status';
$result = mysql_query($query) or die("Query failed: ".$query.'
'. mysql_error());
// $result = mysql_list_tables($db2);
if (!$result) {
echo "DB Error, could not list tables\n";
echo 'MySQL Error: ' . mysql_error();
exit;
}
/***********************************************************/
// sort by date:
$j = 0;
$k = array();
$dateSize = array();
$createDate = array();
$modDate = array();
$rowSize = array();
$fileSize = array();
while ($row = mysql_fetch_row($result)) {
$k[$j] = $row[0];
// number of date chars to show:
$dateSize = 10;
$createDate[$j] = substr($row[11],0,$dateSize);
$modDate[$j] = substr($row[12],0,$dateSize);
$numRecs[$j] = number_format($row[4]);
$rowSize[$j] = number_format($row[5]);
$fileSize[$j] = $row[6];
$numFields[$j] = $row[2];
if ($j == 10){
// print_r($row);
}
$j++;
}
if ( preg_match('/create/i', $sort)){
array_multisort($createDate, SORT_DESC, $modDate, $numRecs, $rowSize, $fileSize, $k, $numFields);
} elseif ( preg_match('/(mod|edit)/i', $sort)){
array_multisort($modDate, SORT_DESC, $createDate, $numRecs, $rowSize, $fileSize, $k, $numFields);
} elseif ( preg_match('/size/i', $sort)){
array_multisort($fileSize,SORT_DESC, $modDate, $createDate, $numRecs, $rowSize, $k, $numFields);
} else {
}
$arSize = count($k);
/***********************************************************/
echo "Tables for $db2, sorted by $sort:
";
$today = date('m/d/Y H:i');
echo $today;
echo " -- SORT BY: ";
echo "Name - \n";
echo "Edit date - \n";
echo "Create date - \n";
echo "Filesize
\n";
echo "";
$j = 0;
echo " | Name | Num.Rec. | Row Size |
File Size | Created | Updated |
";
// Num. Fields |
for ($j=0; $j < $arSize; $j++ ) {
$sk = $k[$j];
$screateDate = $createDate[$j];
$smodDate = $modDate[$j];
$snumRecs = $numRecs[$j];
$srowSize = $rowSize[$j];
$sfileSize = number_format($fileSize[$j]);
$snumFields = $numFields[$j];
$color = 'white';
if ($j % 2 == 0){
$color = '#E0E0E0';
}
// ''.number_format($row[3]).
$sk = "$sk";
echo " | $j. | ".$sk.' | '.
''.$snumRecs.' | '.
''.$srowSize.' | '.
''.$sfileSize.' | '.
''.$screateDate.' | '.
''.$smodDate.' | '.
'
';
// ''.$snumFields.' | '.
}
echo "
";
} else {
echo "Enter the name of a database (eg: nccs) on URL line after 'db=' and reload this page.
";
echo "Example:
/new/rptWriterListTables.php?db=nccs";
}
// mysql_free_result($result);