Das Verhalten von PHP beeinflussen

Transcrição

Look@ http://www.php.net/ and http://www.selfphp.de/funktionsreferenz/index.php
Das Verhalten von PHP beeinflussen
APC — Alternative PHP Cache
Predefined Constants ¶
The constants below are defined by this extension, and will only be available when the extension has either been compiled into PHP or dynamically loaded at
runtime.
APC_BIN_VERIFY_CRC32 (integer)
APC_BIN_VERIFY_MD5 (integer)
APC_ITER_ALL (integer)
APC_ITER_ATIME (integer)
APC_ITER_CTIME (integer)
APC_ITER_DEVICE (integer)
APC_ITER_DTIME (integer)
APC_ITER_FILENAME (integer)
APC_ITER_INODE (integer)
APC_ITER_KEY (integer)
APC_ITER_MD5 (integer)
APC_ITER_MEM_SIZE (integer)
APC_ITER_MTIME (integer)
APC_ITER_NONE (integer)
APC_ITER_NUM_HITS (integer)
APC_ITER_REFCOUNT (integer)
APC_ITER_TTL (integer)
APC_ITER_TYPE (integer)
APC_ITER_VALUE (integer)
APC_LIST_ACTIVE (integer)
APC_LIST_DELETED (integer)
Aktualisiert am 08.03.2014
APC Functions
apc_add — Cache a new variable in the data store
apc_bin_dump — Get a binary dump of the given files and user variables
apc_bin_dumpfile — Output a binary dump of cached files and user variables to a file
apc_bin_load — Load a binary dump into the APC file/user cache
apc_bin_loadfile — Load a binary dump from a file into the APC file/user cache
apc_cache_info — Retrieves cached information from APC's data store
apc_cas — Updates an old value with a new value
apc_clear_cache — Clears the APC cache
apc_compile_file — Stores a file in the bytecode cache, bypassing all filters.
apc_dec — Decrease a stored number
apc_define_constants — Defines a set of constants for retrieval and mass-definition
apc_delete_file — Deletes files from the opcode cache
apc_delete — Removes a stored variable from the cache
apc_exists — Checks if APC key exists
apc_fetch — Fetch a stored variable from the cache
apc_inc — Increase a stored number
apc_load_constants — Loads a set of constants from the cache
apc_sma_info — Retrieves APC's Shared Memory Allocation information
apc_store — Cache a variable in the data store
APD — Advanced PHP debugger
Constant
FUNCTION_TRACE (integer)
ARGS_TRACE (integer)
ASSIGNMENT_TRACE (integer)
STATEMENT_TRACE (integer)
MEMORY_TRACE (integer)
TIMING_TRACE (integer)
Value
1
2
4
8
16
32
SUMMARY_TRACE (integer)
ERROR_TRACE (integer)
PROF_TRACE (integer)
APD_VERSION (string)
64
128
256
example: 1.0.2-dev
APD Functions
apd_breakpoint — Stops the interpreter and waits on a CR from the socket
apd_callstack — Returns the current call stack as an array
apd_clunk — Throw a warning and a callstack
apd_continue — Restarts the interpreter
apd_croak — Throw an error, a callstack and then exit
apd_dump_function_table — Outputs the current function table
apd_dump_persistent_resources — Return all persistent resources as an array
apd_dump_regular_resources — Return all current regular resources as an array
apd_echo — Echo to the debugging socket
apd_get_active_symbols — Get an array of the current variables names in the local scope
apd_set_pprof_trace — Starts the session debugging
apd_set_session_trace_socket — Starts the remote session debugging
apd_set_session_trace — Starts the session debugging
apd_set_session — Changes or sets the current debugging level
override_function — Overrides built-in functions
rename_function — Renames orig_name to new_name in the global function table
bcompiler — PHP bytecode Compiler
bcompiler Functions
bcompiler_load_exe — Reads and creates classes from a bcompiler exe file
bcompiler_load — Reads and creates classes from a bz compressed file
bcompiler_parse_class — Reads the bytecodes of a class and calls back to a user function
bcompiler_read — Reads and creates classes from a filehandle
bcompiler_write_class — Writes a defined class as bytecodes
bcompiler_write_constant — Writes a defined constant as bytecodes
bcompiler_write_exe_footer — Writes the start pos, and sig to the end of a exe type file
bcompiler_write_file — Writes a php source file as bytecodes
bcompiler_write_footer — Writes the single character \x00 to indicate End of compiled data
bcompiler_write_function — Writes a defined function as bytecodes
bcompiler_write_functions_from_file — Writes all functions defined in a file as bytecodes
bcompiler_write_header — Writes the bcompiler header
bcompiler_write_included_filename — Writes an included file as bytecodes
BLENC — BLowfish ENCoder for PHP source scripts
Predefined Constants
BLENC_EXT_VERSION (string)
Blenc Functions
blenc_encrypt — Encrypt a PHP script with BLENC
Error Handling — Error Handling and Logging
Value
1
2
4
8
16
32
64
128
Constant
E_ERROR (integer)
E_WARNING (integer)
E_PARSE (integer)
E_NOTICE (integer)
E_CORE_ERROR (integer)
E_CORE_WARNING (integer)
E_COMPILE_ERROR (integer)
E_COMPILE_WARNING (integer)
Description
Fatal run-time errors. These indicate errors that can not be recovered from, such as a memory allocation problem. Execution of the script is halted.
Run-time warnings (non-fatal errors). Execution of the script is not halted.
Compile-time parse errors. Parse errors should only be generated by the parser.
Run-time notices. Indicate that the script encountered something that could indicate an error, but could also happen in the normal course of running a script.
Fatal errors that occur during PHP's initial startup. This is like an E_ERROR, except it is generated by the core of PHP.
Warnings (non-fatal errors) that occur during PHP's initial startup. This is like an E_WARNING, except it is generated by the core of PHP.
Fatal compile-time errors. This is like an E_ERROR, except it is generated by the Zend Scripting Engine.
Compile-time warnings (non-fatal errors). This is like an E_WARNING, except it is generated by the Zend Scripting Engine.
256
512
1024
2048
4096
8192
16384
32767
E_USER_ERROR (integer)
E_USER_WARNING (integer)
E_USER_NOTICE (integer)
E_STRICT (integer)
E_RECOVERABLE_ERROR (integer)
E_DEPRECATED (integer)
E_USER_DEPRECATED (integer)
E_ALL (integer)
User-generated error message. This is like an E_ERROR, except it is generated in PHP code by using the PHP function trigger_error().
User-generated warning message. This is like an E_WARNING, except it is generated in PHP code by using the PHP function trigger_error().
User-generated notice message. This is like an E_NOTICE, except it is generated in PHP code by using the PHP function trigger_error().
Enable to have PHP suggest changes to your code which will ensure the best interoperability and forward compatibility of your code.
Catchable fatal error. It indicates that a probably dangerous error occurred, but did not leave the Engine in an unstable state. If the error is not caught by a user defined hand
Run-time notices. Enable this to receive warnings about code that will not work in future versions.
User-generated warning message. This is like an E_DEPRECATED, except it is generated in PHP code by using the PHP function trigger_error().
All errors and warnings, as supported, except of level E_STRICT prior to PHP 5.4.0.
Error Handling Functions
debug_backtrace — Generates a backtrace
debug_print_backtrace — Prints a backtrace
error_get_last — Get the last occurred error
error_log — Send an error message to the defined error handling routines
error_reporting — Sets which PHP errors are reported
restore_error_handler — Restores the previous error handler function
restore_exception_handler — Restores the previously defined exception handler function
set_error_handler — Sets a user-defined error handler function
set_exception_handler — Sets a user-defined exception handler function
trigger_error — Generates a user-level error/warning/notice message
user_error — Alias of trigger_error
inclued Functions
inclued_get_data — Get the inclued data
OPcache Functions
opcache_compile_file — Compiles and caches a PHP script without executing it
opcache_get_configuration — Get configuration information about the cache
opcache_get_status — Get status information about the cache
opcache_invalidate — Invalidates a cached script
opcache_reset — Resets the contents of the opcode cache
Output Control — Output Buffering Control
Predefined Constants ¶
The constants below are always available as part of the PHP core.
PHP_OUTPUT_HANDLER_START (integer) - Indicates that output buffering has begun.
PHP_OUTPUT_HANDLER_WRITE (integer) - Indicates that the output buffer is being flushed, and had data to output.
PHP_OUTPUT_HANDLER_FLUSH (integer) - Indicates that the buffer has been flushed.
PHP_OUTPUT_HANDLER_CLEAN (integer) - Indicates that the output buffer has been cleaned.
PHP_OUTPUT_HANDLER_FINAL (integer) - Indicates that this is the final output buffering operation.
PHP_OUTPUT_HANDLER_CONT (integer) - Indicates that the buffer has been flushed, but output buffering will continue.
As of PHP 5.4, this is an alias for PHP_OUTPUT_HANDLER_WRITE.
PHP_OUTPUT_HANDLER_END (integer) - Indicates that output buffering has ended.
As of PHP 5.4, this is an alias for PHP_OUTPUT_HANDLER_FINAL.
PHP_OUTPUT_HANDLER_CLEANABLE (integer) - Controls whether an output buffer created by ob_start() can be cleaned.
PHP_OUTPUT_HANDLER_FLUSHABLE (integer) - Controls whether an output buffer created by ob_start() can be flushed.
PHP_OUTPUT_HANDLER_REMOVABLE (integer) - Controls whether an output buffer created by ob_start() can be removed before the end of the script.
PHP_OUTPUT_HANDLER_STDFLAGS (integer)
The default set of output buffer flags; currently equivalent to PHP_OUTPUT_HANDLER_CLEANABLE | PHP_OUTPUT_HANDLER_FLUSHABLE |
PHP_OUTPUT_HANDLER_REMOVABLE.
Output Control Functions
flush — Flush the output buffer
ob_clean — Clean (erase) the output buffer
ob_end_clean — Clean (erase) the output buffer and turn off output buffering
ob_end_flush — Flush (send) the output buffer and turn off output buffering
ob_flush — Flush (send) the output buffer
ob_get_clean — Get current buffer contents and delete current output buffer
ob_get_contents — Return the contents of the output buffer
ob_get_flush — Flush the output buffer, return it as a string and turn off output buffering
ob_get_length — Return the length of the output buffer
ob_get_level — Return the nesting level of the output buffering mechanism
ob_get_status — Get status of output buffers
ob_gzhandler — ob_start callback function to gzip output buffer
ob_implicit_flush — Turn implicit flush on/off
ob_list_handlers — List all output handlers in use
ob_start — Turn on output buffering
output_add_rewrite_var — Add URL rewriter values
output_reset_rewrite_vars — Reset URL rewriter values
PHP Options/Info — PHP Options and Information
Constant
CREDITS_GROUP
CREDITS_GENERAL
CREDITS_SAPI
CREDITS_MODULES
CREDITS_DOCS
Value
1
2
4
8
16
CREDITS_FULLPAGE
CREDITS_QA
32
64
CREDITS_ALL
-1
Description
A list of the core developers
General credits: Language design and concept, PHP authors and SAPI module.
A list of the server API modules for PHP, and their authors.
A list of the extension modules for PHP, and their authors.
The credits for the documentation team.
Usually used in combination with the other flags. Indicates that a complete
stand-alone HTML page needs to be printed including the information indicated
by the other flags.
The credits for the quality assurance team.
All the credits, equivalent to using: CREDITS_DOCS + CREDITS_GENERAL +
CREDITS_GROUP + CREDITS_MODULES + CREDITS_QA CREDITS_FULLPAGE. It
generates a complete stand-alone HTML page with the appropriate tags. This is
the default value.
phpinfo() constantsConstant
Value
INFO_GENERAL
INFO_CREDITS
INFO_CONFIGURATION
INFO_MODULES
INFO_ENVIRONMENT
1
2
4
8
16
INFO_VARIABLES
INFO_LICENSE
INFO_ALL
32
64
-1
INI constantsConstant
INI_USER
INI_PERDIR
INI_SYSTEM
INI_ALL
Value
1
2
4
7
Description
The configuration line, php.ini location, build date, Web Server, System and
more.
PHP Credits. See also phpcredits().
Current Local and Master values for PHP directives. See also ini_get().
Loaded modules and their respective settings.
Environment Variable information that's also available in $_ENV.
Shows all predefined variables from EGPCS (Environment, GET, POST, Cookie,
Server).
PHP License information. See also the » license faq.
Shows all of the above. This is the default value.
Description
Unused
Unused
Unused
Unused
Assert constants, these values are used to set the assertion options in assert_options().
assert() constantsConstant
INI Setting
Description
ASSERT_ACTIVE
assert.active
Enable assert() evaluation.
ASSERT_CALLBACK
assert.callback
Callback to call on failed assertions.
ASSERT_BAIL
assert.bail
Terminate execution on failed assertions.
ASSERT_WARNING
assert.warning
Issues a PHP warning for each failed assertion
ASSERT_QUIET_EVAL
assert.quiet_eval Disable error_reporting during assertion expression evaluation.
The following constants are only available if the host operating system is Windows, and can tell different versioning information so its possible to
detect various features and make use of them. They are all available as of PHP 5.3.0.
Windows specific constantsConstant
Description
The major version of Windows, this can be either 4 (NT4/Me/98/95), 5 (XP/2003 R2/2003/2000) or
PHP_WINDOWS_VERSION_MAJOR
6 (Vista/2008).
The minor version of Windows, this can be either 0 (Vista/2008/2000/NT4/95), 1 (XP), 2 (2003
PHP_WINDOWS_VERSION_MINOR
R2/2003/XP x64), 10 (98) or 90 (ME).
PHP_WINDOWS_VERSION_BUILD
The Windows build number (for example, Windows Vista with SP1 applied is build 6001)
The platform that PHP currently is running on, this value is 2 on Windows Vista/XP/2000/NT4,
PHP_WINDOWS_VERSION_PLATFORM
Server 2008/2003 and on Windows ME/98/95 this value is 1.
The major version of the service pack installed, this value is 0 if no service pack is installed. For
PHP_WINDOWS_VERSION_SP_MAJOR
example, Windows XP with service pack 3 installed will make this value 3.
PHP_WINDOWS_VERSION_SP_MINOR
The minor version of the service pack installed, this value is 0 if no service pack is installed.
The suitemask is a bitmask that can tell if various features of Windows is installed, see the table
PHP_WINDOWS_VERSION_SUITEMASK
below for possible bitfield values.
This contains the value used to determine the PHP_WINDOWS_NT_* constants. This value may be
PHP_WINDOWS_VERSION_PRODUCTTYPE
one of the PHP_WINDOWS_NT_* constants indicating the platform type.
PHP_WINDOWS_NT_DOMAIN_CONTROLLER This is a domain controller
This is a server system (eg. Server 2008/2003/2000), note that if this is a domain controller its
PHP_WINDOWS_NT_SERVER
reported as PHP_WINDOWS_NT_DOMAIN_CONTROLLER.
PHP_WINDOWS_NT_WORKSTATION
This is a workstation system (eg. Vista/XP/2000/NT4)
This table shows a list of features that can be checked for using the PHP_WINDOWS_VERSION_SUITEMASK bitmask.
Windows suitemask bitfieldsBits
Description
0x00000004
Microsoft BackOffice components are installed.
0x00000400
Windows Server 2003, Web Edition is installed.
0x00004000
Windows Server 2003, Compute Cluster Edition is installed.
Windows Server 2008 Datacenter, Windows Server 2003, Datacenter Edition or Windows 2000
0x00000080
Datacenter Server is installed.
0x00000002
0x00000040
0x00000200
0x00000100
0x00000001
0x00000020
0x00002000
0x00000010
0x00008000
Windows Server 2008 Enterprise, Windows Server 2003, Enterprise Edition, Windows 2000
Advanced Server, or Windows NT Server 4.0 Enterprise Edition is installed.
Windows XP Embedded is installed.
Windows Vista Home Premium, Windows Vista Home Basic, or Windows XP Home Edition is
installed.
Remote Desktop is supported, but only one interactive session is supported. This value is set unless
the system is running in application server mode.
Microsoft Small Business Server was once installed on the system, but may have been upgraded to
another version of Windows.
Microsoft Small Business Server is installed with the restrictive client license in force.
Windows Storage Server 2003 R2 or Windows Storage Server 2003 is installed.
Terminal Services is installed. This value is always set. If this value is set but 0x00000100 is not set,
then the system is running in application server mode.
Windows Home Server is installed.
PHP Options/Info Functions
assert_options — Set/get the various assert flags
assert — Checks if assertion is FALSE
cli_get_process_title — Returns the current process title
cli_set_process_title — Sets the process title
dl — Loads a PHP extension at runtime
extension_loaded — Find out whether an extension is loaded
gc_collect_cycles — Forces collection of any existing garbage cycles
gc_disable — Deactivates the circular reference collector
gc_enable — Activates the circular reference collector
gc_enabled — Returns status of the circular reference collector
get_cfg_var — Gets the value of a PHP configuration option
get_current_user — Gets the name of the owner of the current PHP script
get_defined_constants — Returns an associative array with the names of all the constants and their values
get_extension_funcs — Returns an array with the names of the functions of a module
get_include_path — Gets the current include_path configuration option
get_included_files — Returns an array with the names of included or required files
get_loaded_extensions — Returns an array with the names of all modules compiled and loaded
get_magic_quotes_gpc — Gets the current configuration setting of magic_quotes_gpc
get_magic_quotes_runtime — Gets the current active configuration setting of magic_quotes_runtime
get_required_files — Alias of get_included_files
getenv — Gets the value of an environment variable
getlastmod — Gets time of last page modification
getmygid — Get PHP script owner's GID
getmyinode — Gets the inode of the current script
getmypid — Gets PHP's process ID
getmyuid — Gets PHP script owner's UID
getopt — Gets options from the command line argument list
getrusage — Gets the current resource usages
ini_alter — Alias of ini_set
ini_get_all — Gets all configuration options
ini_get — Gets the value of a configuration option
ini_restore — Restores the value of a configuration option
ini_set — Sets the value of a configuration option
magic_quotes_runtime — Alias of set_magic_quotes_runtime
main — Dummy for main
memory_get_peak_usage — Returns the peak of memory allocated by PHP
memory_get_usage — Returns the amount of memory allocated to PHP
php_ini_loaded_file — Retrieve a path to the loaded php.ini file
php_ini_scanned_files — Return a list of .ini files parsed from the additional ini dir
php_logo_guid — Gets the logo guid
php_sapi_name — Returns the type of interface between web server and PHP
php_uname — Returns information about the operating system PHP is running on
phpcredits — Prints out the credits for PHP
phpinfo — Outputs information about PHP's configuration
phpversion — Gets the current PHP version
putenv — Sets the value of an environment variable
restore_include_path — Restores the value of the include_path configuration option
set_include_path — Sets the include_path configuration option
set_magic_quotes_runtime — Sets the current active configuration setting of magic_quotes_runtime
set_time_limit — Limits the maximum execution time
sys_get_temp_dir — Returns directory path used for temporary files
version_compare — Compares two "PHP-standardized" version number strings
zend_logo_guid — Gets the Zend guid
zend_thread_id — Returns a unique identifier for the current thread
zend_version — Gets the version of the current Zend engine
runkit
RUNKIT_IMPORT_FUNCTIONS (integer) - runkit_import() flag indicating that normal functions should be imported from the specified file.
RUNKIT_IMPORT_CLASS_METHODS (integer) - runkit_import() flag indicating that class methods should be imported from the specified file.
RUNKIT_IMPORT_CLASS_CONSTS (integer) - runkit_import() flag indicating that class constants should be imported from the specified file. Note that this flag is
only meaningful in PHP versions 5.1.0 and above.
RUNKIT_IMPORT_CLASS_PROPS (integer) - runkit_import() flag indicating that class standard properties should be imported from the specified file.
RUNKIT_IMPORT_CLASSES (integer) - runkit_import() flag representing a bitwise OR of the RUNKIT_IMPORT_CLASS_* constants.
RUNKIT_IMPORT_OVERRIDE (integer) - runkit_import() flag indicating that if any of the imported functions, methods, constants, or properties already exist, they
should be replaced with the new definitions. If this flag is not set, then any imported definitions which already exist will be discarded.
RUNKIT_ACC_PUBLIC (integer) - PHP 5 specific flag to runkit_method_add()
RUNKIT_ACC_PROTECTED (integer) - PHP 5 specific flag to runkit_method_add()
RUNKIT_ACC_PRIVATE (integer) - PHP 5 specific flag to runkit_method_add()
CLASSKIT_ACC_PUBLIC (integer) - PHP 5 specific flag to classkit_method_add() Only defined when classkit compatibility is enabled.
CLASSKIT_ACC_PROTECTED (integer) - PHP 5 specific flag to classkit_method_add() Only defined when classkit compatibility is enabled.
CLASSKIT_ACC_PRIVATE (integer) - PHP 5 specific flag to classkit_method_add() Only defined when classkit compatibility is enabled.
CLASSKIT_AGGREGATE_OVERRIDE (integer) - PHP 5 specific flag to classkit_import() Only defined when classkit compatibility is enabled.
RUNKIT_VERSION (string) - Defined to the current version of the runkit package.
CLASSKIT_VERSION (string) - Defined to the current version of the runkit package. Only defined when classkit compatibility is enabled.
runkit Functions
Runkit_Sandbox — Runkit Sandbox Class -- PHP Virtual Machine
Runkit_Sandbox_Parent — Runkit Anti-Sandbox Class
runkit_class_adopt — Convert a base class to an inherited class, add ancestral methods when appropriate
runkit_class_emancipate — Convert an inherited class to a base class, removes any method whose scope is ancestral
runkit_constant_add — Similar to define(), but allows defining in class definitions as well
runkit_constant_redefine — Redefine an already defined constant
runkit_constant_remove — Remove/Delete an already defined constant
runkit_function_add — Add a new function, similar to create_function
runkit_function_copy — Copy a function to a new function name
runkit_function_redefine — Replace a function definition with a new implementation
runkit_function_remove — Remove a function definition
runkit_function_rename — Change a function's name
runkit_import — Process a PHP file importing function and class definitions, overwriting where appropriate
runkit_lint_file — Check the PHP syntax of the specified file
runkit_lint — Check the PHP syntax of the specified php code
runkit_method_add — Dynamically adds a new method to a given class
runkit_method_copy — Copies a method from class to another
runkit_method_redefine — Dynamically changes the code of the given method
runkit_method_remove — Dynamically removes the given method
runkit_method_rename — Dynamically changes the name of the given method
runkit_return_value_used — Determines if the current functions return value will be used
runkit_sandbox_output_handler — Specify a function to capture and/or process output from a runkit sandbox
runkit_superglobals — Return numerically indexed array of registered superglobals
WinCache — Windows Cache for PHP
wincache_fcache_fileinfo — Retrieves information about files cached in the file cache
wincache_fcache_meminfo — Retrieves information about file cache memory usage
wincache_lock — Acquires an exclusive lock on a given key
wincache_ocache_fileinfo — Retrieves information about files cached in the opcode cache
wincache_ocache_meminfo — Retrieves information about opcode cache memory usage
wincache_refresh_if_changed — Refreshes the cache entries for the cached files
wincache_rplist_fileinfo — Retrieves information about resolve file path cache
wincache_rplist_meminfo — Retrieves information about memory usage by the resolve file path cache
wincache_scache_info — Retrieves information about files cached in the session cache
wincache_scache_meminfo — Retrieves information about session cache memory usage
wincache_ucache_add — Adds a variable in user cache only if variable does not already exist in the cache
wincache_ucache_cas — Compares the variable with old value and assigns new value to it
wincache_ucache_clear — Deletes entire content of the user cache
wincache_ucache_dec — Decrements the value associated with the key
wincache_ucache_delete — Deletes variables from the user cache
wincache_ucache_exists — Checks if a variable exists in the user cache
wincache_ucache_get — Gets a variable stored in the user cache
wincache_ucache_inc — Increments the value associated with the key
wincache_ucache_info — Retrieves information about data stored in the user cache
wincache_ucache_meminfo — Retrieves information about user cache memory usage
wincache_ucache_set — Adds a variable in user cache and overwrites a variable if it already exists in the cache
wincache_unlock — Releases an exclusive lock on a given key
Xhprof — Hierarchical Profiler
XHPROF_FLAGS_NO_BUILTINS (integer) - Used to skip all built-in (internal) functions.
XHPROF_FLAGS_CPU (integer) - Used to add CPU profiling information to the output.
XHPROF_FLAGS_MEMORY (integer) - Used to add memory profiling information to the output.
Xhprof Functions
xhprof_disable — Stops xhprof profiler
xhprof_enable — Start xhprof profiler
xhprof_sample_disable — Stops xhprof sample profiler
xhprof_sample_enable — Start XHProf profiling in sampling mode
Manipulation von Audioformaten
ID3 — ID3 Tags
ID3_V1_0 (integer) - ID3_V1_0 is used if you are working with ID3 V1.0 tags. These tags may contain the fields title, artist, album, genre, year and comment.
ID3_V1_1 (integer) - ID3_V1_1 is used if you are working with ID3 V1.1 tags. These tags may all information contained in v1.0 tags plus the track number.
ID3_V2_1 (integer) - ID3_V2_1 is used if you are working with ID3 V2.1 tags.
ID3_BEST (integer) - ID3_BEST is used if would like to let the id3 functions determine which tag version should be used.
ID3 Functions
id3_get_frame_long_name — Get the long name of an ID3v2 frame
id3_get_frame_short_name — Get the short name of an ID3v2 frame
id3_get_genre_id — Get the id for a genre
id3_get_genre_list — Get all possible genre values
id3_get_genre_name — Get the name for a genre id
id3_get_tag — Get all information stored in an ID3 tag
id3_get_version — Get version of an ID3 tag
id3_remove_tag — Remove an existing ID3 tag
id3_set_tag — Update information stored in an ID3 tag
KTaglib
KTaglib uses class constants. Most of the constants are mappings to the according Taglib enums and constants.
KTaglib_MPEG_Header::Version1 (integer) - ID3 version is 1.0
KTaglib_MPEG_Header::Version2 (integer) - ID3 version is 2.0
KTaglib_MPEG_Header::Version2_5 (integer) - ID3 version is 2.5
KTaglib_ID3v2_AttachedPictureFrame::Other (integer) - Picture type Other
KTaglib_ID3v2_AttachedPictureFrame::FileIcon (integer) - Picture type FileIcon
KTaglib_ID3v2_AttachedPictureFrame::OtherFileIcon (integer) - Picture type OtherFileIcon
KTaglib_ID3v2_AttachedPictureFrame::FrontCover (integer) - Picture type FrontCover
KTaglib_ID3v2_AttachedPictureFrame::BackCover (integer) - Picture type BackCover
KTaglib_ID3v2_AttachedPictureFrame::LeafletPage (integer) - Picture type LeafletPage
KTaglib_ID3v2_AttachedPictureFrame::Media (integer) - Picture type Media
KTaglib_ID3v2_AttachedPictureFrame::LeadArtist (integer) - Picture type LeadArtist
KTaglib_ID3v2_AttachedPictureFrame::Artist (integer) - Picture type Artist
KTaglib_ID3v2_AttachedPictureFrame::Conductor (integer) - Picture type Condutor
KTaglib_ID3v2_AttachedPictureFrame::Band (integer) - Picture type Band
KTaglib_ID3v2_AttachedPictureFrame::Composer (integer) - Picture type Composer
KTaglib_ID3v2_AttachedPictureFrame::Lyricist (integer) - Picture type Lyricist
KTaglib_ID3v2_AttachedPictureFrame::RecordingLocation (integer) - Picture type RecordingLocation
KTaglib_ID3v2_AttachedPictureFrame::DuringRecording (integer) - Picture type DuringRecording
KTaglib_ID3v2_AttachedPictureFrame::DuringPerformance (integer) - Picture type DuringPerformance
KTaglib_ID3v2_AttachedPictureFrame::MovieScreenCapture (integer) - Picture type MovieScreenCapture
KTaglib_ID3v2_AttachedPictureFrame::ColouredFish (integer) - Picture type ColouredFish
KTaglib_ID3v2_AttachedPictureFrame::Illustration (integer) - Picture type Illustration
KTaglib_ID3v2_AttachedPictureFrame::BandLogo (integer) - Picture type BandLogo
KTaglib_MPEG_File — The KTaglib_MPEG_File class
KTaglib_MPEG_File::__construct — Opens a new file
KTaglib_MPEG_File::getAudioProperties — Returns an object that provides access to the audio properties
KTaglib_MPEG_File::getID3v1Tag — Returns an object representing an ID3v1 tag
KTaglib_MPEG_File::getID3v2Tag — Returns a ID3v2 object
The KTaglib_MPEG_AudioProperties class
KTaglib_MPEG_AudioProperties::getBitrate — Returns the bitrate of the MPEG file
KTaglib_MPEG_AudioProperties::getChannels — Returns the amount of channels of a MPEG file
KTaglib_MPEG_AudioProperties::getLayer — Returns the layer of a MPEG file
KTaglib_MPEG_AudioProperties::getLength — Returns the length of a MPEG file
KTaglib_MPEG_AudioProperties::getSampleBitrate — Returns the sample bitrate of a MPEG file
KTaglib_MPEG_AudioProperties::getVersion — Returns the version of a MPEG file
KTaglib_MPEG_AudioProperties::isCopyrighted — Returns the copyright status of an MPEG file
KTaglib_MPEG_AudioProperties::isOriginal — Returns if the file is marked as the original file
KTaglib_MPEG_AudioProperties::isProtectionEnabled — Returns if protection mechanisms of an MPEG file are enabled
The KTaglib_Tag class
KTaglib_Tag::getAlbum — Returns the title string from a ID3 tag
KTaglib_Tag::getArtist — Returns the artist string from a ID3 tag
KTaglib_Tag::getComment — Returns the comment from a ID3 tag
KTaglib_Tag::getGenre — Returns the genre from a ID3 tag
KTaglib_Tag::getTitle — Returns the title string from a ID3 tag
KTaglib_Tag::getTrack — Returns the track number from a ID3 tag
KTaglib_Tag::getYear — Returns the year from a ID3 tag
KTaglib_Tag::isEmpty — Returns true if the tag is empty
The KTaglib_ID3v2_Tag class
KTaglib_ID3v2_Tag::addFrame — Add a frame to the ID3v2 tag
KTaglib_ID3v2_Tag::getFrameList — Returns an array of ID3v2 frames, associated with the ID3v2 tag
The KTaglib_ID3v2_Frame class
KTaglib_ID3v2_Frame::getSize — Returns the size of the frame in bytes
KTaglib_ID3v2_Frame::__toString — Returns a string representation of the frame
The KTaglib_ID3v2_AttachedPictureFrame class
KTaglib_ID3v2_AttachedPictureFrame::getDescription — Returns a description for the picture in a picture frame
KTaglib_ID3v2_AttachedPictureFrame::getMimeType — Returns the mime type of the picture
KTaglib_ID3v2_AttachedPictureFrame::getType — Returns the type of the image
KTaglib_ID3v2_AttachedPictureFrame::savePicture — Saves the picture to a file
KTaglib_ID3v2_AttachedPictureFrame::setMimeType — Set's the mime type of the picture
KTaglib_ID3v2_AttachedPictureFrame::setPicture — Sets the frame picture to the given image
KTaglib_ID3v2_AttachedPictureFrame::setType — Set the type of the image
oggvorbis — OGG/Vorbis
Constant
OGGVORBIS_PCM_U8
OGGVORBIS_PCM_S8
OGGVORBIS_PCM_U16_LE
OGGVORBIS_PCM_U16_BE
OGGVORBIS_PCM_S16_LE
OGGVORBIS_PCM_S16_BE
Context options
Option
pcm_mode
rate
bitrate
channels
serialno
comments
Definition
Unsigned 8-bit PCM.
Signed 8-bit PCM.
Unsigned 16-bit PCM. Little Endian byte order.
Unsigned 16-bit PCM. Big Endian byte order.
Signed 16-bit PCM. Little Endian byte order.
Signed 16-bit PCM. Big Endian byte order.
Relevance
Read / Write
Write only
Write only
Write only
Write only
Write only
Default
OGGVORBIS_PCM_S16_LE
44100
128000
2
Random
OpenAL — OpenAL Audio Bindings
ALC_FREQUENCY (integer) - Context Attribute
ALC_REFRESH (integer) - Context Attribute
ALC_SYNC (integer) - Context Attribute
AL_FREQUENCY (integer) - Buffer Setting
AL_BITS (integer) - Buffer Setting
AL_CHANNELS (integer) - Buffer Setting
Definition
PCM byte encoding used. See constants below.
PCM Sampling rate. Measured in Hz.
Vorbis Average Bitrate Encoding / Variable Bitrate Encoding. Measured in bps (ABR) or Quality level (VBR: 0.
Number of PCM channels. 1 == Mono, 2 == Stereo.
Serial Number of stream within file. Must be unique within file. Because of the potential to select a duplicat
Associative array of file comments. Will be translated to strtoupper($name) . "=$value". Note: This context o
AL_SIZE (integer) - Buffer Setting
AL_BUFFER (integer) - Source/Listener Setting (Integer)
AL_SOURCE_RELATIVE (integer) - Source/Listener Setting (Integer)
AL_SOURCE_STATE (integer) - Source/Listener Setting (Integer)
AL_PITCH (integer) - Source/Listener Setting (Float)
AL_GAIN (integer) - Source/Listener Setting (Float)
AL_MIN_GAIN (integer) - Source/Listener Setting (Float)
AL_MAX_GAIN (integer) - Source/Listener Setting (Float)
AL_MAX_DISTANCE (integer) - Source/Listener Setting (Float)
AL_ROLLOFF_FACTOR (integer) - Source/Listener Setting (Float)
AL_CONE_OUTER_GAIN (integer) - Source/Listener Setting (Float)
AL_CONE_INNER_ANGLE (integer) - Source/Listener Setting (Float)
AL_CONE_OUTER_ANGLE (integer) - Source/Listener Setting (Float)
AL_REFERENCE_DISTANCE (integer) - Source/Listener Setting (Float)
AL_POSITION (integer) - Source/Listener Setting (Float Vector)
AL_VELOCITY (integer) - Source/Listener Setting (Float Vector)
AL_DIRECTION (integer) - Source/Listener Setting (Float Vector)
AL_ORIENTATION (integer) - Source/Listener Setting (Float Vector)
AL_FORMAT_MONO8 (integer) - PCM Format
AL_FORMAT_MONO16 (integer) - PCM Format
AL_FORMAT_STEREO8 (integer) - PCM Format
AL_FORMAT_STEREO16 (integer) - PCM Format
AL_INITIAL (integer) - Source State
AL_PLAYING (integer) - Source State
AL_PAUSED (integer) - Source State
AL_STOPPED (integer) - Source State
AL_LOOPING (integer) - Source State
AL_TRUE (integer) - Boolean value recognized by OpenAL
AL_FALSE (integer) - Boolean value recognized by OpenAL
OpenAL Functions
openal_buffer_create — Generate OpenAL buffer
openal_buffer_data — Load a buffer with data
openal_buffer_destroy — Destroys an OpenAL buffer
openal_buffer_get — Retrieve an OpenAL buffer property
openal_buffer_loadwav — Load a .wav file into a buffer
openal_context_create — Create an audio processing context
openal_context_current — Make the specified context current
openal_context_destroy — Destroys a context
openal_context_process — Process the specified context
openal_context_suspend — Suspend the specified context
openal_device_close — Close an OpenAL device
openal_device_open — Initialize the OpenAL audio layer
openal_listener_get — Retrieve a listener property
openal_listener_set — Set a listener property
openal_source_create — Generate a source resource
openal_source_destroy — Destroy a source resource
openal_source_get — Retrieve an OpenAL source property
openal_source_pause — Pause the source
openal_source_play — Start playing the source
openal_source_rewind — Rewind the source
openal_source_set — Set source property
openal_source_stop — Stop playing the source
openal_stream — Begin streaming on a source
Authentifizierungsdienste
KADM5 — Kerberos V
Constants for Attribute Flags
Constants for Options
KADM5 Functions
kadm5_chpass_principal — Changes the principal's password
kadm5_create_principal — Creates a kerberos principal with the given parameters
kadm5_delete_principal — Deletes a kerberos principal
kadm5_destroy — Closes the connection to the admin server and releases all related resources
kadm5_flush — Flush all changes to the Kerberos database
kadm5_get_policies — Gets all policies from the Kerberos database
kadm5_get_principal — Gets the principal's entries from the Kerberos database
kadm5_get_principals — Gets all principals from the Kerberos database
kadm5_init_with_password — Opens a connection to the KADM5 library
kadm5_modify_principal — Modifies a kerberos principal with the given parameters
Radius
RADIUS Options
RADIUS_OPTION_SALT (integer) - When set, this option will result in the attribute value being salt-encrypted.
RADIUS_OPTION_TAGGED (integer) - When set, this option will result in the attribute value being tagged with the value of the tag parameter.
RADIUS Packet Types
RADIUS packets, whether requests or responses, always include a type. These constants are provided to make it easier to specify types when using
radius_create_request() and when comparing the result of radius_send_request().
RADIUS_ACCESS_REQUEST (integer) - An Access-Request, used to authenticate a user against a RADIUS server. Access request packets must include a
RADIUS_NAS_IP_ADDRESS or a RADIUS_NAS_IDENTIFIER attribute, must also include a RADIUS_USER_PASSWORD, RADIUS_CHAP_PASSWORD or a RADIUS_STATE attribute,
and should include a RADIUS_USER_NAME attribute.
RADIUS_ACCESS_ACCEPT (integer) - An Access-Accept response to an Access-Request indicating that the RADIUS server authenticated the user successfully.
RADIUS_ACCESS_REJECT (integer) - An Access-Reject response to an Access-Request indicating that the RADIUS server could not authenticate the user.
RADIUS_ACCESS_CHALLENGE (integer) - An Access-Challenge response to an Access-Request indicating that the RADIUS server requires further information in another
Access-Request before authenticating the user.
RADIUS_ACCOUNTING_REQUEST (integer) - An Accounting-Request, used to convey accounting information for a service to the RADIUS server.
RADIUS_ACCOUNTING_RESPONSE (integer) - An Accounting-Response response to an Accounting-Request.
RADIUS_COA_REQUEST (integer) - A CoA-Request, sent from the RADIUS server to indicate that the authorisations within the user session have changed. A response must be
sent in the form of a CoA-ACK or a CoA-NAK.
RADIUS_COA_ACK (integer) - A CoA-ACK, sent to the RADIUS server to indicate that the user authorisations have been updated.
RADIUS_COA_NAK (integer) - A CoA-NAK, sent to the RADIUS server to indicate that the user authorisations could not be updated.
RADIUS_DISCONNECT_REQUEST (integer) - A Disconnect-Request, sent from the RADIUS server to indicate that the user session must be terminated.
RADIUS_DISCONNECT_ACK (integer) - A Disconnect-ACK, sent to the RADIUS server to indicate that the user session has been terminated.
RADIUS_DISCONNECT_NAK (integer) - A Disconnect-NAK, sent to the RADIUS server to indicate that the user session could not be terminated.
RADIUS Attribute Types
These constants define RADIUS attribute types that can be used with radius_put_addr(), radius_put_attr(), radius_put_int() and radius_put_string().
RADIUS_USER_NAME (integer) - The User-Name attribute. The attribute value is expected to be a string containing the name of the user being authenticated, and can be set
using radius_put_attr().
RADIUS_USER_PASSWORD (integer) - The User-Password attribute. The attribute value is expected to be a string containing the user's password, and can be set using
radius_put_attr(). This value will be obfuscated on transmission as described in » section 5.2 of RFC 2865.
RADIUS_CHAP_PASSWORD (integer) - The Chap-Password attribute. The attribute value is expected to be a string with the first byte containing the CHAP identifier, and the
subsequent 16 bytes containing the MD5 hash of the CHAP identifier, the plaintext password and the CHAP challenge value concatenated together. Note that the CHAP
challenge value should also be sent separately in a RADIUS_CHAP_CHALLENGE attribute.
RADIUS Vendor Specific Attribute Types
RADIUS_VENDOR_MICROSOFT (integer) - Microsoft specific vendor attributes (» RFC 2548), one of:
RADIUS_MICROSOFT_MS_CHAP_RESPONSE
RADIUS_MICROSOFT_MS_CHAP_ERROR
RADIUS_MICROSOFT_MS_CHAP_PW_1
RADIUS_MICROSOFT_MS_CHAP_PW_2
RADIUS_MICROSOFT_MS_CHAP_LM_ENC_PW
RADIUS_MICROSOFT_MS_CHAP_NT_ENC_PW
RADIUS_MICROSOFT_MS_MPPE_ENCRYPTION_POLICY
RADIUS_MICROSOFT_MS_MPPE_ENCRYPTION_TYPES
RADIUS_MICROSOFT_MS_RAS_VENDOR
RADIUS_MICROSOFT_MS_CHAP_DOMAIN
RADIUS_MICROSOFT_MS_CHAP_CHALLENGE
RADIUS_MICROSOFT_MS_CHAP_MPPE_KEYS
RADIUS_MICROSOFT_MS_BAP_USAGE
RADIUS_MICROSOFT_MS_LINK_UTILIZATION_THRESHOLD
RADIUS_MICROSOFT_MS_LINK_DROP_TIME_LIMIT
RADIUS_MICROSOFT_MS_MPPE_SEND_KEY
RADIUS_MICROSOFT_MS_MPPE_RECV_KEY
RADIUS_MICROSOFT_MS_RAS_VERSION
RADIUS_MICROSOFT_MS_OLD_ARAP_PASSWORD
RADIUS_MICROSOFT_MS_NEW_ARAP_PASSWORD
RADIUS_MICROSOFT_MS_ARAP_PASSWORD_CHANGE_REASON
RADIUS_MICROSOFT_MS_FILTER
RADIUS_MICROSOFT_MS_ACCT_AUTH_TYPE
RADIUS_MICROSOFT_MS_ACCT_EAP_TYPE
RADIUS_MICROSOFT_MS_CHAP2_RESPONSE
RADIUS_MICROSOFT_MS_CHAP2_SUCCESS
RADIUS_MICROSOFT_MS_CHAP2_PW
RADIUS_MICROSOFT_MS_PRIMARY_DNS_SERVER
RADIUS_MICROSOFT_MS_SECONDARY_DNS_SERVER
RADIUS_MICROSOFT_MS_PRIMARY_NBNS_SERVER
RADIUS_MICROSOFT_MS_SECONDARY_NBNS_SERVER
RADIUS_MICROSOFT_MS_ARAP_CHALLENGE
Eingabezeilenspezifische Erweiterungen
Ncurses — Ncurses Terminal Screen Control
Error codes
On error ncurses functions return -1. Some functions return 0 on success. See the relevant pages in the documentation for actual return values.
Colors
constant
NCURSES_COLOR_BLACK
NCURSES_COLOR_WHITE
meaning
no color (black)
white
NCURSES_COLOR_RED
NCURSES_COLOR_GREEN
NCURSES_COLOR_YELLOW
NCURSES_COLOR_BLUE
NCURSES_COLOR_CYAN
NCURSES_COLOR_MAGENTA
red - supported when terminal is in color mode
green - supported when terminal is in color mode
yellow - supported when terminal is in color mode
blue - supported when terminal is in color mode
cyan - supported when terminal is in color mode
magenta - supported when terminal is in color mode
Keys
constant
NCURSES_KEY_F0 - NCURSES_KEY_F64
NCURSES_KEY_DOWN
NCURSES_KEY_UP
NCURSES_KEY_LEFT
NCURSES_KEY_RIGHT
NCURSES_KEY_HOME
NCURSES_KEY_BACKSPACE
NCURSES_KEY_DL
NCURSES_KEY_IL
NCURSES_KEY_DC
NCURSES_KEY_IC
NCURSES_KEY_EIC
NCURSES_KEY_CLEAR
NCURSES_KEY_EOS
NCURSES_KEY_EOL
NCURSES_KEY_SF
NCURSES_KEY_SR
NCURSES_KEY_NPAGE
NCURSES_KEY_PPAGE
meaning
function keys F1 - F64
down arrow
up arrow
left arrow
right arrow
home key (upward+left arrow)
backspace
delete line
insert line
delete character
insert char or enter insert mode
exit insert char mode
clear screen
clear to end of screen
clear to end of line
scroll one line forward
scroll one line backward
next page
previous page
NCURSES_KEY_STAB
NCURSES_KEY_CTAB
NCURSES_KEY_CATAB
NCURSES_KEY_SRESET
NCURSES_KEY_RESET
NCURSES_KEY_PRINT
NCURSES_KEY_LL
NCURSES_KEY_A1
NCURSES_KEY_A3
NCURSES_KEY_B2
NCURSES_KEY_C1
NCURSES_KEY_C3
NCURSES_KEY_BTAB
NCURSES_KEY_BEG
NCURSES_KEY_CANCEL
NCURSES_KEY_CLOSE
NCURSES_KEY_COMMAND
NCURSES_KEY_COPY
NCURSES_KEY_CREATE
NCURSES_KEY_END
NCURSES_KEY_EXIT
NCURSES_KEY_FIND
NCURSES_KEY_HELP
NCURSES_KEY_MARK
NCURSES_KEY_MESSAGE
NCURSES_KEY_MOVE
NCURSES_KEY_NEXT
NCURSES_KEY_OPEN
NCURSES_KEY_OPTIONS
set tab
clear tab
clear all tabs
soft (partial) reset
reset or hard reset
print
lower left
upper left of keypad
upper right of keypad
center of keypad
lower left of keypad
lower right of keypad
back tab
beginning
cancel
close
cmd (command)
copy
create
end
exit
find
help
mark
message
move
next
open
options
NCURSES_KEY_PREVIOUS
NCURSES_KEY_REDO
NCURSES_KEY_REFERENCE
NCURSES_KEY_REFRESH
NCURSES_KEY_REPLACE
NCURSES_KEY_RESTART
NCURSES_KEY_RESUME
NCURSES_KEY_SAVE
NCURSES_KEY_SBEG
NCURSES_KEY_SCANCEL
NCURSES_KEY_SCOMMAND
NCURSES_KEY_SCOPY
NCURSES_KEY_SCREATE
NCURSES_KEY_SDC
NCURSES_KEY_SDL
NCURSES_KEY_SELECT
NCURSES_KEY_SEND
NCURSES_KEY_SEOL
NCURSES_KEY_SEXIT
NCURSES_KEY_SFIND
NCURSES_KEY_SHELP
NCURSES_KEY_SHOME
NCURSES_KEY_SIC
NCURSES_KEY_SLEFT
NCURSES_KEY_SMESSAGE
NCURSES_KEY_SMOVE
NCURSES_KEY_SNEXT
NCURSES_KEY_SOPTIONS
NCURSES_KEY_SPREVIOUS
previous
redo
ref (reference)
refresh
replace
restart
resume
save
shiftet beg (beginning)
shifted cancel
shifted command
shifted copy
shifted create
shifted delete char
shifted delete line
select
shifted end
shifted end of line
shifted exit
shifted find
shifted help
shifted home
shifted input
shifted left arrow
shifted message
shifted move
shifted next
shifted options
shifted previous
NCURSES_KEY_SPRINT
NCURSES_KEY_SREDO
NCURSES_KEY_SREPLACE
NCURSES_KEY_SRIGHT
NCURSES_KEY_SRSUME
NCURSES_KEY_SSAVE
NCURSES_KEY_SSUSPEND
NCURSES_KEY_UNDO
NCURSES_KEY_MOUSE
NCURSES_KEY_MAX
shifted print
shifted redo
shifted replace
shifted right arrow
shifted resume
shifted save
shifted suspend
undo
mouse event has occurred
maximum key value
Mouse
Constant
NCURSES_BUTTON1_RELEASED - NCURSES_BUTTON4_RELEASED
NCURSES_BUTTON1_PRESSED - NCURSES_BUTTON4_PRESSED
NCURSES_BUTTON1_CLICKED - NCURSES_BUTTON4_CLICKED
NCURSES_BUTTON1_DOUBLE_CLICKED - NCURSES_BUTTON4_DOUBLE_CLICKED
NCURSES_BUTTON1_TRIPLE_CLICKED - NCURSES_BUTTON4_TRIPLE_CLICKED
NCURSES_BUTTON_CTRL
NCURSES_BUTTON_SHIFT
NCURSES_BUTTON_ALT
NCURSES_ALL_MOUSE_EVENTS
NCURSES_REPORT_MOUSE_POSITION
Ncurses Functions
ncurses_addch — Add character at current position and advance cursor
ncurses_addchnstr — Add attributed string with specified length at current position
ncurses_addchstr — Add attributed string at current position
meaning
button (1-4) released
button (1-4) pressed
button (1-4) clicked
button (1-4) double clicked
button (1-4) triple clicked
ctrl pressed during click
shift pressed during click
alt pressed during click
report all mouse events
report mouse position
ncurses_addnstr — Add string with specified length at current position
ncurses_addstr — Output text at current position
ncurses_assume_default_colors — Define default colors for color 0
ncurses_attroff — Turn off the given attributes
ncurses_attron — Turn on the given attributes
ncurses_attrset — Set given attributes
ncurses_baudrate — Returns baudrate of terminal
ncurses_beep — Let the terminal beep
ncurses_bkgd — Set background property for terminal screen
ncurses_bkgdset — Control screen background
ncurses_border — Draw a border around the screen using attributed characters
ncurses_bottom_panel — Moves a visible panel to the bottom of the stack
ncurses_can_change_color — Checks if terminal color definitions can be changed
ncurses_cbreak — Switch of input buffering
ncurses_clear — Clear screen
ncurses_clrtobot — Clear screen from current position to bottom
ncurses_clrtoeol — Clear screen from current position to end of line
ncurses_color_content — Retrieves RGB components of a color
ncurses_color_set — Set active foreground and background colors
ncurses_curs_set — Set cursor state
ncurses_def_prog_mode — Saves terminals (program) mode
ncurses_def_shell_mode — Saves terminals (shell) mode
ncurses_define_key — Define a keycode
ncurses_del_panel — Remove panel from the stack and delete it (but not the associated window)
ncurses_delay_output — Delay output on terminal using padding characters
ncurses_delch — Delete character at current position, move rest of line left
ncurses_deleteln — Delete line at current position, move rest of screen up
ncurses_delwin — Delete a ncurses window
ncurses_doupdate — Write all prepared refreshes to terminal
ncurses_echo — Activate keyboard input echo
ncurses_echochar — Single character output including refresh
ncurses_end — Stop using ncurses, clean up the screen
ncurses_erase — Erase terminal screen
ncurses_erasechar — Returns current erase character
ncurses_filter — Set LINES for iniscr() and newterm() to 1
ncurses_flash — Flash terminal screen (visual bell)
ncurses_flushinp — Flush keyboard input buffer
ncurses_getch — Read a character from keyboard
ncurses_getmaxyx — Returns the size of a window
ncurses_getmouse — Reads mouse event
ncurses_getyx — Returns the current cursor position for a window
ncurses_halfdelay — Put terminal into halfdelay mode
ncurses_has_colors — Checks if terminal has color capabilities
ncurses_has_ic — Check for insert- and delete-capabilities
ncurses_has_il — Check for line insert- and delete-capabilities
ncurses_has_key — Check for presence of a function key on terminal keyboard
ncurses_hide_panel — Remove panel from the stack, making it invisible
ncurses_hline — Draw a horizontal line at current position using an attributed character and max. n characters long
ncurses_inch — Get character and attribute at current position
ncurses_init_color — Define a terminal color
ncurses_init_pair — Define a color pair
ncurses_init — Initialize ncurses
ncurses_insch — Insert character moving rest of line including character at current position
ncurses_insdelln — Insert lines before current line scrolling down (negative numbers delete and scroll up)
ncurses_insertln — Insert a line, move rest of screen down
ncurses_insstr — Insert string at current position, moving rest of line right
ncurses_instr — Reads string from terminal screen
ncurses_isendwin — Ncurses is in endwin mode, normal screen output may be performed
ncurses_keyok — Enable or disable a keycode
ncurses_keypad — Turns keypad on or off
ncurses_killchar — Returns current line kill character
ncurses_longname — Returns terminals description
ncurses_meta — Enables/Disable 8-bit meta key information
ncurses_mouse_trafo — Transforms coordinates
ncurses_mouseinterval — Set timeout for mouse button clicks
ncurses_mousemask — Sets mouse options
ncurses_move_panel — Moves a panel so that its upper-left corner is at [startx, starty]
ncurses_move — Move output position
ncurses_mvaddch — Move current position and add character
ncurses_mvaddchnstr — Move position and add attributed string with specified length
ncurses_mvaddchstr — Move position and add attributed string
ncurses_mvaddnstr — Move position and add string with specified length
ncurses_mvaddstr — Move position and add string
ncurses_mvcur — Move cursor immediately
ncurses_mvdelch — Move position and delete character, shift rest of line left
ncurses_mvgetch — Move position and get character at new position
ncurses_mvhline — Set new position and draw a horizontal line using an attributed character and max. n characters long
ncurses_mvinch — Move position and get attributed character at new position
ncurses_mvvline — Set new position and draw a vertical line using an attributed character and max. n characters long
ncurses_mvwaddstr — Add string at new position in window
ncurses_napms — Sleep
ncurses_new_panel — Create a new panel and associate it with window
ncurses_newpad — Creates a new pad (window)
ncurses_newwin — Create a new window
ncurses_nl — Translate newline and carriage return / line feed
ncurses_nocbreak — Switch terminal to cooked mode
ncurses_noecho — Switch off keyboard input echo
ncurses_nonl — Do not translate newline and carriage return / line feed
ncurses_noqiflush — Do not flush on signal characters
ncurses_noraw — Switch terminal out of raw mode
ncurses_pair_content — Retrieves foreground and background colors of a color pair
ncurses_panel_above — Returns the panel above panel
ncurses_panel_below — Returns the panel below panel
ncurses_panel_window — Returns the window associated with panel
ncurses_pnoutrefresh — Copies a region from a pad into the virtual screen
ncurses_prefresh — Copies a region from a pad into the virtual screen
ncurses_putp — Apply padding information to the string and output it
ncurses_qiflush — Flush on signal characters
ncurses_raw — Switch terminal into raw mode
ncurses_refresh — Refresh screen
ncurses_replace_panel — Replaces the window associated with panel
ncurses_reset_prog_mode — Resets the prog mode saved by def_prog_mode
ncurses_reset_shell_mode — Resets the shell mode saved by def_shell_mode
ncurses_resetty — Restores saved terminal state
ncurses_savetty — Saves terminal state
ncurses_scr_dump — Dump screen content to file
ncurses_scr_init — Initialize screen from file dump
ncurses_scr_restore — Restore screen from file dump
ncurses_scr_set — Inherit screen from file dump
ncurses_scrl — Scroll window content up or down without changing current position
ncurses_show_panel — Places an invisible panel on top of the stack, making it visible
ncurses_slk_attr — Returns current soft label key attribute
ncurses_slk_attroff — Turn off the given attributes for soft function-key labels
ncurses_slk_attron — Turn on the given attributes for soft function-key labels
ncurses_slk_attrset — Set given attributes for soft function-key labels
ncurses_slk_clear — Clears soft labels from screen
ncurses_slk_color — Sets color for soft label keys
ncurses_slk_init — Initializes soft label key functions
ncurses_slk_noutrefresh — Copies soft label keys to virtual screen
ncurses_slk_refresh — Copies soft label keys to screen
ncurses_slk_restore — Restores soft label keys
ncurses_slk_set — Sets function key labels
ncurses_slk_touch — Forces output when ncurses_slk_noutrefresh is performed
ncurses_standend — Stop using 'standout' attribute
ncurses_standout — Start using 'standout' attribute
ncurses_start_color — Initializes color functionality
ncurses_termattrs — Returns a logical OR of all attribute flags supported by terminal
ncurses_termname — Returns terminals (short)-name
ncurses_timeout — Set timeout for special key sequences
ncurses_top_panel — Moves a visible panel to the top of the stack
ncurses_typeahead — Specify different filedescriptor for typeahead checking
ncurses_ungetch — Put a character back into the input stream
ncurses_ungetmouse — Pushes mouse event to queue
ncurses_update_panels — Refreshes the virtual screen to reflect the relations between panels in the stack
ncurses_use_default_colors — Assign terminal default colors to color id -1
ncurses_use_env — Control use of environment information about terminal size
ncurses_use_extended_names — Control use of extended names in terminfo descriptions
ncurses_vidattr — Display the string on the terminal in the video attribute mode
ncurses_vline — Draw a vertical line at current position using an attributed character and max. n characters long
ncurses_waddch — Adds character at current position in a window and advance cursor
ncurses_waddstr — Outputs text at current postion in window
ncurses_wattroff — Turns off attributes for a window
ncurses_wattron — Turns on attributes for a window
ncurses_wattrset — Set the attributes for a window
ncurses_wborder — Draws a border around the window using attributed characters
ncurses_wclear — Clears window
ncurses_wcolor_set — Sets windows color pairings
ncurses_werase — Erase window contents
ncurses_wgetch — Reads a character from keyboard (window)
ncurses_whline — Draws a horizontal line in a window at current position using an attributed character and max. n characters long
ncurses_wmouse_trafo — Transforms window/stdscr coordinates
ncurses_wmove — Moves windows output position
ncurses_wnoutrefresh — Copies window to virtual screen
ncurses_wrefresh — Refresh window on terminal screen
ncurses_wstandend — End standout mode for a window
ncurses_wstandout — Enter standout mode for a window
ncurses_wvline — Draws a vertical line in a window at current position using an attributed character and max. n characters long
Newt
Newt form exit reasons
constant
NEWT_EXIT_HOTKEY
NEWT_EXIT_COMPONENT
NEWT_EXIT_FDREADY
NEWT_EXIT_TIMER
meaning
hotkey defined by newt_form_add_hot_key() was pressed
some component has caused form to exit
file descriptor specified in newt_form_watch_fd() is ready to be read or written to
time specified in newt_form_set_timer() has elapsed
Newt colorsets
constant
NEWT_COLORSET_ROOT
NEWT_COLORSET_BORDER
NEWT_COLORSET_WINDOW
NEWT_COLORSET_SHADOW
NEWT_COLORSET_TITLE
NEWT_COLORSET_BUTTON
NEWT_COLORSET_ACTBUTTON
NEWT_COLORSET_CHECKBOX
NEWT_COLORSET_ACTCHECKBOX
NEWT_COLORSET_ENTRY
NEWT_COLORSET_LABEL
NEWT_COLORSET_LISTBOX
NEWT_COLORSET_ACTLISTBOX
meaning
NEWT_COLORSET_TEXTBOX
NEWT_COLORSET_ACTTEXTBOX
NEWT_COLORSET_HELPLINE
NEWT_COLORSET_ROOTTEXT
NEWT_COLORSET_EMPTYSCALE
NEWT_COLORSET_FULLSCALE
NEWT_COLORSET_DISENTRY
NEWT_COLORSET_COMPACTBUTTON
NEWT_COLORSET_ACTSELLISTBOX
NEWT_COLORSET_SELLISTBOX
Newt argument flags
constant
NEWT_ARG_LAST
NEWT_ARG_APPEND
meaning
Newt Flags Sense
constant
NEWT_FLAGS_SET
NEWT_FLAGS_RESET
NEWT_FLAGS_TOGGLE
meaning
Newt Components Flags
constant
NEWT_FLAG_RETURNEXIT
NEWT_FLAG_HIDDEN
NEWT_FLAG_SCROLL
NEWT_FLAG_DISABLED
NEWT_FLAG_BORDER
meaning
Exit form, when component is activated
Component is hidden
Component is scrollable
Component is disabled
NEWT_FLAG_WRAP
NEWT_FLAG_NOF12
NEWT_FLAG_MULTIPLE
NEWT_FLAG_SELECTED
NEWT_FLAG_CHECKBOX
NEWT_FLAG_PASSWORD
NEWT_FLAG_SHOWCURSOR
Wrap text
Don't exit form on pressing F12
Component is selected
Component is checkbox
Entry component is password entry
Show cursor
File Descriptor Flags
constant
NEWT_FD_READ
NEWT_FD_WRITE
NEWT_FD_EXCEPT
meaning
Checkbox Tree Flags
constant
meaning
NEWT_CHECKBOXTREE_UNSELECTABLE
NEWT_CHECKBOXTREE_HIDE_BOX
NEWT_CHECKBOXTREE_COLLAPSED
NEWT_CHECKBOXTREE_EXPANDED
NEWT_CHECKBOXTREE_UNSELECTED
NEWT_CHECKBOXTREE_SELECTED
Entry Flags
constant
NEWT_ENTRY_SCROLL
NEWT_ENTRY_HIDDEN
NEWT_ENTRY_RETURNEXIT
NEWT_ENTRY_DISABLED
meaning
Listbox Flags
constant
NEWT_LISTBOX_RETURNEXIT
meaning
Textbox Flags
constant
NEWT_TEXTBOX_WRAP
NEWT_TEXTBOX_SCROLL
meaning
Wrap text in the textbox
Scroll text in the textbox
Form Flags
constant
NEWT_FORM_NOF12
meaning
Don't exit form on F12 press
Newt Keys
constant
NEWT_KEY_TAB
NEWT_KEY_ENTER
NEWT_KEY_SUSPEND
NEWT_KEY_ESCAPE
NEWT_KEY_RETURN
NEWT_KEY_EXTRA_BASE
NEWT_KEY_UP
NEWT_KEY_DOWN
NEWT_KEY_LEFT
NEWT_KEY_RIGHT
NEWT_KEY_BKSPC
NEWT_KEY_DELETE
NEWT_KEY_HOME
meaning
NEWT_KEY_END
NEWT_KEY_UNTAB
NEWT_KEY_PGUP
NEWT_KEY_PGDN
NEWT_KEY_INSERT
NEWT_KEY_F1
NEWT_KEY_F2
NEWT_KEY_F3
NEWT_KEY_F4
NEWT_KEY_F5
NEWT_KEY_F6
NEWT_KEY_F7
NEWT_KEY_F8
NEWT_KEY_F9
NEWT_KEY_F10
NEWT_KEY_F11
NEWT_KEY_F12
NEWT_KEY_RESIZE
Newt Anchors
constant
NEWT_ANCHOR_LEFT
NEWT_ANCHOR_RIGHT
NEWT_ANCHOR_TOP
NEWT_ANCHOR_BOTTOM
meaning
Grid Flags
constant
NEWT_GRID_FLAG_GROWX
meaning
NEWT_GRID_FLAG_GROWY
NEWT_GRID_EMPTY
NEWT_GRID_COMPONENT
NEWT_GRID_SUBGRID
Newt Functions
newt_bell — Send a beep to the terminal
newt_button_bar — This function returns a grid containing the buttons created.
newt_button — Create a new button
newt_centered_window — Open a centered window of the specified size
newt_checkbox_get_value — Retreives value of checkox resource
newt_checkbox_set_flags — Configures checkbox resource
newt_checkbox_set_value — Sets the value of the checkbox
newt_checkbox_tree_add_item — Adds new item to the checkbox tree
newt_checkbox_tree_find_item — Finds an item in the checkbox tree
newt_checkbox_tree_get_current — Returns checkbox tree selected item
newt_checkbox_tree_get_entry_value — Description
newt_checkbox_tree_get_multi_selection — Description
newt_checkbox_tree_get_selection — Description
newt_checkbox_tree_multi — Description
newt_checkbox_tree_set_current — Description
newt_checkbox_tree_set_entry_value — Description
newt_checkbox_tree_set_entry — Description
newt_checkbox_tree_set_width — Description
newt_checkbox_tree — Description
newt_checkbox — Description
newt_clear_key_buffer — Discards the contents of the terminal's input buffer without waiting for additional input
newt_cls — Description
newt_compact_button — Description
newt_component_add_callback — Description
newt_component_takes_focus — Description
newt_create_grid — Description
newt_cursor_off — Description
newt_cursor_on — Description
newt_delay — Description
newt_draw_form — Description
newt_draw_root_text — Displays the string text at the position indicated
newt_entry_get_value — Description
newt_entry_set_filter — Description
newt_entry_set_flags — Description
newt_entry_set — Description
newt_entry — Description
newt_finished — Uninitializes newt interface
newt_form_add_component — Adds a single component to the form
newt_form_add_components — Add several components to the form
newt_form_add_hot_key — Description
newt_form_destroy — Destroys a form
newt_form_get_current — Description
newt_form_run — Runs a form
newt_form_set_background — Description
newt_form_set_height — Description
newt_form_set_size — Description
newt_form_set_timer — Description
newt_form_set_width — Description
newt_form_watch_fd — Description
newt_form — Create a form
newt_get_screen_size — Fills in the passed references with the current size of the terminal
newt_grid_add_components_to_form — Description
newt_grid_basic_window — Description
newt_grid_free — Description
newt_grid_get_size — Description
newt_grid_h_close_stacked — Description
newt_grid_h_stacked — Description
newt_grid_place — Description
newt_grid_set_field — Description
newt_grid_simple_window — Description
newt_grid_v_close_stacked — Description
newt_grid_v_stacked — Description
newt_grid_wrapped_window_at — Description
newt_grid_wrapped_window — Description
newt_init — Initialize newt
newt_label_set_text — Description
newt_label — Description
newt_listbox_append_entry — Description
newt_listbox_clear_selection — Description
newt_listbox_clear — Description
newt_listbox_delete_entry — Description
newt_listbox_get_current — Description
newt_listbox_get_selection — Description
newt_listbox_insert_entry — Description
newt_listbox_item_count — Description
newt_listbox_select_item — Description
newt_listbox_set_current_by_key — Description
newt_listbox_set_current — Description
newt_listbox_set_data — Description
newt_listbox_set_entry — Description
newt_listbox_set_width — Description
newt_listbox — Description
newt_listitem_get_data — Description
newt_listitem_set — Description
newt_listitem — Description
newt_open_window — Open a window of the specified size and position
newt_pop_help_line — Replaces the current help line with the one from the stack
newt_pop_window — Removes the top window from the display
newt_push_help_line — Saves the current help line on a stack, and displays the new line
newt_radio_get_current — Description
newt_radiobutton — Description
newt_redraw_help_line — Description
newt_reflow_text — Description
newt_refresh — Updates modified portions of the screen
newt_resize_screen — Description
newt_resume — Resume using the newt interface after calling newt_suspend
newt_run_form — Runs a form
newt_scale_set — Description
newt_scale — Description
newt_scrollbar_set — Description
newt_set_help_callback — Description
newt_set_suspend_callback — Set a callback function which gets invoked when user presses the suspend key
newt_suspend — Tells newt to return the terminal to its initial state
newt_textbox_get_num_lines — Description
newt_textbox_reflowed — Description
newt_textbox_set_height — Description
newt_textbox_set_text — Description
newt_textbox — Description
newt_vertical_scrollbar — Description
newt_wait_for_key — Doesn't return until a key has been pressed
newt_win_choice — Description
newt_win_entries — Description
newt_win_menu — Description
newt_win_message — Description
newt_win_messagev — Description
newt_win_ternary — Description
Readline — GNU Readline
Readline Functions
readline_add_history — Adds a line to the history
readline_callback_handler_install — Initializes the readline callback interface and terminal, prints the prompt and returns immediately
readline_callback_handler_remove — Removes a previously installed callback handler and restores terminal settings
readline_callback_read_char — Reads a character and informs the readline callback interface when a line is received
readline_clear_history — Clears the history
readline_completion_function — Registers a completion function
readline_info — Gets/sets various internal readline variables
readline_list_history — Lists the history
readline_on_new_line — Inform readline that the cursor has moved to a new line
readline_read_history — Reads the history
readline_redisplay — Redraws the display
readline_write_history — Writes the history
readline — Reads a line
Erweiterungen zur Datenkompression und Archivierung
Bzip2 Functions
bzclose — Close a bzip2 file
bzcompress — Compress a string into bzip2 encoded data
bzdecompress — Decompresses bzip2 encoded data
bzerrno — Returns a bzip2 error number
bzerror — Returns the bzip2 error number and error string in an array
bzerrstr — Returns a bzip2 error string
bzflush — Force a write of all buffered data
bzopen — Opens a bzip2 compressed file
bzread — Binary safe bzip2 file read
bzwrite — Binary safe bzip2 file write
LZF Functions
lzf_compress — LZF compression
lzf_decompress — LZF decompression
lzf_optimized_for — Determines what LZF extension was optimized for
Phar
Constant
Phar::NONE (integer)
Phar::COMPRESSED (integer)
Phar::GZ (integer)
Phar::BZ2 (integer)
Value
0x00000000
0x0000F000
0x00001000
0x00002000
Phar file format constantsConstant
Phar::SAME (integer)
Phar::PHAR (integer)
Phar::TAR (integer)
Phar::ZIP (integer)
Value
0
1
2
3
Phar signature constantsConstant
Phar::MD5 (integer)
Phar::SHA1 (integer)
Phar::OPENSSL (integer)
Value
0x0001
0x0002
0x0003
0x0004
0x0010
Phar webPhar mime override constantsConstant
Value
Description
no compression
bitmask that can be used with file flags to determine if any compression is present
zlib (gzip) compression
bzip2 compression
Description
retain the same file format
phar file format
tar file format
zip file format
Description
signature with md5 hash algorithm
signature with sha1 hash algorithm
signature with sha256 hash algorithm (requires hash extension)
signature with sha512 hash algorithm (requires hash extension)
signature with OpenSSL public/private key pair. This is a true, asymmetric key signature.
Description
Phar::PHP (integer)
Phar::PHPS (integer)
1
2
used to instruct the mimeoverrides parameter of Phar::webPhar() that the extension should be parsed as a PH
used to instruct the mimeoverrides parameter of Phar::webPhar() that the extension should be parsed as a PH
Phar — The Phar class
Phar::addEmptyDir — Add an empty directory to the phar archive
Phar::addFile — Add a file from the filesystem to the phar archive
Phar::addFromString — Add a file from the filesystem to the phar archive
Phar::apiVersion — Returns the api version
Phar::buildFromDirectory — Construct a phar archive from the files within a directory.
Phar::buildFromIterator — Construct a phar archive from an iterator.
Phar::canCompress — Returns whether phar extension supports compression using either zlib or bzip2
Phar::canWrite — Returns whether phar extension supports writing and creating phars
Phar::compress — Compresses the entire Phar archive using Gzip or Bzip2 compression
Phar::compressAllFilesBZIP2 — Compresses all files in the current Phar archive using Bzip2 compression
Phar::compressAllFilesGZ — Compresses all files in the current Phar archive using Gzip compression
Phar::compressFiles — Compresses all files in the current Phar archive
Phar::__construct — Construct a Phar archive object
Phar::convertToData — Convert a phar archive to a non-executable tar or zip file
Phar::convertToExecutable — Convert a phar archive to another executable phar archive file format
Phar::copy — Copy a file internal to the phar archive to another new file within the phar
Phar::count — Returns the number of entries (files) in the Phar archive
Phar::createDefaultStub — Create a phar-file format specific stub
Phar::decompress — Decompresses the entire Phar archive
Phar::decompressFiles — Decompresses all files in the current Phar archive
Phar::delMetadata — Deletes the global metadata of the phar
Phar::delete — Delete a file within a phar archive
Phar::extractTo — Extract the contents of a phar archive to a directory
Phar::getMetadata — Returns phar archive meta-data
Phar::getModified — Return whether phar was modified
Phar::getSignature — Return MD5/SHA1/SHA256/SHA512/OpenSSL signature of a Phar archive
Phar::getStub — Return the PHP loader or bootstrap stub of a Phar archive
Phar::getSupportedCompression — Return array of supported compression algorithms
Phar::getSupportedSignatures — Return array of supported signature types
Phar::getVersion — Return version info of Phar archive
Phar::hasMetadata — Returns whether phar has global meta-data
Phar::interceptFileFuncs — instructs phar to intercept fopen, file_get_contents, opendir, and all of the stat-related functions
Phar::isBuffering — Used to determine whether Phar write operations are being buffered, or are flushing directly to disk
Phar::isCompressed — Returns Phar::GZ or PHAR::BZ2 if the entire phar archive is compressed (.tar.gz/tar.bz and so on)
Phar::isFileFormat — Returns true if the phar archive is based on the tar/phar/zip file format depending on the parameter
Phar::isValidPharFilename — Returns whether the given filename is a valid phar filename
Phar::isWritable — Returns true if the phar archive can be modified
Phar::loadPhar — Loads any phar archive with an alias
Phar::mapPhar — Reads the currently executed file (a phar) and registers its manifest
Phar::mount — Mount an external path or file to a virtual location within the phar archive
Phar::mungServer — Defines a list of up to 4 $_SERVER variables that should be modified for execution
Phar::offsetExists — determines whether a file exists in the phar
Phar::offsetGet — Gets a PharFileInfo object for a specific file
Phar::offsetSet — set the contents of an internal file to those of an external file
Phar::offsetUnset — remove a file from a phar
Phar::running — Returns the full path on disk or full phar URL to the currently executing Phar archive
Phar::setAlias — Set the alias for the Phar archive
Phar::setDefaultStub — Used to set the PHP loader or bootstrap stub of a Phar archive to the default loader
Phar::setMetadata — Sets phar archive meta-data
Phar::setSignatureAlgorithm — set the signature algorithm for a phar and apply it.
Phar::setStub — Used to set the PHP loader or bootstrap stub of a Phar archive
Phar::startBuffering — Start buffering Phar write operations, do not modify the Phar object on disk
Phar::stopBuffering — Stop buffering write requests to the Phar archive, and save changes to disk
Phar::uncompressAllFiles — Uncompresses all files in the current Phar archive
Phar::unlinkArchive — Completely remove a phar archive from disk and from memory
Phar::webPhar — mapPhar for web-based phars. front controller for web applications
PharData — The PharData class
PharData::addEmptyDir — Add an empty directory to the tar/zip archive
PharData::addFile — Add a file from the filesystem to the tar/zip archive
PharData::addFromString — Add a file from the filesystem to the tar/zip archive
PharData::buildFromDirectory — Construct a tar/zip archive from the files within a directory.
PharData::buildFromIterator — Construct a tar or zip archive from an iterator.
PharData::compress — Compresses the entire tar/zip archive using Gzip or Bzip2 compression
PharData::compressFiles — Compresses all files in the current tar/zip archive
PharData::__construct — Construct a non-executable tar or zip archive object
PharData::convertToData — Convert a phar archive to a non-executable tar or zip file
PharData::convertToExecutable — Convert a non-executable tar/zip archive to an executable phar archive
PharData::copy — Copy a file internal to the phar archive to another new file within the phar
PharData::decompress — Decompresses the entire Phar archive
PharData::decompressFiles — Decompresses all files in the current zip archive
PharData::delMetadata — Deletes the global metadata of a zip archive
PharData::delete — Delete a file within a tar/zip archive
PharData::extractTo — Extract the contents of a tar/zip archive to a directory
PharData::isWritable — Returns true if the tar/zip archive can be modified
PharData::offsetSet — set the contents of a file within the tar/zip to those of an external file or string
PharData::offsetUnset — remove a file from a tar/zip archive
PharData::setAlias — dummy function (Phar::setAlias is not valid for PharData)
PharData::setDefaultStub — dummy function (Phar::setDefaultStub is not valid for PharData)
Phar::setMetadata — Sets phar archive meta-data
Phar::setSignatureAlgorithm — set the signature algorithm for a phar and apply it. The
PharData::setStub — dummy function (Phar::setStub is not valid for PharData)
PharFileInfo — The PharFileInfo class
PharFileInfo::chmod — Sets file-specific permission bits
PharFileInfo::compress — Compresses the current Phar entry with either zlib or bzip2 compression
PharFileInfo::__construct — Construct a Phar entry object
PharFileInfo::decompress — Decompresses the current Phar entry within the phar
PharFileInfo::delMetadata — Deletes the metadata of the entry
PharFileInfo::getCRC32 — Returns CRC32 code or throws an exception if CRC has not been verified
PharFileInfo::getCompressedSize — Returns the actual size of the file (with compression) inside the Phar archive
PharFileInfo::getMetadata — Returns file-specific meta-data saved with a file
PharFileInfo::getPharFlags — Returns the Phar file entry flags
PharFileInfo::hasMetadata — Returns the metadata of the entry
PharFileInfo::isCRCChecked — Returns whether file entry has had its CRC verified
PharFileInfo::isCompressed — Returns whether the entry is compressed
PharFileInfo::isCompressedBZIP2 — Returns whether the entry is compressed using bzip2
PharFileInfo::isCompressedGZ — Returns whether the entry is compressed using gz
PharFileInfo::setCompressedBZIP2 — Compresses the current Phar entry within the phar using Bzip2 compression
PharFileInfo::setCompressedGZ — Compresses the current Phar entry within the phar using gz compression
PharFileInfo::setMetadata — Sets file-specific meta-data saved with a file
PharFileInfo::setUncompressed — Uncompresses the current Phar entry within the phar, if it is compressed
PharException — The PharException class
PharException — The PharException class provides a phar-specific exception class for try/catch blocks.
Rar Archiving
RAR_HOST_MSDOS (integer) - Use RarEntry::HOST_MSDOS instead.
RAR_HOST_OS2 (integer) - Use RarEntry::HOST_OS2 instead.
RAR_HOST_WIN32 (integer) - Use RarEntry::HOST_WIN32 instead.
RAR_HOST_UNIX (integer) - Use RarEntry::HOST_UNIX instead.
RAR_HOST_BEOS (integer) - Use RarEntry::HOST_BEOS instead.
Rar Functions
rar_wrapper_cache_stats — Cache hits and misses for the URL wrapper
RarArchive — The RarArchive class
RarArchive::close — Close RAR archive and free all resources
RarArchive::getComment — Get comment text from the RAR archive
RarArchive::getEntries — Get full list of entries from the RAR archive
RarArchive::getEntry — Get entry object from the RAR archive
RarArchive::isBroken — Test whether an archive is broken (incomplete)
RarArchive::isSolid — Check whether the RAR archive is solid
RarArchive::open — Open RAR archive
RarArchive::setAllowBroken — Whether opening broken archives is allowed
RarArchive::__toString — Get text representation
RarEntry — The RarEntry clas
RarEntry::extract — Extract entry from the archive
RarEntry::getAttr — Get attributes of the entry
RarEntry::getCrc — Get CRC of the entry
RarEntry::getFileTime — Get entry last modification time
RarEntry::getHostOs — Get entry host OS
RarEntry::getMethod — Get pack method of the entry
RarEntry::getName — Get name of the entry
RarEntry::getPackedSize — Get packed size of the entry
RarEntry::getStream — Get file handler for entry
RarEntry::getUnpackedSize — Get unpacked size of the entry
RarEntry::getVersion — Get minimum version of RAR program required to unpack the entry
RarEntry::isDirectory — Test whether an entry represents a directory
RarEntry::isEncrypted — Test whether an entry is encrypted
RarEntry::__toString — Get text representation of entry
RarException — The RarException class
RarException::isUsingExceptions — Check whether error handling with exceptions is in use
RarException::setUsingExceptions — Activate and deactivate error handling with exceptions
Zip
ZipArchive uses class constants. There are three types of constants : Flags (prefixed with FL_), errors (prefixed with ER_) and mode (no prefix).
ZipArchive::CREATE (integer) - Create the archive if it does not exist.
ZipArchive::OVERWRITE (integer) - Always start a new archive, this mode will overwrite the file if it already exists.
ZipArchive::EXCL (integer) - Error if archive already exists.
ZipArchive::CHECKCONS (integer) - Perform additional consistency checks on the archive, and error if they fail.
ZipArchive::FL_NOCASE (integer) - Ignore case on name lookup
ZipArchive::FL_NODIR (integer) - Ignore directory component
ZipArchive::FL_COMPRESSED (integer) - Read compressed data
ZipArchive::FL_UNCHANGED (integer) - Use original data, ignoring changes.
ZipArchive::CM_DEFAULT (integer) - better of deflate or store.
ZipArchive::CM_STORE (integer) - stored (uncompressed).
ZipArchive::CM_SHRINK (integer) - shrunk
ZipArchive::CM_REDUCE_1 (integer) - reduced with factor 1
ZipArchive::CM_IMPLODE (integer) - imploded
ZipArchive::CM_DEFLATE (integer) - deflated
ZipArchive::CM_DEFLATE64 (integer) - deflate64
ZipArchive::CM_PKWARE_IMPLODE (integer) - PKWARE imploding
ZipArchive::CM_BZIP2 (integer) - BZIP2 algorithm
ZipArchive::ER_OK (integer) - No error.
ZipArchive::ER_MULTIDISK (integer) - Multi-disk zip archives not supported.
ZipArchive::ER_RENAME (integer) - Renaming temporary file failed.
ZipArchive::ER_CLOSE (integer) - Closing zip archive failed
ZipArchive::ER_SEEK (integer) - Seek error
ZipArchive::ER_READ (integer) - Read error
ZipArchive::ER_WRITE (integer) - Write error
ZipArchive::ER_CRC (integer) - CRC error
ZipArchive::ER_ZIPCLOSED (integer) - Containing zip archive was closed
ZipArchive::ER_NOENT (integer) - No such file.
ZipArchive::ER_EXISTS (integer) - File already exists
ZipArchive::ER_OPEN (integer) - Can't open file
ZipArchive::ER_TMPOPEN (integer) - Failure to create temporary file.
ZipArchive::ER_ZLIB (integer) - Zlib error
ZipArchive::ER_MEMORY (integer) - Memory allocation failure
ZipArchive::ER_CHANGED (string) - Entry has been changed
ZipArchive::ER_COMPNOTSUPP (integer) - Compression method not supported.
ZipArchive::ER_EOF (integer) - Premature EOF
ZipArchive::ER_INVAL (integer) - Invalid argument
ZipArchive::ER_NOZIP (integer) - Not a zip archive
ZipArchive::ER_INTERNAL (integer) - Internal error
ZipArchive::ER_INCONS (integer) - Zip archive inconsistent
ZipArchive::ER_REMOVE (integer) - Can't remove file
ZipArchive::ER_DELETED (integer) - Entry has been deleted
ZipArchive — The ZipArchive class
ZipArchive::addEmptyDir — Add a new directory
ZipArchive::addFile — Adds a file to a ZIP archive from the given path
ZipArchive::addFromString — Add a file to a ZIP archive using its contents
ZipArchive::addGlob — Add files from a directory by glob pattern
ZipArchive::addPattern — Add files from a directory by PCRE pattern
ZipArchive::close — Close the active archive (opened or newly created)
ZipArchive::deleteIndex — delete an entry in the archive using its index
ZipArchive::deleteName — delete an entry in the archive using its name
ZipArchive::extractTo — Extract the archive contents
ZipArchive::getArchiveComment — Returns the Zip archive comment
ZipArchive::getCommentIndex — Returns the comment of an entry using the entry index
ZipArchive::getCommentName — Returns the comment of an entry using the entry name
ZipArchive::getFromIndex — Returns the entry contents using its index
ZipArchive::getFromName — Returns the entry contents using its name
ZipArchive::getNameIndex — Returns the name of an entry using its index
ZipArchive::getStatusString — Returns the status error message, system and/or zip messages
ZipArchive::getStream — Get a file handler to the entry defined by its name (read only).
ZipArchive::locateName — Returns the index of the entry in the archive
ZipArchive::open — Open a ZIP file archive
ZipArchive::renameIndex — Renames an entry defined by its index
ZipArchive::renameName — Renames an entry defined by its name
ZipArchive::setArchiveComment — Set the comment of a ZIP archive
ZipArchive::setCommentIndex — Set the comment of an entry defined by its index
ZipArchive::setCommentName — Set the comment of an entry defined by its name
ZipArchive::statIndex — Get the details of an entry defined by its index.
ZipArchive::statName — Get the details of an entry defined by its name.
ZipArchive::unchangeAll — Undo all changes done in the archive
ZipArchive::unchangeArchive — Revert all global changes done in the archive.
ZipArchive::unchangeIndex — Revert all changes done to an entry at the given index
ZipArchive::unchangeName — Revert all changes done to an entry with the given name.
Zip Functions
zip_close — Close a ZIP file archive
zip_entry_close — Close a directory entry
zip_entry_compressedsize — Retrieve the compressed size of a directory entry
zip_entry_compressionmethod — Retrieve the compression method of a directory entry
zip_entry_filesize — Retrieve the actual file size of a directory entry
zip_entry_name — Retrieve the name of a directory entry
zip_entry_open — Open a directory entry for reading
zip_entry_read — Read from an open directory entry
zip_open — Open a ZIP file archive
zip_read — Read next entry in a ZIP file archive
Zlib Compression
FORCE_GZIP (integer)
FORCE_DEFLATE (integer)
Zlib Functions
gzclose — Close an open gz-file pointer
gzcompress — Compress a string
gzdecode — Decodes a gzip compressed string
gzdeflate — Deflate a string
gzencode — Create a gzip compressed string
gzeof — Test for EOF on a gz-file pointer
gzfile — Read entire gz-file into an array
gzgetc — Get character from gz-file pointer
gzgets — Get line from file pointer
gzgetss — Get line from gz-file pointer and strip HTML tags
gzinflate — Inflate a deflated string
gzopen — Open gz-file
gzpassthru — Output all remaining data on a gz-file pointer
gzputs — Alias of gzwrite
gzread — Binary-safe gz-file read
gzrewind — Rewind the position of a gz-file pointer
gzseek — Seek on a gz-file pointer
gztell — Tell gz-file pointer read/write position
gzuncompress — Uncompress a compressed string
gzwrite — Binary-safe gz-file write
readgzfile — Output a gz-file
zlib_decode — Uncompress any raw/gzip/zlib encoded data
zlib_encode — Compress data with the specified encoding
zlib_get_coding_type — Returns the coding type used for output compression
Kreditkartendaten-Verarbeitung
MCVE — MCVE (Monetra) Payment
M_PENDING (integer)
M_DONE (integer)
M_ERROR (integer)
M_FAIL (integer)
M_SUCCESS (integer)
MCVE Functions
m_checkstatus — Check to see if a transaction has completed
m_completeauthorizations — Number of complete authorizations in queue, returning an array of their identifiers
m_connect — Establish the connection to MCVE
m_connectionerror — Get a textual representation of why a connection failed
m_deletetrans — Delete specified transaction from MCVE_CONN structure
m_destroyconn — Destroy the connection and MCVE_CONN structure
m_destroyengine — Free memory associated with IP/SSL connectivity
m_getcell — Get a specific cell from a comma delimited response by column name
m_getcellbynum — Get a specific cell from a comma delimited response by column number
m_getcommadelimited — Get the RAW comma delimited data returned from MCVE
m_getheader — Get the name of the column in a comma-delimited response
m_initconn — Create and initialize an MCVE_CONN structure
m_initengine — Ready the client for IP/SSL Communication
m_iscommadelimited — Checks to see if response is comma delimited
m_maxconntimeout — The maximum amount of time the API will attempt a connection to MCVE
m_monitor — Perform communication with MCVE (send/receive data) Non-blocking
m_numcolumns — Number of columns returned in a comma delimited response
m_numrows — Number of rows returned in a comma delimited response
m_parsecommadelimited — Parse the comma delimited response so m_getcell, etc will work
m_responsekeys — Returns array of strings which represents the keys that can be used for response parameters on this transaction
m_responseparam — Get a custom response parameter
m_returnstatus — Check to see if the transaction was successful
m_setblocking — Set blocking/non-blocking mode for connection
m_setdropfile — Set the connection method to Drop-File
m_setip — Set the connection method to IP
m_setssl_cafile — Set SSL CA (Certificate Authority) file for verification of server certificate
m_setssl_files — Set certificate key files and certificates if server requires client certificate verification
m_setssl — Set the connection method to SSL
m_settimeout — Set maximum transaction time (per trans)
m_sslcert_gen_hash — Generate hash for SSL client certificate verification
m_transactionssent — Check to see if outgoing buffer is clear
m_transinqueue — Number of transactions in client-queue
m_transkeyval — Add key/value pair to a transaction. Replaces deprecated transparam()
m_transnew — Start a new transaction
m_transsend — Finalize and send the transaction
m_uwait — Wait x microsecs
m_validateidentifier — Whether or not to validate the passed identifier on any transaction it is passed to
m_verifyconnection — Set whether or not to PING upon connect to verify connection
m_verifysslcert — Set whether or not to verify the server ssl certificate
SPPLUS — SPPLUS Payment System
SPPLUS Functions
calcul_hmac — Obtain a hmac key (needs 8 arguments)
calculhmac — Obtain a hmac key (needs 2 arguments)
nthmac — Obtain a nthmac key (needs 2 arguments)
signeurlpaiement — Obtain the payment url (needs 2 arguments)
Kryptografische Erweiterungen
Crack — Cracklib
Crack Functions
crack_check — Performs an obscure check with the given password
crack_closedict — Closes an open CrackLib dictionary
crack_getlastmessage — Returns the message from the last obscure check
crack_opendict — Opens a new CrackLib dictionary
Hash — HASH Message Digest Framework
HASH_HMAC (integer) - Optional flag for hash_init(). Indicates that the HMAC digest-keying algorithm should be applied to the current hashing context.
Hash Functions
hash_algos — Return a list of registered hashing algorithms
hash_copy — Copy hashing context
hash_file — Generate a hash value using the contents of a given file
hash_final — Finalize an incremental hash and return resulting digest
hash_hmac_file — Generate a keyed hash value using the HMAC method and the contents of a given file
hash_hmac — Generate a keyed hash value using the HMAC method
hash_init — Initialize an incremental hashing context
hash_pbkdf2 — Generate a PBKDF2 key derivation of a supplied password
hash_update_file — Pump data into an active hashing context from a file
hash_update_stream — Pump data into an active hashing context from an open stream
hash_update — Pump data into an active hashing context
hash — Generate a hash value (message digest)
Mcrypt
Mcrypt can operate in four block cipher modes (CBC, OFB, CFB, and ECB). If linked against libmcrypt-2.4.x or higher the functions can also operate in the block
cipher mode nOFB and in STREAM mode. Below you find a list with all supported encryption modes together with the constants that are defines for the
encryption mode. For a more complete reference and discussion see Applied Cryptography by Schneier (ISBN 0-471-11709-9).
MCRYPT_MODE_ECB (electronic codebook) is suitable for random data, such as encrypting other keys. Since data there is short and random, the disadvantages
of ECB have a favorable negative effect.
MCRYPT_MODE_CBC (cipher block chaining) is especially suitable for encrypting files where the security is increased over ECB significantly.
MCRYPT_MODE_CFB (cipher feedback) is the best mode for encrypting byte streams where single bytes must be encrypted.
MCRYPT_MODE_OFB (output feedback, in 8bit) is comparable to CFB, but can be used in applications where error propagation cannot be tolerated. It's insecure
(because it operates in 8bit mode) so it is not recommended to use it.
MCRYPT_MODE_NOFB (output feedback, in nbit) is comparable to OFB, but more secure because it operates on the block size of the algorithm.
MCRYPT_MODE_STREAM is an extra mode to include some stream algorithms like "WAKE" or "RC4".
Some other mode and random device constants:
MCRYPT_ENCRYPT (integer)
MCRYPT_DECRYPT (integer)
MCRYPT_DEV_RANDOM (integer)
MCRYPT_DEV_URANDOM (integer)
MCRYPT_RAND (integer)
Mcrypt ciphers
Here is a list of ciphers which are currently supported by the mcrypt extension. For a complete list of supported ciphers, see the defines at the end of mcrypt.h.
The general rule with the mcrypt-2.2.x API is that you can access the cipher from PHP with MCRYPT_ciphername. With the libmcrypt-2.4.x and libmcrypt-2.5.x
API these constants also work, but it is possible to specify the name of the cipher as a string with a call to mcrypt_module_open().
MCRYPT_3DES
MCRYPT_ARCFOUR_IV (libmcrypt > 2.4.x only)
MCRYPT_ARCFOUR (libmcrypt > 2.4.x only)
MCRYPT_BLOWFISH
MCRYPT_CAST_128
MCRYPT_CAST_256
MCRYPT_CRYPT
MCRYPT_DES
MCRYPT_DES_COMPAT (libmcrypt 2.2.x only)
MCRYPT_ENIGMA (libmcrypt > 2.4.x only, alias for MCRYPT_CRYPT)
MCRYPT_GOST
MCRYPT_IDEA (non-free)
MCRYPT_LOKI97 (libmcrypt > 2.4.x only)
MCRYPT_MARS (libmcrypt > 2.4.x only, non-free)
MCRYPT_PANAMA (libmcrypt > 2.4.x only)
MCRYPT_RIJNDAEL_128 (libmcrypt > 2.4.x only)
MCRYPT_RC2
MCRYPT_RC4 (libmcrypt 2.2.x only)
MCRYPT_RC6 (libmcrypt > 2.4.x only)
MCRYPT_RC6_128 (libmcrypt 2.2.x only)
MCRYPT_SAFER64
MCRYPT_SAFER128
MCRYPT_SAFERPLUS (libmcrypt > 2.4.x only)
MCRYPT_SERPENT(libmcrypt > 2.4.x only)
MCRYPT_SERPENT_128 (libmcrypt 2.2.x only)
MCRYPT_SKIPJACK (libmcrypt > 2.4.x only)
MCRYPT_TEAN (libmcrypt 2.2.x only)
MCRYPT_THREEWAY
MCRYPT_TRIPLEDES (libmcrypt > 2.4.x only)
MCRYPT_TWOFISH (for older mcrypt 2.x versions, or mcrypt > 2.4.x )
MCRYPT_TWOFISH128 (TWOFISHxxx are available in newer 2.x versions, but not in the 2.4.x versions)
MCRYPT_TWOFISH192
MCRYPT_TWOFISH256
MCRYPT_WAKE (libmcrypt > 2.4.x only)
MCRYPT_XTEA (libmcrypt > 2.4.x only)
Mcrypt Functions
mcrypt_cbc — Encrypts/decrypts data in CBC mode
mcrypt_cfb — Encrypts/decrypts data in CFB mode
mcrypt_create_iv — Creates an initialization vector (IV) from a random source
mcrypt_decrypt — Decrypts crypttext with given parameters
mcrypt_ecb — Deprecated: Encrypts/decrypts data in ECB mode
mcrypt_enc_get_algorithms_name — Returns the name of the opened algorithm
mcrypt_enc_get_block_size — Returns the blocksize of the opened algorithm
mcrypt_enc_get_iv_size — Returns the size of the IV of the opened algorithm
mcrypt_enc_get_key_size — Returns the maximum supported keysize of the opened mode
mcrypt_enc_get_modes_name — Returns the name of the opened mode
mcrypt_enc_get_supported_key_sizes — Returns an array with the supported keysizes of the opened algorithm
mcrypt_enc_is_block_algorithm_mode — Checks whether the encryption of the opened mode works on blocks
mcrypt_enc_is_block_algorithm — Checks whether the algorithm of the opened mode is a block algorithm
mcrypt_enc_is_block_mode — Checks whether the opened mode outputs blocks
mcrypt_enc_self_test — Runs a self test on the opened module
mcrypt_encrypt — Encrypts plaintext with given parameters
mcrypt_generic_deinit — This function deinitializes an encryption module
mcrypt_generic_end — This function terminates encryption
mcrypt_generic_init — This function initializes all buffers needed for encryption
mcrypt_generic — This function encrypts data
mcrypt_get_block_size — Gets the block size of the specified cipher
mcrypt_get_cipher_name — Gets the name of the specified cipher
mcrypt_get_iv_size — Returns the size of the IV belonging to a specific cipher/mode combination
mcrypt_get_key_size — Gets the key size of the specified cipher
mcrypt_list_algorithms — Gets an array of all supported ciphers
mcrypt_list_modes — Gets an array of all supported modes
mcrypt_module_close — Closes the mcrypt module
mcrypt_module_get_algo_block_size — Returns the blocksize of the specified algorithm
mcrypt_module_get_algo_key_size — Returns the maximum supported keysize of the opened mode
mcrypt_module_get_supported_key_sizes — Returns an array with the supported keysizes of the opened algorithm
mcrypt_module_is_block_algorithm_mode — Returns if the specified module is a block algorithm or not
mcrypt_module_is_block_algorithm — This function checks whether the specified algorithm is a block algorithm
mcrypt_module_is_block_mode — Returns if the specified mode outputs blocks or not
mcrypt_module_open — Opens the module of the algorithm and the mode to be used
mcrypt_module_self_test — This function runs a self test on the specified module
mcrypt_ofb — Encrypts/decrypts data in OFB mode
mdecrypt_generic — Decrypts data
Mhash
Here is a list of hashes which are currently supported by mhash. If a hash is not listed here, but it is listed in the mhash documentation as supported, you can
safely assume that this documentation is outdated.
MHASH_ADLER32
MHASH_CRC32
MHASH_CRC32B
MHASH_GOST
MHASH_HAVAL128
MHASH_HAVAL160
MHASH_HAVAL192
MHASH_HAVAL224
MHASH_HAVAL256
MHASH_MD2
MHASH_MD4
MHASH_MD5
MHASH_RIPEMD128
MHASH_RIPEMD256
MHASH_RIPEMD320
MHASH_SHA1
MHASH_SHA192
MHASH_SHA224
MHASH_SHA256
MHASH_SHA384
MHASH_SHA512
MHASH_SNEFRU128
MHASH_SNEFRU256
MHASH_TIGER
MHASH_TIGER128
MHASH_TIGER160
MHASH_WHIRLPOOL
Mhash Functions
mhash_count — Gets the highest available hash ID
mhash_get_block_size — Gets the block size of the specified hash
mhash_get_hash_name — Gets the name of the specified hash
mhash_keygen_s2k — Generates a key
mhash — Computes hash
OpenSSL
Purpose checking flags ¶
X509_PURPOSE_SSL_CLIENT (integer)
X509_PURPOSE_SSL_SERVER (integer)
X509_PURPOSE_NS_SSL_SERVER (integer)
X509_PURPOSE_SMIME_SIGN (integer)
X509_PURPOSE_SMIME_ENCRYPT (integer)
X509_PURPOSE_CRL_SIGN (integer)
X509_PURPOSE_ANY (integer)
Padding flags for asymmetric encryption
OPENSSL_PKCS1_PADDING (integer)
OPENSSL_SSLV23_PADDING (integer)
OPENSSL_NO_PADDING (integer)
OPENSSL_PKCS1_OAEP_PADDING (integer)
Key types
OPENSSL_KEYTYPE_RSA (integer)
OPENSSL_KEYTYPE_DSA (integer)
OPENSSL_KEYTYPE_DH (integer)
OPENSSL_KEYTYPE_EC (integer)
PKCS7 Flags/Constants
Constant
Description
PKCS7_TEXT
Adds text/plain content type headers to encrypted/signed message. If decrypting or verifying, it strips those headers from the output - if the decrypted or
PKCS7_BINARY
Normally the input message is converted to "canonical" format which is effectively using CR and LF as end of line: as required by the S/MIME specification.
PKCS7_NOINTERN When verifying a message, certificates (if any) included in the message are normally searched for the signing certificate. With this option only the certificat
PKCS7_NOVERIFY Do not verify the signers certificate of a signed message.
PKCS7_NOCHAIN
Do not chain verification of signers certificates: that is don't use the certificates in the signed message as untrusted CAs.
PKCS7_NOCERTS
When signing a message the signer's certificate is normally included - with this option it is excluded. This will reduce the size of the signed message but the
PKCS7_NOATTR
Normally when a message is signed, a set of attributes are included which include the signing time and the supported symmetric algorithms. With this opt
When signing a message, use cleartext signing with the MIME type "multipart/signed". This is the default if you do not specify any flags to openssl_pkcs7_
PKCS7_DETACHED not support S/MIME.
PKCS7_NOSIGS
Don't try and verify the signatures on a message
Signature Algorithms
OPENSSL_ALGO_DSS1 (integer)
OPENSSL_ALGO_SHA1 (integer) - Used as default algorithm by openssl_sign() and openssl_verify().
OPENSSL_ALGO_SHA224 (integer)
OPENSSL_ALGO_RMD160 (integer)
OPENSSL_ALGO_MD5 (integer)
Ciphers
OPENSSL_CIPHER_RC2_40 (integer)
OPENSSL_CIPHER_DES (integer)
OPENSSL_CIPHER_3DES (integer)
OPENSSL_CIPHER_AES_128_CBC (integer)
Version constants
OPENSSL_VERSION_TEXT (string)
OPENSSL_VERSION_NUMBER (integer)
Server Name Indication constants
OPENSSL_TLSEXT_SERVER_NAME (string) - Whether SNI support is available or not.
Key/Certificate parameters
Quite a few of the openssl functions require a key or a certificate parameter. PHP 4.0.5 and earlier have to use a key or certificate resource returned by one of
the openssl_get_xxx() functions. Later versions may use one of the following methods:
Certificates
An X.509 resource returned from openssl_x509_read()
A string having the format file://path/to/cert.pem; the named file must contain a PEM encoded certificate
A string containing the content of a certificate, PEM encoded
Public/Private Keys
A key resource returned from openssl_get_publickey() or openssl_get_privatekey()
For public keys only: an X.509 resource
A string having the format file://path/to/file.pem - the named file must contain a PEM encoded certificate/private key (it may contain both)
A string containing the content of a certificate/key, PEM encoded
For private keys, you may also use the syntax array($key, $passphrase) where $key represents a key specified using the file:// or textual content notation
above, and $passphrase represents a string containing the passphrase for that private key
Certificate Verification
When calling a function that will verify a signature/certificate, the cainfo parameter is an array containing file and directory names that specify the locations of
trusted CA files. If a directory is specified, then it must be a correctly formed hashed directory as the openssl command would use.
OpenSSL Functions
openssl_cipher_iv_length — Gets the cipher iv length
openssl_csr_export_to_file — Exports a CSR to a file
openssl_csr_export — Exports a CSR as a string
openssl_csr_get_public_key — Returns the public key of a CERT
openssl_csr_get_subject — Returns the subject of a CERT
openssl_csr_new — Generates a CSR
openssl_csr_sign — Sign a CSR with another certificate (or itself) and generate a certificate
openssl_decrypt — Decrypts data
openssl_dh_compute_key — Computes shared secret for public value of remote DH key and local DH key
openssl_digest — Computes a digest
openssl_encrypt — Encrypts data
openssl_error_string — Return openSSL error message
openssl_free_key — Free key resource
openssl_get_cipher_methods — Gets available cipher methods
openssl_get_md_methods — Gets available digest methods
openssl_get_privatekey — Alias of openssl_pkey_get_private
openssl_get_publickey — Alias of openssl_pkey_get_public
openssl_open — Open sealed data
openssl_pbkdf2 — Generates a PKCS5 v2 PBKDF2 string, defaults to SHA-1
openssl_pkcs12_export_to_file — Exports a PKCS#12 Compatible Certificate Store File
openssl_pkcs12_export — Exports a PKCS#12 Compatible Certificate Store File to variable.
openssl_pkcs12_read — Parse a PKCS#12 Certificate Store into an array
openssl_pkcs7_decrypt — Decrypts an S/MIME encrypted message
openssl_pkcs7_encrypt — Encrypt an S/MIME message
openssl_pkcs7_sign — Sign an S/MIME message
openssl_pkcs7_verify — Verifies the signature of an S/MIME signed message
openssl_pkey_export_to_file — Gets an exportable representation of a key into a file
openssl_pkey_export — Gets an exportable representation of a key into a string
openssl_pkey_free — Frees a private key
openssl_pkey_get_details — Returns an array with the key details
openssl_pkey_get_private — Get a private key
openssl_pkey_get_public — Extract public key from certificate and prepare it for use
openssl_pkey_new — Generates a new private key
openssl_private_decrypt — Decrypts data with private key
openssl_private_encrypt — Encrypts data with private key
openssl_public_decrypt — Decrypts data with public key
openssl_public_encrypt — Encrypts data with public key
openssl_random_pseudo_bytes — Generate a pseudo-random string of bytes
openssl_seal — Seal (encrypt) data
openssl_sign — Generate signature
openssl_verify — Verify signature
openssl_x509_check_private_key — Checks if a private key corresponds to a certificate
openssl_x509_checkpurpose — Verifies if a certificate can be used for a particular purpose
openssl_x509_export_to_file — Exports a certificate to file
openssl_x509_export — Exports a certificate as a string
openssl_x509_free — Free certificate resource
openssl_x509_parse — Parse an X509 certificate and return the information as an array
openssl_x509_read — Parse an X.509 certificate and return a resource identifier for it
Password Hashing
PASSWORD_BCRYPT (integer) - PASSWORD_BCRYPT is used to create new password hashes using the CRYPT_BLOWFISH algorithm.
This will always result in a hash using the "$2y$" crypt format, which is always 60 characters wide.
Supported Options:
salt - to manually provide a salt to use when hashing the password. Note that this will override and prevent a salt from being automatically generated.
If omitted, a random salt will be generated by password_hash() for each password hashed. This is the intended mode of operation.
cost - which denotes the algorithmic cost that should be used. Examples of these values can be found on the crypt() page.
If ommitted, a default value of 10 will be used. This is a good baseline cost, but you may want to consider increasing it depending on your hardware.
PASSWORD_DEFAULT (integer) - The default algorithm to use for hashing if no algorithm is provided. This may change in newer PHP releases when newer,
stronger hashing algorithms are supported.
It is worth noting that over time this constant can (and likely will) change. Therefore you should be aware that the length of the resulting hash can change.
Therefore, if you use PASSWORD_DEFAULT you should store the resulting hash in a way that can store more than 60 characters (255 is the recomended width).
Password Hashing Functions
password_get_info — Returns information about the given hash
password_hash — Creates a password hash
password_needs_rehash — Checks if the given hash matches the given options
password_verify — Verifies that a password matches a hash
Datenbankerweiterungen
Abstraction Layers
DBA — Database (dbm-style) Abstraction Layer
DBA Functions
dba_close — Close a DBA database
dba_delete — Delete DBA entry specified by key
dba_exists — Check whether key exists
dba_fetch — Fetch data specified by key
dba_firstkey — Fetch first key
dba_handlers — List all the handlers available
dba_insert — Insert entry
dba_key_split — Splits a key in string representation into array representation
dba_list — List all open database files
dba_nextkey — Fetch next key
dba_open — Open database
dba_optimize — Optimize database
dba_popen — Open database persistently
dba_replace — Replace or insert entry
dba_sync — Synchronize database
dbx
DBX_MYSQL (integer)
DBX_ODBC (integer)
DBX_PGSQL (integer)
DBX_MSSQL (integer)
DBX_FBSQL (integer)
DBX_OCI8 (integer) (available from PHP 4.3.0)
DBX_SYBASECT (integer)
DBX_SQLITE (integer) (PHP 5)
DBX_PERSISTENT (integer)
DBX_RESULT_INFO (integer)
DBX_RESULT_INDEX (integer)
DBX_RESULT_ASSOC (integer)
DBX_RESULT_UNBUFFERED (integer) (PHP 5)
DBX_COLNAMES_UNCHANGED (integer) (available from PHP 4.3.0)
DBX_COLNAMES_UPPERCASE (integer) (available from PHP 4.3.0)
DBX_COLNAMES_LOWERCASE (integer) (available from PHP 4.3.0)
DBX_CMP_NATIVE (integer)
DBX_CMP_TEXT (integer)
DBX_CMP_NUMBER (integer)
DBX_CMP_ASC (integer)
DBX_CMP_DESC (integer)
dbx Functions
dbx_close — Close an open connection/database
dbx_compare — Compare two rows for sorting purposes
dbx_connect — Open a connection/database
dbx_error — Report the error message of the latest function call in the module
dbx_escape_string — Escape a string so it can safely be used in an sql-statement
dbx_fetch_row — Fetches rows from a query-result that had the DBX_RESULT_UNBUFFERED flag set
dbx_query — Send a query and fetch all results (if any)
dbx_sort — Sort a result from a dbx_query by a custom sort function
ODBC (Unified)
ODBC_TYPE (integer)
ODBC_BINMODE_PASSTHRU (integer)
ODBC_BINMODE_RETURN (integer)
ODBC_BINMODE_CONVERT (integer)
SQL_ODBC_CURSORS (integer)
SQL_CUR_USE_DRIVER (integer)
SQL_CUR_USE_IF_NEEDED (integer)
SQL_CUR_USE_ODBC (integer)
SQL_CONCURRENCY (integer)
SQL_CONCUR_READ_ONLY (integer)
SQL_CONCUR_LOCK (integer)
SQL_CONCUR_ROWVER (integer)
SQL_CONCUR_VALUES (integer)
SQL_CURSOR_TYPE (integer)
SQL_CURSOR_FORWARD_ONLY (integer)
SQL_CURSOR_KEYSET_DRIVEN (integer)
SQL_CURSOR_DYNAMIC (integer)
SQL_CURSOR_STATIC (integer)
SQL_KEYSET_SIZE (integer)
SQL_CHAR (integer)
SQL_VARCHAR (integer)
SQL_LONGVARCHAR (integer)
SQL_DECIMAL (integer)
SQL_NUMERIC (integer)
SQL_BIT (integer)
SQL_TINYINT (integer)
SQL_SMALLINT (integer)
SQL_INTEGER (integer)
SQL_BIGINT (integer)
SQL_REAL (integer)
SQL_FLOAT (integer)
SQL_DOUBLE (integer)
SQL_BINARY (integer)
SQL_VARBINARY (integer)
SQL_LONGVARBINARY (integer)
SQL_DATE (integer)
SQL_TIME (integer)
SQL_TIMESTAMP (integer)
SQL_TYPE_DATE (integer)
SQL_TYPE_TIME (integer)
SQL_TYPE_TIMESTAMP (integer)
SQL_BEST_ROWID (integer)
SQL_ROWVER (integer)
SQL_SCOPE_CURROW (integer)
SQL_SCOPE_TRANSACTION (integer)
SQL_SCOPE_SESSION (integer)
SQL_NO_NULLS (integer)
SQL_NULLABLE (integer)
SQL_INDEX_UNIQUE (integer)
SQL_INDEX_ALL (integer)
SQL_ENSURE (integer)
SQL_QUICK (integer)
ODBC Functions
odbc_autocommit — Toggle autocommit behaviour
odbc_binmode — Handling of binary column data
odbc_close_all — Close all ODBC connections
odbc_close — Close an ODBC connection
odbc_columnprivileges — Lists columns and associated privileges for the given table
odbc_columns — Lists the column names in specified tables
odbc_commit — Commit an ODBC transaction
odbc_connect — Connect to a datasource
odbc_cursor — Get cursorname
odbc_data_source — Returns information about a current connection
odbc_do — Alias of odbc_exec
odbc_error — Get the last error code
odbc_errormsg — Get the last error message
odbc_exec — Prepare and execute an SQL statement
odbc_execute — Execute a prepared statement
odbc_fetch_array — Fetch a result row as an associative array
odbc_fetch_into — Fetch one result row into array
odbc_fetch_object — Fetch a result row as an object
odbc_fetch_row — Fetch a row
odbc_field_len — Get the length (precision) of a field
odbc_field_name — Get the columnname
odbc_field_num — Return column number
odbc_field_precision — Alias of odbc_field_len
odbc_field_scale — Get the scale of a field
odbc_field_type — Datatype of a field
odbc_foreignkeys — Retrieves a list of foreign keys
odbc_free_result — Free resources associated with a result
odbc_gettypeinfo — Retrieves information about data types supported by the data source
odbc_longreadlen — Handling of LONG columns
odbc_next_result — Checks if multiple results are available
odbc_num_fields — Number of columns in a result
odbc_num_rows — Number of rows in a result
odbc_pconnect — Open a persistent database connection
odbc_prepare — Prepares a statement for execution
odbc_primarykeys — Gets the primary keys for a table
odbc_procedurecolumns — Retrieve information about parameters to procedures
odbc_procedures — Get the list of procedures stored in a specific data source
odbc_result_all — Print result as HTML table
odbc_result — Get result data
odbc_rollback — Rollback a transaction
odbc_setoption — Adjust ODBC settings
odbc_specialcolumns — Retrieves special columns
odbc_statistics — Retrieve statistics about a table
odbc_tableprivileges — Lists tables and the privileges associated with each table
odbc_tables — Get the list of table names stored in a specific data source
PHP Data Objects
Warning : PDO uses class constants since PHP 5.1. Prior releases use global constants in the form PDO_PARAM_BOOL.
PDO::PARAM_BOOL (integer) - Represents a boolean data type.
PDO::PARAM_NULL (integer) - Represents the SQL NULL data type.
PDO::PARAM_INT (integer) - Represents the SQL INTEGER data type.
PDO::PARAM_STR (integer) - Represents the SQL CHAR, VARCHAR, or other string data type.
PDO::PARAM_LOB (integer) - Represents the SQL large object data type.
PDO::PARAM_STMT (integer) - Represents a recordset type. Not currently supported by any drivers.
PDO::PARAM_INPUT_OUTPUT (integer) - Specifies that the parameter is an INOUT parameter for a stored procedure. You must bitwise-OR this value with an
explicit PDO::PARAM_* data type.
PDO::FETCH_LAZY (integer) - Specifies that the fetch method shall return each row as an object with variable names that correspond to the column names
returned in the result set. PDO::FETCH_LAZY creates the object variable names as they are accessed. Not valid inside PDOStatement::fetchAll().
PDO::FETCH_ASSOC (integer) - Specifies that the fetch method shall return each row as an array indexed by column name as returned in the corresponding
result set. If the result set contains multiple columns with the same name, PDO::FETCH_ASSOC returns only a single value per column name.
PDO::FETCH_NAMED (integer) - Specifies that the fetch method shall return each row as an array indexed by column name as returned in the corresponding
result set. If the result set contains multiple columns with the same name, PDO::FETCH_NAMED returns an array of values per column name.
PDO::FETCH_NUM (integer) - Specifies that the fetch method shall return each row as an array indexed by column number as returned in the corresponding
result set, starting at column 0.
PDO::FETCH_BOTH (integer) - Specifies that the fetch method shall return each row as an array indexed by both column name and number as returned in the
corresponding result set, starting at column 0.
PDO::FETCH_OBJ (integer) - Specifies that the fetch method shall return each row as an object with property names that correspond to the column names
returned in the result set.
PDO::FETCH_BOUND (integer) - Specifies that the fetch method shall return TRUE and assign the values of the columns in the result set to the PHP variables to
which they were bound with the PDOStatement::bindParam() or PDOStatement::bindColumn() methods.
PDO::FETCH_COLUMN (integer) - Specifies that the fetch method shall return only a single requested column from the next row in the result set.
PDO::FETCH_CLASS (integer) - Specifies that the fetch method shall return a new instance of the requested class, mapping the columns to named properties in
the class.
Note: The magic __set() method is called if the property doesn't exist in the requested class
PDO::FETCH_INTO (integer) - Specifies that the fetch method shall update an existing instance of the requested class, mapping the columns to named
properties in the class.
PDO::FETCH_FUNC (integer) - Allows completely customize the way data is treated on the fly (only valid inside
PDOStatement::fetchAll()).
PDO::FETCH_GROUP (integer) - Group return by values. Usually combined with PDO::FETCH_COLUMN or PDO::FETCH_KEY_PAIR.
PDO::FETCH_UNIQUE (integer) - Fetch only the unique values.
PDO::FETCH_KEY_PAIR (integer) - Fetch a two-column result into an array where the first column is a key and the second column is the value. Available since
PHP 5.2.3.
PDO::FETCH_CLASSTYPE (integer) - Determine the class name from the value of first column.
PDO::FETCH_SERIALIZE (integer) - As PDO::FETCH_INTO but object is provided as a serialized string. Available since PHP 5.1.0. Since PHP 5.3.0 the class
constructor is never called if this flag is set.
PDO::FETCH_PROPS_LATE (integer) - Call the constructor before setting properties. Available since PHP 5.2.0.
PDO::ATTR_AUTOCOMMIT (integer) - If this value is FALSE, PDO attempts to disable autocommit so that the connection begins a transaction.
PDO::ATTR_PREFETCH (integer) - Setting the prefetch size allows you to balance speed against memory usage for your application. Not all database/driver
combinations support setting of the prefetch size. A larger prefetch size results in increased performance at the cost of higher memory usage.
PDO::ATTR_TIMEOUT (integer) - Sets the timeout value in seconds for communications with the database.
PDO::ATTR_ERRMODE (integer) - See the Errors and error handling section for more information about this attribute.
PDO::ATTR_SERVER_VERSION (integer) - This is a read only attribute; it will return information about the version of the database server to which PDO is
connected.
PDO::ATTR_CLIENT_VERSION (integer) - This is a read only attribute; it will return information about the version of the client libraries that the PDO driver is
using.
PDO::ATTR_SERVER_INFO (integer) - This is a read only attribute; it will return some meta information about the database server to which PDO is connected.
PDO::ATTR_CONNECTION_STATUS (integer)
PDO::ATTR_CASE (integer) - Force column names to a specific case specified by the PDO::CASE_* constants.
PDO::ATTR_CURSOR_NAME (integer) - Get or set the name to use for a cursor. Most useful when using scrollable cursors and positioned updates.
PDO::ATTR_CURSOR (integer) - Selects the cursor type. PDO currently supports either PDO::CURSOR_FWDONLY and PDO::CURSOR_SCROLL. Stick with
PDO::CURSOR_FWDONLY unless you know that you need a scrollable cursor.
PDO::ATTR_DRIVER_NAME (string) - Returns the name of the driver.
Example #1 using PDO::ATTR_DRIVER_NAME
<?php
if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'mysql') {
echo "Running on mysql; doing something mysql specific here\n";
}
?>
PDO::ATTR_ORACLE_NULLS (integer) - Convert empty strings to SQL NULL values on data fetches.
PDO::ATTR_PERSISTENT (integer) - Request a persistent connection, rather than creating a new connection. See Connections and Connection management for
more information on this attribute.
PDO::ATTR_STATEMENT_CLASS (integer)
PDO::ATTR_FETCH_CATALOG_NAMES (integer) - Prepend the containing catalog name to each column name returned in the result set. The catalog name and
column name are separated by a decimal (.) character. Support of this attribute is at the driver level; it may not be supported by your driver.
PDO::ATTR_FETCH_TABLE_NAMES (integer) - Prepend the containing table name to each column name returned in the result set. The table name and column
name are separated by a decimal (.) character. Support of this attribute is at the driver level; it may not be supported by your driver.
PDO::ATTR_STRINGIFY_FETCHES (integer)
PDO::ATTR_MAX_COLUMN_LEN (integer)
PDO::ATTR_DEFAULT_FETCH_MODE (integer)
PDO::ATTR_EMULATE_PREPARES (integer)
PDO::ERRMODE_SILENT (integer) - Do not raise an error or exception if an error occurs. The developer is expected to explicitly check for errors. This is the default
mode. See Errors and error handling for more information about this attribute.
PDO::ERRMODE_WARNING (integer) - Issue a PHP E_WARNING message if an error occurs. See Errors and error handling for more information about this
attribute.
PDO::ERRMODE_EXCEPTION (integer) - Throw a PDOException if an error occurs. See Errors and error handling for more information about this attribute.
PDO::CASE_NATURAL (integer)
Leave column names as returned by the database driver.
PDO::CASE_LOWER (integer) - Force column names to lower case.
PDO::CASE_UPPER (integer) - Force column names to upper case.
PDO::NULL_NATURAL (integer)
PDO::NULL_EMPTY_STRING (integer)
PDO::NULL_TO_STRING (integer)
PDO::FETCH_ORI_NEXT (integer) - Fetch the next row in the result set. Valid only for scrollable cursors.
PDO::FETCH_ORI_PRIOR (integer) - Fetch the previous row in the result set. Valid only for scrollable cursors.
PDO::FETCH_ORI_FIRST (integer) - Fetch the first row in the result set. Valid only for scrollable cursors.
PDO::FETCH_ORI_LAST (integer) - Fetch the last row in the result set. Valid only for scrollable cursors.
PDO::FETCH_ORI_ABS (integer) - Fetch the requested row by row number from the result set. Valid only for scrollable cursors.
PDO::FETCH_ORI_REL (integer) - Fetch the requested row by relative position from the current position of the cursor in the result set. Valid only for scrollable
cursors.
PDO::CURSOR_FWDONLY (integer) - Create a PDOStatement object with a forward-only cursor. This is the default cursor choice, as it is the fastest and most
common data access pattern in PHP.
PDO::CURSOR_SCROLL (integer) - Create a PDOStatement object with a scrollable cursor. Pass the PDO::FETCH_ORI_* constants to control the rows fetched
from the result set.
PDO::ERR_NONE (string) - Corresponds to SQLSTATE '00000', meaning that the SQL statement was successfully issued with no errors or warnings. This constant
is for your convenience when checking PDO::errorCode() or PDOStatement::errorCode() to determine if an error occurred. You will usually know if this is the
case by examining the return code from the method that raised the error condition anyway.
PDO::PARAM_EVT_ALLOC (integer) - Allocation event
PDO::PARAM_EVT_FREE (integer) - Deallocation event
PDO::PARAM_EVT_EXEC_PRE (integer) - Event triggered prior to execution of a prepared statement.
PDO::PARAM_EVT_EXEC_POST (integer) - Event triggered subsequent to execution of a prepared statement.
PDO::PARAM_EVT_FETCH_PRE (integer) - Event triggered prior to fetching a result from a resultset.
PDO::PARAM_EVT_FETCH_POST (integer) - Event triggered subsequent to fetching a result from a resultset.
PDO::PARAM_EVT_NORMALIZE (integer) - Event triggered during bound parameter registration allowing the driver to normalize the parameter name.
PDO — The PDO class
PDO::beginTransaction — Initiates a transaction
PDO::commit — Commits a transaction
PDO::__construct — Creates a PDO instance representing a connection to a database
PDO::errorCode — Fetch the SQLSTATE associated with the last operation on the database handle
PDO::errorInfo — Fetch extended error information associated with the last operation on the database handle
PDO::exec — Execute an SQL statement and return the number of affected rows
PDO::getAttribute — Retrieve a database connection attribute
PDO::getAvailableDrivers — Return an array of available PDO drivers
PDO::inTransaction — Checks if inside a transaction
PDO::lastInsertId — Returns the ID of the last inserted row or sequence value
PDO::prepare — Prepares a statement for execution and returns a statement object
PDO::query — Executes an SQL statement, returning a result set as a PDOStatement object
PDO::quote — Quotes a string for use in a query.
PDO::rollBack — Rolls back a transaction
PDO::setAttribute — Set an attribute
PDOStatement — The PDOStatement class
PDOStatement::bindColumn — Bind a column to a PHP variable
PDOStatement::bindParam — Binds a parameter to the specified variable name
PDOStatement::bindValue — Binds a value to a parameter
PDOStatement::closeCursor — Closes the cursor, enabling the statement to be executed again.
PDOStatement::columnCount — Returns the number of columns in the result set
PDOStatement::debugDumpParams — Dump an SQL prepared command
PDOStatement::errorCode — Fetch the SQLSTATE associated with the last operation on the statement handle
PDOStatement::errorInfo — Fetch extended error information associated with the last operation on the statement handle
PDOStatement::execute — Executes a prepared statement
PDOStatement::fetch — Fetches the next row from a result set
PDOStatement::fetchAll — Returns an array containing all of the result set rows
PDOStatement::fetchColumn — Returns a single column from the next row of a result set
PDOStatement::fetchObject — Fetches the next row and returns it as an object.
PDOStatement::getAttribute — Retrieve a statement attribute
PDOStatement::getColumnMeta — Returns metadata for a column in a result set
PDOStatement::nextRowset — Advances to the next rowset in a multi-rowset statement handle
PDOStatement::rowCount — Returns the number of rows affected by the last SQL statement
PDOStatement::setAttribute — Set a statement attribute
PDOStatement::setFetchMode — Set the default fetch mode for this statement
PDOException — The PDOException class
PDO Drivers
CUBRID (PDO) — CUBRID Functions (PDO_CUBRID)
MS SQL Server (PDO) — Microsoft SQL Server and Sybase Functions (PDO_DBLIB)
Firebird (PDO) — Firebird Functions (PDO_FIREBIRD)
IBM (PDO) — IBM Functions (PDO_IBM)
Informix (PDO) — Informix Functions (PDO_INFORMIX)
MySQL (PDO) — MySQL Functions (PDO_MYSQL)
MS SQL Server (PDO) — Microsoft SQL Server Functions (PDO_SQLSRV)
Oracle (PDO) — Oracle Functions (PDO_OCI)
ODBC and DB2 (PDO) — ODBC and DB2 Functions (PDO_ODBC)
PostgreSQL (PDO) — PostgreSQL Functions (PDO_PGSQL)
SQLite (PDO) — SQLite Functions (PDO_SQLITE)
4D (PDO) — 4D Functions (PDO_4D)
Anbieterspezifische Datenbankerweiterungen
CUBRID
CUBRID SQL execution flags
The following constants can be used when executing SQL statement. They can be passed to cubrid_prepare() and cubrid_execute().
Constant
Description
CUBRID_INCLUDE_OID
Determine whether to get OID during query execution.
CUBRID_ASYNC
Execute the query in asynchronous mode.
CUBRID_EXEC_QUERY_ALL Execute the query in synchronous mode. This flag must be set when executing multiple SQL statements.
CUBRID fetch flags
The following constants can be used when fetching the results to specify fetch behaviour. They can be passed to cubrid_fetch() and cubrid_fetch_array().
Constant
Description
CUBRID_NUM
Get query result as a numeric array (0-default).
CUBRID_ASSOC
Get query result as an associative array.
CUBRID_BOTH
CUBRID_OBJECT
CUBRID_LOB
Get query result as both numeric and associative arrays (default value).
Get query result an object.
The constant CUBRID_LOB can be used when you want to operate the lob object. It can be passed to cubrid_fetch(), cubrid_fetch_row(), cubrid_fetch_array
CUBRID cursor position flags
The following constants can be used when positioning the cursor in query results. They can be passed to or returned by cubrid_move_cursor().
Constant
Description
CUBRID_CURSOR_FIRST
Move current cursor to the first position in the result.
CUBRID_CURSOR_CURRENT Move current cursor as a default value if the origin is not specified.
CUBRID_CURSOR_LAST
Move current cursor to the last position in the result.
CUBRID_CURSOR_SUCCESS Returned value of cubrid_move_cursor() function in case of success. This flag has been removed from 8.4.1.
CUBRID_NO_MORE_DATA
Returned value of cubrid_move_cursor() function in case of failure. This flag has been removed from 8.4.1.
CUBRID_CURSOR_ERROR
Returned value of cubrid_move_cursor() function in case of failure. This flag has been removed from 8.4.1.
CUBRID auto-commit mode flags
The following constants can be used when setting the auto-commit mode for the database connection. They can be passed to cubrid_set_autocommit() or
returned by cubrid_get_autocommit().
Constant
CUBRID_AUTOCOMMIT_TRUE
CUBRID_AUTOCOMMIT_FALSE
Description
Enable the auto-commit mode.
Disable the auto-commit mode.
CUBRID parameter flags
The following constants can be used when setting the database parameter. They can be passed to cubrid_set_db_parameter().
Constant
Description
CUBRID_PARAM_ISOLATION_LEVEL Transaction isolation level for the database connection.
CUBRID_PARAM_LOCK_TIMEOUT
Transaction timeout in seconds.
CUBRID isolation level flags
The following constants can be used when setting the transaction isolation level. They can be passed to cubrid_set_db_parameter() or returned by
cubrid_get_db_parameter().
Constant
TRAN_COMMIT_CLASS_UNCOMMIT_INSTANCE
TRAN_COMMIT_CLASS_COMMIT_INSTANCE
TRAN_REP_CLASS_UNCOMMIT_INSTANCE
TRAN_REP_CLASS_COMMIT_INSTANCE
TRAN_REP_CLASS_REP_INSTANCE
TRAN_SERIALIZABLE
Description
The lowest isolation level (1). A dirty, non-repeatable or phantom read may occur for the tuple and a non-repeatable read ma
A relatively low isolation level (2). A dirty read does not occur, but non-repeatable or phantom read may occur.
The default isolation of CUBRID (3). A dirty, non-repeatable or phantom read may occur for the tuple, but repeatable read is e
A relatively low isolation level (4). A dirty read does not occur, but non-repeatable or phantom read may.
A relatively high isolation level (5). A dirty or non-repeatable read does not occur, but a phantom read may.
The highest isolation level (6). Problems concerning concurrency (e.g. dirty read, non-repeatable read, phantom read, etc.) do
CUBRID schema flags
The following constants can be used when getting schema information. They can be passed to cubrid_schema().
Constant
Description
CUBRID_SCH_CLASS
Get name and type of table in CUBRID.
CUBRID_SCH_VCLASS
Get name and type of view in CUBRID.
CUBRID_SCH_QUERY_SPEC
Get the query definition of view.
CUBRID_SCH_ATTRIBUTE
Get the attributes of table column.
CUBRID_SCH_CLASS_ATTRIBUTE
Get the attributes of table.
CUBRID_SCH_METHOD
Get the instance method. The instance method is a method called by a class instance. It is used more often than the class method becau
CUBRID_SCH_CLASS_METHOD
Get the class method. The class method is a method called by a class object. It is usually used to create a new class instance or to initializ
CUBRID_SCH_METHOD_FILE
Get the information of the file where the method of the table is defined.
CUBRID_SCH_SUPERCLASS
Get the name and type of table which table inherites attributes from.
CUBRID_SCH_SUBCLASS
Get the name and type of table which inherites attributes from this table.
CUBRID_SCH_CONSTRAINT
Get the table constraints.
CUBRID_SCH_TRIGGER
Get the table triggers.
CUBRID_SCH_CLASS_PRIVILEGE
Get the privilege information of table.
CUBRID_SCH_ATTR_PRIVILEGE
Get the privilege information of column.
CUBRID_SCH_DIRECT_SUPER_CLASS Get the direct super table of table.
CUBRID_SCH_PRIMARY_KEY
Get the table primary key.
CUBRID_SCH_IMPORTED_KEYS
Get imported keys of table.
CUBRID_SCH_EXPORTED_KEYS
Get exported keys of table.
CUBRID_SCH_CROSS_REFERENCE
CUBRID error facility code
Constant
CUBRID_FACILITY_DBMS
CUBRID_FACILITY_CAS
CUBRID_FACILITY_CCI
CUBRID_FACILITY_CLIENT
Get reference relationship of tow tables.
Description
The error occurred in CUBRID dbms.
The error occurred in CUBRID broker cas.
The error occurred in CUBRID cci.
The error occurred in CUBRID PHP client.
CUBRID Functions
cubrid_bind — Bind variables to a prepared statement as parameters
cubrid_close_prepare — Close the request handle
cubrid_close_request — Close the request handle
cubrid_col_get — Get contents of collection type column using OID
cubrid_col_size — Get the number of elements in collection type column using OID
cubrid_column_names — Get the column names in result
cubrid_column_types — Get column types in result
cubrid_commit — Commit a transaction
cubrid_connect_with_url — Establish the environment for connecting to CUBRID server
cubrid_connect — Open a connection to a CUBRID Server
cubrid_current_oid — Get OID of the current cursor location
cubrid_disconnect — Close a database connection
cubrid_drop — Delete an instance using OID
cubrid_error_code_facility — Get the facility code of error
cubrid_error_code — Get error code for the most recent function call
cubrid_error_msg — Get last error message for the most recent function call
cubrid_execute — Execute a prepared SQL statement
cubrid_fetch — Fetch the next row from a result set
cubrid_free_result — Free the memory occupied by the result data
cubrid_get_autocommit — Get auto-commit mode of the connection
cubrid_get_charset — Return the current CUBRID connection charset
cubrid_get_class_name — Get the class name using OID
cubrid_get_client_info — Return the client library version
cubrid_get_db_parameter — Returns the CUBRID database parameters
cubrid_get_query_timeout — Get the query timeout value of the request
cubrid_get_server_info — Return the CUBRID server version
cubrid_get — Get a column using OID
cubrid_insert_id — Return the ID generated for the last updated AUTO_INCREMENT column
cubrid_is_instance — Check whether the instance pointed by OID exists
cubrid_lob_close — Close BLOB/CLOB data
cubrid_lob_export — Export BLOB/CLOB data to file
cubrid_lob_get — Get BLOB/CLOB data
cubrid_lob_send — Read BLOB/CLOB data and send straight to browser
cubrid_lob_size — Get BLOB/CLOB data size
cubrid_lob2_bind — Bind a lob object or a string as a lob object to a prepared statement as parameters.
cubrid_lob2_close — Close LOB object.
cubrid_lob2_export — Export the lob object to a file.
cubrid_lob2_import — Import BLOB/CLOB data from a file.
cubrid_lob2_new — Create a lob object.
cubrid_lob2_read — Read from BLOB/CLOB data.
cubrid_lob2_seek64 — Move the cursor of a lob object.
cubrid_lob2_seek — Move the cursor of a lob object.
cubrid_lob2_size64 — Get a lob object's size.
cubrid_lob2_size — Get a lob object's size.
cubrid_lob2_tell64 — Tell the cursor position of the LOB object.
cubrid_lob2_tell — Tell the cursor position of the LOB object.
cubrid_lob2_write — Write to a lob object.
cubrid_lock_read — Set a read lock on the given OID
cubrid_lock_write — Set a write lock on the given OID
cubrid_move_cursor — Move the cursor in the result
cubrid_next_result — Get result of next query when executing multiple SQL statements
cubrid_num_cols — Return the number of columns in the result set
cubrid_num_rows — Get the number of rows in the result set
cubrid_pconnect_with_url — Open a persistent connection to CUBRID server
cubrid_pconnect — Open a persistent connection to a CUBRID server
cubrid_prepare — Prepare a SQL statement for execution
cubrid_put — Update a column using OID
cubrid_rollback — Roll back a transaction
cubrid_schema — Get the requested schema information
cubrid_seq_drop — Delete an element from sequence type column using OID
cubrid_seq_insert — Insert an element to a sequence type column using OID
cubrid_seq_put — Update the element value of sequence type column using OID
cubrid_set_add — Insert a single element to set type column using OID
cubrid_set_autocommit — Set autocommit mode of the connection
cubrid_set_db_parameter — Sets the CUBRID database parameters
cubrid_set_drop — Delete an element from set type column using OID
cubrid_set_query_timeout — Set the timeout time of query execution
cubrid_version — Get the CUBRID PHP module's version
CUBRID MySQL Compatibility Functions
cubrid_affected_rows — Return the number of rows affected by the last SQL statement
cubrid_client_encoding — Return the current CUBRID connection charset
cubrid_close — Close CUBRID connection
cubrid_data_seek — Move the internal row pointer of the CUBRID result
cubrid_db_name — Get db name from results of cubrid_list_dbs
cubrid_errno — Return the numerical value of the error message from previous CUBRID operation
cubrid_error — Get the error message
cubrid_fetch_array — Fetch a result row as an associative array, a numeric array, or both
cubrid_fetch_assoc — Return the associative array that corresponds to the fetched row
cubrid_fetch_field — Get column information from a result and return as an object
cubrid_fetch_lengths — Return an array with the lengths of the values of each field from the current row
cubrid_fetch_object — Fetche the next row and returns it as an object
cubrid_fetch_row — Return a numerical array with the values of the current row
cubrid_field_flags — Return a string with the flags of the given field offset
cubrid_field_len — Get the maximum length of the specified field
cubrid_field_name — Return the name of the specified field index
cubrid_field_seek — Move the result set cursor to the specified field offset
cubrid_field_table — Return the name of the table of the specified field
cubrid_field_type — Return the type of the column corresponding to the given field offset
cubrid_list_dbs — Return an array with the list of all existing CUBRID databases
cubrid_num_fields — Return the number of columns in the result set
cubrid_ping — Ping a server connection or reconnect if there is no connection
cubrid_query — Send a CUBRID query
cubrid_real_escape_string — Escape special characters in a string for use in an SQL statement
cubrid_result — Return the value of a specific field in a specific row
cubrid_unbuffered_query — Perform a query without fetching the results into memory
CUBRID Obsolete Aliases and Function
cubrid_load_from_glo — Read data from a GLO instance and save it in a file
cubrid_new_glo — Create a glo instance
cubrid_save_to_glo — Save requested file in a GLO instance
cubrid_send_glo — Read data from glo and send it to std output
DB++
db++ error codes
DB++ Functions
dbplus_add — Add a tuple to a relation
dbplus_aql — Perform AQL query
dbplus_chdir — Get/Set database virtual current directory
dbplus_close — Close a relation
dbplus_curr — Get current tuple from relation
dbplus_errcode — Get error string for given errorcode or last error
dbplus_errno — Get error code for last operation
dbplus_find — Set a constraint on a relation
dbplus_first — Get first tuple from relation
dbplus_flush — Flush all changes made on a relation
dbplus_freealllocks — Free all locks held by this client
dbplus_freelock — Release write lock on tuple
dbplus_freerlocks — Free all tuple locks on given relation
dbplus_getlock — Get a write lock on a tuple
dbplus_getunique — Get an id number unique to a relation
dbplus_info — Get information about a relation
dbplus_last — Get last tuple from relation
dbplus_lockrel — Request write lock on relation
dbplus_next — Get next tuple from relation
dbplus_open — Open relation file
dbplus_prev — Get previous tuple from relation
dbplus_rchperm — Change relation permissions
dbplus_rcreate — Creates a new DB++ relation
dbplus_rcrtexact — Creates an exact but empty copy of a relation including indices
dbplus_rcrtlike — Creates an empty copy of a relation with default indices
dbplus_resolve — Resolve host information for relation
dbplus_restorepos — Restore position
dbplus_rkeys — Specify new primary key for a relation
dbplus_ropen — Open relation file local
dbplus_rquery — Perform local (raw) AQL query
dbplus_rrename — Rename a relation
dbplus_rsecindex — Create a new secondary index for a relation
dbplus_runlink — Remove relation from filesystem
dbplus_rzap — Remove all tuples from relation
dbplus_savepos — Save position
dbplus_setindex — Set index
dbplus_setindexbynumber — Set index by number
dbplus_sql — Perform SQL query
dbplus_tcl — Execute TCL code on server side
dbplus_tremove — Remove tuple and return new current tuple
dbplus_undo — Undo
dbplus_undoprepare — Prepare undo
dbplus_unlockrel — Give up write lock on relation
dbplus_unselect — Remove a constraint from relation
dbplus_update — Update specified tuple in relation
dbplus_xlockrel — Request exclusive lock on relation
dbplus_xunlockrel — Free exclusive lock on relation
dBase
dBase Functions
dbase_add_record — Adds a record to a database
dbase_close — Closes a database
dbase_create — Creates a database
dbase_delete_record — Deletes a record from a database
dbase_get_header_info — Gets the header info of a database
dbase_get_record_with_names — Gets a record from a database as an associative array
dbase_get_record — Gets a record from a database as an indexed array
dbase_numfields — Gets the number of fields of a database
dbase_numrecords — Gets the number of records in a database
dbase_open — Opens a database
dbase_pack — Packs a database
dbase_replace_record — Replaces a record in a database
filePro
filePro Functions
filepro_fieldcount — Find out how many fields are in a filePro database
filepro_fieldname — Gets the name of a field
filepro_fieldtype — Gets the type of a field
filepro_fieldwidth — Gets the width of a field
filepro_retrieve — Retrieves data from a filePro database
filepro_rowcount — Find out how many rows are in a filePro database
filepro — Read and verify the map file
Firebird/InterBase
Firebird/InterBase transaction flags
The following constants can be passed to ibase_trans() to specify transaction behaviour
Constant
Description
IBASE_DEFAULT
The default transaction settings are to be used. This default is determined by the client library, which defines it as IBASE_WRITE|IBASE_CONCURRENCY
IBASE_READ
Starts a read-only transaction.
IBASE_WRITE
Starts a read-write transaction.
IBASE_CONSISTENCY Starts a transaction with the isolation level set to 'consistency', which means the transaction cannot read from tables that are being modified by other c
IBASE_CONCURRENC
Y
Starts a transaction with the isolation level set to 'concurrency' (or 'snapshot'), which means the transaction has access to all tables, but cannot see cha
Starts a transaction with the isolation level set to 'read committed'. This flag should be combined with either IBASE_REC_VERSION or IBASE_REC_NO_V
IBASE_COMMITTED
row can be read. If IBASE_REC_VERSION was specified, a row can even be read when a modification to it is pending in a concurrent transaction.
IBASE_WAIT
Indicated that a transaction should wait and retry when a conflict occurs.
IBASE_NOWAIT
Indicated that a transaction should fail immediately when a conflict occurs.
Firebird/InterBase fetch flags
The following constants can be passed to ibase_fetch_row(), ibase_fetch_assoc() or ibase_fetch_object() to specify fetch behaviour.
Constant
Description
IBASE_FETCH_BLOBS
Also available as IBASE_TEXTfor backward compatibility. Causes BLOB contents to be fetched inline, instead of being fetched as BLOB identifiers.
IBASE_FETCH_ARRAYS Causes arrays to be fetched inline. Otherwise, array identifiers are returned. Array identifiers can only be used as arguments to INSERT operations, as
IBASE_UNIXTIME
Causes date and time fields not to be returned as strings, but as UNIX timestamps (the number of seconds since the epoch, which is 1-Jan-1970 0:00 U
The following constants are used to pass requests and options to the service API functions (ibase_server_info(), ibase_db_info(), ibase_backup(),
ibase_restore() and ibase_maintain_db()). Please refer to the Firebird/InterBase manuals for the meaning of these options.
IBASE_BKP_IGNORE_CHECKSUMS
IBASE_BKP_IGNORE_LIMBO
IBASE_BKP_METADATA_ONLY
IBASE_BKP_NO_GARBAGE_COLLECT
IBASE_BKP_OLD_DESCRIPTIONS
IBASE_BKP_NON_TRANSPORTABLE
IBASE_BKP_CONVERT
Options to ibase_backup()
IBASE_RES_DEACTIVATE_IDX
IBASE_RES_NO_SHADOW
IBASE_RES_NO_VALIDITY
IBASE_RES_ONE_AT_A_TIME
IBASE_RES_REPLACE
IBASE_RES_CREATE
IBASE_RES_USE_ALL_SPACE - Options to ibase_restore()
IBASE_PRP_PAGE_BUFFERS
IBASE_PRP_SWEEP_INTERVAL
IBASE_PRP_SHUTDOWN_DB
IBASE_PRP_DENY_NEW_TRANSACTIONS
IBASE_PRP_DENY_NEW_ATTACHMENTS
IBASE_PRP_RESERVE_SPACE
IBASE_PRP_RES_USE_FULL
IBASE_PRP_RES
IBASE_PRP_WRITE_MODE
IBASE_PRP_WM_ASYNC
IBASE_PRP_WM_SYNC
IBASE_PRP_ACCESS_MODE
IBASE_PRP_AM_READONLY
IBASE_PRP_AM_READWRITE
IBASE_PRP_SET_SQL_DIALECT
IBASE_PRP_ACTIVATE
IBASE_PRP_DB_ONLINE
IBASE_RPR_CHECK_DB
IBASE_RPR_IGNORE_CHECKSUM
IBASE_RPR_KILL_SHADOWS
IBASE_RPR_MEND_DB
IBASE_RPR_VALIDATE_DB
IBASE_RPR_FULL
IBASE_RPR_SWEEP_DB - Options to ibase_maintain_db()
IBASE_STS_DATA_PAGES
IBASE_STS_DB_LOG
IBASE_STS_HDR_PAGES
IBASE_STS_IDX_PAGES
IBASE_STS_SYS_RELATIONS - Options to ibase_db_info()
IBASE_SVC_SERVER_VERSION
IBASE_SVC_IMPLEMENTATION
IBASE_SVC_GET_ENV
IBASE_SVC_GET_ENV_LOCK
IBASE_SVC_GET_ENV_MSG
IBASE_SVC_USER_DBPATH
IBASE_SVC_SVR_DB_INFO
IBASE_SVC_GET_USERS - Options to ibase_server_info()
Firebird/InterBase Functions
ibase_add_user — Add a user to a security database
ibase_affected_rows — Return the number of rows that were affected by the previous query
ibase_backup — Initiates a backup task in the service manager and returns immediately
ibase_blob_add — Add data into a newly created blob
ibase_blob_cancel — Cancel creating blob
ibase_blob_close — Close blob
ibase_blob_create — Create a new blob for adding data
ibase_blob_echo — Output blob contents to browser
ibase_blob_get — Get len bytes data from open blob
ibase_blob_import — Create blob, copy file in it, and close it
ibase_blob_info — Return blob length and other useful info
ibase_blob_open — Open blob for retrieving data parts
ibase_close — Close a connection to an InterBase database
ibase_commit_ret — Commit a transaction without closing it
ibase_commit — Commit a transaction
ibase_connect — Open a connection to a database
ibase_db_info — Request statistics about a database
ibase_delete_user — Delete a user from a security database
ibase_drop_db — Drops a database
ibase_errcode — Return an error code
ibase_errmsg — Return error messages
ibase_execute — Execute a previously prepared query
ibase_fetch_assoc — Fetch a result row from a query as an associative array
ibase_fetch_object — Get an object from a InterBase database
ibase_fetch_row — Fetch a row from an InterBase database
ibase_field_info — Get information about a field
ibase_free_event_handler — Cancels a registered event handler
ibase_free_query — Free memory allocated by a prepared query
ibase_free_result — Free a result set
ibase_gen_id — Increments the named generator and returns its new value
ibase_maintain_db — Execute a maintenance command on the database server
ibase_modify_user — Modify a user to a security database
ibase_name_result — Assigns a name to a result set
ibase_num_fields — Get the number of fields in a result set
ibase_num_params — Return the number of parameters in a prepared query
ibase_param_info — Return information about a parameter in a prepared query
ibase_pconnect — Open a persistent connection to an InterBase database
ibase_prepare — Prepare a query for later binding of parameter placeholders and execution
ibase_query — Execute a query on an InterBase database
ibase_restore — Initiates a restore task in the service manager and returns immediately
ibase_rollback_ret — Roll back a transaction without closing it
ibase_rollback — Roll back a transaction
ibase_server_info — Request information about a database server
ibase_service_attach — Connect to the service manager
ibase_service_detach — Disconnect from the service manager
ibase_set_event_handler — Register a callback function to be called when events are posted
ibase_trans — Begin a transaction
ibase_wait_event — Wait for an event to be posted by the database
FrontBase
FBSQL_ASSOC (integer)
FBSQL_NUM (integer)
FBSQL_BOTH (integer)
FBSQL_LOCK_DEFERRED (integer)
FBSQL_LOCK_OPTIMISTIC (integer)
FBSQL_LOCK_PESSIMISTIC (integer)
FBSQL_ISO_READ_UNCOMMITTED (integer)
FBSQL_ISO_READ_COMMITTED (integer)
FBSQL_ISO_REPEATABLE_READ (integer)
FBSQL_ISO_SERIALIZABLE (integer)
FBSQL_ISO_VERSIONED (integer)
FBSQL_UNKNOWN (integer)
FBSQL_STOPPED (integer)
FBSQL_STARTING (integer)
FBSQL_RUNNING (integer)
FBSQL_STOPPING (integer)
FBSQL_NOEXEC (integer)
FBSQL_LOB_DIRECT (integer)
FBSQL_LOB_HANDLE (integer)
FrontBase Functions
fbsql_affected_rows — Get number of affected rows in previous FrontBase operation
fbsql_autocommit — Enable or disable autocommit
fbsql_blob_size — Get the size of a BLOB
fbsql_change_user — Change logged in user of the active connection
fbsql_clob_size — Get the size of a CLOB
fbsql_close — Close FrontBase connection
fbsql_commit — Commits a transaction to the database
fbsql_connect — Open a connection to a FrontBase Server
fbsql_create_blob — Create a BLOB
fbsql_create_clob — Create a CLOB
fbsql_create_db — Create a FrontBase database
fbsql_data_seek — Move internal result pointer
fbsql_database_password — Sets or retrieves the password for a FrontBase database
fbsql_database — Get or set the database name used with a connection
fbsql_db_query — Send a FrontBase query
fbsql_db_status — Get the status for a given database
fbsql_drop_db — Drop (delete) a FrontBase database
fbsql_errno — Returns the error number from previous operation
fbsql_error — Returns the error message from previous operation
fbsql_fetch_array — Fetch a result row as an associative array, a numeric array, or both
fbsql_fetch_assoc — Fetch a result row as an associative array
fbsql_fetch_field — Get column information from a result and return as an object
fbsql_fetch_lengths — Get the length of each output in a result
fbsql_fetch_object — Fetch a result row as an object
fbsql_fetch_row — Get a result row as an enumerated array
fbsql_field_flags — Get the flags associated with the specified field in a result
fbsql_field_len — Returns the length of the specified field
fbsql_field_name — Get the name of the specified field in a result
fbsql_field_seek — Set result pointer to a specified field offset
fbsql_field_table — Get name of the table the specified field is in
fbsql_field_type — Get the type of the specified field in a result
fbsql_free_result — Free result memory
fbsql_get_autostart_info — Description
fbsql_hostname — Get or set the host name used with a connection
fbsql_insert_id — Get the id generated from the previous INSERT operation
fbsql_list_dbs — List databases available on a FrontBase server
fbsql_list_fields — List FrontBase result fields
fbsql_list_tables — List tables in a FrontBase database
fbsql_next_result — Move the internal result pointer to the next result
fbsql_num_fields — Get number of fields in result
fbsql_num_rows — Get number of rows in result
fbsql_password — Get or set the user password used with a connection
fbsql_pconnect — Open a persistent connection to a FrontBase Server
fbsql_query — Send a FrontBase query
fbsql_read_blob — Read a BLOB from the database
fbsql_read_clob — Read a CLOB from the database
fbsql_result — Get result data
fbsql_rollback — Rollback a transaction to the database
fbsql_rows_fetched — Get the number of rows affected by the last statement
fbsql_select_db — Select a FrontBase database
fbsql_set_characterset — Change input/output character set
fbsql_set_lob_mode — Set the LOB retrieve mode for a FrontBase result set
fbsql_set_password — Change the password for a given user
fbsql_set_transaction — Set the transaction locking and isolation
fbsql_start_db — Start a database on local or remote server
fbsql_stop_db — Stop a database on local or remote server
fbsql_table_name — Get table name of field
fbsql_tablename — Alias of fbsql_table_name
fbsql_username — Get or set the username for the connection
fbsql_warnings — Enable or disable FrontBase warnings
IBM DB2, Cloudscape and Apache Derby
DB2_BINARY (integer) - Specifies that binary data shall be returned as is. This is the default mode.
DB2_CONVERT (integer) - Specifies that binary data shall be converted to a hexadecimal encoding and returned as an ASCII string.
DB2_PASSTHRU (integer) - Specifies that binary data shall be converted to a NULL value.
DB2_SCROLLABLE (integer) - Specifies a scrollable cursor for a statement resource. This mode enables random access to rows in a result set, but currently is supported only by IBM DB2 Universal Database.
DB2_FORWARD_ONLY (integer) - Specifies a forward-only cursor for a statement resource. This is the default cursor type and is supported on all database servers.
DB2_PARAM_IN (integer) - Specifies the PHP variable should be bound as an IN parameter for a stored procedure.
DB2_PARAM_OUT (integer) - Specifies the PHP variable should be bound as an OUT parameter for a stored procedure.
DB2_PARAM_INOUT (integer) - Specifies the PHP variable should be bound as an INOUT parameter for a stored procedure.
DB2_PARAM_FILE (integer) - Specifies that the column should be bound directly to a file for input.
DB2_AUTOCOMMIT_ON (integer) - Specifies that autocommit should be turned on.
DB2_AUTOCOMMIT_OFF (integer) - Specifies that autocommit should be turned off.
DB2_DOUBLE (integer) - Specifies that the variable should be bound as a DOUBLE, FLOAT, or REAL data type.
DB2_LONG (integer) - Specifies that the variable should be bound as a SMALLINT, INTEGER, or BIGINT data type.
DB2_CHAR (integer) - Specifies that the variable should be bound as a CHAR or VARCHAR data type.
DB2_CASE_NATURAL (integer) - Specifies that column names will be returned in their natural case.
DB2_CASE_LOWER (integer) - Specifies that column names will be returned in lower case.
DB2_CASE_UPPER (integer) - Specifies that column names will be returned in upper case.
DB2_DEFERRED_PREPARE_ON (integer) - Specifies that deferred prepare should be turned on for the specified statement resource.
DB2_DEFERRED_PREPARE_OFF (integer) - Specifies that deferred prepare should be turned off for the specified statement resource.
IBM DB2 Functions
db2_autocommit — Returns or sets the AUTOCOMMIT state for a database connection
db2_bind_param — Binds a PHP variable to an SQL statement parameter
db2_client_info — Returns an object with properties that describe the DB2 database client
db2_close — Closes a database connection
db2_column_privileges — Returns a result set listing the columns and associated privileges for a table
db2_columns — Returns a result set listing the columns and associated metadata for a table
db2_commit — Commits a transaction
db2_conn_error — Returns a string containing the SQLSTATE returned by the last connection attempt
db2_conn_errormsg — Returns the last connection error message and SQLCODE value
db2_connect — Returns a connection to a database
db2_cursor_type — Returns the cursor type used by a statement resource
db2_escape_string — Used to escape certain characters
db2_exec — Executes an SQL statement directly
db2_execute — Executes a prepared SQL statement
db2_fetch_array — Returns an array, indexed by column position, representing a row in a result set
db2_fetch_assoc — Returns an array, indexed by column name, representing a row in a result set
db2_fetch_both — Returns an array, indexed by both column name and position, representing a row in a result set
db2_fetch_object — Returns an object with properties representing columns in the fetched row
db2_fetch_row — Sets the result set pointer to the next row or requested row
db2_field_display_size — Returns the maximum number of bytes required to display a column
db2_field_name — Returns the name of the column in the result set
db2_field_num — Returns the position of the named column in a result set
db2_field_precision — Returns the precision of the indicated column in a result set
db2_field_scale — Returns the scale of the indicated column in a result set
db2_field_type — Returns the data type of the indicated column in a result set
db2_field_width — Returns the width of the current value of the indicated column in a result set
db2_foreign_keys — Returns a result set listing the foreign keys for a table
db2_free_result — Frees resources associated with a result set
db2_free_stmt — Frees resources associated with the indicated statement resource
db2_get_option — Retrieves an option value for a statement resource or a connection resource
db2_last_insert_id — Returns the auto generated ID of the last insert query that successfully executed on this connection
db2_lob_read — Gets a user defined size of LOB files with each invocation
db2_next_result — Requests the next result set from a stored procedure
db2_num_fields — Returns the number of fields contained in a result set
db2_num_rows — Returns the number of rows affected by an SQL statement
db2_pclose — Closes a persistent database connection
db2_pconnect — Returns a persistent connection to a database
db2_prepare — Prepares an SQL statement to be executed
db2_primary_keys — Returns a result set listing primary keys for a table
db2_procedure_columns — Returns a result set listing stored procedure parameters
db2_procedures — Returns a result set listing the stored procedures registered in a database
db2_result — Returns a single column from a row in the result set
db2_rollback — Rolls back a transaction
db2_server_info — Returns an object with properties that describe the DB2 database server
db2_set_option — Set options for connection or statement resources
db2_special_columns — Returns a result set listing the unique row identifier columns for a table
db2_statistics — Returns a result set listing the index and statistics for a table
db2_stmt_error — Returns a string containing the SQLSTATE returned by an SQL statement
db2_stmt_errormsg — Returns a string containing the last SQL statement error message
db2_table_privileges — Returns a result set listing the tables and associated privileges in a database
db2_tables — Returns a result set listing the tables and associated metadata in a database
Informix
IFX_SCROLL (integer)
IFX_HOLD (integer)
IFX_LO_RDONLY (integer)
IFX_LO_WRONLY (integer)
IFX_LO_APPEND (integer)
IFX_LO_RDWR (integer)
IFX_LO_BUFFER (integer)
IFX_LO_NOBUFFER (integer)
Informix Functions
ifx_affected_rows — Get number of rows affected by a query
ifx_blobinfile_mode — Set the default blob mode for all select queries
ifx_byteasvarchar — Set the default byte mode
ifx_close — Close Informix connection
ifx_connect — Open Informix server connection
ifx_copy_blob — Duplicates the given blob object
ifx_create_blob — Creates an blob object
ifx_create_char — Creates an char object
ifx_do — Execute a previously prepared SQL-statement
ifx_error — Returns error code of last Informix call
ifx_errormsg — Returns error message of last Informix call
ifx_fetch_row — Get row as an associative array
ifx_fieldproperties — List of SQL fieldproperties
ifx_fieldtypes — List of Informix SQL fields
ifx_free_blob — Deletes the blob object
ifx_free_char — Deletes the char object
ifx_free_result — Releases resources for the query
ifx_get_blob — Return the content of a blob object
ifx_get_char — Return the content of the char object
ifx_getsqlca — Get the contents of sqlca.sqlerrd[0..5] after a query
ifx_htmltbl_result — Formats all rows of a query into a HTML table
ifx_nullformat — Sets the default return value on a fetch row
ifx_num_fields — Returns the number of columns in the query
ifx_num_rows — Count the rows already fetched from a query
ifx_pconnect — Open persistent Informix connection
ifx_prepare — Prepare an SQL-statement for execution
ifx_query — Send Informix query
ifx_textasvarchar — Set the default text mode
ifx_update_blob — Updates the content of the blob object
ifx_update_char — Updates the content of the char object
ifxus_close_slob — Deletes the slob object
ifxus_create_slob — Creates an slob object and opens it
ifxus_free_slob — Deletes the slob object
ifxus_open_slob — Opens an slob object
ifxus_read_slob — Reads nbytes of the slob object
ifxus_seek_slob — Sets the current file or seek position
ifxus_tell_slob — Returns the current file or seek position
ifxus_write_slob — Writes a string into the slob object
Ingres DBMS, EDBC, and Enterprise Access Gateways
INGRES_ASSOC (integer) - Columns are returned into the array having the fieldname as the array index. Used with ingres_fetch_array().
INGRES_NUM (integer) - Columns are returned into the array having a numerical index to the fields. By default this index starts at 1, the first field in the result.
To change this value, see ingres.array_index_start. Used with ingres_fetch_array().
INGRES_BOTH (integer) - Columns are returned into the array having both a numerical index and the fieldname as the array index. Used with ingres_fetch_array().
INGRES_EXT_VERSION (string) - Specifies the version of the Ingres Extension. Available since version 1.2.0 of the PECL extension.
INGRES_API_VERSION (integer) - Specifies the version of Ingres OpenAPI that the extension was built against. Available since version 1.2.0 of the PECL extension.
INGRES_CURSOR_READONLY (integer) - Specifies that Ingres cursors should be opened in "readonly" mode. Available since version 1.2.0 of the PECL extension. Used with ingres.cursor_mode.
INGRES_CURSOR_UPDATE (integer) - Specifies that Ingres cursors should be opened "for update." Available since version 1.2.0 of the PECL extension. Used with ingres.cursor_mode.
INGRES_DATE_MULTINATIONAL (integer) - Equivalent to the II_DATE_FORMAT setting of MULTINATIONAL. Available since version 1.2.0 of the PECL extension.
Used with ingres_connect(), ingres_pconnect() and ingres_set_environment(). See options in ingres_set_environment().
INGRES_DATE_MULTINATIONAL4 (integer) - Equivalent to the II_DATE_FORMAT setting of MULTINATIONAL4. Available since version 1.2.0 of the PECL
extension. Used with ingres_connect(), ingres_pconnect() and ingres_set_environment(). See options in ingres_set_environment().
INGRES_DATE_FINNISH (integer) - Equivalent to the II_DATE_FORMAT setting of FINNISH. Available since version 1.2.0 of the PECL extension. Used with
ingres_connect(), ingres_pconnect() and ingres_set_environment(). See options in ingres_set_environment().
INGRES_DATE_ISO (integer) - Equivalent to the II_DATE_FORMAT setting of ISO. Available since version 1.2.0 of the PECL extension. Used with ingres_connect(),
ingres_pconnect() and ingres_set_environment(). See options in ingres_set_environment().
INGRES_DATE_ISO4 (integer) - Equivalent to the II_DATE_FORMAT setting of ISO4. Available since version 1.2.0 of the PECL extension. Used with
INGRES_DATE_GERMAN (integer) - Equivalent to the II_DATE_FORMAT setting of GERMAN. Available since version 1.2.0 of the PECL extension. Used with
INGRES_DATE_MDY (integer) - Equivalent to the II_DATE_FORMAT setting of MDY. Available since version 1.2.0 of the PECL extension. Used with
INGRES_DATE_DMY (integer) - Equivalent to the II_DATE_FORMAT setting of DMY. Available since version 1.2.0 of the PECL extension. Used with
INGRES_DATE_YMD (integer) - Equivalent to the II_DATE_FORMAT setting of YMD. Available since version 1.2.0 of the PECL extension. Used with
INGRES_MONEY_LEADING (integer) - Specifies the currency character that should be placed at the start of a money value. Equivalent to setting
II_MONEY_FORMAT to "L:". Available since version 1.2.0 of the PECL extension. Used with ingres_connect(), ingres_pconnect() and ingres_set_environment().
See options in ingres_set_environment().
INGRES_MONEY_TRAILING (integer) - Specifies the currency character that should be placed at the end of a money value. Equivalent to setting
II_MONEY_FORMAT to "T:". Available since version 1.2.0 of the PECL extension. Used with ingres_connect(), ingres_pconnect() and ingres_set_environment().
See options in ingres_set_environment().
INGRES_STRUCTURE_BTREE (integer) - Specifies the default table or index structure to BTREE when used in combination with the options or index_structure
option when connecting. Available since version 1.4.0 of the PECL extension. Used with ingres_connect() and ingres_pconnect(). See options in ingres_connect().
INGRES_STRUCTURE_CBTREE (integer) - Specifies the default table or index structure to COMPRESSED BTREE when used in combination with the options or
index_structure option when connecting. Available since version 1.4.0 of the PECL extension. Used with ingres_connect() and ingres_pconnect(). See options in
ingres_connect().
INGRES_STRUCTURE_HASH (integer) - Specifies the default table or index structure to HASH when used in combination with the options or index_structure
option when connecting. Available since version 1.4.0 of the PECL extension. Used with ingres_connect() and ingres_pconnect(). See options in ingres_connect().
INGRES_STRUCTURE_CHASH (integer) - Specifies the default table or index structure to COMPRESSED HASH when used in combination with the options or
ingres_connect().
INGRES_STRUCTURE_HEAP (integer) - Specifies the default table structure to HEAP when used in combination with the options option when connecting.
Available since version 1.4.0 of the PECL extension. Used with ingres_connect() and ingres_pconnect(). See options in ingres_connect().
INGRES_STRUCTURE_CHEAP (integer) - Specifies the default table structure to COMPRESSED HEAP when used in combination with the options option when
connecting. Available since version 1.4.0 of the PECL extension. Used with ingres_connect() and ingres_pconnect(). See options in ingres_connect().
INGRES_STRUCTURE_ISAM (integer) - Specifies the default table or index structure to ISAM when used in combination with the options or index_structure option
when connecting. Available since version 1.4.0 of the PECL extension. Used with ingres_connect() and ingres_pconnect(). See options in ingres_connect().
INGRES_STRUCTURE_CISAM (integer) - Specifies the default table or index structure to COMPRESSED ISAM when used in combination with the options or
ingres_connect().
Ingres Functions
ingres_autocommit_state — Test if the connection is using autocommit
ingres_autocommit — Switch autocommit on or off
ingres_charset — Returns the installation character set
ingres_close — Close an Ingres database connection
ingres_commit — Commit a transaction
ingres_connect — Open a connection to an Ingres database
ingres_cursor — Get a cursor name for a given result resource
ingres_errno — Get the last Ingres error number generated
ingres_error — Get a meaningful error message for the last error generated
ingres_errsqlstate — Get the last SQLSTATE error code generated
ingres_escape_string — Escape special characters for use in a query
ingres_execute — Execute a prepared query
ingres_fetch_array — Fetch a row of result into an array
ingres_fetch_assoc — Fetch a row of result into an associative array
ingres_fetch_object — Fetch a row of result into an object
ingres_fetch_proc_return — Get the return value from a procedure call
ingres_fetch_row — Fetch a row of result into an enumerated array
ingres_field_length — Get the length of a field
ingres_field_name — Get the name of a field in a query result
ingres_field_nullable — Test if a field is nullable
ingres_field_precision — Get the precision of a field
ingres_field_scale — Get the scale of a field
ingres_field_type — Get the type of a field in a query result
ingres_free_result — Free the resources associated with a result identifier
ingres_next_error — Get the next Ingres error
ingres_num_fields — Get the number of fields returned by the last query
ingres_num_rows — Get the number of rows affected or returned by a query
ingres_pconnect — Open a persistent connection to an Ingres database
ingres_prepare — Prepare a query for later execution
ingres_query — Send an SQL query to Ingres
ingres_result_seek — Set the row position before fetching data
ingres_rollback — Roll back a transaction
ingres_set_environment — Set environment features controlling output options
ingres_unbuffered_query — Send an unbuffered SQL query to Ingres
MaxDB
MaxDB PHP client constants
The following constants to use with maxdb_options() are defined. For further description of these constants see » http://maxdb.sap.com/documentation/.
Constant
Description
MAXDB_COMPNAME
The component name used to initialise the SQLDBC runtime environment.
MAXDB_APPLICATION
The application to be connected to the database.
MAXDB_APPVERSION
The version of the application.
MAXDB_SQLMODE
The SQL mode.
MAXDB_UNICODE
TRUE, if the connection is an unicode (UCS2) client or FALSE, if not.
MAXDB_TIMEOUT
The maximum allowed time of inactivity after which the connection to the database is closed by the system.
MAXDB_ISOLATIONLEVEL
Specifies whether and how shared locks and exclusive locks are implicitly requested or released.
MAXDB_PACKETCOUNT
The number of different request packets used for the connection.
MAXDB_STATEMENTCACHESIZE The number of prepared statements to be cached for the connection for re-use.
MAXDB_CURSORPREFIX
The prefix to use for result tables that are automatically named.
MaxDB fetch constants
The function maxdb_fetch_array() uses a constant for the different types of result arrays. The following constants are defined:
MAXDB_ASSOC
MAXDB_ASSOC_UPPER
MAXDB_ASSOC_LOWER
MAXDB_BOTH
MAXDB_NUM
Columns are returned into the array having the fieldname as the array index.
Columns are returned into the array having the upper case fieldname as the array index.
Columns are returned into the array having the lower case fieldname as the array index.
Columns are returned into the array having both a numerical index and the fieldname as the array index.
Columns are returned into the array having a numerical index to the fields. This index starts with 0, the first field in the result.
MaxDB Functions
maxdb_affected_rows — Gets the number of affected rows in a previous MaxDB operation
maxdb_autocommit — Turns on or off auto-commiting database modifications
maxdb_bind_param — Alias of maxdb_stmt_bind_param
maxdb_bind_result — Alias of maxdb_stmt_bind_result
maxdb_change_user — Changes the user of the specified database connection
maxdb_character_set_name — Returns the default character set for the database connection
maxdb_client_encoding — Alias of maxdb_character_set_name
maxdb_close_long_data — Alias of maxdb_stmt_close_long_data
maxdb_close — Closes a previously opened database connection
maxdb_commit — Commits the current transaction
maxdb_connect_errno — Returns the error code from last connect call
maxdb_connect_error — Returns a string description of the last connect error
maxdb_connect — Open a new connection to the MaxDB server
maxdb_data_seek — Adjusts the result pointer to an arbitary row in the result
maxdb_debug — Performs debugging operations
maxdb_disable_reads_from_master — Disable reads from master
maxdb_disable_rpl_parse — Disable RPL parse
maxdb_dump_debug_info — Dump debugging information into the log
maxdb_embedded_connect — Open a connection to an embedded MaxDB server
maxdb_enable_reads_from_master — Enable reads from master
maxdb_enable_rpl_parse — Enable RPL parse
maxdb_errno — Returns the error code for the most recent function call
maxdb_error — Returns a string description of the last error
maxdb_escape_string — Alias of maxdb_real_escape_string
maxdb_execute — Alias of maxdb_stmt_execute
maxdb_fetch_array — Fetch a result row as an associative, a numeric array, or both
maxdb_fetch_assoc — Fetch a result row as an associative array
maxdb_fetch_field_direct — Fetch meta-data for a single field
maxdb_fetch_field — Returns the next field in the result set
maxdb_fetch_fields — Returns an array of resources representing the fields in a result set
maxdb_fetch_lengths — Returns the lengths of the columns of the current row in the result set
maxdb_fetch_object — Returns the current row of a result set as an object
maxdb_fetch_row — Get a result row as an enumerated array
maxdb_fetch — Alias of maxdb_stmt_fetch
maxdb_field_count — Returns the number of columns for the most recent query
maxdb_field_seek — Set result pointer to a specified field offset
maxdb_field_tell — Get current field offset of a result pointer
maxdb_free_result — Frees the memory associated with a result
maxdb_get_client_info — Returns the MaxDB client version as a string
maxdb_get_client_version — Get MaxDB client info
maxdb_get_host_info — Returns a string representing the type of connection used
maxdb_get_metadata — Alias of maxdb_stmt_result_metadata
maxdb_get_proto_info — Returns the version of the MaxDB protocol used
maxdb_get_server_info — Returns the version of the MaxDB server
maxdb_get_server_version — Returns the version of the MaxDB server as an integer
maxdb_info — Retrieves information about the most recently executed query
maxdb_init — Initializes MaxDB and returns an resource for use with maxdb_real_connect
maxdb_insert_id — Returns the auto generated id used in the last query
maxdb_kill — Disconnects from a MaxDB server
maxdb_master_query — Enforce execution of a query on the master in a master/slave setup
maxdb_more_results — Check if there any more query results from a multi query
maxdb_multi_query — Performs a query on the database
maxdb_next_result — Prepare next result from multi_query
maxdb_num_fields — Get the number of fields in a result
maxdb_num_rows — Gets the number of rows in a result
maxdb_options — Set options
maxdb_param_count — Alias of maxdb_stmt_param_count
maxdb_ping — Pings a server connection, or tries to reconnect if the connection has gone down
maxdb_prepare — Prepare an SQL statement for execution
maxdb_query — Performs a query on the database
maxdb_real_connect — Opens a connection to a MaxDB server
maxdb_real_escape_string — Escapes special characters in a string for use in an SQL statement, taking into account the current charset of the connection
maxdb_real_query — Execute an SQL query
maxdb_report — Enables or disables internal report functions
maxdb_rollback — Rolls back current transaction
maxdb_rpl_parse_enabled — Check if RPL parse is enabled
maxdb_rpl_probe — RPL probe
maxdb_rpl_query_type — Returns RPL query type
maxdb_select_db — Selects the default database for database queries
maxdb_send_long_data — Alias of maxdb_stmt_send_long_data
maxdb_send_query — Send the query and return
maxdb_server_end — Shut down the embedded server
maxdb_server_init — Initialize embedded server
maxdb_set_opt — Alias of maxdb_options
maxdb_sqlstate — Returns the SQLSTATE error from previous MaxDB operation
maxdb_ssl_set — Used for establishing secure connections using SSL
maxdb_stat — Gets the current system status
maxdb_stmt_affected_rows — Returns the total number of rows changed, deleted, or inserted by the last executed statement
maxdb_stmt_bind_param — Binds variables to a prepared statement as parameters
maxdb_stmt_bind_result — Binds variables to a prepared statement for result storage
maxdb_stmt_close_long_data — Ends a sequence of maxdb_stmt_send_long_data
maxdb_stmt_close — Closes a prepared statement
maxdb_stmt_data_seek — Seeks to an arbitray row in statement result set
maxdb_stmt_errno — Returns the error code for the most recent statement call
maxdb_stmt_error — Returns a string description for last statement error
maxdb_stmt_execute — Executes a prepared Query
maxdb_stmt_fetch — Fetch results from a prepared statement into the bound variables
maxdb_stmt_free_result — Frees stored result memory for the given statement handle
maxdb_stmt_init — Initializes a statement and returns an resource for use with maxdb_stmt_prepare
maxdb_stmt_num_rows — Return the number of rows in statements result set
maxdb_stmt_param_count — Returns the number of parameter for the given statement
maxdb_stmt_prepare — Prepare an SQL statement for execution
maxdb_stmt_reset — Resets a prepared statement
maxdb_stmt_result_metadata — Returns result set metadata from a prepared statement
maxdb_stmt_send_long_data — Send data in blocks
maxdb_stmt_sqlstate — Returns SQLSTATE error from previous statement operation
maxdb_stmt_store_result — Transfers a result set from a prepared statement
maxdb_store_result — Transfers a result set from the last query
maxdb_thread_id — Returns the thread ID for the current connection
maxdb_thread_safe — Returns whether thread safety is given or not
maxdb_use_result — Initiate a result set retrieval
maxdb_warning_count — Returns the number of warnings from the last query for the given link
MongoDB
Core Classes
MongoClient — The MongoClient class
MongoDB — The MongoDB class
MongoCollection — The MongoCollection class
MongoCursor — The MongoCursor class
Types
MongoId — The MongoId class
MongoCode — The MongoCode class
MongoDate — The MongoDate class
MongoRegex — The MongoRegex class
MongoBinData — The MongoBinData class
MongoInt32 — The MongoInt32 class
MongoInt64 — The MongoInt64 class
MongoDBRef — The MongoDBRef class
MongoMinKey — The MongoMinKey class
MongoMaxKey — The MongoMaxKey class
MongoTimestamp — The MongoTimestamp class
Miscellaneous
MongoLog — The MongoLog class
MongoPool — The MongoPool class
Mongo — The Mongo class [deprecated]
Mongo Functions
bson_decode — Deserializes a BSON object into a PHP array
bson_encode — Serializes a PHP variable into a BSON string
Exceptions
MongoException — The MongoException class
MongoResultException — The MongoResultException class
MongoCursorException — The MongoCursorException class
MongoCursorTimeoutException — The MongoCursorTimeoutException class
MongoConnectionException — The MongoConnectionException class
MongoGridFSException — The MongoGridFSException class
mSQL
Vordefinierte Konstanten
MSQL_ASSOC (integer)
MSQL_NUM (integer)
MSQL_BOTH (integer)
mSQL-Funktionen
msql_affected_rows — Gibt die Anzahl der betroffenen Datensätze zurück
msql_close — Schließt eine mSQL-Verbindung
msql_connect — Öffnet eine mSQL-Verbindung
msql_create_db — Erzeugt eine mSQL Datenbank
msql_createdb — Alias von msql_create_db
msql_data_seek — Bewegt den internen Datensatzzeiger
msql_db_query — Sendet eine mSQL Abfrage an den Server
msql_dbname — Alias von msql_result
msql_drop_db — Löscht eine mSQL Datenbank
msql_error — Gibt die letzte mSQL-Fehlermeldung zurück
msql_fetch_array — Holt eine Zeile als Array
msql_fetch_field — Gibt Feldinformationen in einem Objekt zurück
msql_fetch_object — Holt eine Zeile als Objekt
msql_fetch_row — Holt eine Zeile als numerisches Array
msql_field_flags — Gibt alle Flags für das angegebene Feld zurück
msql_field_len — Gibt die Länge des angegebenen Feldes zurück
msql_field_name — Gibt den Feldnamen des bezeichneten Feldes zurück
msql_field_seek — Setzt den internen Feld-Zeiger auf den angegebenen Feldindex
msql_field_table — Gibt den Tabellennamen für ein Feld zurück
msql_field_type — Gibt den Datentyp des angegebenen Feldes zurück
msql_fieldflags — Alias für msql_field_flags
msql_fieldlen — Alias für msql_field_len
msql_fieldname — Alias für msql_field_name
msql_fieldtable — Alias für msql_field_table
msql_fieldtype — Alias für msql_field_type
msql_free_result — Gibt den durch Ergebnisse belegten Speicher frei
msql_list_dbs — Listet alle mSQL Datenbanken auf dem Server auf
msql_list_fields — Listet alle Felder einer Tabelle auf
msql_list_tables — Listet alle Tabellen einer mSQL-Datenbank auf
msql_num_fields — Gibt die Anzahl der Felder in einem Abfrageergebnis zurück
msql_num_rows — Gibt die Anzahl der Zeilen in einem Abfrageergebnis zurück
msql_numfields — Alias für msql_num_fields
msql_numrows — Alias für msql_num_rows
msql_pconnect — Öffnet eine persistente mSQL-Verbindung
msql_query — Schickt eine mSQL-Abfrage zum Server
msql_regcase — Alias für sql_regcase
msql_result — Holt den Wert eines einzelnen Feldes
msql_select_db — Wählt eine mSQL Datenbank aus
msql_tablename — Alias für msql_result
msql — Alias für msql_db_query
Microsoft SQL Server
MSSQL_ASSOC (integer) - Gibt ein assoziatives Array zurück. Wird bei mssql_fetch_array() als result_type-Parameter verwendet.
MSSQL_NUM (integer) - Gibt ein Array mit numerischen Schlüsseln zurück. Wird bei mssql_fetch_array() als result_type-Parameter verwendet.
MSSQL_BOTH (integer) - Gibt ein Array mit numerischen Schlüsseln und Schlüsseln mit den Feldnamen zurück. Dies ist der voreingestellte Wert für den
result_type-Parameter von mssql_fetch_array().
SQLTEXT (integer) - Gibt den MSSQL-Typ 'TEXT' an, der bei mssql_bind() als type-Parameter verwendet wird.
SQLVARCHAR (integer) - Gibt den MSSQL-Typ 'VARCHAR' an, der bei mssql_bind() als type-Parameter verwendet wird.
SQLCHAR (integer) - Gibt den MSSQL-Typ 'CHAR' an, der bei mssql_bind() als type-Parameter verwendet wird.
SQLINT1 (integer) - Bedeutet ein Byte im Bereich von -128 bis 127.
SQLINT2 (integer) - Bedeutet zwei Bytes im Bereich von -32768 bis 32767.
SQLINT4 (integer) - Bedeutet vier Bytes im Bereich von -2147483648 bis 2147483647.
SQLBIT (integer) - Gibt den MSSQL-Typ 'BIT' an, der bei mssql_bind() als type-Parameter verwendet wird.
SQLFLT4 (integer) - Bedeutet eine vier Byte Gleitkommazahl.
SQLFLT8 (integer) - Bedeutet eine acht Byte Gleitkommazahl.
Mssql-Funktionen
mssql_bind — Fügt einer Stored Procedure oder einer Remote Stored Procedure einen Parameter hinzu
mssql_close — Schließt die Verbindung zum MS SQL Server
mssql_connect — Baut eine Verbindung zum MS SQL Server auf
mssql_data_seek — Bewegt den internen Datensatzzeiger
mssql_execute — Führt eine Stored Procedure in einer MS SQL-Datenbank aus
mssql_fetch_array — Liefert einen Ergebnis-Datensatz als assoziatives Array, als numerisches Array oder beides
mssql_fetch_assoc — Liefert ein assoziatives Array des aktuellen Datensatzes aus dem Ergebnis, das durch die Ergebniskennung bestimmt ist
mssql_fetch_batch — Liefert den nächsten Stapel von Datensätzen
mssql_fetch_field — Liefert Informationen über ein Feld
mssql_fetch_object — Liefert einen Datensatz als Objekt
mssql_fetch_row — Liefert einen Datensatz als indiziertes Array
mssql_field_length — Liefert die Länge eines Feldes
mssql_field_name — Liefert den Namen eines Feldes
mssql_field_seek — Setzt einen Feld-Offset
mssql_field_type — Liefert den Typ eines Feldes
mssql_free_result — Gibt den Ergebnisspeicher frei
mssql_free_statement — Gibt den Anweisungsspeicher frei
mssql_get_last_message — Gibt die letzte Meldung des Servers zurück
mssql_guid_string — Wandelt eine binäre GUID mit 16 Bytes in eine Zeichenkette um
mssql_init — Initialisiert eine Stored Procedure oder eine Remote Stored Procedure
mssql_min_error_severity — Setzt die untere Fehlerschwelle
mssql_min_message_severity — Setzt die untere Schwelle für Meldungen
mssql_next_result — Bewegt den internen Ergebnis-Zeiger zum nächsten Ergebnis
mssql_num_fields — Liefert die Anzahl der Felder eines Ergebnisses
mssql_num_rows — Liefert die Anzahl der Datensätze eines Ergebnisses
mssql_pconnect — Baut eine persistente MS SQL Verbindung auf
mssql_query — Sendet eine MS SQL Anfrage
mssql_result — Liefert die bei einer Abfrage gefundenen Daten
mssql_rows_affected — Liefert die Anzahl der von einer Anfrage betroffenen Datensätze
mssql_select_db — Wählt eine MS SQL Datenbank aus
MySQL Drivers and Plugins
MySQL — Ursprüngliche MySQL API
MySQL-Client Konstanten
Ab PHP 4.3.0 ist es möglich zusätzliche Client-Flags bei den Funktionen mysql_connect() und mysql_pconnect() anzugeben. Die folgenden Konstanten sind definiert:
Konstante
Beschreibung
MYSQL_CLIENT_COMPRESS
Benutze das Kompression Protokoll
MYSQL_CLIENT_IGNORE_SPACE Erlaubt Leerzeichen nach Funktionsnamen
MYSQL_CLIENT_INTERACTIVE
Erlaubt Inaktivität von interactive_timeout Sekunden (anstatt wait_timeout) bevor die Verbindung geschlossen wird.
MYSQL_CLIENT_SSL
Benutze SSL Verschlüsselung. Dieses Flag kann nur mit Version 4.x der MySQL Client-Bibliothek oder neuer benutzt werden. Mit PHP 4 und d
MySQL fetch Konstanten
Die Funktion mysql_fetch_array() verwendet eine Konstante für die verschiedenen Arten der Ergebnisarrays. Die folgenden Konstanten sind definiert:
Konstante
MYSQL_ASSOC
MYSQL_BOTH
MYSQL_NUM
Beschreibung
Spalten werden in einem assoziativen Array zurückgegeben.
Spalten werden sowohl als assoziatives als auch als numerisches Array zurückgegeben.
Spalten werden als numerisches Array zurückgegeben. Der Index beginnt bei 0, dieser entspricht dem ersten Feld des Ergebnisses.
MySQL Funktionen
mysql_affected_rows — Liefert die Anzahl betroffener Datensätze einer vorhergehenden MySQL Operation
mysql_client_encoding — Liefert den Namen des Zeichensatzes
mysql_close — Schließt eine Verbindung zu MySQL
mysql_connect — Öffnet eine Verbindung zu einem MySQL-Server
mysql_create_db — Anlegen einer MySQL-Datenbank
mysql_data_seek — Bewegt den internen Ergebnis-Zeiger
mysql_db_name — Liefert Schema Namen vom Aufruf von mysql_list_dbs
mysql_db_query — Selektiert ein Schema und führt in ihm Anfrage aus
mysql_drop_db — Löschen eines Schemas
mysql_errno — Liefert die Nummer einer Fehlermeldung einer zuvor ausgeführten MySQL Operation
mysql_error — Liefert den Fehlertext der zuvor ausgeführten MySQL Operation
mysql_escape_string — Maskiert einen String zur Benutzung in einer MySQL Abfrage
mysql_fetch_array — Liefert einen Datensatz als assoziatives Array, als numerisches Array oder beides
mysql_fetch_assoc — Liefert einen Datensatz als assoziatives Array
mysql_fetch_field — Liefert ein Objekt mit Feldinformationen aus einem Anfrageergebnis
mysql_fetch_lengths — Liefert die Länge eines jeden Feldes in einem Ergebnis
mysql_fetch_object — Liefert eine Ergebniszeile als Objekt
mysql_fetch_row — Liefert einen Datensatz als indiziertes Array
mysql_field_flags — Liefert die Flags des spezifizierten Feldes in einem Anfrageergebnis
mysql_field_len — Liefert die Länge des angegebenen Feldes
mysql_field_name — Liefert den Namen eines Feldes in einem Ergebnis
mysql_field_seek — Setzt den Ergebniszeiger auf ein bestimmtes Feldoffset
mysql_field_table — Liefert den Namen der Tabelle, die das genannte Feld enthält
mysql_field_type — Liefert den Typ des spezifizierten Feldes in einem Ergebnis
mysql_free_result — Gibt belegten Speicher wieder frei
mysql_get_client_info — Liefert MySQL Clientinformationen
mysql_get_host_info — Liefert MySQL Host Informationen
mysql_get_proto_info — Liefert MySQL Protokollinformationen
mysql_get_server_info — Liefert MySQL Server Informationen
mysql_info — Liefert Informationen über die zuletzt ausgeführte Anfrage zurück
mysql_insert_id — Liefert die ID, die in der vorherigen Abfrage erzeugt wurde
mysql_list_dbs — Auflistung der verfügbaren Datenbanken (Schemata) auf einem MySQL Server
mysql_list_fields — Listet MySQL Tabellenfelder auf
mysql_list_processes — Zeigt die MySQL Prozesse an
mysql_list_tables — Listet Tabellen in einer MySQL Datenbank auf
mysql_num_fields — Liefert die Anzahl der Felder in einem Ergebnis
mysql_num_rows — Liefert die Anzahl der Zeilen im Ergebnis
mysql_pconnect — Öffnet eine persistente Verbindung zum MySQL Server
mysql_ping — Ping a server connection or reconnect if there is no connection
mysql_query — Sendet eine Anfrage an MySQL
mysql_real_escape_string — Maskiert spezielle Zeichen innerhalb eines Strings für die Verwendung in einer SQL-Anweisung
mysql_result — Liefert Ergebnis
mysql_select_db — Auswahl einer MySQL Datenbank
mysql_set_charset — Setzt den Verbindungszeichensatz
mysql_stat — Zeigt den momentanen Serverstatus an
mysql_tablename — Liefert den Namen einer Tabelle
mysql_thread_id — Zeigt die aktuelle Thread ID an
mysql_unbuffered_query — Sendet eine SQL Anfrage an MySQL, ohne Ergebniszeilen abzuholen und zu puffern.
Mysqli — MySQL Improved Extension
MYSQLI_READ_DEFAULT_GROUP - Liest Optionen aus der angegebenen Gruppe in my.cnf oder der mit MYSQLI_READ_DEFAULT_FILE angegebenen Datei.
MYSQLI_READ_DEFAULT_FILE - Liest Optionen aus der angegebenen Datei anstelle von my.cnf.
MYSQLI_OPT_CONNECT_TIMEOUT - Verbindungs-Timeout in Sekunden.
MYSQLI_OPT_LOCAL_INFILE - Gestattet Nutzung des LOAD LOCAL INFILE-Kommandos.
MYSQLI_INIT_COMMAND - Kommando, das bei der Verbindungsaufnahme zum MySQL-Server ausgeführt werden soll. Dieses Kommando wird auch bei
automatischer Wiederaufnahme der Verbindung nach Unterbrechungen ausgeführt.
MYSQLI_CLIENT_SSL - Nutze SSL-Verschlüsselung. Diese Option sollte nicht von Applikationen gesetzt werden, sie wird stattdessen von der MySQL-Client-Bibliothek intern gesetzt.
MYSQLI_CLIENT_COMPRESS - Nutze komprimierte Übertragung.
MYSQLI_CLIENT_INTERACTIVE - Unterbricht die Verbindung nach interactive_timeout Sekunden Inaktivität (an Stelle von wait_timeout). Die wait_timeout
Variable der Verbindungssession wir auf den Wert der interactive_timeout Variablen der Session gesetzt.
MYSQLI_CLIENT_IGNORE_SPACE - Ermöglicht Leerzeichen nach Funktionsnamen, dadurch werden alle Funktionsnamen automatisch zu reservierten Worten.
MYSQLI_CLIENT_NO_SCHEMA - Deaktiviert die datenbank.tabelle.spalte-Syntax.
MYSQLI_CLIENT_MULTI_QUERIES - Ermöglicht mehrere Semikolon-getrennte Abfragen innerhalb eines einzelnen mysqli_query() Aufrufs.
MYSQLI_STORE_RESULT - Abfrageergebnisse werden clientseitig gepuffert.
MYSQLI_USE_RESULT - Abfrageergebnisse werden nicht clientseitig gepuffert.
MYSQLI_ASSOC - Spaltenwerte werden als Array mit dem Spaltennamen als Schlüssel zurückgegeben.
MYSQLI_NUM - Spaltenwerte werden als Array mit der Spaltennummer als Schlüssel zurückgegeben.
MYSQLI_BOTH - Spaltenwerte werden als Array mit sowohl der Spaltennummer als auch dem Spaltennamen als Schlüssel zurückgegeben.
MYSQLI_NOT_NULL_FLAG - Gibt an, dass eine Spalte als NOT NULL definiert ist.
MYSQLI_PRI_KEY_FLAG - Spalte ist Teil eines Primärschlüssels.
MYSQLI_UNIQUE_KEY_FLAG - Spalte ist Teil eines Unique Index.
MYSQLI_MULTIPLE_KEY_FLAG - Spalte ist Teil eines Index.
MYSQLI_BLOB_FLAG - Spalte ist als BLOB definiert.
MYSQLI_UNSIGNED_FLAG - Spalte ist als UNSIGNED definiert.
MYSQLI_ZEROFILL_FLAG - Spalte ist als ZEROFILL definiert.
MYSQLI_AUTO_INCREMENT_FLAG - Spalte ist als AUTO_INCREMENT definiert.
MYSQLI_TIMESTAMP_FLAG - Spalte ist als TIMESTAMP definiert.
MYSQLI_SET_FLAG - Spalte ist als SET definiert.
MYSQLI_NUM_FLAG - Spalte ist als NUMERIC definiert.
MYSQLI_PART_KEY_FLAG - Spalte ist Teil eines mehrspaltigen Index.
MYSQLI_GROUP_FLAG - Spalte ist Teil der GROUP BY-Bedingung
MYSQLI_TYPE_DECIMAL - Spalte ist als DECIMAL definiert.
MYSQLI_TYPE_NEWDECIMAL - Spalte ist als DECIMAL oder NUMERIC definiert. (ab MySQL 5.0.3)
MYSQLI_TYPE_BIT - Spalte ist als BIT definiert. (ab MySQL 5.0.3)
MYSQLI_TYPE_TINY - Spalte ist als TINYINT definiert.
MYSQLI_TYPE_SHORT - Spalte ist als SMALLINT definiert.
MYSQLI_TYPE_LONG - Spalte ist als INT definiert.
MYSQLI_TYPE_FLOAT - Spalte ist als FLOAT definiert.
MYSQLI_TYPE_DOUBLE - Spalte ist als DOUBLE definiert.
MYSQLI_TYPE_NULL - Spalte ist als DEFAULT NULL definiert.
MYSQLI_TYPE_TIMESTAMP - Spalte ist als TIMESTAMP definiert.
MYSQLI_TYPE_LONGLONG - Spalte ist als BIGINT definiert.
MYSQLI_TYPE_INT24 - Spalte ist als MEDIUMINT definiert.
MYSQLI_TYPE_DATE - Spalte ist als DATE definiert.
MYSQLI_TYPE_TIME - Spalte ist als TIME definiert.
MYSQLI_TYPE_DATETIME - Spalte ist als DATETIME definiert.
MYSQLI_TYPE_YEAR - Spalte ist als YEAR definiert.
MYSQLI_TYPE_NEWDATE - Spalte ist als DATE definiert.
MYSQLI_TYPE_INTERVAL - Spalte ist als INTERVAL definiert.
MYSQLI_TYPE_ENUM - Spalte ist als ENUM definiert.
MYSQLI_TYPE_SET - Spalte ist als SET definiert.
MYSQLI_TYPE_TINY_BLOB - Spalte ist als TINYBLOB definiert.
MYSQLI_TYPE_MEDIUM_BLOB - Spalte ist als MEDIUMBLOB definiert.
MYSQLI_TYPE_LONG_BLOB - Spalte ist als LONGBLOB definiert.
MYSQLI_TYPE_BLOB - Spalte ist als BLOB definiert.
MYSQLI_TYPE_VAR_STRING - Spalte ist als VARCHAR definiert.
MYSQLI_TYPE_STRING - Spalte ist als STRING definiert.
MYSQLI_TYPE_CHAR - Spalte ist als CHAR definiert.
MYSQLI_TYPE_GEOMETRY - Spalte ist als GEOMETRY definiert.
MYSQLI_NEED_DATA - Weitere Daten für eine gebundenen Variable verfügbar.
MYSQLI_NO_DATA - Keine weiteren Daten für eine gebundenen Variable verfügbar.
MYSQLI_DATA_TRUNCATED - Daten wurden unvollständig übertragen. Verfügbar ab PHP 5.1.0 und MySQL 5.0.5.
MYSQLI_ENUM_FLAG - Spalte ist als ENUM definiert. Verfügbar ab PHP 5.3.0.
MYSQLI_CURSOR_TYPE_FOR_UPDATE
MYSQLI_CURSOR_TYPE_NO_CURSOR
MYSQLI_CURSOR_TYPE_READ_ONLY
MYSQLI_CURSOR_TYPE_SCROLLABLE
MYSQLI_STMT_ATTR_CURSOR_TYPE
MYSQLI_STMT_ATTR_PREFETCH_ROWS
MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH
MYSQLI_SET_CHARSET_NAME
Mysqlnd — MySQL Native Driver
mysqlnd_ms — Mysqlnd replication and load balancing plugin
Mysqlnd_ms Funktionen
mysqlnd_ms_get_last_gtid — Returns the latest global transaction ID
mysqlnd_ms_get_last_used_connection — Returns an array which describes the last used connection
mysqlnd_ms_get_stats — Returns query distribution and connection statistics
mysqlnd_ms_match_wild — Finds whether a table name matches a wildcard pattern or not
mysqlnd_ms_query_is_select — Find whether to send the query to the master, the slave or the last used MySQL server
mysqlnd_ms_set_qos — Sets the quality of service needed from the cluster
mysqlnd_ms_set_user_pick_server — Sets a callback for user-defined read/write splitting
mysqlnd_qc — Mysqlnd query result cache plugin
mysqlnd_qc — Mysqlnd query result cache plugin
mysqlnd_qc Funktionen
mysqlnd_qc_clear_cache — Flush all cache contents
mysqlnd_qc_get_available_handlers — Returns a list of available storage handler
mysqlnd_qc_get_cache_info — Returns information on the current handler, the number of cache entries and cache entries, if available
mysqlnd_qc_get_core_stats — Statistics collected by the core of the query cache
mysqlnd_qc_get_normalized_query_trace_log — Returns a normalized query trace log for each query inspected by the query cache
mysqlnd_qc_get_query_trace_log — Returns a backtrace for each query inspected by the query cache
mysqlnd_qc_set_cache_condition — Set conditions for automatic caching
mysqlnd_qc_set_is_select — Installs a callback which decides whether a statement is cached
mysqlnd_qc_set_storage_handler — Change current storage handler
mysqlnd_qc_set_user_handlers — Sets the callback functions for a user-defined procedural storage handler
mysqlnd_uh — Mysqlnd user handler plugin
Most of the constants refer to details of the MySQL Client Server Protocol. Please, refer to the MySQL reference manual to learn about their meaning. To avoid
content duplication, only short descriptions are given.
MysqlndUhConnection::simpleCommand() related
The following constants can be used to detect what command is to be send through MysqlndUhConnection::simpleCommand().
MYSQLND_UH_MYSQLND_COM_SLEEP (integer) - MySQL Client Server protocol command: COM_SLEEP.
MYSQLND_UH_MYSQLND_COM_QUIT (integer) - MySQL Client Server protocol command: COM_QUIT.
MYSQLND_UH_MYSQLND_COM_INIT_DB (integer) - MySQL Client Server protocol command: COM_INIT_DB.
MYSQLND_UH_MYSQLND_COM_QUERY (integer) - MySQL Client Server protocol command: COM_QUERY.
MYSQLND_UH_MYSQLND_COM_FIELD_LIST (integer) - MySQL Client Server protocol command: COM_FIELD_LIST.
MYSQLND_UH_MYSQLND_COM_CREATE_DB (integer) - MySQL Client Server protocol command: COM_CREATE_DB.
MYSQLND_UH_MYSQLND_COM_DROP_DB (integer) - MySQL Client Server protocol command: COM_DROP_DB.
MYSQLND_UH_MYSQLND_COM_REFRESH (integer) - MySQL Client Server protocol command: COM_REFRESH.
MYSQLND_UH_MYSQLND_COM_SHUTDOWN (integer) - MySQL Client Server protocol command: COM_SHUTDOWN.
MYSQLND_UH_MYSQLND_COM_STATISTICS (integer) - MySQL Client Server protocol command: COM_STATISTICS.
MYSQLND_UH_MYSQLND_COM_PROCESS_INFO (integer) - MySQL Client Server protocol command: COM_PROCESS_INFO.
MYSQLND_UH_MYSQLND_COM_CONNECT (integer) - MySQL Client Server protocol command: COM_CONNECT.
MYSQLND_UH_MYSQLND_COM_PROCESS_KILL (integer) - MySQL Client Server protocol command: COM_PROCESS_KILL.
MYSQLND_UH_MYSQLND_COM_DEBUG (integer) - MySQL Client Server protocol command: COM_DEBUG.
MYSQLND_UH_MYSQLND_COM_PING (integer) - MySQL Client Server protocol command: COM_PING.
MYSQLND_UH_MYSQLND_COM_TIME (integer) - MySQL Client Server protocol command: COM_TIME.
MYSQLND_UH_MYSQLND_COM_DELAYED_INSERT (integer) - MySQL Client Server protocol command: COM_DELAYED_INSERT.
MYSQLND_UH_MYSQLND_COM_CHANGE_USER (integer) - MySQL Client Server protocol command: COM_CHANGE_USER.
MYSQLND_UH_MYSQLND_COM_BINLOG_DUMP (integer) - MySQL Client Server protocol command: COM_BINLOG_DUMP.
MYSQLND_UH_MYSQLND_COM_TABLE_DUMP (integer) - MySQL Client Server protocol command: COM_TABLE_DUMP.
MYSQLND_UH_MYSQLND_COM_CONNECT_OUT (integer) - MySQL Client Server protocol command: COM_CONNECT_OUT.
MYSQLND_UH_MYSQLND_COM_REGISTER_SLAVED (integer) - MySQL Client Server protocol command: COM_REGISTER_SLAVED.
MYSQLND_UH_MYSQLND_COM_STMT_PREPARE (integer) - MySQL Client Server protocol command: COM_STMT_PREPARE.
MYSQLND_UH_MYSQLND_COM_STMT_EXECUTE (integer) - MySQL Client Server protocol command: COM_STMT_EXECUTE.
MYSQLND_UH_MYSQLND_COM_STMT_SEND_LONG_DATA (integer) - MySQL Client Server protocol command: COM_STMT_SEND_LONG_DATA.
MYSQLND_UH_MYSQLND_COM_STMT_CLOSE (integer) - MySQL Client Server protocol command: COM_STMT_CLOSE.
MYSQLND_UH_MYSQLND_COM_STMT_RESET (integer) - MySQL Client Server protocol command: COM_STMT_RESET.
MYSQLND_UH_MYSQLND_COM_SET_OPTION (integer) - MySQL Client Server protocol command: COM_SET_OPTION.
MYSQLND_UH_MYSQLND_COM_STMT_FETCH (integer) - MySQL Client Server protocol command: COM_STMT_FETCH.
MYSQLND_UH_MYSQLND_COM_DAEMON (integer) - MySQL Client Server protocol command: COM_DAEMON.
MYSQLND_UH_MYSQLND_COM_END (integer) - MySQL Client Server protocol command: COM_END.
The following constants can be used to analyze the ok_packet argument of MysqlndUhConnection::simpleCommand().
MYSQLND_UH_MYSQLND_PROT_GREET_PACKET (integer) - MySQL Client Server protocol packet: greeting.
MYSQLND_UH_MYSQLND_PROT_AUTH_PACKET (integer) - MySQL Client Server protocol packet: authentication.
MYSQLND_UH_MYSQLND_PROT_OK_PACKET (integer) - MySQL Client Server protocol packet: OK.
MYSQLND_UH_MYSQLND_PROT_EOF_PACKET (integer) - MySQL Client Server protocol packet: EOF.
MYSQLND_UH_MYSQLND_PROT_CMD_PACKET (integer) - MySQL Client Server protocol packet: command.
MYSQLND_UH_MYSQLND_PROT_RSET_HEADER_PACKET (integer) - MySQL Client Server protocol packet: result set header.
MYSQLND_UH_MYSQLND_PROT_RSET_FLD_PACKET (integer) - MySQL Client Server protocol packet: resultset field.
MYSQLND_UH_MYSQLND_PROT_ROW_PACKET (integer) - MySQL Client Server protocol packet: row.
MYSQLND_UH_MYSQLND_PROT_STATS_PACKET (integer) - MySQL Client Server protocol packet: stats.
MYSQLND_UH_MYSQLND_PREPARE_RESP_PACKET (integer) - MySQL Client Server protocol packet: prepare response.
MYSQLND_UH_MYSQLND_CHG_USER_RESP_PACKET (integer) - MySQL Client Server protocol packet: change user response.
MYSQLND_UH_MYSQLND_PROT_LAST (integer) - No practical meaning. Last entry marker of internal C data structure list.
MysqlndUhConnection::close() related
The following constants can be used to detect why a connection has been closed through MysqlndUhConnection::close().
MYSQLND_UH_MYSQLND_CLOSE_EXPLICIT (integer) - User has called mysqlnd to close the connection.
MYSQLND_UH_MYSQLND_CLOSE_IMPLICIT (integer) - Implicitly closed, for example, during garbage connection.
MYSQLND_UH_MYSQLND_CLOSE_DISCONNECTED (integer) - Connection error.
MYSQLND_UH_MYSQLND_CLOSE_LAST (integer) - No practical meaning. Last entry marker of internal C data structure list.
MysqlndUhConnection::setServerOption() related
The following constants can be used to detect which option is set through MysqlndUhConnection::setServerOption().
MYSQLND_UH_SERVER_OPTION_MULTI_STATEMENTS_ON (integer) - Option: enables multi statement support.
MYSQLND_UH_SERVER_OPTION_MULTI_STATEMENTS_OFF (integer) - Option: disables multi statement support.
MysqlndUhConnection::setClientOption() related
The following constants can be used to detect which option is set through MysqlndUhConnection::setClientOption().
MYSQLND_UH_MYSQLND_OPTION_OPT_CONNECT_TIMEOUT (integer) - Option: connection timeout.
MYSQLND_UH_MYSQLND_OPTION_OPT_COMPRESS (integer) - Option: whether the MySQL compressed protocol is to be used.
MYSQLND_UH_MYSQLND_OPTION_OPT_NAMED_PIPE (integer) - Option: named pipe to use for connection (Windows).
MYSQLND_UH_MYSQLND_OPTION_INIT_COMMAND (integer) - Option: init command to execute upon connect.
MYSQLND_UH_MYSQLND_READ_DEFAULT_FILE (integer) - Option: MySQL server default file to read upon connect.
MYSQLND_UH_MYSQLND_READ_DEFAULT_GROUP (integer) - Option: MySQL server default file group to read upon connect.
MYSQLND_UH_MYSQLND_SET_CHARSET_DIR (integer) - Option: charset description files directory.
MYSQLND_UH_MYSQLND_SET_CHARSET_NAME (integer) - Option: charset name.
MYSQLND_UH_MYSQLND_OPT_LOCAL_INFILE (integer) - Option: Whether to allow LOAD DATA LOCAL INFILE use.
MYSQLND_UH_MYSQLND_OPT_PROTOCOL (integer) - Option: supported protocol version.
MYSQLND_UH_MYSQLND_SHARED_MEMORY_BASE_NAME (integer) - Option: shared memory base name for shared memory connections.
MYSQLND_UH_MYSQLND_OPT_READ_TIMEOUT (integer) - Option: connection read timeout.
MYSQLND_UH_MYSQLND_OPT_WRITE_TIMEOUT (integer) - Option: connection write timeout.
MYSQLND_UH_MYSQLND_OPT_USE_RESULT (integer) - Option: unbuffered result sets.
MYSQLND_UH_MYSQLND_OPT_USE_REMOTE_CONNECTION (integer) - Embedded server related.
MYSQLND_UH_MYSQLND_OPT_USE_EMBEDDED_CONNECTION (integer) - Embedded server related.
MYSQLND_UH_MYSQLND_OPT_GUESS_CONNECTION (integer) - TODO
MYSQLND_UH_MYSQLND_SET_CLIENT_IP (integer) - TODO
MYSQLND_UH_MYSQLND_SECURE_AUTH (integer) - TODO
MYSQLND_UH_MYSQLND_REPORT_DATA_TRUNCATION (integer) - Option: Whether to report data truncation.
MYSQLND_UH_MYSQLND_OPT_RECONNECT (integer) - Option: Whether to reconnect automatically.
MYSQLND_UH_MYSQLND_OPT_SSL_VERIFY_SERVER_CERT (integer) - Option: TODO
MYSQLND_UH_MYSQLND_OPT_NET_CMD_BUFFER_SIZE (integer) - Option: mysqlnd network buffer size for commands.
MYSQLND_UH_MYSQLND_OPT_NET_READ_BUFFER_SIZE (integer) - Option: mysqlnd network buffer size for reading from the server.
MYSQLND_UH_MYSQLND_OPT_SSL_KEY (integer) - Option: SSL key.
MYSQLND_UH_MYSQLND_OPT_SSL_CERT (integer) - Option: SSL certificate.
MYSQLND_UH_MYSQLND_OPT_SSL_CA (integer) - Option: SSL CA.
MYSQLND_UH_MYSQLND_OPT_SSL_CAPATH (integer) - Option: Path to SSL CA.
MYSQLND_UH_MYSQLND_OPT_SSL_CIPHER (integer) - Option: SSL cipher.
MYSQLND_UH_MYSQLND_OPT_SSL_PASSPHRASE (integer) - Option: SSL passphrase.
MYSQLND_UH_SERVER_OPTION_PLUGIN_DIR (integer) - Option: server plugin directory.
MYSQLND_UH_SERVER_OPTION_DEFAULT_AUTH (integer) - Option: default authentication method.
MYSQLND_UH_SERVER_OPTION_SET_CLIENT_IP (integer) - TODO
MYSQLND_UH_MYSQLND_OPT_MAX_ALLOWED_PACKET (integer) - Option: maximum allowed packet size. Available as of PHP 5.4.0.
MYSQLND_UH_MYSQLND_OPT_AUTH_PROTOCOL (integer) - Option: TODO. Available as of PHP 5.4.0.
MYSQLND_UH_MYSQLND_OPT_INT_AND_FLOAT_NATIVE (integer) - Option: make mysqlnd return integer and float columns as long even when using the
MySQL Client Server text protocol. Only available with a custom build of mysqlnd.
Other
The plugins version number can be obtained using MYSQLND_UH_VERSION or MYSQLND_UH_VERSION_ID. MYSQLND_UH_VERSION is the string
representation of the numerical version number MYSQLND_UH_VERSION_ID, which is an integer such as 10000. Developers can calculate the version number as
follows.
Version (part)
Example
Major*10000
1*10000 = 10000
Minor*100
0*100 = 0
Patch
0=0
MYSQLND_UH_VERSION_ID 10000
MYSQLND_UH_VERSION (string) - Plugin version string, for example, "1.0.0-alpha".
MYSQLND_UH_VERSION_ID (integer) - Plugin version number, for example, 10000.
mysqlnd_mux — Mysqlnd connection multiplexing plugin
The plugins version number can be obtained using MYSQLND_MUX_VERSION or MYSQLND_MUX_VERSION_ID. MYSQLND_MUX_VERSION is the string
representation of the numerical version number MYSQLND_MUX_VERSION_ID, which is an integer such as 10000. Developers can calculate the version number
as follows.
Version (part)
Example
Major*10000
1*10000 = 10000
Minor*100
0*100 = 0
Patch
0=0
MYSQLND_MUX_VERSION_ID 10000
MYSQLND_MUX_VERSION (string) - Plugin version string, for example, "1.0.0-prototype".
MYSQLND_MUX_VERSION_ID (integer) - Plugin version number, for example, 10000.
mysqlnd_memcache — Mysqlnd Memcache plugin
MySQL Memcache Plugin related
MYSQLND_MEMCACHE_DEFAULT_REGEXP (string) - Default regular expression (PCRE style) used for matching SELECT statements that will be mapped into a
MySQL Memcache Plugin access point, if possible. It is also possible to use mysqlnd_memcache_set(), but the default approach is using this regular expression
for pattern matching.
Assorted
The version number of this plugin can be obtained by using MYSQLND_MEMCACHE_VERSION or MYSQLND_MEMCACHE_VERSION_ID.
MYSQLND_MEMCACHE_VERSION is the string representation of the numerical version number MYSQLND_MEMCACHE_VERSION_ID, which is an integer such
as 10000. Developers can calculate the version number as follows.
Version (part)
Example
Major*10000
1*10000 = 10000
Minor*100
0*100 = 0
Patch
0=0
MYSQLND_MEMCACHE_VERSION_ID 10000
MYSQLND_MEMCACHE_VERSION (string) - Plugin version string, for example, "1.0.0-alpha".
MYSQLND_MEMCACHE_VERSION_ID (integer) - Plugin version number, for example, 10000.
Oracle OCI8
OCI_DEFAULT (integer) - Statement-Ausführungsmodus. Ein Statement wird nicht automatisch committed, wenn dieser Modus benutzt wird.
OCI_DESCRIBE_ONLY (integer) - Statement-Ausführungsmodus. Benutze diesen Modus, wenn die Suchabfrage nicht ausgeführt werden soll, sondern nur eine
Beschreibung der Selektierten Liste gewünscht ist.
OCI_COMMIT_ON_SUCCESS (integer) - Statement-Ausführungsmodus. Das Statement wird automatisch committed nach einem oci_execute()-Aufruf.
OCI_EXACT_FETCH (integer) - Statement-Abrufmodus. Kann benutzt werden, wenn die Applikation bereits im Vorfeld die genaue Anzahl der abzurufenden
Zeilen kennt. Dieser Modus schaltet das Prefetching (Vorab-Abruf) bei Oracle Release 8 und höher aus. Der Zeiger wird bei erreichen der benötigten Zeilen
beendet und verringert somit die benötigten Ressourcen des Servers.
OCI_SYSDATE (integer)
OCI_B_BFILE (integer) - Wird bei oci_bind_by_name() benutzt, wenn BFILEs gebunden werden.
OCI_B_CFILEE (integer) - Wird bei oci_bind_by_name() benutzt, wenn CFILEs gebunden werden.
OCI_B_CLOB (integer) - Wird bei oci_bind_by_name() benutzt, wenn CLOBs gebunden werden.
OCI_B_BLOB (integer) - Wird bei oci_bind_by_name() benutzt, wenn BLOBs gebunden werden.
OCI_B_ROWID (integer) - Wird bei oci_bind_by_name() benutzt, wenn ROWIDs gebunden werden.
OCI_B_CURSOR (integer) - Wird bei oci_bind_by_name() benutzt, wenn Zeiger (CURSOR) gebunden werden, die zuvor mit oci_new_descriptor() reserviert wurden.
OCI_B_NTY (integer) - Wird bei oci_bind_by_name() benutzt, wenn benannte Datentypen gebunden werden. Zu beachten: in PHP < 5.0 wurde das
OCI_B_SQLT_NTY genannt.
OCI_B_BIN (integer)
SQLT_BFILEE (integer) - Das gleiche wie OCI_B_BFILE.
SQLT_CFILEE (integer)
Das gleiche wie OCI_B_CFILEE.
SQLT_CLOB (integer) - Das gleiche wie OCI_B_CLOB.
SQLT_BLOB (integer) - Das gleiche wie OCI_B_BLOB.
SQLT_RDD (integer) - Das gleiche wie OCI_B_ROWID.
SQLT_NTY (integer) - Das gleiche wie OCI_B_NTY.
SQLT_LNG (integer) - Wird bei oci_bind_by_name() benutzt, wenn LONG-Werte gebunden werden.
SQLT_LBI (integer) - Wird bei oci_bind_by_name() benutzt, wenn LONG-RAW-Werte gebunden werden.
SQLT_BIN (integer) - Wird bei oci_bind_by_name() benutzt, wenn RAW-Werte gebunden werden.
SQLT_NUM (integer) - Wird bei oci_bind_array_by_name() benutzt, wenn Arrays aus NUMBERs gebunden werden.
SQLT_INT (integer) - Wird bei oci_bind_array_by_name() benutzt, wenn Arrays aus INTEGERs gebunden werden.
SQLT_AFC (integer) - Wird bei oci_bind_array_by_name() benutzt, wenn Arrays aus CHARs gebunden werden.
SQLT_CHR (integer) - Wird bei oci_bind_array_by_name() benutzt, wenn Arrays aus VARCHAR2s gebunden werden. Wird auch bei oci_bind_by_name() benutzt.
SQLT_VCS (integer) - Wird bei oci_bind_array_by_name() benutzt, wenn Arrays aus VARCHARs gebunden werden.
SQLT_AVC (integer) - Wird bei oci_bind_array_by_name() benutzt, wenn Arrays aus CHARZs gebunden werden.
SQLT_STR (integer) - Wird bei oci_bind_array_by_name() benutzt, wenn Arrays aus STRINGs gebunden werden.
SQLT_LVC (integer) - Wird bei oci_bind_array_by_name() benutzt, wenn Arrays aus LONG-VARCHARs gebunden werden.
SQLT_FLT (integer) - Wird bei oci_bind_array_by_name() benutzt, wenn Arrays aus FLOATs gebunden werden.
SQLT_ODT (integer) - Wird bei oci_bind_array_by_name() benutzt, wenn Arrays aus LONGs gebunden werden.
SQLT_BDOUBLE (integer)
SQLT_BFLOAT (integer)
OCI_FETCHSTATEMENT_BY_COLUMN (integer) - Standardmodus von oci_fetch_all().
OCI_FETCHSTATEMENT_BY_ROW (integer) - Alternativmodus von oci_fetch_all().
OCI_ASSOC (integer) - Wird bei oci_fetch_all() und oci_fetch_array() benutzt, um ein assoziatives Array als Ergebnis zu erhalten.
OCI_NUM (integer) - Wird bei oci_fetch_all() und oci_fetch_array() benutzt, um ein durchnummeriertes Array als Ergebnis zu erhalten.
OCI_BOTH (integer) - Wird bei oci_fetch_all() und oci_fetch_array() benutzt, um ein Array mit assoziativem als auch durchnummeriertes Index als Ergebnis zu erhalten.
OCI_RETURN_NULLS (integer) - Wird bei oci_fetch_array() benutzt, um bei Feldwerten von NULL leere Arrayelement zu erhalten.
OCI_RETURN_LOBS (integer) - Wird bei oci_fetch_array() benutzt, um den Wert eines LOBs anstelle des Deskriptors zu bekommen.
OCI_DTYPE_FILE (integer) - Ein Schalter der oci_new_descriptor() mitteilt einen neuen FILE-Deskriptor zu initialisieren.
OCI_DTYPE_LOB (integer) - Ein Schalter der oci_new_descriptor() mitteilt einen neuen LOB-Deskriptor zu initialisieren.
OCI_DTYPE_ROWID (integer) - Ein Schalter der oci_new_descriptor() mitteilt einen neuen ROWID-Deskriptor zu initialisieren.
OCI_D_FILE (integer) - Das gleiche wie OCI_DTYPE_FILE.
OCI_D_LOB (integer) - Das gleiche wie OCI_DTYPE_LOB.
OCI_D_ROWID (integer) - Das gleiche wie OCI_DTYPE_ROWID.
OCI_SYSOPER (integer) - Wird benutzt, um bei oci_connect() als SYSOPER mit externen Credentials oci8.privileged_connect sollte hierfür aktiviert sein) verbunden zu werden.
OCI_SYSDBA (integer) - Wird benutzt, um bei oci_connect() als SYSDBA mit externen Credentials oci8.privileged_connect sollte hierfür aktiviert sein) verbunden zu werden.
OCI_LOB_BUFFER_FREE (integer) - Wird mit OCI-Lob::flush benutzt, um die benutzten Buffer zu leeren.
OCI_TEMP_CLOB (integer) - Wird mit OCI-Lob::writeTemporary benutzt, um explizit anzuzeigen, dass temporäre CLOBs generiert werden sollen.
OCI_TEMP_BLOB (integer) - Wird mit OCI-Lob::writeTemporary benutzt, um explizit anzuzeigen, dass temporäre BLOBs generiert werden sollen.
Supported Datatypes
The driver supports the following types when binding parameters using the oci_bind_by_name() function:
Type
Mapping
SQLT_NTY
Maps a native collection type from a PHP collection object, such as those created by oci_new_collection().
SQLT_BFILEE
Maps a native descriptor, such as those created by oci_new_descriptor().
SQLT_CFILEE
SQLT_CLOB
SQLT_BLOB
SQLT_RDD
SQLT_NUM
Converts the PHP parameter to a 'C' long type, and binds to that value.
SQLT_RSET
Maps a native statement handle, such as those created by oci_parse() or those retrieved from other OCI queries.
SQLT_BOL
Bind the PHP parameter to a PL/SQL BOOLEAN
SQLT_CHR and any other type Converts the PHP parameter to a string type and binds as a string.
The following types are supported when retrieving columns from a result set:
Type
SQLT_RSET
SQLT_RDD
SQLT_BLOB
SQLT_CLOB
SQLT_BFILE
SQLT_LNG
Mapping
Creates an oci statement resource to represent the cursor.
Creates a ROWID object.
Creates a LOB object.
Bound as SQLT_CHR, returned as a string
SQLT_LBI
Any other type
Bound as SQLT_BIN, returned as a string
Bound as SQLT_CHR, returned as a string
OCI8 Funktionen
oci_bind_array_by_name — Bindet ein PHP-Array namentlich an ein Oracle-PL/SQL-Array
oci_bind_by_name — Bindet eine PHP-Variable an einen Oracle Platzhalter
oci_cancel — Bricht das Lesen eines Zeigers ab
oci_client_version — Returns the Oracle client library version
oci_close — Schließt eine Oracle-Verbindung
oci_commit — Commits the outstanding database transaction
oci_connect — Connect to an Oracle database
oci_define_by_name — Associates a PHP variable with a column for query fetches
oci_error — Liefert den letzten Fehler
oci_execute — Executes a statement
oci_fetch_all — Holt alle Reihen der Ergebnisdaten in ein Array
oci_fetch_array — Liefert die nächste Zeile der Ergebnisdaten als assoziatives und/oder numerisches Array
oci_fetch_assoc — Liefert die nächste Zeile der Ergebnisdaten als assoziatives Array
oci_fetch_object — Liefert die nächste Zeile der Ergebnisdaten als Objekt
oci_fetch_row — Liefert die nächste Zeile der Ergebnisdaten als numerisches Array
oci_fetch — Holt die nächste Reihe in den Ergebnispuffer
oci_field_is_null — Checks if the field is NULL
oci_field_name — Returns the name of a field from the statement
oci_field_precision — Tell the precision of a field
oci_field_scale — Tell the scale of the field
oci_field_size — Returns field's size
oci_field_type_raw — Tell the raw Oracle data type of the field
oci_field_type — Returns field's data type
oci_free_descriptor — Frees a descriptor
oci_free_statement — Gibt alle verknüpften Ressourcen eines Statements oder Zeigers frei.
oci_get_implicit_resultset — Returns the next child statement resource from a parent statement resource that has Oracle Database 12c Implicit Result Sets
oci_internal_debug — Enables or disables internal debug output
oci_lob_copy — Copies large object
oci_lob_is_equal — Compares two LOB/FILE locators for equality
oci_new_collection — Allocates new collection object
oci_new_connect — Connect to the Oracle server using a unique connection
oci_new_cursor — Allocates and returns a new cursor (statement handle)
oci_new_descriptor — Initializes a new empty LOB or FILE descriptor
oci_num_fields — Returns the number of result columns in a statement
oci_num_rows — Returns number of rows affected during statement execution
oci_parse — Prepares an Oracle statement for execution
oci_password_change — Changes password of Oracle's user
oci_pconnect — Connect to an Oracle database using a persistent connection
oci_result — Returns field's value from the fetched row
oci_rollback — Rolls back the outstanding database transaction
oci_server_version — Returns the Oracle Database version
oci_set_action — Sets the action name
oci_set_client_identifier — Sets the client identifier
oci_set_client_info — Sets the client information
oci_set_edition — Sets the database edition
oci_set_module_name — Sets the module name
oci_set_prefetch — Sets number of rows to be prefetched by queries
oci_statement_type — Returns the type of a statement
OCI-Collection — The OCI-Collection class
OCI-Collection::append — Appends element to the collection
OCI-Collection::assign — Assigns a value to the collection from another existing collection
OCI-Collection::assignElem — Assigns a value to the element of the collection
OCI-Collection::free — Frees the resources associated with the collection object
OCI-Collection::getElem — Returns value of the element
OCI-Collection::max — Returns the maximum number of elements in the collection
OCI-Collection::size — Returns size of the collection
OCI-Collection::trim — Trims elements from the end of the collection
OCI-Lob — The OCI-Lob class
OCI-Lob::append — Appends data from the large object to another large object
OCI-Lob::close — Closes LOB descriptor
OCI-Lob::eof — Tests for end-of-file on a large object's descriptor
OCI-Lob::erase — Erases a specified portion of the internal LOB data
OCI-Lob::export — Exports LOB's contents to a file
OCI-Lob::flush — Flushes/writes buffer of the LOB to the server
OCI-Lob::free — Frees resources associated with the LOB descriptor
OCI-Lob::getBuffering — Returns current state of buffering for the large object
OCI-Lob::import — Imports file data to the LOB
OCI-Lob::load — Returns large object's contents
OCI-Lob::read — Reads part of the large object
OCI-Lob::rewind — Moves the internal pointer to the beginning of the large object
OCI-Lob::save — Saves data to the large object
OCI-Lob::saveFile — Alias von OCI-Lob::import
OCI-Lob::seek — Sets the internal pointer of the large object
OCI-Lob::setBuffering — Changes current state of buffering for the large object
OCI-Lob::size — Returns size of large object
OCI-Lob::tell — Returns the current position of internal pointer of large object
OCI-Lob::truncate — Truncates large object
OCI-Lob::write — Writes data to the large object
OCI-Lob::writeTemporary — Writes a temporary large object
OCI-Lob::writeToFile — Alias von OCI-Lob::export
OCI8 - Veraltete Aliase und Funktionen
ocibindbyname — Alias von oci_bind_by_name
ocicancel — Alias von oci_cancel
ocicloselob — Alias von OCI-Lob::close
ocicollappend — Alias von OCI-Collection::append
ocicollassign — Alias von OCI-Collection::assign
ocicollassignelem — Alias von OCI-Collection::assignElem
ocicollgetelem — Alias von OCI-Collection::getElem
ocicollmax — Alias von OCI-Collection::max
ocicollsize — Alias von OCI-Collection::size
ocicolltrim — Alias von OCI-Collection::trim
ocicolumnisnull — Alias von oci_field_is_null
ocicolumnname — Alias von oci_field_name
ocicolumnprecision — Alias von oci_field_precision
ocicolumnscale — Alias von oci_field_scale
ocicolumnsize — Alias von oci_field_size
ocicolumntype — Alias von oci_field_type
ocicolumntyperaw — Alias von oci_field_type_raw
ocicommit — Alias von oci_commit
ocidefinebyname — Alias von oci_define_by_name
ocierror — Alias von oci_error
ociexecute — Alias von oci_execute
ocifetch — Alias von oci_fetch
ocifetchinto — Fetcht die nächste Zeile des Ergebnisses in ein Array (deprecated!)
ocifetchstatement — Alias von oci_fetch_all
ocifreecollection — Alias von OCI-Collection::free
ocifreecursor — Alias von oci_free_statement
ocifreedesc — Alias von OCI-Lob::free
ocifreestatement — Alias von oci_free_statement
ociinternaldebug — Alias von oci_internal_debug
ociloadlob — Alias von OCI-Lob::load
ocilogoff — Alias von oci_close
ocilogon — Alias von oci_connect
ocinewcollection — Alias von oci_new_collection
ocinewcursor — Alias von oci_new_cursor
ocinewdescriptor — Alias von oci_new_descriptor
ocinlogon — Alias von oci_new_connect
ocinumcols — Alias von oci_num_fields
ociparse — Alias von oci_parse
ociplogon — Alias von oci_pconnect
ociresult — Alias von oci_result
ocirollback — Alias von oci_rollback
ocirowcount — Alias von oci_num_rows
ocisavelob — Alias von OCI-Lob::save
ocisavelobfile — Alias von OCI-Lob::import
ociserverversion — Alias von oci_server_version
ocisetprefetch — Alias von oci_set_prefetch
ocistatementtype — Alias von oci_statement_type
ociwritelobtofile — Alias von OCI-Lob::export
ociwritetemporarylob — Alias von OCI-Lob::writeTemporary
Ovrimos SQL
Ovrimos SQL Funktionen
ovrimos_close — Closes the connection to ovrimos
ovrimos_commit — Commits the transaction
ovrimos_connect — Connect to the specified database
ovrimos_cursor — Returns the name of the cursor
ovrimos_exec — Executes an SQL statement
ovrimos_execute — Executes a prepared SQL statement
ovrimos_fetch_into — Fetches a row from the result set
ovrimos_fetch_row — Fetches a row from the result set
ovrimos_field_len — Returns the length of the output column
ovrimos_field_name — Returns the output column name
ovrimos_field_num — Returns the (1-based) index of the output column
ovrimos_field_type — Returns the type of the output column
ovrimos_free_result — Frees the specified result_id
ovrimos_longreadlen — Specifies how many bytes are to be retrieved from long datatypes
ovrimos_num_fields — Returns the number of columns
ovrimos_num_rows — Returns the number of rows affected by update operations
ovrimos_prepare — Prepares an SQL statement
ovrimos_result_all — Prints the whole result set as an HTML table
ovrimos_result — Retrieves the output column
ovrimos_rollback — Rolls back the transaction
Paradox File Access
Contants for field types
Name
PX_FIELD_ALPHA
PX_FIELD_DATE
PX_FIELD_SHORT
PX_FIELD_LONG
PX_FIELD_CURRENCY
PX_FIELD_NUMBER
PX_FIELD_LOGICAL
PX_FIELD_MEMOBLOB
PX_FIELD_BLOB
PX_FIELD_FMTMEMOBLOB
PX_FIELD_OLE
PX_FIELD_GRAPHIC
PX_FIELD_TIME
PX_FIELD_TIMESTAMP
PX_FIELD_AUTOINC
PX_FIELD_BCD
PX_FIELD_BYTES
PX_KEYTOLOWER
Meaning
Character data with fixed length
Date, number of days since 1.1.0000
Short integer (2 Bytes)
Long integer (4 Bytes)
same as PX_FIELD_NUMBER
Double
Boolean
Binary large object
Binary large object (not supported)
Binary large object
OLE object (basically a blob, not supported)
Graphic (basically a blob, not supported)
time, number of milli seconds since midnight
timestamp, number of milli seconds since 1.1.0000
Auto incrementing interger (like PX_FIELD_LONG)
Decimal number stored in bcd format (not supported)
Array of Bytes with not more than 255 bytes (not supported)
Turn all field names into lower case
PX_KEYTOUPPER
Turn all field names into upper case
Contants for file types
Name
PX_FILE_INDEX_DB
PX_FILE_PRIM_INDEX
PX_FILE_NON_INDEX_DB
PX_FILE_NON_INC_SEC_INDEX
PX_FILE_SEC_INDEX
PX_FILE_INC_SEC_INDEX
PX_FILE_NON_INC_SEC_INDEX_G
PX_FILE_SEC_INDEX_G
PX_FILE_INC_SEC_INDEX_G
Meaning
Indexed database
Primary index
None indexed database
None incremental secondary index
Secondary index
Incremental secondary index
Non incremental secondary index
Secondary index
Non incremental secondary index
Paradox Funktionen
px_close — Closes a paradox database
px_create_fp — Create a new paradox database
px_date2string — Converts a date into a string.
px_delete_record — Deletes record from paradox database
px_delete — Deletes resource of paradox database
px_get_field — Returns the specification of a single field
px_get_info — Return lots of information about a paradox file
px_get_parameter — Gets a parameter
px_get_record — Returns record of paradox database
px_get_schema — Returns the database schema
px_get_value — Gets a value
px_insert_record — Inserts record into paradox database
px_new — Create a new paradox object
px_numfields — Returns number of fields in a database
px_numrecords — Returns number of records in a database
px_open_fp — Open paradox database
px_put_record — Stores record into paradox database
px_retrieve_record — Returns record of paradox database
px_set_blob_file — Sets the file where blobs are read from
px_set_parameter — Sets a parameter
px_set_tablename — Sets the name of a table (deprecated)
px_set_targetencoding — Sets the encoding for character fields (deprecated)
px_set_value — Sets a value
px_timestamp2string — Converts the timestamp into a string.
px_update_record — Updates record in paradox database
PostgreSQL
PGSQL_ASSOC (integer) - Wird an die Funktion pg_fetch_array() übergeben. Gibt ein assoziatives Array zurück, mit den Feldnamen als Indizes und den entsprechenden Werten.
PGSQL_NUM (integer) - Wird an die Funktion pg_fetch_array() übergeben. Gibt ein numerisches Array zurück, mit den Feldnummern als Indizes und den entsprechenden Werten.
PGSQL_BOTH (integer) - Wird an die Funktion pg_fetch_array() übergeben. Gibt ein Array zurück, das sowohl assoziativ (mit den Feldnamen) als auch numerisch
(mit den Feldnummern) indiziert ist, und den entsprechenden Werten.
PGSQL_CONNECT_FORCE_NEW (integer) - Wird an die Funktion pg_connect() übergeben, um eine neue Verbindung zu erzwingen, anstatt eine identische,
bereits geöffnete Verbindung wieder zu benutzen.
PGSQL_CONNECTION_BAD (integer) - Wird von der Funktion pg_connection_status() zurückgegeben und zeigt an, dass der Status der Datenbankverbindung ungültig ist.
PGSQL_CONNECTION_OK (integer) - Wird von der Funktion pg_connection_status() zurückgegeben und zeigt an, dass der Status der Datenbankverbindung gültig ist.
PGSQL_SEEK_SET (integer) - Wird an die Funktion pg_lo_seek() übergeben. Das Objekt wird von Beginn an durchsucht.
PGSQL_SEEK_CUR (integer) - Wird an die Funktion pg_lo_seek() übergeben. Das Objekt wird ab der aktuellen Position durchsucht.
PGSQL_SEEK_END (integer) - Wird an die Funktion pg_lo_seek() übergeben. Das Objekt wird, ausgehend vom Ende, durchsucht.
PGSQL_EMPTY_QUERY (integer) - Wird von der Funktion pg_result_status() zurückgegeben, wenn der an den Server gesendete String leer war.
PGSQL_COMMAND_OK (integer) - Wird von der Funktion pg_result_status() zurückgegeben. Ein Kommando wurde erfolgreich ausgeführt, aber es wurden keine Daten zurückgegeben.
PGSQL_TUPLES_OK (integer) - Wird von der Funktion pg_result_status() zurückgegeben. Ein Kommando wurde erfolgreich ausgeführt und es wurden Daten (wie
etwa ein SELECT oder SHOW) zurückgegeben.
PGSQL_COPY_OUT (integer) - Wird von der Funktion pg_result_status() zurückgegeben. Ein Datentransfer vom Server wurde gestartet.
PGSQL_COPY_IN (integer) - Wird von der Funktion pg_result_status() zurückgegeben. Ein Datentransfer zum Server wurde gestartet.
PGSQL_BAD_RESPONSE (integer) - Wird von der Funktion pg_result_status() zurückgegeben. Die Serverantwort wurde nicht verstanden.
PGSQL_NONFATAL_ERROR (integer) - Wird von der Funktion pg_result_status() zurückgegeben. Ein nicht-fataler Fehler (eine Notiz oder Warnung) ist aufgetreten.
PGSQL_FATAL_ERROR (integer) - Wird von der Funktion pg_result_status() zurückgegeben. Ein fataler Fehler ist aufgetreten.
PGSQL_TRANSACTION_IDLE (integer) - Wird von der Funktion pg_transaction_status() zurückgegeben. Die Verbindung wird momentan nicht benutzt, es findet aktuell keine Transaktion statt.
PGSQL_TRANSACTION_ACTIVE (integer) - Wird von der Funktion pg_transaction_status() zurückgegeben. Die Verbindung wird momentan benutzt. Es wird eine
Abfrage ausgeführt, die noch nicht beendet ist.
PGSQL_TRANSACTION_INTRANS (integer) - Wird von der Funktion pg_transaction_status() zurückgegeben. Die Verbindung wird von einer Transaktion benutzt, ist aber momentan nicht aktiv.
PGSQL_TRANSACTION_INERROR (integer) - Wird von der Funktion pg_transaction_status() zurückgegeben. Die Verbindung wurde von einer abgebrochenen
Transaktion benutzt und ist momentan nicht aktiv.
PGSQL_TRANSACTION_UNKNOWN (integer) - Wird von der Funktion pg_transaction_status() zurückgegeben. Die Verbindung ist ungültig.
PGSQL_DIAG_SEVERITY (integer) - Wird an die Funktion pg_result_error_field() übergeben. Gibt den Schweregrad des Fehlers zurück. Die Feldinhalte sind
ERROR, FATAL oder PANIC (in einer Fehlermeldung) oder WARNING, NOTICE, DEBUG, INFO oder LOG (in einer Notice-Meldung) oder eine lokalisierte
Übersetzung davon. Dieses Feld ist immer verfügbar.
PGSQL_DIAG_SQLSTATE (integer) - Wird an die Funktion pg_result_error_field() übergeben. Gibt den SQLSTATE-Code des Fehlers zurück. Der SQLSTATE-Code
identifiziert den Typ des aufgetretenen Fehlers. Dieser kann von Anwendungen ausgewertet werden, um entsprechende Operationen auszuführen
(beispielsweise Fehlerbehandlungsroutinen), als Reaktion auf einen bestimmten Datenbankfehler. dieses Feld kann nicht lokalisiert werden und ist immer
verfügbar.
PGSQL_DIAG_MESSAGE_PRIMARY (integer) - Wird an die Funktion pg_result_error_field() übergeben. Dies ist die primäre, für Menschen lesbare Fehlermeldung
(normalerweise in einer Zeile) und ist immer verfügbar.
PGSQL_DIAG_MESSAGE_DETAIL (integer) - Wird an die Funktion pg_result_error_field() übergeben. Detail: eine optionale untergeordnete Fehlermeldung, in der
das Problem genauer beschrieben wird. Diese Meldung kann mehrere Zeilen lang sein.
PGSQL_DIAG_MESSAGE_HINT (integer) - Wird an die Funktion pg_result_error_field() übergeben. Hint: ein optionaler Hinweis, wie mit dem Problem umzugehen
ist. Dies wurde eingeführt, um (möglicherweise unpassende) Lösungen zur Verfügung zu stellen, anstatt harte Fakten, wie bei Details. Diese Meldung kann
mehrere Zeilen lang sein.
PGSQL_DIAG_STATEMENT_POSITION (integer) - Wird an die Funktion pg_result_error_field() übergeben. Dies ist ein String, der eine dezimale Integerzahl
enthält, die die Cursorposition des originalen SQL-Strings angibt, an der ein Fehler auftrat. Das erste Zeichen hat die Position 1 und zur Bestimmung der
Positionen werden Zeichen zugrundegelegt und nicht Bytes.
PGSQL_DIAG_INTERNAL_POSITION (integer) - Wird an die Funktion pg_result_error_field() übergeben. Per Definition ist das dasselbe wie das Feld
PG_DIAG_STATEMENT_POSITION, es wird aber benutzt, wenn die Cursorposition auf ein intern generiertes Kommando verweist und nicht auf eines, das vom
Benutzer eingegeben wurde. Das Feld
PG_DIAG_INTERNAL_QUERY - wird immer gesetzt, wenn dieses Feld gesetzt ist.
PGSQL_DIAG_INTERNAL_QUERY (integer) - Wird an die Funktion pg_result_error_field() übergeben. Dies ist der Text eines fehlgeschlagenen, intern generierten
Kommandos. Das kann beispielsweise eine SQL-Abfrage sein, die von einer PL/pgSQL-Funktion gesendet wurde.
PGSQL_DIAG_CONTEXT (integer) - Wird an die Funktion pg_result_error_field() übergeben. Dies gibt einen Hinweis auf den Kontext, in dem ein Fehler auftrat.
Gegenwärtig sind Zurückverfolgungen des Aufrufstacks von Funktionen aktivierter prozeduraler Sprachen darin enthalten, sowie intern generierte Abfragen. Die
Ablaufverfolgung enthält einen Eintrag pro Zeile, die neuesten Einträge zuerst.
PGSQL_DIAG_SOURCE_FILE (integer) - Wird an die Funktion pg_result_error_field() übergeben. Dies ist der Name der Datei im PostgreSQL-Quellcode, bei der der Fehler gemeldet wurde.
PGSQL_DIAG_SOURCE_LINE (integer) - Wird an die Funktion pg_result_error_field() übergeben. Die Zeilennummer in der Datei im PostgreSQL-Quellcode, bei der der Fehler gemeldet wurde.
PGSQL_DIAG_SOURCE_FUNCTION (integer) - Wird an die Funktion pg_result_error_field() übergeben. Der Name der Funktion im PostgreSQL-Quellcode, bei der
der Fehler gemeldet wurde.
PGSQL_ERRORS_TERSE (integer) - Wird an die Funktion pg_set_error_verbosity() übergeben. Damit wird festgelegt, dass Fehlermeldungen die Felder severity,
primary text und position enthalten. Normalerweise passt das alles in eine Zeile.
PGSQL_ERRORS_DEFAULT (integer) - Wird an die Funktion pg_set_error_verbosity() übergeben. Die Standardeinstellung gibt Meldungen mit den oben
beschriebenen Inhalten zurück, zuzüglich aller Details, Hinweise und Kontext-Informationen. (Dies kann mehrere Zeilen umfassen.)
PGSQL_ERRORS_VERBOSE (integer) - Wird an die Funktion pg_set_error_verbosity() übergeben. In diesem Modus werden alle verfügbaren Felder zurückgegeben.
PGSQL_STATUS_LONG (integer) - Wird an die Funktion pg_result_status() übergeben. Zeigt an, dass ein numerischer Ergebniscode gewünscht ist.
PGSQL_STATUS_STRING (integer) - Wird an die Funktion pg_result_status() übergeben. Zeigt an, dass eine textuelles Ergebnis gewünscht ist.
PGSQL_CONV_IGNORE_DEFAULT (integer) - Wird an die Funktion pg_convert() übergeben. Während der Konversion werden Standardwerte in der Tabelle ignoriert.
PGSQL_CONV_FORCE_NULL (integer) - Wird an die Funktion pg_convert() übergeben. Anstelle eines leeren Strings string wird der SQL Nullwert NULL benutzt.
PGSQL_CONV_IGNORE_NOT_NULL (integer) - Wird an die Funktion pg_convert() übergeben. Die Konversion von NULL in SQL NOT NULL-Spalten wird ignoriert.
PostgreSQL-Funktionen
pg_affected_rows — Gibt die Anzahl betroffener Datensätze (Tupel) zurück
pg_cancel_query — Löscht eine asynchrone Abfrage
pg_client_encoding — Gibt die Kodierung des Clients zurück
pg_close — Schließt eine PostgreSQL-Verbindung
pg_connect — Öffnet eine PostgreSQL-Verbindung
pg_connection_busy — Gibt den Status der Verbindung zurück (busy/not busy)
pg_connection_reset — Setzt die Verbindung zurück und verbindet neu
pg_connection_status — Gibt den Verbindungsstatus zurück
pg_convert — Konvertiert die Werte eines assoziativen Arrays in passende Werte für SQL-Kommandos.
pg_copy_from — Fügt Datensätze aus einem Array in eine Tabelle ein
pg_copy_to — Kopiert eine Tabelle in ein Array
pg_dbname — Gibt den Namen der Datenbank zurück
pg_delete — Lscht Datenstze
pg_end_copy — Synchronisation mit dem PostgreSQL-Server
pg_escape_bytea — Maskiert Zeichenketten zum Einfügen in ein Feld vom Typ bytea
pg_escape_identifier — Escape a identifier for insertion into a text field
pg_escape_literal — Escape a literal for insertion into a text field
pg_escape_string — Maskiert einen String zum Einfgen in Felder mit text/char Datentypen
pg_execute — Fordert den Datenankserver auf, eine vorbereitete Anfrage mit den angegebenen Parametern auszuführen und wartet auf das Ergebnis
pg_fetch_all_columns — Gibt alle Werte einer bestimmten Spalte eines Abfrageergebnisses in einem Array zurück
pg_fetch_all — Gibt alle Zeilen eines Abfrageergebnisses als Array zurück
pg_fetch_array — Holt eine Zeile als Array
pg_fetch_assoc — Holt eine Zeile als assoziatives Array
pg_fetch_object — Holt einen Datensatz als Objekt
pg_fetch_result — Liefert Werte aus einer Ergebnismenge
pg_fetch_row — Holt einen Datensatz als numerisches Array
pg_field_is_null — Prüft, ob ein Feld einen SQL NULL-Wert enthält
pg_field_name — Gibt den Namen eines Feldes zurück
pg_field_num — Gibt die Feldnummer des angegebenen Feldes zurück
pg_field_prtlen — Gibt die Länge des Feldes zurück
pg_field_size — Gibt den belegten Speicher für ein Feld zurück
pg_field_table — Gibt zu einem Feldnamen den Namen der Tabelle oder deren oid zurück, in der das Feld definiert ist
pg_field_type_oid — Gibt die ID des PostgreSQL-Datentyps (OID) eines Feldes zurück
pg_field_type — Gibt den Datentyp eines Feldes zurück
pg_free_result — Gibt den durch Ergebnisse belegten Speicher frei
pg_get_notify — Gibt eine SQL NOTIFY-Nachricht zurück
pg_get_pid — Prüft die Datenbankverbindung
pg_get_result — Gibt asynchrone Abfrageergebnisse zurück
pg_host — Gibt den Namen des Host zurück, zu dem verbunden wurde
pg_insert — Überträgt Werte aus einem Array in eine Tabelle
pg_last_error — Gibt die letzte Fehlermeldung einer Verbindung zurück
pg_last_notice — Gibt die letzte NOTICE-Meldung des PostgreSQL-Servers zurück
pg_last_oid — Gibt den Objektbezeichner (OID) des zuletzt eingefügten Datensatzes zurück
pg_lo_close — Schließt ein Large Object
pg_lo_create — Erzeugt ein Large Object
pg_lo_export — Exportiert ein Large Object in eine Datei
pg_lo_import — Importiert ein Large Object aus einer Datei
pg_lo_open — Öffnet ein Large Object
pg_lo_read_all — Liest ein Large Object vollständig und reicht es direkt an den Browser weiter
pg_lo_read — Liest ein Large Object
pg_lo_seek — Setzt die Lese- oder Schreibposition in einem Large Object
pg_lo_tell — Gibt die aktuelle Lese- oder Schreibposition in einem Large Object zurück
pg_lo_truncate — Truncates a large object
pg_lo_unlink — Löscht ein Large Object
pg_lo_write — Schreibt in ein Large Object
pg_meta_data — Gibt Metadaten einer Tabelle als Array zurück
pg_num_fields — Gibt die Anzahl der Felder in einem Abfrageergebnis zurück
pg_num_rows — Gibt die Anzahl der Zeilen in einem Abfrageergebnis zurück
pg_options — Gibt die Verbindungsoptionen der aktuellen Verbindung zurück
pg_parameter_status — Gibt den Wert einer aktuellen Server-Einstellung zurück
pg_pconnect — Öffnet eine persistente PostgreSQL-Verbindung
pg_ping — Prüft die Datenbankverbindung
pg_port — Gibt die Portnummer zurück, über die die Verbindung aufgebaut wurde
pg_prepare — Sendet eine Aufforderung an den Server, eine vorbereitete Anfrage mit den übergebenen Parametern zu erzeugen und wartet auf ihre Beendigung.
pg_put_line — Sendet eine NULL-terminierte Zeichenkette zum PostgreSQL-Server
pg_query_params — Sendet ein Kommando zum Server und wartet seine Ausführung ab. Getrennt vom SQL-Kommando können dabei Parameter übergeben werden.
pg_query — Führt eine Abfrage aus
pg_result_error_field — Gibt den Inhalt eines bestimmtes Feldes zu einer Fehlermeldung zurück
pg_result_error — Gibt die mit der Ergebniskennung verknüpfte Fehlermeldung zurück
pg_result_seek — Setzt den internen Datensatzzeiger auf die angegebene Position in einem Abfrageergebnis
pg_result_status — Gibt den Status eines Abfrageergebnisses zurück
pg_select — Wählt Datensätze aus
pg_send_execute — Sendet eine Aufforderung an den Server, eine vorbereitete Abfrage mit den übergebenen Parametern auszuführen, ohne auf die Ergebnisse zu warten.
pg_send_prepare — Sendet eine Aufforderung an den Server, eine vorbereitete Abfrage mit den übergebenen Parametern zu erzeugen, ohne auf ihre Beendigung zu warten.
pg_send_query_params — Sendet ein Kommando und separate Parameter zum Server, ohne auf die Rückgabe der Ergebnisse zu warten
pg_send_query — Sendet eine asynchrone Abfrage
pg_set_client_encoding — Setzt die Kodierung des Clients
pg_set_error_verbosity — Bestimmt den Detaillierungsgrad von Fehlermeldungen, die von pg_last_error und pg_result_error zurückgegeben werden.
pg_trace — Ermöglicht die Ablaufverfolgung einer Verbindung
pg_transaction_status — Gibt den aktuellen Transaktionsstatus des Servers zurück
pg_tty — Gibt den TTY Namen für die Verbindung zurück
pg_unescape_bytea — Entfernt Maskierungen für den Typ bytea
pg_untrace — Beendet die Ablaufverfolgung einer PostgreSQL-Verbindung
pg_update — Aktualisiert eine Tabelle
pg_version — Gibt ein Array zurück, das die Versionen von Client, Protokoll und Server enthält (falls verfügbar).
SQLite
SQLITE_ASSOC (int) - Spaltenwerte werden als Array zurückgegeben mit den Spaltennamen als Schlüssel.
SQLITE_BOTH (int) - Spalten werden als Array zurückgegeben in dem sowohl die Spaltennummer als auch der Spaltenname als Schlüssel genutzt wird.
SQLITE_NUM (int) - Spalten werden in einem Array mit numerischen Schlüsseln, beginnend mit 0, zurükgegeben
SQLITE_OK (int) - Erfolgreiche Ausführung.
SQLITE_ERROR (int) - SQL Fehler oder fehlende Datenbank.
SQLITE_INTERNAL (int) - Interner Fehler in SQLite.
SQLITE_PERM (int) - Fehlende Zugriffsberechtigung.
SQLITE_ABORT (int) - Abbruchanforderung aus einer Callback-Routine.
SQLITE_BUSY (int) - Die Datenbankdatei ist gesperrt.
SQLITE_LOCKED (int) - Eine Tabelle in der Datenbank ist gesperrt.
SQLITE_NOMEM (int) - Speicheranforderung fehlgeschlagen.
SQLITE_READONLY (int) - Schreibversuch auf eine nur-lesen Datenbank.
SQLITE_INTERRUPT (int) - Interner Abbruch einer Operation.
SQLITE_IOERR (int) - Datei Ein-/Ausgabefehler.
SQLITE_NOTADB (int) - Die zu öffnende Datei ist keine Datenbank.
SQLITE_CORRUPT (int) - Die Datenbankdatei ist beschädigt.
SQLITE_FORMAT (int) - Datenbankformatfehler.
SQLITE_NOTFOUND (int) - Tabelle oder Eintrag nicht gefunden.
SQLITE_FULL (int) - EinfÃ¼gen mangels Speicherplatz fehlgeschlagen (intern).
SQLITE_CANTOPEN (int) - Datenbankdatei kann nicht geöffnet werden.
SQLITE_PROTOCOL (int) - Protokollfehler beim Sperren einer Datenbank. Database lock protocol error.
SQLITE_EMPTY (int) - Datenbank ist leer (internal).
SQLITE_SCHEMA (int) - Das Datenbankschema hat sich geändert.
SQLITE_TOOBIG (int) - Zu viele Daten für eine Tabellenzeile.
SQLITE_CONSTRAINT (int) - Abbruch wegen einer fehlgeschlagenen PrÃ¼fbedingung.
SQLITE_MISMATCH (int) - Unverträgliche Datentypen.
SQLITE_MISUSE (int) - Fehlerhafte Nutzung der Bibliothek.
SQLITE_NOLFS (int) - Nutzung eines auf diesem System nicht vorhandenen Betriebsystemfeatures.
SQLITE_AUTH (int) - Autorisierung fehlgeschlagen.
SQLITE_ROW (int) - Interner Prozess hat eine andere Zeile bereitgestellt.
SQLITE_DONE (int) - Interner Prozess hat die Ausführung abgeschlossen.
SQLite Funktionen
sqlite_array_query — Führt eine Datenbankabfrage durch und liefert das gesamte Abfrageergebnis als Liste zurück
sqlite_busy_timeout — Setzt die maximale Dauer für das Warten auf die Freigabe einer Datenbank, oder sperrt das Warten selbst
sqlite_changes — Liefert die Anzahl der vom letzten SQL-Befehl geänderten Datenbankeinträge.
sqlite_close — Schließt eine SQLite-Datenbankverbindung
sqlite_column — Holt eine Spalte des aktuellen Ergebnissatzes
sqlite_create_aggregate — Registriert eine benutzerdefinierte Funktion, um SQL-Abfragen zu aggregieren
sqlite_create_function — Registriert eine "reguläre" nutzerdefinierte Funktion für den Gebrauch in SQL-Befehlen
sqlite_current — Holt die aktuelle Zeile als Array aus dem Abfrageergebnis
sqlite_error_string — Liefert eine textuelle Beschreibung eines Fehler-Codes
sqlite_escape_string — Bereitet einen String für die Verwendung als SQL-Parameter auf
sqlite_exec — Führt eine ergebnislose Abfrage in einer definierten Datenbank aus
sqlite_factory — Öffnet eine SQLite-Datenbank und gibt ein SQLiteDatabase-Objekt zurück
sqlite_fetch_all — Holt sich alle Reihen eines Abfrageergebnisses und liefert sie als Array im Array zurück
sqlite_fetch_array — Liest die nächste Zeile aus dem Datenbankergebnis und gibt sie als Array zurück
sqlite_fetch_column_types — Liefert ein Array mit den Spaltentypen einer bestimmten Tabelle
sqlite_fetch_object — Holt sich die nächste Reihe des Ergebnisses und gibt diese als Objekt zurück
sqlite_fetch_single — Holt sich die erste Spalte eines Abfrageergebnisses als String
sqlite_fetch_string — Alias von sqlite_fetch_single
sqlite_field_name — Gibt den Namen eines Feldes zurück
sqlite_has_more — Findet heraus, ob noch Reihen im Ergebnis vorhanden sind
sqlite_has_prev — Gibt zurück, ob eine vorige Reihe existiert oder nicht
sqlite_key — Liefert den aktuellen Zeilenindex
sqlite_last_error — Liefert den Fehlercode des letzten Fehlers einer Datenbank
sqlite_last_insert_rowid — Liefert die Zeilenidentifikation der zuletzt eingefügten Reihe zurück
sqlite_libencoding — Liefert die Kodierung der verwendeten SQLite-Bibliothek zurück
sqlite_libversion — Liefert die Version der genutzten SQLite-Bibliothek
sqlite_next — Wechselt zu der nächsten Zeilennummer
sqlite_num_fields — Liefert die Anzahl der Felder eines Abfrageergebnisses zurück
sqlite_num_rows — Liefert die Anzahl an Reihen eines gepufferten Abfrageergebnisses zurück
sqlite_open — Öffnet eine SQLite-Datenbank und erzeugt die Datenbank, wenn diese nicht existiert.
sqlite_popen — Öffnet eine persistente Verbindung zu einer SQLite-Datenbank und erzeugt diese im Bedarfsfall
sqlite_prev — Springt zur vorige Zeile
sqlite_query — Führt auf einer Datenbank eine Abfrage durch und liefert das Abfrageergebnis zurück
sqlite_rewind — Springt zur ersten Zeile
sqlite_seek — Wechselt zu einer Reihe in einem gepufferten Abfrageergebnis
sqlite_single_query — Führt eine Query aus und liefert ein Array für eine einzige Spalte oder den Wert der ersten Reihe.
sqlite_udf_decode_binary — Dekodiert Binärdaten und reicht diese als Parameter weiter zu einer benutzerdefinierten Funktion (UDF)
sqlite_udf_encode_binary — Kodiert Binärdaten bevor sie von einer benutzerdefinierten Funktion (UDF) zurückgegeben werden
sqlite_unbuffered_query — Führt eine Abfrage aus, aber übernimmt die Daten nicht gleich ins PHP
sqlite_valid — Gibt an, ob weitere Zeilen zur Verfügung stehen
SQLite3
SQLITE3_ASSOC (integer) - Legt fest, dass die Sqlite3Result::fetchArray()-Methode eine assoziative Liste zurückgeben soll. Die Liste wird durch den Spaltennamen
indiziert, wie er in dem Anfrageergebnis zurückgegeben wurde.
SQLITE3_NUM (integer) - Legt fest, dass die Sqlite3Result::fetchArray()-Methode eine Liste zurückgeben soll, die durch die Spaltennummer indiziert wird, wie sie
in dem Anfrageergebnis zurückgegeben wurde, beginnend mit Spalte 0.
SQLITE3_BOTH (integer) - Legt fest, dass die Sqlite3Result::fetchArray()-Methode eine Liste zurückgeben soll, die sowohl durch den Spaltennamen, als auch
durch die Spaltennummer indiziert wird. Die geschieht analog dazu, wie es im Anfrageergebnis zurückgegeben wurde, beginnend mit Spalte 0.
SQLITE3_INTEGER (integer) - Repräsentiert die SQLite3 'INTEGER'-Speicherklasse.
SQLITE3_FLOAT (integer) - Repräsentiert die SQLite3 'REAL (FLOAT)'-Speicherklasse.
SQLITE3_TEXT (integer) - Repräsentiert die SQLite3 'TEXT'-Speicherklasse.
SQLITE3_BLOB (integer) - Repräsentiert die SQLite3 'BLOB'-Speicherklasse.
SQLITE3_NULL (integer) - Repräsentiert die SQLite3 'NULL'-Speicherklasse.
SQLITE3_OPEN_READONLY (integer) - Legt fest, dass die SQLite3-Datenbank nur für den lesenden Zugriff geöffnet wird.
SQLITE3_OPEN_READWRITE (integer) - Legt fest, dass die SQLite3 Datenbank für den Lese- und Schreibzugriff geöffnet wird.
SQLITE3_OPEN_CREATE (integer) - Legt fest, dass die SQLite3 Datenbank vor dem Öffnen angelegt wird, wenn diese noch nicht existiert.
SQLite3 — Die SQLite3-Klasse
SQLite3::busyTimeout — Sets the busy connection handler
SQLite3::changes — Gibt die Anzahl der Datenbankreihen zurück, die durch die letzte SQL-Anfrage verändert, gelöscht oder hinzugefügt wurden.
SQLite3::close — Beendet eine Datenbankverbindung
SQLite3::__construct — Instantiiert ein SQLite3 Objekt und öffnet eine SQLite3 Datenbank
SQLite3::createAggregate — Registriert eine PHP-Funktion zum Gebrauch als SQL-Aggregat-Funktion
SQLite3::createCollation — Registers a PHP function for use as an SQL collating function
SQLite3::createFunction — Registriert eine PHP-Funktion, die als SQL-Skalar-Funktion genutzt werden kann
SQLite3::escapeString — Gibt eine passend maskierte Zeichenkette zurück
SQLite3::exec — Führt eine ergebnislose Anfrage gegen den Datenbank-Server aus
SQLite3::lastErrorCode — Gibt den numerischen Ergebniscode der letzten fehlgeschlagenen SQLite-Anweisung zurück
SQLite3::lastErrorMsg — Gibt einen englischen Text zurück, der die letzten fehlgeschlagenen SQLite-Anfrage beschreibt.
SQLite3::lastInsertRowID — Gibt die Datensatz-Id des zuletzt getätigten INSERT in die Datenbank zurück
SQLite3::loadExtension — Attempts to load an SQLite extension library
SQLite3::open — Öffnet eine SQlite Datenbank
SQLite3::prepare — Bereitet eine SQL-Anweisung für die Ausführung vor
SQLite3::query — Führt eine SQL-Anfrage aus
SQLite3::querySingle — Executes a query and returns a single result
SQLite3::version — Returns the SQLite3 library version as a string constant and as a number
SQLite3Stmt — The SQLite3Stmt class
SQLite3Stmt::bindParam — Binds a parameter to a statement variable
SQLite3Stmt::bindValue — Binds the value of a parameter to a statement variable
SQLite3Stmt::clear — Clears all current bound parameters
SQLite3Stmt::close — Closes the prepared statement
SQLite3Stmt::execute — Executes a prepared statement and returns a result set object
SQLite3Stmt::paramCount — Returns the number of parameters within the prepared statement
SQLite3Stmt::reset — Resets the prepared statement
SQLite3Result — Die SQLite3Result Klasse
SQLite3Result::columnName — Returns the name of the nth column
SQLite3Result::columnType — Returns the type of the nth column
SQLite3Result::fetchArray — Fetches a result row as an associative or numerically indexed array or both
SQLite3Result::finalize — Closes the result set
SQLite3Result::numColumns — Returns the number of columns in the result set
SQLite3Result::reset — Resets the result set back to the first row
Microsoft SQL Server Driver for PHP
SQLSRV_FETCH_ASSOC (integer) - Forces sqlsrv_fetch_array() to return an associative array when passed as a parameter.
SQLSRV_FETCH_NUMERIC (integer) - Forces sqlsrv_fetch_array() to return an array with numeric when passed as a parameter.
SQLSRV_FETCH_BOTH (integer) - Forces sqlsrv_fetch_array() to return an array with both associative and numeric keys when passed as a parameter (the default behavior).
SQLSRV_ERR_ALL (integer) - Forces sqlsrv_errors() to return both errors and warings when passed as a parameter (the default behavior).
SQLSRV_ERR_ERRORS (integer) - Forces sqlsrv_errors() to return errors only (no warnings) when passed as a parameter.
SQLSRV_ERR_WARNINGS (integer) - Forces sqlsrv_errors() to return warnings only (no errors) when passed as a parameter.
SQLSRV_LOG_SYSTEM_ALL (integer) - Turns on logging of all subsystems when passed to sqlsrv_configure() as a parameter.
SQLSRV_LOG_SYSTEM_CONN (integer) - Turns on logging of connection activity when passed to sqlsrv_configure() as a parameter.
SQLSRV_LOG_SYSTEM_INIT (integer) - Turns on logging of initialization activity when passed to sqlsrv_configure() as a parameter.
SQLSRV_LOG_SYSTEM_OFF (integer) - Turns off logging of all subsystems when passed to sqlsrv_configure() as a parameter.
SQLSRV_LOG_SYSTEM_STMT (integer) - Turns on logging of statement activity when passed to sqlsrv_configure() as a parameter.
SQLSRV_LOG_SYSTEM_UTIL (integer) - Turns on logging of error function activity when passed to sqlsrv_configure() as a parameter.
SQLSRV_LOG_SEVERITY_ALL (integer) - Specifies that errors, warnings, and notices will be logged when passed to sqlsrv_configure() as a parameter.
SQLSRV_LOG_SEVERITY_ERROR (integer) - Specifies that errors will be logged when passed to sqlsrv_configure() as a parameter.
SQLSRV_LOG_SEVERITY_NOTICE (integer) - Specifies that notices will be logged when passed to sqlsrv_configure() as a parameter.
SQLSRV_LOG_SEVERITY_WARNING (integer) - Specifies that warnings will be logged when passed to sqlsrv_configure() as a parameter.
SQLSRV_NULLABLE_YES (integer) - Indicates that a column is nullable.
SQLSRV_NULLABLE_NO (integer) - Indicates that a column is not nullable.
SQLSRV_NULLABLE_UNKNOWN (integer) - Indicates that it is not known if a column is nullable.
SQLSRV_PARAM_IN (integer) - Indicates an input parameter when passed to sqlsrv_query() or sqlsrv_prepare().
SQLSRV_PARAM_INOUT (integer) - Indicates a bidirectional parameter when passed to sqlsrv_query() or sqlsrv_prepare().
SQLSRV_PARAM_OUT (integer) - Indicates an output parameter when passed to sqlsrv_query() or sqlsrv_prepare().
SQLSRV_PHPTYPE_INT (integer) - Specifies an integer PHP data type. For usage information, see » How to: Specify PHP Types.
SQLSRV_PHPTYPE_DATETIME (integer) - Specifies a datetime PHP data type. For usage information, see » How to: Specify PHP Types.
SQLSRV_PHPTYPE_FLOAT (integer) - Specifies a float PHP data type. For usage information, see » How to: Specify PHP Types.
SQLSRV_PHPTYPE_STREAM (integer) - Specifies a PHP stream. This constant works like a function and accepts an encoding constant. See the SQLSRV_ENC_*
constants. For usage information, see » How to: Specify PHP Types.
SQLSRV_PHPTYPE_STRING (integer) - Specifies a string PHP data type. This constant works like a function and accepts an encoding constant. See the
SQLSRV_ENC_* constants. For usage information, see » How to: Specify PHP Types.
SQLSRV_ENC_BINARY (integer) - Specifies that data is returned as a raw byte stream from the server without performing encoding or translation. For usage
information, see » How to: Specify PHP Types.
SQLSRV_ENC_CHAR (integer) - Data is returned in 8-bit characters as specified in the code page of the Windows locale that is set on the system. Any multi-byte
characters or characters that do not map into this code page are substituted with a single byte question mark (?) character. This is the default encoding. For
usage information, see » How to: Specify PHP Types.
UTF-8 (integer) - Specifies that data is returned with UTF-8 encoding. For usage information, see » How to: Specify PHP Types.
SQLSRV_SQLTYPE_BIGINT (integer) - Describes the bigint SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_BINARY (integer) - Describes the binary SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_BIT (integer) - Describes the bit SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_CHAR (integer) - Describes the char SQL Server data type. This constant works like a function and accepts a parameter indicating the number
characters. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_DATE (integer) - Describes the date SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_DATETIME (integer) - Describes the datetime SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_DATETIME2 (integer) - Describes the datetime2 SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_DATETIMEOFFSET (integer) - Describes the datetimeoffset SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_DECIMAL (integer) - Describes the decimal SQL Server data type. This constant works like a function and accepts two parameters indicating
(in order) precision and scale. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_FLOAT (integer) - Describes the float SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_IMAGE (integer) - Describes the image SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_INT (integer) - Describes the int SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_MONEY (integer) - Describes the money SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_NCHAR (integer) - Describes the nchar SQL Server data type. This constant works like a function and accepts a single parameter indicating the
character count. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_NUMERIC (integer) - Describes the numeric SQL Server data type. This constant works like a function and accepts two parameter indicating
(in order) precision and scale. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_NVARCHAR (integer) - Describes the nvarchar SQL Server data type. This constant works like a function and accepts a single parameter
indicating the character count. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_NVARCHAR('max') (integer) - Describes the nvarchar(MAX) SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_NTEXT (integer) - Describes the ntext SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_REAL (integer) - Describes the real SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_SMALLDATETIME (integer) - Describes the smalldatetime SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_SMALLINT (integer) - Describes the smallint SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_SMALLMONEY (integer) - Describes the smallmoney SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_TEXT (integer) - Describes the text SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_TIME (integer) - Describes the time SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_TIMESTAMP (integer) - Describes the timestamp SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_TINYINT (integer) - Describes the tinyint SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_UNIQUEIDENTIFIER (integer) - Describes the uniqueidentifier SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_UDT (integer) - Describes the UDT SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_VARBINARY (integer) - Describes the varbinary SQL Server data type. This constant works like a function and accepts a single parameter
indicating the byte count. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_VARBINARY('max') (integer) - Describes the varbinary(MAX) SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_VARCHAR (integer) - Describes the varchar SQL Server data type. This constant works like a function and accepts a single parameter
indicating the character count. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_VARCHAR('max') (integer) - Describes the varchar(MAX) SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_SQLTYPE_XML (integer) - Describes the XML SQL Server data type. For usage information, see » How to: Specify SQL Types.
SQLSRV_TXN_READ_UNCOMMITTED (integer) - Inidicates a transaction isolation level of READ UNCOMMITTED. This value is used to set the
TransactionIsolation level in the $connectionOptions arrary passed to sqlsrv_connect().
SQLSRV_TXN_READ_COMMITTED (integer) - Inidicates a transaction isolation level of READ COMMITTED. This value is used to set the TransactionIsolation level
in the $connectionOptions arrary passed to sqlsrv_connect().
SQLSRV_TXN_REPEATABLE_READ (integer) - Inidicates a transaction isolation level of REPEATABLE READ. This value is used to set the TransactionIsolation level
in the $connectionOptions arrary passed to sqlsrv_connect().
SQLSRV_TXN_SNAPSHOT (integer) - Inidicates a transaction isolation level of SNAPSHOT. This value is used to set the TransactionIsolation level in the
$connectionOptions arrary passed to sqlsrv_connect().
SQLSRV_TXN_READ_SERIALIZABLE (integer) - Inidicates a transaction isolation level of SERIALIZABLE. This value is used to set the TransactionIsolation level in
the $connectionOptions arrary passed to sqlsrv_connect().
SQLSRV_CURSOR_FORWARD (integer) - Inidicates a forward-only cursor. For usage information, see » Specifying a Cursor Type and Selecting Rows.
SQLSRV_CURSOR_STATIC (integer) - Inidicates a static cursor. For usage information, see » Specifying a Cursor Type and Selecting Rows.
SQLSRV_CURSOR_DYNAMIC (integer) - Inidicates a dynamic cursor. For usage information, see » Specifying a Cursor Type and Selecting Rows.
SQLSRV_CURSOR_KEYSET (integer) - Inidicates a keyset cursor. For usage information, see » Specifying a Cursor Type and Selecting Rows.
SQLSRV_CURSOR_BUFFERED (integer) - Creates a client-side cursor query. Lets you access rows in any order. For usage information, see » Specifying a Cursor Type and Selecting Rows.
SQLSRV_SCROLL_NEXT (integer) - Specifies which row to select in a result set. For usage information, see » Specifying a Cursor Type and Selecting Rows.
SQLSRV_SCROLL_PRIOR (integer) - Specifies which row to select in a result set. For usage information, see » Specifying a Cursor Type and Selecting Rows.
SQLSRV_SCROLL_FIRST (integer) - Specifies which row to select in a result set. For usage information, see » Specifying a Cursor Type and Selecting Rows.
SQLSRV_SCROLL_LAST (integer) - Specifies which row to select in a result set. For usage information, see » Specifying a Cursor Type and Selecting Rows.
SQLSRV_SCROLL_ABSOLUTE (integer) - Specifies which row to select in a result set. For usage information, see » Specifying a Cursor Type and Selecting Rows.
SQLSRV_SCROLL_RELATIVE (integer) - Specifies which row to select in a result set. For usage information, see » Specifying a Cursor Type and Selecting Rows.
SQLSRV Funktionen
sqlsrv_begin_transaction — Begins a database transaction
sqlsrv_cancel — Cancels a statement
sqlsrv_client_info — Returns information about the client and specified connection
sqlsrv_close — Closes an open connection and releases resourses associated with the connection
sqlsrv_commit — Commits a transaction that was begun with sqlsrv_begin_transaction
sqlsrv_configure — Changes the driver error handling and logging configurations
sqlsrv_connect — Opens a connection to a Microsoft SQL Server database
sqlsrv_errors — Returns error and warning information about the last SQLSRV operation performed
sqlsrv_execute — Executes a statement prepared with sqlsrv_prepare
sqlsrv_fetch_array — Returns a row as an array
sqlsrv_fetch_object — Retrieves the next row of data in a result set as an object
sqlsrv_fetch — Makes the next row in a result set available for reading
sqlsrv_field_metadata — Retrieves metadata for the fields of a statement prepared by sqlsrv_prepare or sqlsrv_query
sqlsrv_free_stmt — Frees all resources for the specified statement
sqlsrv_get_config — Returns the value of the specified configuration setting
sqlsrv_get_field — Gets field data from the currently selected row
sqlsrv_has_rows — Indicates whether the specified statement has rows
sqlsrv_next_result — Makes the next result of the specified statement active
sqlsrv_num_fields — Retrieves the number of fields (columns) on a statement
sqlsrv_num_rows — Retrieves the number of rows in a result set
sqlsrv_prepare — Prepares a query for execution
sqlsrv_query — Prepares and executes a query.
sqlsrv_rollback — Rolls back a transaction that was begun with sqlsrv_begin_transaction
sqlsrv_rows_affected — Returns the number of rows modified by the last INSERT, UPDATE, or DELETE query executed
sqlsrv_send_stream_data — Sends data from parameter streams to the server
sqlsrv_server_info — Returns information about the server
Sybase
Sybase Funktionen
sybase_affected_rows — Gets number of affected rows in last query
sybase_close — Closes a Sybase connection
sybase_connect — Opens a Sybase server connection
sybase_data_seek — Moves internal row pointer
sybase_deadlock_retry_count — Sets the deadlock retry count
sybase_fetch_array — Fetch row as array
sybase_fetch_assoc — Fetch a result row as an associative array
sybase_fetch_field — Get field information from a result
sybase_fetch_object — Fetch a row as an object
sybase_fetch_row — Get a result row as an enumerated array
sybase_field_seek — Sets field offset
sybase_free_result — Frees result memory
sybase_get_last_message — Returns the last message from the server
sybase_min_client_severity — Sets minimum client severity
sybase_min_error_severity — Sets minimum error severity
sybase_min_message_severity — Sets minimum message severity
sybase_min_server_severity — Sets minimum server severity
sybase_num_fields — Gets the number of fields in a result set
sybase_num_rows — Get number of rows in a result set
sybase_pconnect — Open persistent Sybase connection
sybase_query — Sends a Sybase query
sybase_result — Get result data
sybase_select_db — Selects a Sybase database
sybase_set_message_handler — Sets the handler called when a server message is raised
sybase_unbuffered_query — Send a Sybase query and do not block
tokyo_tyrant
TokyoTyrant — The TokyoTyrant class
TokyoTyrant::add — Adds to a numeric key
TokyoTyrant::connect — Connect to a database
TokyoTyrant::connectUri — Connects to a database
TokyoTyrant::__construct — Construct a new TokyoTyrant object
TokyoTyrant::copy — Copies the database
TokyoTyrant::ext — Execute a remote script
TokyoTyrant::fwmKeys — Returns the forward matching keys
TokyoTyrant::get — The get purpose
TokyoTyrant::getIterator — Get an iterator
TokyoTyrant::num — Number of records in the database
TokyoTyrant::out — Removes records
TokyoTyrant::put — Puts values
TokyoTyrant::putCat — Concatenates to a record
TokyoTyrant::putKeep — Puts a record
TokyoTyrant::putNr — Puts value
TokyoTyrant::putShl — Concatenates to a record
TokyoTyrant::restore — Restore the database
TokyoTyrant::setMaster — Set the replication master
TokyoTyrant::size — Returns the size of the value
TokyoTyrant::stat — Get statistics
TokyoTyrant::sync — Synchronize the database
TokyoTyrant::tune — Tunes connection values
TokyoTyrant::vanish — Empties the database
TokyoTyrantTable — The TokyoTyrantTable class
TokyoTyrantTable::add — Adds a record
TokyoTyrantTable::genUid — Generate unique id
TokyoTyrantTable::get — Get a row
TokyoTyrantTable::getIterator — Get an iterator
TokyoTyrantTable::getQuery — Get a query object
TokyoTyrantTable::out — Remove records
TokyoTyrantTable::put — Store a row
TokyoTyrantTable::putCat — Concatenates to a row
TokyoTyrantTable::putKeep — Put a new record
TokyoTyrantTable::putNr — Puts value
TokyoTyrantTable::putShl — Concatenates to a record
TokyoTyrantTable::setIndex — Sets index
TokyoTyrantQuery — The TokyoTyrantQuery class
TokyoTyrantQuery::addCond — Adds a condition to the query
TokyoTyrantQuery::__construct — Construct a new query
TokyoTyrantQuery::count — Counts records
TokyoTyrantQuery::current — Returns the current element
TokyoTyrantQuery::hint — Get the hint string of the query
TokyoTyrantQuery::key — Returns the current key
TokyoTyrantQuery::metaSearch — Retrieve records with multiple queries
TokyoTyrantQuery::next — Moves the iterator to next entry
TokyoTyrantQuery::out — Removes records based on query
TokyoTyrantQuery::rewind — Rewinds the iterator
TokyoTyrantQuery::search — Searches records
TokyoTyrantQuery::setLimit — Limit results
TokyoTyrantQuery::setOrder — Orders results
TokyoTyrantQuery::valid — Checks the validity of current item
TokyoTyrantIterator — The TokyoTyrantIterator class
TokyoTyrantIterator::__construct — Construct an iterator
TokyoTyrantIterator::current — Get the current value
TokyoTyrantIterator::key — Returns the current key
TokyoTyrantIterator::next — Move to next key
TokyoTyrantIterator::rewind — Rewinds the iterator
TokyoTyrantIterator::valid — Rewinds the iterator
Datums- und zeitrelevante Erweiterungen
Calendar
CAL_GREGORIAN (integer)
CAL_JULIAN (integer)
CAL_JEWISH (integer)
CAL_FRENCH (integer)
CAL_NUM_CALS (integer)
CAL_DOW_DAYNO (integer)
CAL_DOW_SHORT (integer)
CAL_DOW_LONG (integer)
CAL_MONTH_GREGORIAN_SHORT (integer)
CAL_MONTH_GREGORIAN_LONG (integer)
CAL_MONTH_JULIAN_SHORT (integer)
CAL_MONTH_JULIAN_LONG (integer)
CAL_MONTH_JEWISH (integer)
CAL_MONTH_FRENCH (integer)
Die folgenden Konstanten gibt es seit PHP 4.3.0:
CAL_EASTER_DEFAULT (integer)
CAL_EASTER_ROMAN (integer)
CAL_EASTER_ALWAYS_GREGORIAN (integer)
CAL_EASTER_ALWAYS_JULIAN (integer)
Die folgenden Konstanten gibt es seit PHP 5.0.0:
CAL_JEWISH_ADD_ALAFIM_GERESH (integer)
CAL_JEWISH_ADD_ALAFIM (integer)
CAL_JEWISH_ADD_GERESHAYIM (integer)
Calendar Funktionen
cal_days_in_month — Gibt die Anzahl der Tage eines bestimmten Monats in einem bestimmten Jahr in einem bestimmten Kalender zurück
cal_from_jd — Converts from Julian Day Count to a supported calendar
cal_info — Gibt Informationen zu einem bestimmten Kalender zurück
cal_to_jd — Converts from a supported calendar to Julian Day Count
easter_date — Zeitpunkt des Osterfestes (0 Uhr) als Unix-Timestamp
easter_days — Anzahl der Tage zwischen dem 21. März und Ostersonntag
frenchtojd — Konvertiert ein Datum der Französischen Revolution zu einem Julianischen Datum
gregoriantojd — Konvertierung vom Gregorianischen Kalender zum Julianischen Datum
jddayofweek — Bestimmt den Wochentag aus einem Julianischen Datum
jdmonthname — Bestimmt den Monat aus dem Julianischen Datum
jdtofrench — Konvertiert ein Julianisches Datum zum Kalender der Französischen Revolution
jdtogregorian — Konvertierung vom Julianischen Datum zum Gregorianischen Kalender
jdtojewish — Konvertierung vom Julianischen Datum zum Jüdischen Kalender
jdtojulian — Konvertierung vom Julianischen Datum zum Julianischen Kalender
jdtounix — Konvertiert Julianisches Datum in Unix-Timestamp
jewishtojd — Konvertiert vom Jüdischen Kalender zum Julianischen Datum
juliantojd — Konvertierung vom Julianischen Kalender zum Julianischen Datum
unixtojd — Konvertiert Unix-Timestamp in Julianisches Datum
Date/Time — Date and Time
Die folgenden Konstanten existieren seit PHP 5.1.2, sie spezifizieren Rückgabeformate für die Funktionen date_sunrise() und date_sunset().
SUNFUNCS_RET_TIMESTAMP (integer) - Timestamp
SUNFUNCS_RET_STRING (integer) - Stunde:Minute (z.B. 08:02)
SUNFUNCS_RET_DOUBLE (integer) - Sunden als Fließkommawert (z.B. 8.75)
DateTime — The DateTime class
DateTime::add — Adds an amount of days, months, years, hours, minutes and seconds to a DateTime object
DateTime::__construct — Returns new DateTime object
DateTime::createFromFormat — Returns new DateTime object formatted according to the specified format
DateTime::getLastErrors — Returns the warnings and errors
DateTime::modify — Alters the timestamp
DateTime::__set_state — The __set_state handler
DateTime::setDate — Sets the date
DateTime::setISODate — Sets the ISO date
DateTime::setTime — Sets the time
DateTime::setTimestamp — Sets the date and time based on an Unix timestamp
DateTime::setTimezone — Sets the time zone for the DateTime object
DateTime::sub — Subtracts an amount of days, months, years, hours, minutes and seconds from a DateTime object
DateTimeImmutable — The DateTimeImmutable class
DateTimeImmutable::add — Adds an amount of days, months, years, hours, minutes and seconds
DateTimeImmutable::__construct — Returns new DateTimeImmutable object
DateTimeImmutable::createFromFormat — Returns new DateTimeImmutable object formatted according to the specified format
DateTimeImmutable::getLastErrors — Returns the warnings and errors
DateTimeImmutable::modify — Alters the timestamp
DateTimeImmutable::__set_state — The __set_state handler
DateTimeImmutable::setDate — Sets the date
DateTimeImmutable::setISODate — Sets the ISO date
DateTimeImmutable::setTime — Sets the time
DateTimeImmutable::setTimestamp — Sets the date and time based on an Unix timestamp
DateTimeImmutable::setTimezone — Sets the time zone
DateTimeImmutable::sub — Subtracts an amount of days, months, years, hours, minutes and seconds
DateTimeInterface — The DateTimeInterface interface
DateTime::diff — Returns the difference between two DateTime objects
DateTime::format — Returns date formatted according to given format
DateTime::getOffset — Returns the timezone offset
DateTime::getTimestamp — Gets the Unix timestamp
DateTime::getTimezone — Return time zone relative to given DateTime
DateTime::__wakeup — The __wakeup handler
DateTimeZone — The DateTimeZone class
DateTimeZone::__construct — Creates new DateTimeZone object
DateTimeZone::getLocation — Returns location information for a timezone
DateTimeZone::getName — Returns the name of the timezone
DateTimeZone::getOffset — Returns the timezone offset from GMT
DateTimeZone::getTransitions — Returns all transitions for the timezone
DateTimeZone::listAbbreviations — Returns associative array containing dst, offset and the timezone name
DateTimeZone::listIdentifiers — Returns a numerically indexed array containing all defined timezone
DateInterval — The DateInterval class
DateInterval::__construct — Creates a new DateInterval object
DateInterval::createFromDateString — Sets up a DateInterval from the relative parts of the string
DateInterval::format — Formats the interval
DatePeriod — The DatePeriod class
DatePeriod::__construct — Creates a new DatePeriod object
Datum/Uhrzeit Funktionen
checkdate — Prüft ein Gregorianisches Datum auf Gültigkeit
date_add — Alias von DateTime::add
date_create_from_format — Alias von DateTime::createFromFormat
date_create_immutable_from_format — Alias von DateTimeImmutable::createFromFormat
date_create_immutable — Alias von DateTimeImmutable::__construct
date_create — Alias von DateTime::__construct
date_date_set — Alias von DateTime::setDate
date_default_timezone_get — Gets the default timezone used by all date/time functions in a script
date_default_timezone_set — Sets the default timezone used by all date/time functions in a script
date_diff — Alias von DateTime::diff
date_format — Alias von DateTime::format
date_get_last_errors — Alias von DateTime::getLastErrors
date_interval_create_from_date_string — Alias von DateInterval::createFromDateString
date_interval_format — Alias von DateInterval::format
date_isodate_set — Alias von DateTime::setISODate
date_modify — Alias von DateTime::modify
date_offset_get — Alias von DateTime::getOffset
date_parse_from_format — Get info about given date formatted according to the specified format
date_parse — Returns associative array with detailed info about given date
date_sub — Alias von DateTime::sub
date_sun_info — Returns an array with information about sunset/sunrise and twilight begin/end
date_sunrise — Returns time of sunrise for a given day and location
date_sunset — Returns time of sunset for a given day and location
date_time_set — Alias von DateTime::setTime
date_timestamp_get — Alias von DateTime::getTimestamp
date_timestamp_set — Alias von DateTime::setTimestamp
date_timezone_get — Alias von DateTime::getTimezone
date_timezone_set — Alias von DateTime::setTimezone
date — Formatiert ein(e) angegebene(s) Ortszeit/Datum
getdate — Gibt Datums- und Zeitinformationen zurück
gettimeofday — Ermittelt die aktuelle Zeit
gmdate — Formatiert eine GMT/UTC Zeit-/Datumsangabe
gmmktime — Gibt einen Unix-Timestamp (Zeitstempel) für ein GMT Datum zurück
gmstrftime — Formatiert eine Datum-/Zeitangabe in GMT/UTC-Format entsprechend den lokalen Einstellungen
idate — Format a local time/date as integer
localtime — Ermittelt die lokale Zeit
microtime — Gibt den aktuellen Unix-Timestamp/Zeitstempel mit Mikrosekunden zurück
mktime — Gibt den Unix-Timestamp/Zeitstempel für ein Datum zurück
strftime — Formatiert eine Zeit-/Datumsangabe nach den lokalen Einstellungen
strptime — Parse a time/date generated with strftime
strtotime — Wandelt ein beliebiges in englischer Textform angegebenes Datum in einen UNIX-Zeitstempel (Timestamp) um
time — Gibt den aktuellen Unix-Timestamp/Zeitstempel zurück
timezone_abbreviations_list — Alias von DateTimeZone::listAbbreviations
timezone_identifiers_list — Alias von DateTimeZone::listIdentifiers
timezone_location_get — Alias von DateTimeZone::getLocation
timezone_name_from_abbr — Gibt den Namen der Zeitzonenabkürzung zurück
timezone_name_get — Alias von DateTimeZone::getName
timezone_offset_get — Alias von DateTimeZone::getOffset
timezone_open — Alias von DateTimeZone::__construct
timezone_transitions_get — Alias von DateTimeZone::getTransitions
timezone_version_get — Gets the version of the timezonedb
Supported Date and Time Formats
Time Formats
This page describes the different time formats that the strtotime(), DateTime and date_create() parser understands.
Used Symbols
Description
Formats
Examples
frac
. [0-9]+
.21342, ".85"
hh
0?[1-9] | "1"[0-2]
04, "7", "12"
HH
[01][0-9] | "2"[0-4]
04, "7", "19"
meridian
[AaPp] .? [Mm] .? [\0\t ]
A.m., "pM", "am."
MM
[0-5][0-9]
00, "12", "59"
II
[0-5][0-9]
00, "12", "59"
space
[ \t]
tz
(? [A-Za-z]{1,6} ")"? | [A-Z][a-z]+([_/][A-Z][a-z]+)+
CEST, "Europe/Amsterdam", "America/Indiana/Knox"
tzcorrection
GMT? [+-] hh ":"? MM?
+0400, "GMT-07:00", "-07:00"
12 Hour Notation
Description
Hour only, with meridian
Hour and minutes, with meridian
Format
hh space? meridian
hh [.:] MM space? meridian
Hour, minutes and seconds, with meridian
MS SQL (Hour, minutes, seconds and fraction with meridian), PHP 5.3 and later only
hh [.:] MM [.:] II space? meridian
hh ":" MM ":" II [.:] [0-9]+ meridian
24 Hour Notation
Description
Hour and minutes
Hour and minutes, no colon
Hour, minutes and seconds
Hour, minutes and seconds, no colon
Hour, minutes, seconds and timezone
Hour, minutes, seconds and fraction
Time zone information
Format
't'? HH [.:] MM
't'? HH MM
't'? HH [.:] MM [.:] II
't'? HH MM II
't'? HH [.:] MM [.:] II space? ( tzcorrection | tz )
't'? HH [.:] MM [.:] II frac
tz | tzcorrection
Examples
4 am, "5PM"
4:08 am, "7:19P.M."
4:08:37 am,
"7:19:19P.M."
4:08:39:12313am
Examples
04:08, "19.19", "T23:43"
0408, "t1919", "T2343"
04.08.37, "t19:19:19"
040837, "T191919"
040837CEST, "T191919-0700"
04.08.37.81412, "19:19:19.532453"
CEST, "Europe/Amsterdam", "+0430", "GMT-06:00"
Date Formats
This page describes the different date formats that the strtotime(), DateTime and date_create() parser understands.
Used Symbols
Description
daysuf
dd
DD
m
M
mm
MM
Format
st | "nd" | "rd" | "th"
([0-2]?[0-9] | "3"[01]) daysuf?
0 [0-9] | [1-2][0-9] | "3" [01]
'january' | 'february' | 'march' | 'april' | 'may' | 'june' | 'july' | 'august' | 'september' | 'october' | 'november' | 'december' | 'jan' | 'feb' | 'mar' | 'apr' | 'may' |
"XII"
'jan' | 'feb' | 'mar' | 'apr' | 'may' | 'jun' | 'jul' | 'aug' | 'sep' | 'sept' | 'oct' | 'nov' | 'dec'
0? [0-9] | "1"[0-2]
0 [0-9] | "1"[0-2]
y
yy
YY
[0-9]{1,4}
[0-9]{2}
[0-9]{4}
Localized Notations
Description
American month and day
American month, day and year
Four digit year, month and day with slashes
Four digit year and month (GNU)
Year, month and day with dashes
Day, month and four digit year, with dots, tabs or dashes
Day, month and two digit year, with dots or tabs
Day, textual month and year
Textual month and four digit year (Day reset to 1)
Four digit year and textual month (Day reset to 1)
Textual month, day and year
Textual month and day
Day and textual month
Month abbreviation, day and year
Year, month abbreviation and day
Year (and just the year)
Textual month (and just the month)
ISO8601 Notations
Description
Eight digit year, month and day
Four digit year, month and day with slashes
Two digit year, month and day with dashes
Format
mm "/" dd
mm "/" dd "/" y
YY "/" mm "/" dd
YY "-" mm
y "-" mm "-" dd
dd [.\t-] mm [.-] YY
dd [.\t] mm "." yy
dd ([ \t.-])* m ([ \t.-])* y
m ([ \t.-])* YY
YY ([ \t.-])* m
m ([ .\t-])* dd [,.stndrh\t ]+ y
m ([ .\t-])* dd [,.stndrh\t ]*
d ([ .\t-])* m
M "-" DD "-" y
y "-" M "-" DD
YY
m
Format
YY MM DD
YY "/" MM "/" DD
yy "-" MM "-" DD
Examples
5/12, "10/27"
12/22/78, "1/17/2006", "1/17/6"
2008/6/30, "1978/12/22"
2008-6, "2008-06", "1978-12"
2008-6-30, "78-12-22", "8-6-21"
30-6-2008, "22.12\t1978"
30.6.08, "22\t12\t78"
30-June 2008, "22DEC78", "14 III 1879"
June 2008, "DEC1978", "March 1879"
2008 June, "1978-XII", "1879.MArCH"
July 1st, 2008, "April 17, 1790", "May.9,78"
July 1st,, "Apr 17", "May.9"
1 July, "17 Apr", "9.May"
May-09-78, "Apr-17-1790"
78-Dec-22, "1814-MAY-17"
1978, "2008"
March, "jun", "DEC"
Examples
15810726, "19780417", "18140517"
2008/06/30, "1978/12/22"
08-06-30, "78-12-22"
Four digit year with optional sign, month and day
[+-]? YY "-" MM "-" DD
-0002-07-26, "+1978-04-17", "1814-05-17"
Hinweis: For the y and yy formats, years below 100 are handled in a special way when the y or yy symbol is used. If the year falls in the range 0 (inclusive) to 69
(inclusive), 2000 is added. If the year falls in the range 70 (inclusive) to 99 (inclusive) then 1900 is added. This means that "00-01-01" is interpreted as "2000-0101".
Hinweis: The "Day, month and two digit year, with dots or tabs" format (dd [.\t] mm "." yy) only works for the year values 61 (inclusive) to 99 (inclusive) outside those years the time format "HH [.:] MM [.:] SS" has precedence.
Hinweis: The "Year (and just the year)" format only works if a time string has already been found -- otherwise this format is recognised as HH MM.
Hinweis: It is possible to over- and underflow the dd and DD format. Day 0 means the last day of previous month, whereas overflows count into the next month.
This makes "2008-08-00" equivalent to "2008-07-31" and "2008-06-31" equivalent to "2008-07-01" (June only has 30 days).
It is also possible to underflow the mm and MM formats with the value 0. A month value of 0 means December of the previous year. As example "2008-00-22" is
equivalent to "2007-12-22".
If you combine the previous two facts and underflow both the day and the month, the following happens: "2008-00-00" first gets converted to "2007-12-00"
which then gets converted to "2007-11-30". This also happens with the string "0000-00-00", which gets transformed into "-0001-11-30" (the year -1 in the ISO
8601 calendar, which is 2 BC in the proleptic Gregorian calendar).
Compound Formats
This page describes the different compound date/time formats that the strtotime(), DateTime and date_create() parser understands.
Used Symbols
Description
DD
doy
frac
hh
Formats
0 [0-9] | [1-2][0-9] | "3" [01]
00[1-9] | "0"[1-9][0-9] | [1-2][0-9][0-9] | "3"[0-5][0-9] | "36"[0-6]
. [0-9]+
0?[1-9] | "1"[0-2]
Examples
02, "12", "31"
36[0-6] "000", "012", "366"
.21342, ".85"
04, "7", "12"
HH
meridian
ii
II
M
MM
space
ss
SS
W
tzcorrection
YY
[01][0-9] | "2"[0-4]
[AaPp] .? [Mm] .? [\0\t ]
[0-5][0-9]
[0-5][0-9]
'jan' | 'feb' | 'mar' | 'apr' | 'may' | 'jun' | 'jul' | 'aug' | 'sep' | 'sept' | 'oct' | 'nov' | 'dec'
[0-5][0-9]
[ \t]
[0-5][0-9]
[0-5][0-9]
0[1-9] | [1-4][0-9] | "5"[0-3]
GMT? [+-] hh ":"? MM?
[0-9]{4}
04, "7", "19"
A.m., "pM", "am."
04, "8", "59"
04, "08", "59"
00, "12", "59"
04, "8", "59"
04, "08", "59"
05, "17", "53"
+0400, "GMT-07:00", "-07:00"
2000, "2008", "1978"
Localized Notations
Description
Common Log Format
EXIF
ISO year with ISO week
ISO year with ISO week and day
MySQL
PostgreSQL: Year with day-of-year
SOAP
Unix Timestamp
XMLRPC
XMLRPC (Compact)
WDDX
Format
dd "/" M "/" YY : HH ":" II ":" SS space tzcorrection
YY ":" MM ":" DD " " HH ":" II ":" SS
YY "-"? "W" W
YY "-"? "W" W "-"? [0-7]
YY "-" MM "-" DD " " HH ":" II ":" SS
YY "."? doy
Examples
10/Oct/2000:13:55:36 -0700
2008:08:07 18:11:31
2008W27, "2008-W28"
2008W273, "2008-W28-3"
07.08.2008 18:11
2008.197, "2008197"
2008-07-01T22:35:17.02, "2008-07YY "-" MM "-" DD "T" HH ":" II ":" SS frac tzcorrection? 01T22:35:17.03+08:00"
@ "-"? [0-9]+
@1215282385
YY MM DD "T" hh ":" II ":" SS
20080701T22:38:07, "20080701T9:38:07"
YY MM DD 't' hh II SS
20080701t223807, "20080701T093807"
YY "-" mm "-" dd "T" hh ":" ii ":" ss
2008-7-1T9:3:37
Hinweis: The "W" in the "ISO year with ISO week" and "ISO year with ISO week and day" formats is case-sensitive, you can only use the upper case "W".
The "T" in the SOAP, XMRPC and WDDX formats is case-sensitive, you can only use the upper case "T".
The "Unix Timestamp" format sets the timezone to UTC.
Relative Formats
This page describes the different relative date/time formats that the strtotime(), DateTime and date_create() parser understands.
Used Symbols
dayname 'sunday' | 'monday' | 'tuesday' | 'wednesday' | 'thursday' | 'friday' | 'saturday' | 'sun' | 'mon' | 'tue' | 'wed' | 'thu' | 'fri' | 'sat' | 'sun'
daytext
'weekday' | 'weekdays'
number
[+-]?[0-9]+
ordinal
'first' | 'second' | 'third' | 'fourth' | 'fifth' | 'sixth' | 'seventh' | 'eighth' | 'ninth' | 'tenth' | 'eleventh' | 'twelfth' | 'next' | 'last' | 'previous' | 'this'
reltext
'next' | 'last' | 'previous' | 'this'
space
[ \t]+
unit
(('sec' | 'second' | 'min' | 'minute' | 'hour' | 'day' | 'fortnight' | 'forthnight' | 'month' | 'year') 's'?) | 'weeks' | daytext
Day-based Notations
Format
'yesterday'
'midnight'
'today'
'now'
'noon'
'tomorrow'
'back of' hour
'front of' hour
'first day' ' of'?
'last day' ' of'?
Description
Midnight of yesterday
The time is set to 00:00:00
Now - this is simply ignored
Midnight of tomorrow
15 minutes past the specified hour
15 minutes before the specified hour
Sets the day of the first of the current month. This phrase is best used together with a month name following it.
Sets the day to the last day of the current month. This phrase is best used together with a month name following it.
Examples
yesterday 14:00
yesterday noon
back of 7pm, "bac
front of 5am, "fro
first day of Januar
last day of next m
ordinal space dayname space 'of'
'last' space dayname space 'of'
number space? (unit | 'week')
ordinal space unit
'ago'
dayname
reltext space 'week'
Calculates the x-th week day of the current month.
Calculates the last week day of the current month.
Handles relative time items where the value is a number.
Handles relative time items where the value is text.
Negates all the values of previously found relative time items.
Moves to the next day of this name.
Handles the special format "weekday + last/this/next week".
first sat of July 200
last sat of July 200
+5 weeks, "12 day
fifth day, "second
2 days ago, "8 day
Monday
Monday next wee
Hinweis: Relative statements are always processed after non-relative statements. This makes "+1 week july 2008" and "july 2008 +1 week" equivalent.
Exceptions to this rule are: "yesterday", "midnight", "today", "noon" and "tomorrow". Note that "tomorrow 11:00" and "11:00 tomorrow" are different.
Considering today's date of "July 23rd, 2008" the first one produces "2008-07-24 11:00" where as the second one produces "2008-07-24 00:00". The reason for
this is that those five statements directly influence the current time.
Hinweis: Observe the following remarks when the current day-of-week is the same as the day-of-week used in the date/time string. The current day-of-week
could have been (re-)calculated by non-relative parts of the date/time string however.
"dayname" does not advance to another day. (Example: "Wed July 23rd, 2008" means "2008-07-23").
"number dayname" does not advance to another day. (Example: "1 wednesday july 23rd, 2008" means "2008-07-23").
"number week dayname" will first add the number of weeks, but does not advance to another day. In this case "number week" and "dayname" are two distinct
blocks. (Example: "+1 week wednesday july 23rd, 2008" means "2008-07-30").
"ordinal dayname" does advance to another day. (Example "first wednesday july 23rd, 2008" means "2008-07-30").
"number week ordinal dayname" will first add the number of weeks, and then advances to another day. In this case "number week" and "ordinal dayname" are
two distinct blocks. (Example: "+1 week first wednesday july 23rd, 2008" means "2008-08-06").
"ordinal dayname 'of' " does not advance to another day. (Example: "first wednesday of july 23rd, 2008" means "2008-07-02" because the specific phrase with
'of' resets the day-of-month to '1' and the '23rd' is ignored here).
Also observe that the "of" in "ordinal space dayname space 'of' " and "'last' space dayname space 'of' " does something special.
It sets the day-of-month to 1.
"ordinal dayname 'of' " does not advance to another day. (Example: "first tuesday of july 2008" means "2008-07-01").
"ordinal dayname " does advance to another day. (Example: "first tuesday july 2008" means "2008-07-08", see also point 4 in the list above).
"'last' dayname 'of' " takes the last dayname of the current month. (Example: "last wed of july 2008" means "2008-07-30")
"'last' dayname" takes the last dayname from the current day. (Example: "last wed july 2008" means "2008-06-25"; "july 2008" first sets the current date to
"2008-07-01" and then "last wed" moves to the previous Wednesday which is "2008-06-25").
Hinweis: Relative month values are calculated based on the length of months that they pass through. An example would be "+2 month 2011-11-30", which
would produce "2012-01-30". This is due to November being 30 days in length, and December being 31 days in length, producing a total of 61 days.
Liste unterstützter Zeitzonen (siehe: http://ch2.php.net/manual/de/book.datetime.php )
Afrika
Amerika
Antarktis
Arktis
Asien
Atlantisch
Australien
Europa
Indisch
Pazifisch
Andere
Dateisystemrelevante Erweiterungen
Unterstützung menschlicher Sprache und Zeichenkodierung
Bildverarbeitung und –generierung
E-Mail-relevante Erweiterungen
Mathematische Erweiterungen
Non-Text MIME-Ausgaben
Erweiterungen zur Prozesskontrolle
Sonstige Grunderweiterungen
Sonstige Dienste
Suchmaschinenerweiterungen
Serverspezifische Erweiterungen
Session-Erweiterungen
Textverarbeitung
Variablen- und typbezogene Erweiterungen
Web Services
Windowsbasierte Erweiterungen
XML-Manipulation

Das Verhalten von PHP beeinflussen

Transcrição

Documentos relacionados

Session: Workforce Scheduling Set Covering

English - Giuliano Bortolassi

college of education up integrated school

Dreadnaught Server

Rikhi Ram`s Discussion Forum - Rikhi Ram`s Online Music Store

Rfr gjcnfdbnm vepsre yf pdfyjr yjrbz k vbz710

ACM International Collegiate Programming Contest 2015

Variable Semantics Possible Values Source Table (descriptor

Remote Educational Experiment Applied To the Discipline of

Upgrade - TYPO3-Demo