Simple relation Default theme
You can get options list from other table
HIDE CODE
<?php $xcrud = Xcrud::get_instance(); $xcrud->table('employees'); $xcrud->table_name('Simple relation'); $xcrud->relation('officeCode','offices','officeCode','city'); $xcrud->label('officeCode','Office in'); $xcrud->columns('firstName,lastName,officeCode'); $xcrud->fields('firstName,lastName,officeCode'); $xcrud->limit(10); echo $xcrud->render(); ?>
Simple relation
Add Export into CSV Print Search
# | Firstname | Lastname | Office in | |
---|---|---|---|---|
1 | Anthony8 | Bow | Tokyo | View Edit Remove |
2 | Leslie | Jennings | Tokyo | View Edit Remove |
3 | Leslie | Thompson | San Francisco | View Edit Remove |
4 | Julie | Firrelli | Boston | View Edit Remove |
5 | Steve | Patterson | Boston | View Edit Remove |
6 | Foon Yue | Tseng | View Edit Remove | |
7 | George N | Vanauf | NYC | View Edit Remove |
8 | Loui | Bondur | Paris | View Edit Remove |
9 | Gerard | Hernandez | Paris | View Edit Remove |
10 | Pamela | Castillo | Paris | View Edit Remove |
?>