Generate forms programmatically

Add callback function to custom validation. Callback function should accept array of all form submited values, where keys are mysql table column names. Callback function should return true if submission was valid and false if invalid. User may provide multiple custom validation functions using this method.

Using custom validation only error text will be passed in array to on error callback functions, without element name or id

string or array $callback - name of callback functions or array with instance and method (parameters that are supported by "call_user_func" function)

string $error_str - error string to show if submitted values didn't pass validation

Allows or disallows HTML tag usage in form (converts to html entities if HTML tags are not allowed)

Currently this method applies to whole form

bool $html - true to allow HTML tags and false to disallow

Provides custom language for input labels and error messages

For input labels, use mysql table column names as keys. and for error messages, use "colum nname"_"error type". Check validation types section for possible error type values

array $lang - language array

set_language(array("username" => "Username", "pass" => "Password", "pass_required" => "You must enter password"))

Set callback function which will be called, if form is successfully submited (user input passes form validation)

Callback function should accept one parameter. Parameter type depends on form type.

• If it is select form, then result resource from select query will be returned from mysql_query function. Check mysql_query for possible returned values
• If insert form, then integer - auto increment value (ID) for inserted row will be returned using mysql_insert_id() function. Check mysql_insert_id for possible returned values
• If update form, then integer - how many rows where affected by query, using mysql_affected_rows function. Check mysql_affected_rows for possible returned values

Callback function should return true to allow page refresh or provided redirection, or false to not refresh or redirect page

User can submit only one on success callback function per form. Previous function will be overwritten

