------------------------------------------------ PTMDB MODULE - db_get_row_hashes_like() FUNCTION ------------------------------------------------ ------------ USAGE FORMAT ------------ Where @rows is a returned array of hash references: @rows = &db_get_row_hashes_like($db_object, $table); @rows = &db_get_row_hashes_like($db_object, $table, $column, $value); @rows = &db_get_row_hashes_like($db_object, $table, $column, $value, $sort_column); @rows = &db_get_row_hashes_like($db_object, $table, $column, $value, $sort_column, $descending); @rows = &db_get_row_hashes_like($db_object, $table, $column, $value, $sort_column, $descending, $count); @rows = &db_get_row_hashes_like($db_object, $table, $column, $value, $sort_column, $descending, $low_limit, $count); ----------- DESCRIPTION ----------- Based on db_get_rows_like(), fetches rows from a given database table. If no $column/$value pair is set, "1" is put in its place in the SQL WHERE statement. Set $column and $value to use a `column` LIKE 'value' comparison. Set $sort_column to a column name to sort the results by a given column's values. Set $descending to 1 if $sort_column is in use and you wish to sort in descending order. Set $count to retrieve [up to] a given amount of rows. Set $low_limit (zero-based) and $count to retrieve a particular range of rows. Returns an array of hash references, each of which contains a database table row in column => value pairs Within each hash reference is a key named "_keys" which contains the list of column headers in the order in which they were provided from the database table, and can be used to display columns in the proper order --------- 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 REQUIRED The name of the table from which you would like to pull row information. $column OPTIONAL The column name to use in a `column` LIKE 'value' test comparison. $value OPTIONAL / REQUIRED Only required if $column is specified -- The value to use in a `column` LIKE 'value' comparison. $sort_column OPTIONAL The name of a column to use for sorting. Automatically sorts in ascending order unless $descending is set. $descending OPTIONAL Set this value to 1 if $sort_column has been set and you wish to sort in decending order. $low_limit OPTIONAL The lower limit (zero-based) you would like to start reading from. This option may be left out entirely if you wish to start from the beginning of the returned rows. $count OPTIONAL The number of rows you wish to pull from the database. If no value is specified for $count all matched rows will be read. ------- RETURNS ------- An array of hash references. Each hash reference contains one row's contents in column => value pair format. Within each hash reference is a key named "_keys" which contains a reference to a list of column headers in the order in which they were provided from the database table, and can be used to display the columns in the proper order, as these column headers are used to name the hash keys. Sample Return Value, Internal Format: @rows = ( { _keys => ['col1', 'col2', 'col3'], col1 => 'val1', col2 => 'val2', col3 => 'val3' }, { _keys => ['col1', 'col2', 'col3'], col1 => 'val4', col2 => 'val5', col3 => 'val6' }, { _keys => ['col1', 'col2', 'col3'], col1 => 'val7', col2 => 'val8', col3 => 'val9' } ); -------------- USAGE EXAMPLES -------------- ----------------------------------------------------- Example 1: Print First 5 Rows with Column Names from 'MyTable' Where 'name' Begins with 'M' ----------------------------------------------------- {_keys}}) { print("$col: " . $row->{$col} . "
\n"); } print("
\n"); } ?> -------- SEE ALSO -------- MODULES PTMDB FUNCTIONS PTMDB - db_connect() PTMDB - db_get_column_count() PTMDB - db_get_columns() PTMDB - db_get_row_count() PTMDB - db_get_rows_like() PTMDB - db_get_row_hashes() PTMDB - db_get_row_hashes_where()