Simple relation Bootstrap 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();
?>
Warning: Undefined variable $bool in /home/mixcprassd/public_html/backendDemo/xcrud/xcrud.php on line 1165
Simple relation
| # | Firstname | Lastname | Officecode | |
|---|---|---|---|---|
| 1 | Diane | Murphy | Tokyo | View Edit Remove |
| 2 | Mar'y | Patterson | San Francisco | View Edit Remove |
| 3 | Jeff | Firrelli | San Francisco | View Edit Remove |
| 4 | William | Patterson | London | View Edit Remove |
| 5 | Gerard | Bondur | Paris | View Edit Remove |
| 6 | Anthony | Bow | San Francisco | View Edit Remove |
| 7 | Leslie | Jennings | San Francisco | View Edit Remove |
| 8 | Leslie | Thompson | San Francisco | View Edit Remove |
| 9 | Julie | Firrelli | Boston | View Edit Remove |
| 10 | Steve | Patterson | Boston | View Edit Remove |