Xataface Wiki | Wiki

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

documentation_guide

Field	Value
Page name	documentation_guide
Page id	70
Page title	Documentation Guide
Content	Xataface uses a wiki to manage its online documentation which can be edited by anyone. All you have to do is login with your forum username and password ([http://xataface.com/forum/profile.php?mode=regis
Keywords	documentation wiki
Language	en

GettingStarted:Introduction

Field	Value
Page name	GettingStarted:Introduction
Page id	71
Page title	Introduction
Content	Web Lite is a simple framework for building data-driven web applications in PHP and MySQL. This section introduces some of the concepts and applications of Dataface. To fully understand what Xataface is, we must first define a few key terms: '''Fram
Keywords	introduction requirements getting started
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

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: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: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: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: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: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: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

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

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

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

Key

Field	Value
Page name	Key
Page id	83
Page title	fields.ini Directive: Key
Content	The Key directive is used only when the table is a view and you need to explicitly define which columns are part of the primary key. For example, if we created a view on the books table to only show books in a given year as follows: <code> create
Keywords	Key, Views, MySQL Views, Create View, PRI, Primary Keys
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

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

sql_delegate_method

Field	Value
Page name	sql_delegate_method
Page id	87
Page title	__sql__ Delegate Method
Content	return to Delegate class methods Synopsis The __sql__ delegate class method can be defined in any delegate class to specify the SQL query that should be used to fetch records for a given table. This method overrides the __sql__? direct
Keywords	__sql__, SQL queries, delegate class
Language	en

secure

Field	Value
Page name	secure
Page id	88
Page title	secure fields.ini directive
Content	fields.ini file directive used only with container fields?. If this flag is set, then the field contents will be treated in a secure manner and will obey the application permissions. If this directive is not set, then uploaded files in [[containe
Keywords	secure,fields.ini file
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

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

Authenticating_Against_the_PHPBB_Users_table

Field

Value

Page name

Authenticating_Against_the_PHPBB_Users_table

Page id

Page title

Authenticating Against the PHPBB Users Table

Content

Return to authentication

Table of Contents

Xataface is able to use the PHPBB users table to authenticate against so that, you can allow your users to log into your Xataface application using the same credentials as they use to access your PHPBB message fo

Keywords

PHPBB, authentication, security, authentication modules

Language

Authenticating_Against_the_Joomla!_Users_Table

Field	Value
Page name	Authenticating_Against_the_Joomla!_Users_Table
Page id	93
Content	Xataface is able to use the joomla users table to authenticate against so that, you can allow your users to log into your Xataface application using the same credentials as they use to access your joomla website. Achieving this level of integration requir
Keywords	joomla authentication md5
Language	en

fieldname__validate

Field

Value

Page name

fieldname__validate

Page id

Page title

fieldname__validate Delegate Class Method

Content

Return to Delegate class methods

Table of Contents

Synopsis

Xataface allows you to add validation on any particular field in table by adding a fieldname__validate method to the table's delegate class of the form: <code> function myfield__valida

Keywords

validate, validation, delegate class validation, custom validator

Language

validators

Field

Value

Page name

validators

Page id

Page title

validators:NAME fields.ini directive

Content

Return to fields.ini file

Table of Contents

Synopsis

In the fields.ini file you can specify validation rules to be applied to any field by adding the validators:NAME directive in that field's section of the fields.ini file.

===Available Va

Keywords

validation, form validation, validators,validator:name

Language

validators:VALIDATOR_NAME:message

Field

Value

Page name

validators:VALIDATOR_NAME:message

Page id

Page title

validators:VALIDATOR_NAME:message directive for the fields.ini file

Content

Return to fields.ini file

Table of Contents

Synopsis

If you want to customize the error message associated with a particular validation rule? you can use the validators:VALIDATOR_NAME:message directive in the fields.ini file.

===F

Keywords

validation messages,error messages,form validation rules

Language

_auth

Field

Value

Page name

_auth

Page id

Page title

_auth section of the conf.ini file

Content

Return to conf.ini file

Table of Contents

Synopsis

The _auth section of the conf.ini file includes configuration directives to enable authentication in a Xataface application. For more information about authentication and regis

Keywords

_auth,authentication,conf.ini file,allow_register

Language

registration_form

Field

Value

Page name

registration_form

Page id

Page title

Setting up User Registration

Content

Table of Contents

Synopsis

Xataface optionally enables you to allow users to register for an account in your application. If your users table includes a column for email, it will also perform email validation before the account is activated. Befor

Keywords

registration form, _auth, authentication

Language

Xataface Wiki | Wiki

calendar

Synopsis

documentation_guide

GettingStarted:Introduction

GettingStarted:Why_Use_Xataface

Why Use Xataface?

GettingStarted:Installation

Installation

GettingStarted:first_application

Creating Your First Application

GettingStarted:using_first_app

Using Your First Application

GettingStarted:customizing

Customizing Field labels, descriptions, and widgets

GettingStarted:valuelists

Using Value-lists

GettingStarted:relationships

Relationships

GettingStarted:validation

Form Validation

GettingStarted:delegate_classes

Delegate Classes

GettingStarted:triggers

Triggers

Creating_Printable_Reports

Creating a Printable Report

Key

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

A site with a backoffice

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

site_with_backoffice

sql_delegate_method

Synopsis

secure

file

Dynamic select boxes

Dynamic_select_boxes

Dynamic select boxes

setSecurityFilters

Example

Authenticating_Against_the_PHPBB_Users_table

Authenticating_Against_the_Joomla!_Users_Table

fieldname__validate

Synopsis

validators

Synopsis

validators:VALIDATOR_NAME:message

Synopsis

_auth

Synopsis

registration_form

Synopsis