Simple relation

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
Actions
1Gerard2BonduraaaaaaaNYC View Edit Remove
2Anthony8BowSan Francisco View Edit Remove
3LeslieJenningsTokyo View Edit Remove
4LeslieThompsonSan Francisco View Edit Remove
5JulieFirrelliBoston View Edit Remove
6StevePattersonBoston View Edit Remove
7Foon YueTseng View Edit Remove
8George NVanaufNYC View Edit Remove
9LouiBondurParis View Edit Remove
10GerardHernandezParis View Edit Remove
Search