DEMO SITE v1.7.15

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();
?>

Simple relation

#FirstnameLastnameOffice in 
1Foon YueTsengBoston
2GeorgeVanaufNYC
3LouiBondurBoston
4PamelaCastilloBoston
5LarryBottLondon
6BarryJonesLondon
7AndyFixterLondon
8PeterMarshSydney
9TomKingSydney
10MamiNishiTokyo
Search