PTM Logo Version 0.5.1 Beta
Home    SVN    Downloads    Documentation    Forum    Contact
This Site is 100%
Powered by PTM

SourceForge.net Logo
Documentation
I   Index
II   GNU GPL
III   Description
IV   Installation
V   Language Overview
VI   Tags
VII   Variables
VIII   Functions
IX   Modules
  PTMDB
      • db_add_row()
      • db_add_row_hash()
      • db_create_database()
      • db_create_table()
      • db_connect()
      • db_disconnect()
      • db_delete_row()
      • db_delete_row_like()
      • db_delete_row_where()
      • db_drop_database()
      • db_drop_table()
      • db_get_column_count()
      • db_get_column_stats()
      • db_get_columns()
      • db_get_databases()
      • db_get_index_stats()
      • db_get_indexes()
      • db_get_process_stats()
      • db_get_row()
      • db_get_row_count()
      • db_get_row_count_like()
      • db_get_row_count_where()
      • db_get_row_hash()
      • db_get_row_hash_like()
      • db_get_row_hash_where()
      • db_get_row_hashes()
      • db_get_row_hashes_like()
      • db_get_row_hashes_where()
      • db_get_row_like()
      • db_get_row_where()
      • db_get_rows()
      • db_get_rows_like()
      • db_get_rows_where()
      • db_get_table_stats()
      • db_get_tables()
      • db_select_database()
      • db_query()
      • db_update_row()
      • db_update_row_hash()
      • db_update_row_hash_like()
      • db_update_row_hash_where()
      • db_update_row_like()
      • db_update_row_where()
  RSS20
Documentation
View / Download this file.
--------------------------------------------
PTMDB MODULE - db_get_table_stats() FUNCTION
--------------------------------------------

  ------------
  USAGE FORMAT
  ------------

    Where @stats is a returned array of array references:

    @stats = &db_get_table_stats($db_object);
    @stats = &db_get_table_stats($db_object, $db_name);

  -----------
  DESCRIPTION
  -----------

    Retrieves table statistics from a given database. If a database has already
    been selected, the only required parameter is the database object. If a
    database has not been selected, or you wish to list tables from another
    database, a database name is required as well. Returns an array of array
    references, each containing table information.

  ---------
  ARGUMENTS
  ---------

    $db_object

      REQUIRED

      A database handler object. This object stores connection information and
      is returned from a db_connect() function call. This object is of the same
      type as is returned by a DBI->connect function call.

    $db_name

      OPTIONAL / REQUIRED

      The name of the database from which to pull table statistics. This is only
      required if a database has not yet been selected using the
      db_select_database() function or an SQL 'USE' statement, or alternately if
      you wish to pull table stats from a different database than the one
      currently selected.

  -------
  RETURNS
  -------

    An array of array references. Each array reference contains table
    information. This information can vary depending on database type.
    See your database documentation for the "SHOW TABLE STATUS" SQL query.
    MySQL, for example, returns table information in the following order:

      Table Name, Engine, Version, Row Format, Row Count,
      Avg Row Length (bytes), Data Length (bytes), Max Data Length (bytes),
      Index Length (bytes), Data Free, Auto-Increment, Creation Time,
      Update Time, Check Time, Collation, Checksum, Create Options, Comment

  --------
  SEE ALSO
  --------

    MODULES

      PTMDB

    FUNCTIONS

      PTMDB - db_select_database()
Home    SVN    Downloads    Documentation    Forum    Contact