File: Toolbox.php

Source Location: /DBA_Relational-0.2.0/Toolbox.php

Classes:

Page Details:

Filesource: Source Code for this file

Includes:

require_once('PEAR.php') [line 23]

dbaToQuickform [line 34]

void dbaToQuickform(
 &$form,  $schema,  $auxMeta)

Insert widgets into a quickform object suitable for updating a row in a DBA table.

Author: Brent Cook <busterb@mail.utexas.edu>
Version: 0.19
Access: public

Parameters

	&$form
	$schema
	$auxMeta

[ Top ]

formatHtmlTable [line 196]

string formatHtmlTable(
array $rows, [array $fields = null])

Generates an HTML table from a results set

This function uses custom CSS classes to define the table style. A recommended CSS is as follows:

.dbatable { border: solid; border-color: gray; border-collapse: collapse; } .dbatablefield { font-weight: bold; text-align: center; color: black; background-color: #CCCCFF; border: solid; border-color: gray; border-width: thin; } .dbatablerow0 { font-weight: normal; color: black; background-color: #FFFFFF; border: solid; border-color: gray; border-width: thin; } .dbatablerow1 { font-weight: normal; color: black; background-color: #F4F4F4; border: solid; border-color: gray; border-width: thin; }

Return: HTML-formatted results set

Parameters

array	$rows
array	$fields	list of fields to display

[ Top ]

formatTextTable [line 104]

string formatTextTable(
array $rows, [array $fields = null], [string $style = 'oracle'])

Generates a text table from a results set, a-la MySQL

Return: text-formatted results set

Parameters

array	$rows
array	$fields	list of fields to display
string	$style	style to display table in; 'oracle', 'mysql'

[ Top ]

quickformToDBA [line 81]

array quickformToDBA(
 $schema,  $auxMeta)

Postprocess $_POST variables that were left by a form using addQuickformDBA

Return: DBA row suitable for inserting into a DBA table

Parameters

	$schema
	$auxMeta

[ Top ]