Xataface Wiki | Wiki

column:legend

Field	Value
Page name	column:legend
Page id	182
Language	en

advmultiselect

Field	Value
Page name	advmultiselect
Page id	183
Language	en

setSecurityFilters

Field	Value
Page name	setSecurityFilters
Page id	91
Page title	setSecurityFilter() method
Content	Example In the delegate class for the users table: `<?php class tables_users { function init(&$table){ if ( !isAdmin() ){ $table->setSecurityFilter(array('group_id'=>10)); } } }` Thi
Language	en

init

Field	Value
Page name	init
Page id	140
Page title	init() Delegate Class Method
Content	Synopsis This method is called once, just after the table is loaded for the first time. It allows you to specify initialization details, such as security filters. Note that it takes a single parameter: a Dataface_Table o
Language	en

http://xataface.com/documentation/how-to/site_with_backoffice_How_to_build_a_site_with_a_backoffice_

Field	Value
Page name	http://xataface.com/documentation/how-to/site_with_backoffice_How_to_build_a_site_with_a_backoffice_
Page id	84
Page title	A site with a backoffice
Content	A site with a backoffice To create a site with a backoffice for the administrator, so that the visitors do not have to log in to read the pages, you add this code in the ApplicationDelegate.php file in the conf directory : <code> function getPerm
Language	en

Cached_permissions

Field	Value
Page name	Cached_permissions
Page id	179
Page title	Cached Permissions
Content	Cached Permissions Introduction When you insert a SQL query in your getPermissions function, this will slow down the app dramatically because this function is called by each query. To resolve this problem, it is better to use cached permissi
Keywords	permissions, cache, quick, query
Language	en

Clean_the_html_for_the_export

Field	Value
Page name	Clean_the_html_for_the_export
Page id	178
Page title	Clean the HTML to export data
Content	Clean HTML tags and entities to export your data Override the display() of the field to strip the tags... but this would affect all parts of the application where the HTML fields are displayed. Create a grafted field, then override its display to
Language	en

Creating_Printable_Reports

Field

Value

Page name

Creating_Printable_Reports

Page id

Page title

Creating a Custom Printable Report

Content

Creating a Printable Report

Table of Contents

Creating a Printable Report

It is often useful to provide your users with a printable report that is generated from your database. Although Xataface doesn't include an explicit reporting module to allow the end users to create their own

Language

GettingStarted:first_application

Field	Value
Page name	GettingStarted:first_application
Page id	74
Page title	Creating your First Application
Content	Creating Your First Application Build a simple Xataface application. For our first Xataface application we will try to build a web site for Faculty of Widgetry (From the example in the "Why Use Xataface" page). The web site needs to store inform
Keywords	htaccess first application installation
Language	en

GettingStarted:customizing

Field	Value
Page name	GettingStarted:customizing
Page id	76
Page title	Customizing Field labels, descriptions, and widgets
Content	Customizing Field labels, descriptions, and widgets Using simple INI configuration files, you can customize the look and feel of your application. You can change widgets, labels, field descriptions, and more. In the previous 2 sections we learned
Keywords	widget labels descriptions onclick handlers
Language	en

GettingStarted:delegate_classes

Field	Value
Page name	GettingStarted:delegate_classes
Page id	80
Page title	Delegate Classes
Content	Delegate Classes Use Delegate classes to add permissions, custom serialization, display filters, calculated fields, import/export functionality, and other custom functionality to your application. For many applications, the configuration files p
Keywords	delegate classes,getTitle,getPermissions
Language	en

file

Field	Value
Page name	file
Page id	89
Content	Dynamic select boxes To create two select boxes whose one is dependent (slave) of the other (master), we need to use some javascript with Jason. Create the valuelists.ini: <code> valuelist for the slave [slaves_list] __sql__ = "select sla
Language	en

Dynamic_select_boxes

Field	Value
Page name	Dynamic_select_boxes
Page id	90
Content	Dynamic select boxes To create two select boxes whose one is dependent (slave) of the other (master), we need to use some javascript with Jason. Create the valuelists.ini: <code> valuelist for the slave [slaves_list] __sql__ = "select sla
Language	en

GettingStarted:validation

Field	Value
Page name	GettingStarted:validation
Page id	79
Page title	Form Validation
Content	Form Validation Xataface allows you to add validation rules to fields using the fields.ini file A common requirement for forms is to have some validation rules. Here are some example validation rules: The Username field is required. The Us
Keywords	form validation,required field,validation rules
Language	en

Grafted_fields

Field	Value
Page name	Grafted_fields
Page id	158
Page title	Grafted fields
Content	Grafted Fields Introduction When there are numerous tables, it is difficult for the user to see get an information that will help one to enter the right data in the right field. So instead of navigating in the relative tables and lose some t
Keywords	grafted fields, grafted, sorting columns, sort, relative records, relative tables
Language	en

http://xataface.com/documentation/how-to/site_with_backoffice

Field	Value
Page name	http://xataface.com/documentation/how-to/site_with_backoffice
Page id	85
Page title	How to build a site with an optional login form
Content
Language	en

site_with_backoffice

Field	Value
Page name	site_with_backoffice
Page id	86
Content
Language	en

GettingStarted:Installation

Field	Value
Page name	GettingStarted:Installation
Page id	73
Page title	Installation
Content	Installation Download and installation instructions for the Web Lite framework. Xataface is a 100% PHP Framework that comes with all dependencies as part of the installation. The framework itself lives inside a single directory that should be plac
Keywords	installation troubleshooting downloading
Language	en

GettingStarted:relationships

