Validators

Validators can be used to check entries in data fields before they are saved in the database. Limbas offers several options for this.

Regular expressions

The simplest option is to use the regular expressions of the field types. For each field type, the stored regular expression is used in the form (JavaScript) and on the server side (PHP) to check the content for correctness. This functionality is integrated by default. The regular expressions are customizable.

Rights

Group rights Group rights can be used to create write rights for each field according to your own criteria. These rights check whether a field may be written to at all. They are therefore only suitable for preliminary checks.

Trigger

Triggers are the classic way for validations. A database trigger and a Limbas PHP trigger can check the input and prevent it from being saved.

Validator function

The most convenient option uses a validator function to check the entered values. To do this, a function “lmb_ValidatePostRequest($params[Array])” must exist in an extension file ext_ajax.inc. In addition, the check per table must be activated in the table settings via the “Validation check” item. If both points apply, a preliminary request with the complete content of the form is sent to the function before the form is saved. The content of the array ($params) must be evaluated explicitly. It is advisable to create a separate structure with sub-functions or classes in the function according to criteria such as which table or which form or user group. The return value is an array containing the status and value. The following statuses are possible:

• true // is saved without confirmation
• false // like notice
• notice // is saved after notice
• alert // as after notice not saved
• confirm // is saved after request
• submit // like true

If the status is “alert”, a “class” and a “title” can also be specified for the relevant input fields. This makes it possible to highlight fields and set a description as a title. The array has the following format:

• [‘title’][ELEMENTID] = ‘TEXT’
• [‘class’][ELEMENTID] = ‘TEXT’

function lmb_ValidatePostRequest(&$params){
 if($params['gtabid'] == 2 && $params['formid'] == 1){
   if(is_numeric($params['gtabid'][g_2_1])){
      return true;
   }else{
      $out['status'] = 'alert';
      $out['value'] = 'Es können nur Zahlen gespeichert werden!';
      $out['title']['g_5_3'] = 'nur Zahlen erlaubt';
      $out['class']['g_5_3'] = 'lmbGlistBodyNotice notice1';
   }
   return $out;
 }
 return true;
}