Docs – PHP Database Form

System Requirements

phpcontrols — Tue, 15 Jul 2014 03:07:40 +0000

PHP Database Form requires web server that supports PHP 5.3 and higher.

PHP 5.3 or later
Apache, Tomcat, or Microsoft IIS web server

PHP Database Form supports all major databases:

PHP Database Form Supports all major web browsers:

Constructor

phpcontrols — Tue, 15 Jul 2014 04:02:54 +0000

PHP Database Form constructor takes three parameters. Use this method to create the PHP Database Form object. Usually this is the first line in your code.

Signature:

public function __constructor($sql, $sql_key='id', $sql_table='')

Parameters:

$sql: SQL SELECT statement. This is the only SQL statement users needs to implement. The SELECT statement must include the primary key as one of the columns if not using the wildcard start(*) in SELECT statement.
$sql_key: The name of the database table primary key. The default is “id”.
$sql_table: Name of the database table used in the SQL statement. If not defined, the table name is automatically parsed from the SQL statement.

Example:

$dbForm = new C_DatabaseForm("SELECT * FROM employees", "EmployeeID", "employees");

set_label()

phpcontrols — Tue, 15 Jul 2014 04:18:00 +0000

set_label(mixed $col, mixed $label) : $this

Set form element label

Parameters

mixed	$col	Database table column name
mixed	$label	Label

set_dimension()

phpcontrols — Tue, 15 Jul 2014 09:02:35 +0000

set_dimension(mixed $col, int $cols, int $rows) : $this

Set control dimension width and height. Note that this is not the same as set_form_dimension().

It is used with text type only. For column type text, the width is translated to “size”, its height is ignored. for text area, the width is translated to “cols” and height to “rows”

Parameters

mixed	$col	Database table column name
int	$cols	If the column is a text box, it’s the size that represents number of characters. If the column is a textarea, it’s the value for cols attribute in textarea.
int	$rows	Optional. Number of rows in a textarea (only)

set_form_dimension()

phpcontrols — Fri, 18 Jul 2014 17:58:13 +0000

set_form_dimension(mixed $f_width, string $f_height) : $this|void

Set form width and height. Overwrites parent definition for template.

Parameters

mixed	$form_width	Form width
string	$form_height	Form height

set_default()

phpcontrols — Fri, 18 Jul 2014 18:07:42 +0000

set_default(mixed $col, string $default) : $this

Set control default value for a field

Parameters

mixed	$col	Database table column name
string	$default	Default value

set_readonly()

phpcontrols — Fri, 18 Jul 2014 18:09:32 +0000

set_readonly(array $cols) : $this

Set one more more columns as read only field. Note that the parameter is an array.

Parameters

array

$cols

Column name(s)

set_required()

phpcontrols — Fri, 18 Jul 2014 18:10:59 +0000

set_required(array $cols) : $this

Set required fields. The parameter is an array that can take one or more fields.

Parameters

array

$cols

Columns name(s)

set_hide()

phpcontrols — Fri, 18 Jul 2014 18:11:36 +0000

set_hide(mixed $col) : $this

Hide a field on the form from displaying with CSS display:none. Note that the field still exists on the form but not visible.

Do not use this field to hide sensitive information such as password.

Parameters

mixed

$col

Database table column name

set_placeholder()

phpcontrols — Fri, 18 Jul 2014 18:12:30 +0000

set_placeholder(mixed $col, mixed $ph_text) : $this

Placeholder text for HTML form element.

Parameters

mixed	$col	Database table column name
mixed	$ph_text	Placeholder text