Publisher review:SQL helper functions - A set of functions sitting on top of the abstraction layer that makes it a little easier to do SQL stuff. A set of functions sitting on top of the abstraction layer that makes it a little easier to do SQL stuff.
You must set some global variables prior to including this library: $db_type which database abstraction layer to use. If your layer is defined in "db-odbc.phl", set this variable to "odbc". $db_dsn Which database to connect to (dsn=data source name) $db_user Which user to connect as $db_pass Password used when connecting Some optional global variables can be set: $sql_debug true/false, toggles debug information $sql_log_facility how to log debug information $sql_log_dest debug information destination $sql_log_facility and $sql_log_dest are passed as the second and third args to PHP's error_log() function, respectively. The default is debugging through the PHP TCP debugger to port 1400 on localhost. Debug information is also disabled by default. The following global variables will be defined: $db_connection The opened connection. USAGE: All you have to do is require("sql.phl"), either explicitly in the pages where you want to use it, or through auto_prepend_file somehow. Being a lazy programmer, I always include everything I need with auto-prepend from a file I call "config.phl" looking something like this: $db_type = "odbc"; $db_user = "myuser"; $db_pass = "mypassword"; $db_dsn = "SVT=Solid; DSN=MyDB" require("sql.phl"); ?> Once you have included this file, a database connection will be opened for you once it is needed, and this connection will be used for all queries. Memory is freed automatically for all functions except sql().
SQL helper functions is a PHP script for Snippets scripts design by Stig S. Bakken.
It runs on following operating system: Windows / Linux / BSD / Solaris.
Operating system:Windows / Linux / BSD / Solaris
SQL helper functions script details 
