function ColNames($tbl, $db_name) { global $db, $current_col_count; global $one_gig_a, $one_gig_z, $two_gig_a, $two_gig_z; $col_names = ""; $current_col_count = 0; $query = "sp_columns {$tbl}"; $result = @sqlsrv_query($db, $query); if (FALSE == $result) { $err_msg = get_sql_error(); print "\r\n"; print "In database: " . $db_name . "\r\n"; print "Can not query table: " . $tbl . "\r\n"; print $err_msg . "\r\n"; return -1; } do { while ($row = sqlsrv_fetch_array($result)) { $name = trim($row[3]); $dtype = trim($row[5]); $precision = intval(trim($row[6])); if ($precision >= $one_gig_a && $precision <= $one_gig_z) { $precision = "1 Gig"; } if ($precision >= $two_gig_a && $precision <= $two_gig_z) { $precision = "2 Gigs"; } if ($precision > $one_gig_a) { $precision = number_format($precision); } $length = trim($row[7]); if ($length >= $one_gig_a && $length <= $one_gig_z) { $length = "1 Gig"; } if ($length >= $two_gig_a && $length <= $two_gig_z) { $length = "2 Gigs"; } if ($length > $one_gig_a) { $length = number_format($length); } //$nullable = trim($row[10]); $column_def = trim($row[12]); $is_nullable = trim($row[17]); if (0 == strlen($is_nullable)) { $is_nullable = "UNKNOWN"; } $current_col_count += 1; if (strlen($name) <= 7) { $tab = "\t\t\t\t\t"; } elseif (strlen($name) <= 15) { $tab = "\t\t\t\t"; } elseif (strlen($name) <= 23) { $tab = "\t\t\t"; } elseif (strlen($name) <= 31) { $tab = "\t\t"; } else { $tab = "\t"; } $last_comma = strlen($column_def) ? ", def: " : ""; $col_names = sprintf("%s\r\n%s%s%s, %s, %s [%s]%s %s", $col_names, $name, $tab, $dtype, $is_nullable, $precision, $length, $last_comma, $column_def); } } while (sqlsrv_next_result($result)); sqlsrv_free_stmt($result); $col_names = substr($col_names, strlen("\r\n")) . "\r\n\r\n"; return $col_names; }
function RowCount($tbl, $db_name) { global $db; $query = "select count(*) from {$tbl}"; $result = @sqlsrv_query($db, $query); if (FALSE == $result) { $err_msg = get_sql_error(); print "\n"; print "In database: " . $db_name . "\n"; print "Can not query table: " . $tbl . "\n"; print $err_msg . "\n"; print "Will return -1 for the # of rows, but this will not effect overall row counts.\n\n"; return -1; } do { while ($row = sqlsrv_fetch_array($result)) { $count = $row[0]; } } while (sqlsrv_next_result($result)); sqlsrv_free_stmt($result); return $count; }