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