\JCORE\DATA\API\MySQLPOSTGRES_connector

class POSTGRES_connector

Summary

Methods
Properties
Constants
__construct()
getDbType()
set_connection()
is_persistent()
verify_connection()
resultToAssoc()
raw()
retrieve()
update()
create()
delete()
__destruct()
$connection
No constants found
No protected methods found
No protected properties found
N/A
No private methods found
$dbType
$DSN
$host
$username
$password
$database
$persistent
$force_new
N/A

Properties

$connection

$connection : string

stores the connection resource

Type

string

$dbType

$dbType : string

The data base "dbType" MYSQL-POSTGRES-.

..

Type

string

$DSN

$DSN : string

The Data Source Name

Type

string

$host

$host : string

The host name WITH PORT

Type

string

$username

$username : string

username

Type

string

$password

$password : string

password

Type

string

$database

$database : string

database

Type

string

$persistent

$persistent : boolean

persistent

Type

boolean

$force_new

$force_new : boolean

force_new

Type

boolean

Methods

__construct()

__construct(  $DSN,   $config) : NULL

Constructor

Parameters

$DSN
$config

Returns

NULL

getDbType()

getDbType() : string

DESCRIPTOR: Get the "private" dbType

Returns

string —

dbType

set_connection()

set_connection(  $persistent = NULL) : NULL

DESCRIPTOR: This sets a connection resource pass TRUE/FALSE OR 'true' from ini [config.dbConnectionPool.ini]

Parameters

$persistent

Returns

NULL

is_persistent()

is_persistent() : boolean

DESCRIPTOR: This checks if a connection resource is persistent

Returns

boolean

verify_connection()

verify_connection() : boolean

DESCRIPTOR: VERIFIES A CONNECTION

Returns

boolean

resultToAssoc()

resultToAssoc(  $result,   $query) : array

DESCRIPTOR: converts a POSTGRES result to an array

Parameters

$result
$query

Returns

array

raw()

raw(string  $query) : \JCORE\DATA\API\MySQL\result

DESCRIPTOR: EXECUTE A QUERY exception handling and logging dealt with

Parameters

string $query

Returns

\JCORE\DATA\API\MySQL\result

retrieve()

retrieve(  $query,   $args = false) : \JCORE\DATA\API\MySQL\result

DESCRIPTOR: EXECUTE A SELECT if args["returnArray"] === true the function will return the result as a PHP array

Parameters

$query
$args

Returns

\JCORE\DATA\API\MySQL\result

update()

update(  $query,   $args = false) : \JCORE\DATA\API\MySQL\result

DESCRIPTOR: EXECUTE AN UPDATE if args["returnArray"] === true the function will return the number of affected rows as well as the "pg_last_notice" from the query

Parameters

$query
$args

Returns

\JCORE\DATA\API\MySQL\result

create()

create(  $query,   $args = false) : \JCORE\DATA\API\MySQL\result

DESCRIPTOR: EXECUTE AN INSERT if $args["returnArray"] === true the function will return the "pg_last_oid" the number of "pg_affected_rows" as well as the "pg_last_notice " from the query

Parameters

$query
$args

Returns

\JCORE\DATA\API\MySQL\result

delete()

delete(  $query,   $args = false) : array

DESCRIPTOR: EXECUTE A DELETE if args["returnArray"] === true the function will return the number of affected rows as well as the "pg_last_notice " from the query

Parameters

$query
$args

Returns

array

__destruct()

__destruct() : null

DESCRIPTOR: __destruct

Returns

null