Child classes:
- VMssqlRow
- Virtual Web Platform - MsSQL Table Row
Inherited Methods
Class: VMssqlDatabase
- VMssqlDatabase::__construct()
- Class constructor
- VMssqlDatabase::getRow()
- Get a row from a table
- VMssqlDatabase::getTable()
- Get database table
- VMssqlDatabase::listTables()
- List database tables
- VMssqlDatabase::loadAssocList()
- Get database response as associative list
- VMssqlDatabase::loadResult()
- Get database response as single data field
- VMssqlDatabase::nameQuote()
- Quote a database identifier
- VMssqlDatabase::query()
- Send database query
- VMssqlDatabase::quote()
- Quote a database value
- VMssqlDatabase::__destruct()
- Class destructor
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::createQuery()
- Create Query
- 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::__get()
- VObject::__isset()
- VObject::__set()
- VObject::__toString()
- Return object as a string
- VObject::__unset()
Class Details
Virtual Web Platform - MsSQL Table
This class provides the driver for MsSQL Table 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
$columns = null
[line 71]
Tags:
- var - Columns
- access - public
Type: array
Overrides:
[ Top ]
$paging = null
[line 57]
Tags:
- access - public
Type: object Paging
Overrides:
[ Top ]
$primary_key = null
[line 85]
Tags:
- var - Primary key column
- access - public
Type: string
Overrides:
[ Top ]
$rows = array()
[line 78]
Tags:
- var - Rows
- access - public
Type: array
Overrides:
[ Top ]
$tableName = null
[line 64]
Tags:
- access - public
Type: string
Overrides:
[ Top ]
Class Methods
__construct
VMssqlTable __construct(
[
$tableName = null])
[line 470]
Class constructor
Tags:
- access - public
Overrides VMssqlDatabase::__construct() (Class constructor)
Parameters:
- $tableName -
[ Top ]
__destruct
void __destruct(
)
[line 93]
Class destructor
Tags:
- access - public
Overrides VMssqlDatabase::__destruct() (Class destructor)
Parameters:
[ Top ]
createFilter
object Filter createFilter(
)
[line 104]
Create a filter
Tags:
- return - object
Parameters:
[ Top ]
getMatches
array|object Matched getMatches(
obect
$filter)
[line 117]
Get Matches
Tags:
- return - column identifiers on success, error or warning on failure
- access - public
Parameters:
- obect $filter - Filter
[ Top ]
getPaging
object Table &getPaging(
)
[line 224]
Get paging object
Tags:
- return - paging
- access - public
Parameters:
[ Top ]
getProperties
array getProperties(
[
$public = true])
[line 174]
Get table properties
Tags:
- return - Table properties
- access - public
Overrides VObject::getProperties() (Get object properties)
Parameters:
- $public -
[ Top ]
getRow
object Row &getRow(
mixed
$key, [string
$tableName = null], [string
$databaseName = null])
[line 411]
Get a row from a table
Tags:
- return - object on success, error or warning on failure
- access - public
Overrides VMssqlDatabase::getRow() (Get a row from a table)
Parameters:
- mixed $key - Row identifier (primary key value)
- string $tableName - Table name
- string $databaseName - Database name
[ Top ]
listColumns
array listColumns(
)
[line 452]
List Columns
Tags:
- return - Column list
Parameters:
[ Top ]
loadColumns
true|object True loadColumns(
)
[line 251]
Load table columns
Tags:
- return - on success, error or warning otherwise
- access - public
Parameters:
[ Top ]
loadData
true|object True loadData(
)
[line 331]
Load table data
Tags:
- return - on success, error or warning otherwise
- access - public
Parameters:
[ Top ]
setPaging
void setPaging(
object Table
&$paging)
[line 239]
set paging object
Tags:
- access - public
Parameters:
- object Table &$paging - paging
[ Top ]
setProperties
true setProperties(
array
$properties)
[line 205]
Set table properties
Tags:
- return - on success
- access - public
Overrides VObject::setProperties() (Set property values)
Parameters:
- array $properties - Properties
[ Top ]