Set callback function which will be called, if form is submited with errors (user input didn't pass validation)

Callback function should accept one parameter - two dimensional array with error texts, input name and HTML element input id (for javascript error displaying), except if it was error from custom validation, then only error text will be provided in array, without name and id

If on_error function isn't provided, then class will automatically print out errors, if function is set, then no errors will be print out

User can submit only one on error callback function per form. Previous function will be overwritten

Example of array passed to callback function

Array
(
 [0] =>  Array
 (
	["id"] => username_0
	["name"] => username
	["error"] => Please enter the value for input username
 )
 [1] =>  Array	
 (
	["id"] => pass_0
	["name"] => pass
	["error"] => Please enter the value for input pass
 )
)

Set callback function which will be called after form validation (if user input passes form validation), but before forming query text and use it on mysql table

Callback function should accept one parameter - array with column names as keys and submitted values as values

User can submit only one modification callback function per form. Previous function will be overwritten

Example of array passed to callback function

Array
(
	["username"] =>  my_user_name
 	["password"] => my_pass
	["captcha"] => 4FTG3
)

Add custom HTML code to form. HTML code as any input in form will be wrapped to new table row and table data HTML elements. Provided HTML code maybe custom input or just for decoration purpose

If name of input element is provided, then one td cell will be created for input label from language array or column name and other for input field, just like any other input element. To avoid it provide parameter $hidden as true

string $html - string with HTML markup

string $name - name of input element if input element is provided, default value - empty

bool $in_query - should value submitted through this input element appear in generated query using input name as column name in mysql table, if it is input element. If true, value will be included in query. Default value is false

bool $hidden - use if you don't want class to create label for your provided input (just like hidden form elements)

Add class predefined validation to input elements provided with add_custom_html method. Predefined validation is based on input type and required/maxlen values

string $name - name of input element to validate (same value provided to add_custom_html method)

string $group - mysql data type group name from HTML inputs for mysql datatypes

bool $required - if should be validated as required from Validation types. Default value - false

int $maxlen - maximal length of value interpreted as string from Validation types. Default value empty (will not be counted)

Generate form, which will insert new data to database

string $table_name - name of mysql table for which form is generated

array $exclude - array with column names as values, which columns should be excluded from form

string $redir - where to redirect after successful form submission using header("Location:"). Default value is empty, so page will be refreshed. Page won't be redirected or refreshed if submitted values didn't pass form validation or if on success callback function returns false, or if output already started and headers can not be sent

string $submit - value for submit button (Text that appears on button)

Generate form, which will update existing data in database

string $table_name - name of mysql table for which form is generated

string $condition - what rows to update, mysql where clause (for example: WHERE ID = '1')

array $exclude - array with column names as values, which columns should be excluded from form

string $redir - where to redirect after successful form submission using header("Location:"). Default value is empty, so page will be refreshed. Page won't be redirected or refreshed if submitted values didn't pass form validation or if on success callback function returns false, or if output already started and headers can not be sent

string $submit - value for submit button (Text that appears on button)

Generate form, which will select existing data from database which matches user provided column values

Select query will be generated from form input element values

string $table_name - name of mysql table for which form is generated

array $exclude - array with column names as values, which columns should be excluded from form

string $addon - additional conditions for query. Where clause will be automatically generated using pairs from input name and input value. It is possible to provide additional condition, like order, limit, offset, group (any condition that can go fter where clause in mysql query). You must provide valid addon, for query to work. Use debug() method to check mysql query texts and errors

string $redir - where to redirect after successful form submission using header("Location:"). Default value is empty, so page will be refreshed. Page won't be redirected or refreshed if submitted values didn't pass form validation or if on success callback function returns false, or if output already started and headers can not be sent

string $submit - value for submit button (Text that appears on button)

Generate form, which will delete existing data in database which matches user provided column values

Delete query will be generated from form input element values

string $table_name - name of mysql table for which form is generated

array $exclude - array with column names as values, which columns should be excluded from form

string $redir - where to redirect after successful form submission using header("Location:"). Default value is empty, so page will be refreshed. Page won't be redirected or refreshed if submitted values didn't pass form validation or if on success callback function returns false, or if output already started and headers can not be sent

string $submit - value for submit button (Text that appears on button)

If value is not empty

Except bool type inputs, where it checks whether checkbox was checked

<tr>
<td class='int_label'>
	[columnname or language]: 
</td>
<td class='int_input'>
	<input type='text' 
	name='[columnname]_[formnum]' 
	id='[columnname]_[formnum]' 
	maxlength='[length]'
	value='[value]'/>
</td>
</tr>

<tr>
<td class='decimal_label'>
	[columnname or language]: 
</td>
<td class='decimal_input'>
	<input type='text' 
	name='[columnname]_[formnum]' 
	id='[columnname]_[formnum]' 
	maxlength='[length]'
	value='[value]'/>
</td>
</tr>

<tr>
<td class='float_label'>
	[columnname or language]: 
</td>
<td class='float_input'>
	<input type='text' 
	name='[columnname]_[formnum]' 
	id='[columnname]_[formnum]' 
	maxlength='[length]'
	value='[value]'/>
</td>
</tr>

<tr>
<td colspan='2' class='text_label'>
	[columnname or language]: 
</td>
</tr> 
<tr>
<td colspan='2' class='text_input'>
	<textarea
	name='[columnname]_[formnum]' 
	id='[columnname]_[formnum]'>
	</textarea>
</td>
</tr> 

<tr>
<td colspan='2' class='bool_input'>
	<input type='hidden' 
	name='[columnname]_[formnum]' 
	value='0'/>
	<input type='checkbox' 
	name='[columnname]_[formnum]' 
	id='[columnname]_[formnum]' 
	value='1' />
	[columnname or language]: 
</td>
</tr>

<tr>
<td class='enum_label'>
	[columnname or language]:
</td> 
<td class='enum_input'> 
	<select name='[columnname]_[formnum]' 
	id='[columnname]_[formnum]'> 
		<option value='[defined_value]'>
			[defined_value or language]
		</option> 
	</select> 
</td>
</tr> 

<tr>
<td class='set_label'>
	[columnname or language]:
</td> 
<td class='set_input'>
	<input type='hidden' 
	name='[columnname]_[formnum]' 
	value=''/>
	<select name='[columnname]_[formnum][]' 
	id='[columnname]_[formnum]' 
	multiple='multiple' 
	size='3'> 
		<option value='[defined_value]' >
			[defined_value or language]
		</option> 
	</select> 
</td>
</tr>

<tr>
<td class='char_label'>
	[columnname or language]:
</td>
<td class='char_input'>
	<input type='text' 
	name='[columnname]_[formnum]' 
	id='[columnname]_[formnum]' 
	maxlength='[length]'/>
</td>
</tr>

ID - [mysql table name]_[formnum]

<form id='test_table_1'>

CSS class - [mysql table name]

<table class='test_table'>

CSS class for td with text labels - [type group]_label

CSS class for td with input element - [type group]_input

<td class='int_label'>Username: </td>

<td class='int_input'><input type='text' name='username_1' id='username_1' value='1' maxlength=''/></td>

<td class='submit_input' colspan='2'><input type='hidden' name='test_table_1'/><input type='submit' id='submit_1' value='Submit'/></td>

ID - [columnname]_[formnum]

<input type='text' name='username_1' id='username_1' value='1' maxlength=''/>

ID - submit_[formnum]

<input type='submit' id='submit_1' value='Submit'/>