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

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

    Where $ret is a return value of 1 or 0 (zero):

    $ret = &db_update_row_hash_like($db_object, $table, $column, $value,
                               \%column_value_pairs);
    $ret = &db_update_row_hash_like($db_object, $table, $column, $value,
                               {$col1=>$val1, $col2=>$val2});

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

    Updates a given database table row where $column LIKE $value.
    The intended use of this function is to allow updating a row with only
    certain column fields filled in without having to define every field.
    Returns 1 if successful
    Returns 0 (zero) if not successful

  ---------
  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 in which you would like to update row information.

    $column

      REQUIRED

      The column name to use in a `column` LIKE 'value' test comparison.

    $value

      REQUIRED

      The value to use in a `column` LIKE 'value' test comparison.

    \%column_value_pairs

      REQUIRED

      A hash reference containing the reqested field column => value quantifier
      pairs. This may be either a direct hash reference or an inline Perl hash
      reference defined in {$column => $value} format.

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

    1 if row was updated successfully
    0 (zero) if row was not updated successfully or no row matches were found.

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

    -----------------------------------------------------------------
    Example 1: Update a Row in 'MyTable' Where 'name' Begins with 'M'
    -----------------------------------------------------------------

      <?
        $ret = &db_update_row_hash_like($dbobj, 'MyTable', 'name', 'm%',
                                        {'name'=>'John'});
      ?>

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

    MODULES

      PTMDB

    FUNCTIONS

      PTMDB - db_connect()
      PTMDB - db_update_row_hash()
      PTMDB - db_update_row_hash_where()
      PTMDB - db_update_row_like()
Home    SVN    Downloads    Documentation    Forum    Contact