Child classes:
- VMssqlTable
- Virtual Web Platform - MsSQL Table
Inherited Methods
Class: VDatabase
- VDatabase::__construct()
- Class constructor
- VDatabase::connect()
- Connect to database
- VDatabase::createQuery()
- Create Query
- VDatabase::disconnect()
- Disconnect from database
- VDatabase::drop()
- Drop database
- VDatabase::getDBType()
- Get database type
- VDatabase::getRow()
- Get a row from a table
- VDatabase::getTable()
- Get database table
- VDatabase::loadTables()
- Load tables
- VDatabase::setQuery()
- Set database query string
- VDatabase::unloadTables()
- UnLoad tables
Class: VDBI
- VDBI::__construct()
- Class constructor
- VDBI::createTable()
- Create Table
- VDBI::getDatabase()
- Get a database object
- VDBI::getDefaultDatabaseName()
- Get default database name
- VDBI::getInstance()
- Get instance of DBI object
- VDBI::getRow()
- Get a row from a table
- VDBI::getTable()
- Get database table
- VDBI::isError()
- Test if a value is an error
- VDBI::isWarning()
- Test if a value is a warning
- VDBI::listDatabases()
- List databases
- VDBI::listDBTypes()
- Get list of supported database types
- VDBI::listTables()
- List database tables
- VDBI::loadDatabases()
- Load databases
- VDBI::lock()
- Lock a section of code
- VDBI::nameQuote()
- Quote a database identifier
- VDBI::quote()
- Quote a database value
- VDBI::raiseError()
- Generate an error
- VDBI::raiseWarning()
- Generate a warning
- VDBI::unlock()
- UnLock a section of code
Class: VObject
- VObject::__construct()
- Class Constructor
- VObject::bind()
- Bind values to this object
- VObject::delete()
- Delete Object
- VObject::get()
- Get value
- VObject::getAll()
- Get all object values
- VObject::getError()
- Get error message
- VObject::getErrors()
- Get errors
- VObject::getMethods()
- Get object methods
- VObject::getProperties()
- Get object properties
- VObject::save()
- Save Object
- VObject::set()
- Set a value
- VObject::setError()
- Set error value
- VObject::setProperties()
- Set property values
- VObject::setProperty()
- Set property value
- VObject::toString()
- Convert object to string
- VObject::__destruct()
- Class Destructor
- VObject::__toString()
- Return object as a string
Class Details
Virtual Web Platform - MsSQL Database support
This class provides the driver for MsSQL Database Access.
Tags:
- author - Ralph Ritoch <rritoch@gmail.com>
- copyright - (c) Ralph Ritoch - All Rights Reserved
- link - VNetPublishing.Com
- license - VNETLPL Limited Public License
[ Top ]
Class Variables
$database = null
[line 70]
Tags:
- var - Database
- access - public
Type: string
Overrides:
[ Top ]
$password = null
[line 63]
Tags:
- var - Password
- access - public
Type: string
Overrides:
[ Top ]
$server = 'localhost'
[line 77]
Tags:
- var - Server
- access - public
Type: string
Overrides:
[ Top ]
$username = null
[line 56]
Tags:
- var - Username
- access - public
Type: string
Overrides:
[ Top ]
$_cerrmsg = null
[line 91]
Tags:
- var - Error message
- access - public
Type: string
Overrides:
[ Top ]
$_result = null
[line 84]
Tags:
- var - Request result
- access - public
Type: mixed
Overrides:
[ Top ]
Class Methods
__construct
VMssqlDatabase __construct(
)
[line 341]
Class constructor
Tags:
- access - public
Overridden in child classes as:
- VMssqlTable::__construct()
- Class constructor
Overrides VDatabase::__construct() (Class constructor)
Parameters:
[ Top ]
__destruct
void __destruct(
)
[line 321]
Class destructor
Tags:
- access - public
Overridden in child classes as:
- VMssqlTable::__destruct()
- Class destructor
Overrides VObject::__destruct() (Class Destructor)
Parameters:
[ Top ]
getRow
object Row &getRow(
mixed
$key, [string
$tableName = null], [string
$databaseName = null])
[line 305]
Get a row from a table
Tags:
- return - object on success, error or warning on failure
- access - public
Overridden in child classes as:
- VMssqlTable::getRow()
- Get a row from a table
Overrides VDatabase::getRow() (Get a row from a table)
Parameters:
- mixed $key - Row identifier (primary key value)
- string $tableName - Table name
- string $databaseName - Database name
[ Top ]
getTable
object Table &getTable(
string
$tableName, [string
$databaseName = null])
[line 269]
Get database table
Tags:
- return - object on success, error or warning on failure
Overrides VDatabase::getTable() (Get database table)
Parameters:
- string $tableName - Table Name
- string $databaseName - Database name
[ Top ]
listTables
array|object Table listTables(
[string
$databaseName = null])
[line 232]
List database tables
Tags:
- return - names on success, error or warning on failure
- access - public
Overrides VDBI::listTables() (List database tables)
Parameters:
- string $databaseName - Database name
[ Top ]
loadAssocList
array|object Response loadAssocList(
)
[line 132]
Get database response as associative list
Tags:
- return - data on success, error or warning on failure
- access - public
Parameters:
[ Top ]
loadResult
mixed loadResult(
)
[line 163]
Get database response as single data field
Tags:
- return - Response data on success, error or warning on failure
- access - public
Parameters:
[ Top ]
nameQuote
string nameQuote(
string
$name)
[line 101]
Quote a database identifier
Tags:
- return - Quoted string
- access - public
Overrides VDBI::nameQuote() (Quote a database identifier)
Parameters:
- string $name - Identifier
[ Top ]
query
true|object True query(
)
[line 191]
Send database query
Tags:
- return - on success, error or warning on failure
- access - public
Parameters:
[ Top ]
quote
string quote(
$val, string
$name)
[line 114]
Quote a database value
Tags:
- return - Quoted string
- access - public
Overrides VDBI::quote() (Quote a database value)
Parameters:
- string $name - Identifier
- $val -
[ Top ]