DEMO SITE v1.7.26

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

Warning: Undefined variable $bool in /home/mixcprassd/public_html/backendDemo/xcrud/xcrud.php on line 1165

Simple relation

#FirstnameLastnameOfficecode
Actions
1DianeMurphyTokyo View Edit Remove
2Mar'yPattersonSan Francisco View Edit Remove
3JeffFirrelliSan Francisco View Edit Remove
4WilliamPattersonLondon View Edit Remove
5GerardBondurParis View Edit Remove
6AnthonyBowSan Francisco View Edit Remove
7LeslieJenningsSan Francisco View Edit Remove
8LeslieThompsonSan Francisco View Edit Remove
9JulieFirrelliBoston View Edit Remove
10StevePattersonBoston View Edit Remove
Search Execution time: 0.008 sMemory usage: 0.18 MB