Overview
  • Class

Classes

  • DSNHelper
  • GxDBConnect

Exceptions

  • GxDBException

Class DSNHelper

Copyright: 2012, 2016 Leandro Silva (http://grafluxe.com)
License: MIT
Author: Leandro Silva
Classdesc:

Data Source Name (DSN) helper. This class is filled with static methods that return DSN strings. Use it to simplify the database connection process. Note that the 'db' method parameters can be set to an empty string if you plan to assign the database later.


Located at DSNHelper.class.php

Methods summary

public static string
# cubrid( string $db, string $host = "localhost", string $port = "" )

DSN for CUBRID.

DSN for CUBRID.

Parameters

$db
$host
$host="localhost"
$port
$port=""

Returns

string
public static string
# sybase( string $db, string $host = "localhost", string $charset = "", string $appname = "" )

DSN for Microsoft SQL Server and Sybase.

DSN for Microsoft SQL Server and Sybase.

Parameters

$db
$host
$host="localhost"
$charset
$charset=""
$appname
$appname=""

Returns

string
public static string
# firebird( string $db, string $charset = "", string $role = "" )

DSN for Firebird.

DSN for Firebird.

Parameters

$db
$charset
$charset=""
$role
$role=""

Returns

string
public static string
# ibm_ini( string $ini )

DSN for IBM via config file.

DSN for IBM via config file.

Parameters

$ini

Returns

string
public static string
# ibm( String $db, String $host = "localhost", String $port = "", String $usr = "", String $pwd = "" )

DSN for IBM.

DSN for IBM.

Parameters

$db
$host
$host="localhost"
$port
$port=""
$usr
$usr=""
$pwd
$pwd=""

Returns

string
public static string
# informix_ini( string $ini )

DSN for Informix via config file.

DSN for Informix via config file.

Parameters

$ini

Returns

string
public static string
# informix( string $db, string $server, string $app, boolean $connection_pooling, boolean $encrypt, string $failover_partner, integer $login_timeout, string $multiple_active_result_sets, boolean $quoted_id, string $trace_file, boolean $trace_on, string $transaction_isolation, boolean $trust_server_certificate, string $wsid )

DSN for Informix.

DSN for Informix.

Parameters

$db
$server
$app
$connection_pooling
$encrypt
$failover_partner
$login_timeout
$multiple_active_result_sets
$quoted_id
$trace_file
$trace_on
$transaction_isolation
$trust_server_certificate
$wsid

Returns

string
public static string
# mysql( string $db, string $host = "localhost", string $port = "", string $charset = "" )

DSN for MySQL (versions 3-5).

DSN for MySQL (versions 3-5).

Parameters

$db
$host
$host="localhost"
$port
$port=""
$charset
$charset=""

Returns

string
public static string
# mysql_socket( string $db, string $unix_socket, string $charset = "" )

DSN for MySQL Unix Socket (versions 3-5).

DSN for MySQL Unix Socket (versions 3-5).

Parameters

$db
$unix_socket
$charset
$charset=""

Returns

string
public static string
# oci( string $db )

DSN for OCI.

DSN for OCI.

Parameters

$db

Returns

string
public static string
# odbc( string $db )

DSN for ODBC and DB2.

DSN for ODBC and DB2.

Parameters

$db

Returns

string
public static string
# odbc_full( string $db, string $host = "localhost", string $port = "", string $protocol = "", string $usr = "", string $pwd = "" )

DSN for ODBC and DB2 with full syntax.

DSN for ODBC and DB2 with full syntax.

Parameters

$db
$host
$host="localhost"
$port
$port=""
$protocol
$protocol=""
$usr
$usr=""
$pwd
$pwd=""

Returns

string
public static string
# odbc_msaccess( string $mdb, string $usr )

DSN for ODBC MS Access.

DSN for ODBC MS Access.

Parameters

$mdb
$usr

Returns

string
public static string
# pgsql( string $db, string $host = "localhost", string $port = "", string $usr = "", string $pwd = "" )

DSN for PostgreSQL.

DSN for PostgreSQL.

Parameters

$db
$host
$host="localhost"
$port
$port=""
$usr
$usr=""
$pwd
$pwd=""

Returns

string
public static string
# sqlite( string $db )

DSN for sqlite.

DSN for sqlite.

Parameters

$db

Returns

string
public static string
# sqlite_in_memory( )

DSN for sqlite in memory.

DSN for sqlite in memory.

Returns

string
public static string
# sqlite2( string $db )

DSN for sqlite2.

DSN for sqlite2.

Parameters

$db

Returns

string
public static string
# sqlite2_in_memory( )

DSN for sqlite2 in memory.

DSN for sqlite2 in memory.

Returns

string
API documentation generated by ApiGen