ingres_set_environment
(PECL ingres >= 1.2.0)
ingres_set_environment — Set environment features controlling output options
Description
$link
, array $options
)ingres_set_environment() is called to set environmental options that affect the output of certain values from Ingres, such as the timezone, date format, decimal character separator, and float precision.
Parameters
-
link
-
The connection link identifier
options
-
An enumerated array of option name/value pairs. The following table lists the option name and the expected type
Option name Option type Description Example date_century_boundary integer The threshold by which a 2-digit year is determined to be in the current century or in the next century. Equivalent to II_DATE_CENTURY_BOUNDARY 50 timezone string Controls the timezone of the session. If not set, it will default the value defined by II_TIMEZONE_NAME. If II_TIMEZONE_NAME is not defined, NA-PACIFIC (GMT-8 with Daylight Savings) is used. UNITED-KINGDOM date_format integer Sets the allowable input and output format for Ingres dates. Defaults to the value defined by II_DATE_FORMAT. If II_DATE_FORMAT is not set, the default date format is US, for example mm/dd/yy. Valid values for date_format are:
- INGRES_DATE_DMY
- INGRES_DATE_FINISH
- INGRES_DATE_GERMAN
- INGRES_DATE_ISO
- INGRES_DATE_ISO4
- INGRES_DATE_MDY
- INGRES_DATE_MULTINATIONAL
- INGRES_DATE_MULTINATIONAL4
- INGRES_DATE_YMD
- INGRES_DATE_US
INGRES_DATE_ISO4 decimal_separator string The character identifier for decimal data "," money_lort integer Leading or trailing currency sign. Valid values for money_lort are:
- INGRES_MONEY_LEADING
- INGRES_MONEY_TRAILING
INGRES_MONEY_LEADING money_sign string The currency symbol to be used with the MONEY datatype € money_precision integer The precision of the MONEY datatype 2 float4_precision integer Precision of the FLOAT4 datatype 10 float8_precision integer Precision of the FLOAT8 data 10 blob_segment_length integer The amount of data in bytes to fetch at a time when retrieving BLOB or CLOB data. Defaults to 4096 bytes when not set explicitly 8192
Return Values
Returns TRUE
on success or FALSE
on failure.
Examples
Example #1 Set date_format to ISO4
<?php
$options = array( "date_format" => INGRES_DATE_ISO4 );
if (ingres_set_environment($link, $options))
{
$result=ingres_query($link,"select date('now') as date");
while ( $object = ingres_fetch_object ($result) ) {
echo $object->date."\n";
}
}
?>
Example #2 Set timezone to HONG-KONG
<?php
$options = array( "timezone" => "HONG-KONG");
if (ingres_set_environment($link, $options))
{
$result=ingres_query($link,"select date('now') as date");
while ( $object = ingres_fetch_object ($result) ) {
echo $object->date."\n";
}
}
?>
See Also
- ingres_connect() - Open a connection to an Ingres database
- ingres_query() - Send an SQL query to Ingres
- PHP Руководство
- Функции по категориям
- Индекс функций
- Справочник функций
- Расширения для работы с базами данных
- Расширения для работы с базами данных отдельных производителей
- Ingres DBMS, EDBC, and Enterprise Access Gateways
- ingres_autocommit_state
- ingres_autocommit
- ingres_charset
- ingres_close
- ingres_commit
- ingres_connect
- ingres_cursor
- ingres_errno
- ingres_error
- ingres_errsqlstate
- ingres_escape_string
- ingres_execute
- ingres_fetch_array
- ingres_fetch_assoc
- ingres_fetch_object
- ingres_fetch_proc_return
- ingres_fetch_row
- ingres_field_length
- ingres_field_name
- ingres_field_nullable
- ingres_field_precision
- ingres_field_scale
- ingres_field_type
- ingres_free_result
- ingres_next_error
- ingres_num_fields
- ingres_num_rows
- ingres_pconnect
- ingres_prepare
- ingres_query
- ingres_result_seek
- ingres_rollback
- ingres_set_environment
- ingres_unbuffered_query
Коментарии
404 Not Found