Inline Editing (Validation) Bootstrap 5 theme
Inline Editing and using the normal validation and also relations
HIDE CODE
<?php $xcrud = Xcrud::get_instance(); $xcrud->table('employees'); $xcrud->table_name('Employees - Single click cell to edit!'); $xcrud->validation_required('lastName',2)->validation_required('firstName',2)->validation_required('jobTitle'); $xcrud->validation_required('email'); $xcrud->validation_pattern('email','email')->validation_pattern('extension','alpha_numeric')->validation_pattern('officeCode','natural'); $xcrud->relation('officeCode','offices','officeCode','city'); $xcrud->limit(10); $xcrud->set_logging(true); $xcrud->fields_inline('lastName,firstName,extension,email,officeCode,reportsTo,jobTitle');//set the fields to allow inline editing echo $xcrud->render(); ?>
Employees - Single click cell to edit!
# | Lastname | Firstname | Extension | Officecode | Reportsto | Jobtitle | ||
---|---|---|---|---|---|---|---|---|
1 | Patterson | Stev | x4334 | spatterson@classicmodelcars.com | Boston | 561143 | Sales Repr ddd | View Edit Remove |
2 | Fausto | Foon Yue | 999 | ftseng@classicmodelcars.com | NYC | 1143 | Sales Rep | View Edit Remove |
3 | Vanauf | George N | x4102 | gvanauf@classicmodelcars.com | NYC | 1143 | Sales Rep | View Edit Remove |
4 | Bondur | Loui | x6493 | lbondur@classicmodelcars.com | Paris | 1102 | Sales Rep | View Edit Remove |
5 | Hernandez | Gerard | x2028 | ghernande@classicmodelcars.com | NYC | 1102 | Sales Rep | View Edit Remove |
6 | Castillo | Pamela | x2759 | pcastillo@classicmodelcars.com | Paris | 1102 | Sales Rep | View Edit Remove |
7 | Bott | Larry | x2311 | lbott@classicmodelcars.com | London | 1102 | Sales Rep | View Edit Remove |
8 | Jones | Barry | x102 | bjones@classicmodelcars.com | London | 1102 | Sales Rep | View Edit Remove |
9 | Fixter | Andy | x101 | afixter@classicmodelcars.com | Sydney | 1088 | Sales Rep | View Edit Remove |
10 | Marsh | Peter | x102 | pmarsh@classicmodelcars.com | Sydney | 1088 | Sales Rep | View Edit Remove |