function PrintRowCount($now, $db_name, $tables, $max_len)
{
global $db_server, $line, $output_file, $using_output_file, $fp;
global $db_file_size, $line, $hdr, $current_col_count;
$db_file_size = 0;
$metadata = GetDatabaseMetaData($db_name);
$fname = $metadata[0];
$db_file_size = $metadata[1];
fwrite($fp, "\r\n");
fwrite($fp, "=============================================================================\r\n");
fwrite($fp, "date : " . $now . "\r\n");
fwrite($fp, "server : " . $db_server . "\r\n");
fwrite($fp, "database : " . $db_name . "\r\n");
fwrite($fp, "# of tables : " . sizeof($tables) . "\r\n");
fwrite($fp, "=============================================================================\r\n");
if ($db_file_size >= 0) {
fwrite($fp, "file path : " . $fname . "\r\n");
fwrite($fp, "file size : " . number_format($db_file_size) . "\r\n");
}
fwrite($fp, "\r\n");
fwrite($fp, $hdr . "\r\n\r\n");
$total_cols = 0;
foreach ($tables as $t) {
$count = ColNames($t, $db_name);
$line_tbl_name = substr("-------------------------------------------------------------------------------", 0, strlen($db_name) + 1 + strlen($t) + 5 + strlen($current_col_count));
fwrite($fp, $line_tbl_name . "\r\n");
fwrite($fp, $db_name . "." . $t . " { " . $current_col_count . " }\r\n");
fwrite($fp, $line_tbl_name . "\r\n");
fwrite($fp, "{$count}\r\n");
$total_cols += intval($current_col_count);
}
fwrite($fp, "\r\n");
fflush($fp);
return $total_cols;
}
function PrintRowCount($now, $db_name, $tables, $max_len)
{
global $db_server, $line, $output_file, $using_output_file, $fp;
global $db_file_size;
$db_file_size = 0;
$metadata = GetDatabaseMetaData($db_name);
$fname = $metadata[0];
$db_file_size = $metadata[1];
fwrite($fp, "\n");
fwrite($fp, "date : " . $now . "\n");
fwrite($fp, "server : " . $db_server . "\n");
fwrite($fp, "database : " . $db_name . "\n");
fwrite($fp, "# of tables : " . sizeof($tables) . "\n");
if ($db_file_size >= 0) {
fwrite($fp, "file path : " . $fname . "\n");
fwrite($fp, "file size : " . number_format($db_file_size) . "\n");
}
fwrite($fp, "\n");
fwrite($fp, "rows\t\ttable name\n");
$short_line = substr($line, 0, $max_len);
fwrite($fp, "====\t\t{$short_line}\n");
$total_rows = 0;
foreach ($tables as $t) {
$count = RowCount($t, $db_name);
if ($count >= 1000000) {
fwrite($fp, number_format($count) . "\t{$t}\n");
} else {
fwrite($fp, number_format($count) . "\t\t{$t}\n");
}
// -1 is returned when an error occurs, but don't want to skew the results
if (-1 == $count) {
$count = 0;
}
$total_rows += intval($count);
}
fwrite($fp, "===================={$short_line}\n");
fwrite($fp, number_format($total_rows) . " total rows.\n");
fwrite($fp, "\n");
fwrite($fp, "{$line}\n{$line}\n");
fflush($fp);
return $total_rows;
}
