DEMO SITE v1.7.15

Simple relation Bootstrap 4.5 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 
1PamelaCastilloSan Francisco
2LarryBottTokyo
3BarryJonesRIO DE JANEIRO
4AndyFixterSydney
5PeterMarshSydney
6TomKingSydney
7MamiNishiTokyo
8YoshimiKatoTokyo
9MartinGerardParis
10POCI
Search