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
1StevePattersonLondon View Edit Remove
2Foon YueTsengchuNYC View Edit Remove
3LouiBondurParis View Edit Remove
4GerardHernandezParis View Edit Remove
5PamelaCastilloBoston View Edit Remove
6LarryBottLondon View Edit Remove
7BarryJonesLondon View Edit Remove
8AndyFixterSydney View Edit Remove
9PeterMarshSydney View Edit Remove
10TomKingSydney View Edit Remove
Search