Input - Autocomplete 1.7.26 Bootstrap 5 theme
Manage date using the comprehensive Flat Pickr
HIDE CODE
<?php
$xcrud = Xcrud::get_instance();
$xcrud->table("payments");
$xcrud->set_attr("checkNumber",array("list"=>"europe-countries"));
echo $xcrud->render();
?>
<datalist id="europe-countries">
<option>Russia</option>
<option>Germany</option>
<option>United Kingdom</option>
</datalist>
<?php
/*
* Xcrud Configuration for Input Mask
*
* This section configures the Xcrud instance and applies input masks to fields
* using the Inputmask plugin. Below is a list of commonly used input mask formats.
*
* Usage:
* - Set the "data-inputmask" attribute with the desired mask pattern.
*
* Example:
* $xcrud->set_attr("field_name", array("data-inputmask" => "'mask': 'pattern'"));
*
* Commonly Used Input Mask Formats:
*
* 1. Phone Number
* - Format: (123) 456-7890
* - Mask: '999 999-9999'
* - Example:
* $xcrud->set_attr("phoneNumber", array("data-inputmask" => "'mask': '(999) 999-9999'"));
*
* 2. Date (MM/DD/YYYY)
* - Format: 12/31/2024
* - Mask: '99/99/9999'
* - Example:
* $xcrud->set_attr("dateOfBirth", array("data-inputmask" => "'mask': '99/99/9999'"));
*
* 3. Social Security Number (SSN)
* - Format: 123-45-6789
* - Mask: '999-99-9999'
* - Example:
* $xcrud->set_attr("ssn", array("data-inputmask" => "'mask': '999-99-9999'"));
*
* 4. Zip Code (US)
* - Format: 12345 or 12345-6789
* - Mask: '99999[-9999]'
* - Example:
* $xcrud->set_attr("zipCode", array("data-inputmask" => "'mask': '99999[-9999]'"));
*
* 5. Credit Card Number
* - Format: 1234 5678 9012 3456
* - Mask: '9999 9999 9999 9999'
* - Example:
* $xcrud->set_attr("creditCard", array("data-inputmask" => "'mask': '9999 9999 9999 9999'"));
*
* 6. Currency
* - Format: $1,234.56
* - Mask: '$9999.99'
* - Example:
* $xcrud->set_attr("amount", array("data-inputmask" => "'mask': '$9999.99'"));
*
* 7. Time (24-Hour Format)
* - Format: 14:30
* - Mask: '99:99'
* - Example:
* $xcrud->set_attr("time", array("data-inputmask" => "'mask': '99:99'"));
*
* 8. Custom Alphanumeric
* - Format: AB-12345
* - Mask: 'AA-99999'
* - Example:
* $xcrud->set_attr("customField", array("data-inputmask" => "'mask': 'AA-99999'"));
*/
?>
Payments
| # | Customernumber | Checknumber | Paymentdate | Amount | |
|---|---|---|---|---|---|
| 1 | 158 | 12-123456_ | 19.11.2004 00:00:00 | 7 | View Edit Remove |
| 2 | 161 | BR3523847 | 14.11.2004 16:00:37 | 7 | View Edit Remove |
| 3 | 161 | BR478494 | 18.11.2003 00:00:00 | 7 | View Edit Remove |
| 4 | 161 | KG644125 | 02.02.2005 00:00:00 | 12692.1955 | View Edit Remove |
| 5 | 161 | NI908214 | 05.08.2003 00:00:00 | 12692.1955 | View Edit Remove |
| 6 | 167 | GN228846 | 03.12.2003 00:00:00 | 12692.1955 | View Edit Remove |
| 7 | 171 | GB878038 | 15.03.2004 00:00:00 | 18997.89 | View Edit Remove |
| 8 | 171 | IL104425 | 22.11.2003 00:00:00 | 42783.81 | View Edit Remove |
| 9 | 172 | 83-2091___ | 09.09.2004 00:34:00 | 1960.8 | View Edit Remove |
| 10 | 172 | CE51751 | 04.12.2004 00:00:00 | 51209.58 | View Edit Remove |