Input - Autocomplete NEW
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 | Test1 | |
---|---|---|---|---|---|---|
1 | 10364 | OM31496 | 16.07.2020 00:00:00 | 3 | View Edit Remove | |
2 | 103600 | OM31491 | 23.07.2020 00:00:00 | 3 | rus | View Edit Remove |
3 | 11310 | HQ5502 | 20.12.2001 00:00:00 | 40000 | View Edit Remove | |
4 | 112 | HQ55022 | 30.07.2020 00:00:00 | 40000 | View Edit Remove | |
5 | 113 | GG31455 | 16.05.2003 00:00:00 | 45870 | View Edit Remove | |
6 | 114 | MA76552 | 15.12.2004 00:00:00 | 82261 | View Edit Remove | |
7 | 114 | NP60385 | 31.05.2003 00:00:00 | 7565 | View Edit Remove | |
8 | 114 | NR27552 | 10.03.2004 00:00:00 | 44894 | View Edit Remove | |
9 | 119 | DB933704 | 14.11.2004 00:00:00 | 19501.82 | View Edit Remove | |
10 | 119 | LN373447 | 08.08.2004 00:00:00 | 47924.19 | View Edit Remove |