Inherited Methods
Class: VMysqlTable
- VMysqlTable::__construct()
- Class constructor
- VMysqlTable::createFilter()
- Create a filter
- VMysqlTable::getMatches()
- Get Matches
- VMysqlTable::getPaging()
- Get paging object
- VMysqlTable::getProperties()
- Get table properties
- VMysqlTable::getRow()
- Get a row from a table
- VMysqlTable::importXMLData()
- Import data from XML
- VMysqlTable::listColumns()
- List Columns
- VMysqlTable::loadColumns()
- Load table columns
- VMysqlTable::loadData()
- Load table data
- VMysqlTable::setPaging()
- set paging object
- VMysqlTable::setProperties()
- Set table properties
- VMysqlTable::__destruct()
- Class destructor
Class: VMysqlDatabase
- VMysqlDatabase::__construct()
- Class constructor
- VMysqlDatabase::createQuery()
- Create Query
- VMysqlDatabase::createTable()
- Create Table
- VMysqlDatabase::getRow()
- Get a row from a table
- VMysqlDatabase::getTable()
- Get database table
- VMysqlDatabase::listTables()
- List database tables
- VMysqlDatabase::loadAssocList()
- Get database response as associative list
- VMysqlDatabase::loadResult()
- Get database response as single data field
- VMysqlDatabase::nameQuote()
- Quote a database identifier
- VMysqlDatabase::query()
- Send database query
- VMysqlDatabase::quote()
- Quote a database value
- VMysqlDatabase::__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::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 - MySQL Table Row
This class provides the driver for MySQL Row 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
$fields
[line 45]
Tags:
- var - Fields
- access - public
Type: array
Overrides:
[ Top ]
$_new = true
[line 51]
Tags:
- access - public
Type: boolean
Overrides:
[ Top ]
Class Methods
delete
true|object True delete(
)
[line 245]
Delete row
Tags:
- return - on success, warning or error on failure
- access - public
Overrides VObject::delete() (Delete Object)
Parameters:
[ Top ]
get
mixed &get(
string
$field, [mixed
$default = null])
[line 82]
Get Field
Tags:
- return - field value
- access - public
Overrides VObject::get() (Get value)
Parameters:
- string $field - Field name
- mixed $default - Default value
[ Top ]
getAll
Object getAll(
[boolean
$public = true])
[line 99]
Get all fields
Tags:
- return - properties
- access - public
Overrides VObject::getAll() (Get all object values)
Parameters:
- boolean $public - Return public properties
[ Top ]
load
true|object True load(
[mixed
$oid = null])
[line 270]
Load a row
Note: Use null as the row identifier to create a new row
Tags:
- return - on success, warning or error on failure
Parameters:
- mixed $oid - Row Identifier (Primary key value)
[ Top ]
save
true|object Returns save(
)
[line 135]
Save row
Note: If the table does not have a primary key this function will fail with an error. If the rows primary key has a null value a new row will be inserted. The primary key must be an identity column or else the primary key may be filled in with a useless value.
Tags:
- return - true on success or an error on failure
- access - public
Overrides VObject::save() (Save Object)
Parameters:
[ Top ]
set
void set(
string
$field, [mixed
$value = null])
[line 61]
Set the value of a field
Tags:
- access - public
Overrides VObject::set() (Set a value)
Parameters:
- string $field - Field identifier
- mixed $value - Value
[ Top ]