Overview

Classes

  • Ws_logged_inModel
  • Ws_permissionsModel
  • Ws_role_permModel
  • Ws_rolesModel
  • Ws_user_roleModel
  • Ws_userModel
  • WsAuth
  • WsauthController
  • WsChart
  • WsConfig
  • WsController
  • WsDatabase
  • WsForm
  • WsImage
  • WsLocalize
  • WsModel
  • WsModelForm
  • WsModelGridView
  • WsUrl

Functions

  • __autoload
  • callHook
  • WsErrorHandler
  • Overview
  • Class

Class WsDatabase

WsDatabase Is base class for working with database objects in Webiness framework. It handles connection to database server and exeecution of SQL commands.

Example usage:

$db = new WsDatabase()

// query database
$res = $db->query('SELECT name FROM mytable WHERE id<=:id', array(
     ':id' => 3
));
// number of results
$number_of_results = $db->nRows;

// update record in database
$db->execute('UPDATE mytable SET name=:name WHERE id=:id',
    array(':name' => 'new', ':id' => 3));

Direct known subclasses

WsModel

Indirect known subclasses

Ws_logged_inModel, Ws_permissionsModel, Ws_role_permModel, Ws_rolesModel, Ws_user_roleModel, Ws_userModel
Located at WsDatabase.class.php
Methods summary
public
# __construct( )
public
# __destruct( )
public array
# query( string $sql, array $parameters = array() )

Prepare and execute custom SQL query that return results (SELECT).

Prepare and execute custom SQL query that return results (SELECT).

Parameters

$sql
Custom SQL query
$parameters
List of parameters forwarded to $query

Returns

array
$results Results of SQL query
public
# execute( string $sql, array $parameters = array() )

Prepare and execute custom SQL query that don't return results (INSERT, UPDATE, DELETE).

Prepare and execute custom SQL query that don't return results (INSERT, UPDATE, DELETE).

Parameters

$sql
Custom SQL query
$parameters
List of parameters forwarded to $query
public
# execute_batch( string $sql )

Execute multiple custom SQL commands without parameters

Execute multiple custom SQL commands without parameters

Parameters

$sql
Custom SQL query
public
# close( )

Closes connection to database server.

Closes connection to database server.

Properties summary
public integer $nRows

$nRows Number of affected or returned rows

$nRows Number of affected or returned rows

See

WsDatabase::query()
WsDatabase::execute()
#
public boolean $isConnected

$isConnected Is database connection live

$isConnected Is database connection live

# false
API documentation generated by ApiGen