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_indexes() FUNCTION
----------------------------------------

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

    Where @indexes is the returned list of Index columns/fields:

    @indexes = &db_get_indexes($db_object, $table_name);
    @indexes = &db_get_indexes($db_object, $table_name, $db_name);

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

    Retrieves a list of Index column headers from a given database table. If a
    database has already been selected, the only required parameters are the
    database object and a table name. If a database has not been selected, or
    you wish to list Index column names from a table in another database, a
    database name is required as well. Returns an array containing the Index
    column header names from the given database (based on MySQL "SHOW INDEXES"
    return format).

  ---------
  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.

    $table_name

      REQUIRED

      The name of the table from which you would like to pull Index column
      headers.

    $db_name

      OPTIONAL / REQUIRED

      The name of the database from which to pull table Indexes. 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 column headers from a different database than the
      one currently selected.

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

    A list (array) containing the Index column header names from the selected
    table in the order in which they were returned from the database server.

  --------------
  USAGE EXAMPLES
  --------------

    ------------------------------------------------------------------
    Example 1: Display the Index Column Names from the Table 'MyTable'
    ------------------------------------------------------------------

      <?= join(', ', &db_get_indexes($dbobj, 'MyTable')) =?>
Home    SVN    Downloads    Documentation    Forum    Contact