Field	Value
Page name	GettingStarted:relationships
Page id	78
Page title	Relationships
Content	Relationships Xataface allows you to define relationships between tables using the relationships.ini file. Xataface applications without relationships between tables can be quite boring. In our FacultyOfWidgetry application, we have implicitly d
Keywords	relationships
Language	en

GettingStarted:triggers

Field	Value
Page name	GettingStarted:triggers
Page id	81
Page title	Triggers
Content	Triggers Triggers are methods that can be defined to carry out custom behaviors when certain events occur in the application (e.g., when records are saved, inserted, or deleted). Triggers are generally regarded as one of the more advanced featur
Keywords	triggers, beforeSave, afterSave, beforeInsert, afterInsert,sending email
Language	en

GettingStarted:valuelists

Field	Value
Page name	GettingStarted:valuelists
Page id	77
Page title	Using Valuelists
Content	Using Value-lists Value-lists serve as vocabularies that can be used for fields such as select lists, checkbox groups, and auto-complete fields. So far we have not used any enumerated fields such as select lists, checkbox groups, or auto-complet
Keywords	valuelists, __sql__, select lists, checkbox options,checkbox groups,vocabularies
Language	en

GettingStarted:using_first_app

Field	Value
Page name	GettingStarted:using_first_app
Page id	75
Page title	Using Your First Application
Content	Using Your First Application A Web Lite application, at its core, provides 4 standard operations: Add new records, edit existing records, delete records, and find records. This section gives a brief overview of how to use your first Dataface applic
Keywords	"find form","edit form","delete record","user interface",ui,template,look and feel
Language	en

GettingStarted:Why_Use_Xataface

Field	Value
Page name	GettingStarted:Why_Use_Xataface
Page id	72
Page title	Why Use Xataface
Content	Why Use Xataface? Some simple examples similar to those that are frequently encountered by web developers, and how dataface can be used to acheive a solution. As a web services developer in the Faculty of Applied Sciences at Simon Fraser Universit
Keywords	introduction motivation why
Language	en

Using_RecordGrid

Field

Value

Page name

Using_RecordGrid

Page id

115

Page title

Using RecordGrid

Content

Xataface RecordGrid Class and Template

Also see RecordGrid in the API Doc.

Table of Contents

Xataface RecordGrid Class and Template

Introduction

As we learned in '''[http://xat

Keywords

RecordGrid, Dataface_RecordGrid, data in tabular form

Language

Introduction_to_the_Xataface_API

Field

Value

Page name

Introduction_to_the_Xataface_API

Page id

101

Page title

Introduction to the Xataface API

Content

Back to the wiki

Table of Contents

Synopsis

Xataface is provides an API to help in developing your own custom actions. This API includes objects and functions to more easily interact with the database (i.e. search, edit, d

Keywords

xataface api, df_get_record, df_get_records_array, Dataface_Record, Editing, Saving, Loading, Searching

Language

beforeSave

Field

Value

Page name

beforeSave

Page id

109

Page title

beforeSave Trigger

Content

Back to Delegate class methods

Table of Contents

Synopsis

The beforeSave trigger can be implemented in any table's Delegate Class Methods? to perform functionality that should be run *before* a record of that table is saved.

Keywords

triggers, beforeSave,

Language

calendar

Field

Value

Page name

calendar

Page id

100

Page title

Calendar Widget

Content

Back to widget:type

Table of Contents

Synopsis

The calendar widget is the default widget for editing date and datetime fields. It is javascript pop-up calendar that allows users to select date and time visually. It can be configured to allow di

Keywords

calendar widget, fields.ini file, widget:type

Language

test_page_34

Field	Value
Page name	test_page_34
Page id	177
Page title	Hello World
Content	Hello world
Language	en

viewable_editable_fields

Field	Value
Page name	viewable_editable_fields
Page id	180
Page title	How to make a field editable for some users and only viewable for some other users
Content	If we want only some users to edit a field and some other users only to view that field, then we need to define a fieldX__permissions() method for that field which gives desired permissions for specific users. One solution is as below. ==permi
Language	en

before_authenticate

Field	Value
Page name	before_authenticate
Page id	102
Page title	before_authenticate hook
Content	Return to Application Delegate Class The before_authenticate hook is a method that can be defined in the Application Delegate Class which is called before the authentication step occurs on every request (not just on login). It is m
Keywords	authentication
Language	en

Xataface Wiki | Wiki

column:legend

advmultiselect

setSecurityFilters

Example

init

Synopsis

http://xataface.com/documentation/how-to/site_with_backoffice_How_to_build_a_site_with_a_backoffice_

A site with a backoffice

Cached_permissions

Cached Permissions

Introduction

Clean_the_html_for_the_export

Clean HTML tags and entities to export your data

Creating_Printable_Reports

Creating a Printable Report

GettingStarted:first_application

Creating Your First Application

GettingStarted:customizing

Customizing Field labels, descriptions, and widgets

GettingStarted:delegate_classes

Delegate Classes

file

Dynamic select boxes

Dynamic_select_boxes

Dynamic select boxes

GettingStarted:validation

Form Validation

Grafted_fields

Grafted Fields

Introduction

http://xataface.com/documentation/how-to/site_with_backoffice

site_with_backoffice

GettingStarted:Installation

Installation

GettingStarted:relationships

Relationships

GettingStarted:triggers

Triggers

GettingStarted:valuelists

Using Value-lists

GettingStarted:using_first_app

Using Your First Application

GettingStarted:Why_Use_Xataface

Why Use Xataface?

Using_RecordGrid

Xataface RecordGrid Class and Template

Introduction

Introduction_to_the_Xataface_API

Synopsis

beforeSave

Synopsis

calendar

Synopsis

test_page_34

viewable_editable_fields

before_authenticate