LiveUser
[ class tree: LiveUser ] [ index: LiveUser ] [ all elements ]
Packages:
LiveUser_Admin
LiveUser


Classes:
LiveUser_Admin
LiveUser_Admin_Auth_Common
LiveUser_Admin_Auth_DB
LiveUser_Admin_Auth_MDB
LiveUser_Admin_Auth_MDB2
LiveUser_Admin_Perm_Complex
LiveUser_Admin_Perm_Medium
LiveUser_Admin_Perm_Simple
LiveUser_Admin_Perm_Storage_MDB2
LiveUser_Admin_Storage
LiveUser_Admin_Storage_MDB2
LiveUser_Admin_Storage_SQL
Files:
Admin.php
Common.php
Complex.php
DB.php
MDB.php
MDB2.php
MDB2.php
MDB2.php
Medium.php
Simple.php
SQL.php
Storage.php

Class: LiveUser_Admin_Storage_SQL

Source Location: /LiveUser_Admin-0.1.0/Storage/SQL.php

Class Overview

LiveUser_Admin_Storage
   |
   --LiveUser_Admin_Storage_SQL

This is a PEAR::MDB2 backend driver for the LiveUser class.


Author(s):

Version:

  • $Id: SQL.php,v 1.11 2004/12/18 21:55:53 lsmith Exp $

Variables

Methods

Child classes:

LiveUser_Admin_Storage_MDB2
This is a PEAR::MDB2 backend driver for the LiveUser class.

Inherited Variables

Inherited Methods

Class: LiveUser_Admin_Storage

LiveUser_Admin_Storage::LiveUser_Admin_Storage()
Constructor
LiveUser_Admin_Storage::disconnect()
properly disconnect from resources

Class Details

[line 50]
This is a PEAR::MDB2 backend driver for the LiveUser class.

A PEAR::MDB2 connection object can be passed to the constructor to reuse an existing connection. Alternatively, a DSN can be passed to open a new one.

Requirements:

  • File "Liveuser.php" (contains the parent class "LiveUser")
  • Array of connection options or a PEAR::MDB2 connection object must be passed to the constructor. Example: array('dsn' => 'mysql://user:pass@host/db_name') OR &$conn (PEAR::MDB2 connection object)



[ Top ]

Class Variables

$alias = array()

[line 80]


Type:   mixed


[ Top ]

$fields = array()

[line 78]


Type:   mixed


[ Top ]

$prefix =  'liveuser_'

[line 74]

Table prefix Prefix for all db tables the container has.
  • Access: public

Type:   string


[ Top ]

$tables = array()

[line 76]


Type:   mixed


[ Top ]


Method Detail

LiveUser_Admin_Storage_SQL (Constructor)   [line 89]

void LiveUser_Admin_Storage_SQL( mixed &$confArray, &$storageConf)

Constructor
  • Access: protected

Parameters:

mixed   &$confArray   —  configuration array
   &$storageConf   — 

[ Top ]

createInsert   [line 145]

void createInsert( $table, $fields, $values)


Parameters:

   $table   — 
   $fields   — 
   $values   — 

[ Top ]

createJoinFilter   [line 482]

void createJoinFilter( $root_table, $filters, $tables, $selectable_tables, [ $visited = array()])


Parameters:

   $root_table   — 
   $filters   — 
   $tables   — 
   $selectable_tables   — 
   $visited   — 

[ Top ]

createSelect   [line 322]

void createSelect( $fields, $filters, $orders, $root_table, $selectable_tables)


Parameters:

   $fields   — 
   $filters   — 
   $orders   — 
   $root_table   — 
   $selectable_tables   — 

[ Top ]

createUpdate   [line 208]

void createUpdate( $table, $fields, $filters)


Parameters:

   $table   — 
   $fields   — 
   $filters   — 

[ Top ]

createWhere   [line 366]

void createWhere( $filters, [ $joinfilters = array()])


Parameters:

   $filters   — 
   $joinfilters   — 

[ Top ]

delete   [line 216]

void delete( $table, $filters)


Parameters:

   $table   — 
   $filters   — 

[ Top ]

disconnect   [line 639]

void disconnect( )

properly disconnect from resources
  • Access: public

Overridden in child classes as:

LiveUser_Admin_Storage_MDB2::disconnect()

Overrides LiveUser_Admin_Storage::disconnect() (properly disconnect from resources)
[ Top ]

findTables   [line 416]

void findTables( &$fields, &$filters, &$orders, $selectable_tables)


Parameters:

   &$fields   — 
   &$filters   — 
   &$orders   — 
   $selectable_tables   — 

[ Top ]

insert   [line 94]

void insert( $table, $data)


Parameters:

   $table   — 
   $data   — 

[ Top ]

selectAll   [line 298]

void selectAll( $fields, $filters, $orders, $rekey, $limit, $offset, $root_table, $selectable_tables)


Parameters:

   $fields   — 
   $filters   — 
   $orders   — 
   $rekey   — 
   $limit   — 
   $offset   — 
   $root_table   — 
   $selectable_tables   — 

[ Top ]

selectCol   [line 274]

void selectCol( $table, $field, $filters)


Parameters:

   $table   — 
   $field   — 
   $filters   — 

[ Top ]

selectOne   [line 245]

void selectOne( $table, $field, $filters, [ $count = false])


Parameters:

   $table   — 
   $field   — 
   $filters   — 
   $count   — 

[ Top ]

update   [line 153]

void update( $table, $data, $filters)


Parameters:

   $table   — 
   $data   — 
   $filters   — 

[ Top ]
Documentation generated on Mon, 11 Mar 2019 14:00:09 -0400 by phpDocumentor 1.4.4. PEAR Logo Copyright © PHP Group 2004.