Input - Autocomplete NEW 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 | 103 | HQ336336 | 29.10.2004 00:00:00 | 6074 | View Edit Remove |
| 2 | 103 | JM555205 | 05.06.2003 00:00:00 | 6074 | View Edit Remove |
| 3 | 103 | OM314933 | 18.12.2004 00:00:00 | 6074 | View Edit Remove |
| 4 | 112 | 86-4823245 | 17.12.2004 00:00:00 | 6074 | View Edit Remove |
| 5 | 112 | 55-0225454 | 06.06.2003 00:00:00 | 32641.98 | View Edit Remove |
| 6 | 112 | ND748579 | 20.08.2004 00:00:00 | 33347.88 | View Edit Remove |
| 7 | 114 | GG31455 | 16.05.2003 00:00:00 | 45864.03 | View Edit Remove |
| 8 | 114 | MA765515 | 15.12.2004 00:00:00 | 82261.22 | View Edit Remove |
| 9 | 114 | NP603840 | 31.05.2003 00:00:00 | 7565.08 | View Edit Remove |
| 10 | 114 | NR27552 | 10.03.2004 00:00:00 | 44894.25 | View Edit Remove |