View / Download this file.
-----------------------------------------
PTMDB MODULE - db_add_row_hash() FUNCTION
-----------------------------------------
------------
USAGE FORMAT
------------
Where $ret is a return value of 1 or 0 (zero):
$ret = &db_add_row_hash($db_object, $table, \%column_value_pairs);
$ret = &db_add_row_hash($db_object, $table, {$col1=>$val1, $col2=>$val2});
-----------
DESCRIPTION
-----------
Adds a row to a given database table from a hash reference with
column => value pairs.
The intended use of this function is to allow adding 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 to which you would like to add row information.
\%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 added successfully
0 (zero) if row was not added successfully.
--------------
USAGE EXAMPLES
--------------
-----------------------------------------------------------------
Example 1: Add a New Row with 'id' and 'name' Values to 'MyTable'
-----------------------------------------------------------------
<?
$ret = &db_add_row_hash($dbobj, 'MyTable', {'id'=>'1', 'name'=>'John'});
?>
--------
SEE ALSO
--------
MODULES
PTMDB
FUNCTIONS
PTMDB - db_connect()
PTMDB - db_add_row()
|