Input - Autocomplete 1.7.26 Semantic UI 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 | Test1 | |
---|---|---|---|---|---|---|
1 | 11 | NT | 19.12.2004 00:00:00 | 100 | 33 | View Edit Remove |
2 | 114 | NP60385 | 31.05.2003 00:00:00 | 100 | View Edit Remove | |
3 | 114 | NR27552 | 10.03.2004 00:00:00 | 100 | View Edit Remove | |
4 | 119 | DB933704 | 14.11.2004 00:00:00 | 100 | View Edit Remove | |
5 | 124 | AE215433 | 05.03.2005 00:00:00 | 82261009 | View Edit Remove | |
6 | 124 | BG255406 | 28.08.2004 00:00:00 | 82261 | View Edit Remove | |
7 | 124 | CQ287967 | 11.04.2003 00:00:00 | 82261009 | View Edit Remove | |
8 | 124 | ET64396 | 16.04.2005 00:00:00 | 82261 | View Edit Remove | |
9 | 124 | HI366474 | 27.12.2004 00:00:00 | 47142.7 | View Edit Remove | |
10 | 124 | HR86578 | 02.11.2004 00:00:00 | 55639.66 | View Edit Remove |