slot gacor
slot gacor
Join other table - Bootstrap 4.5 theme - eXtended CRUD & Data Management System
DEMO SITE v1.7.28

Join other table Bootstrap 4.5 theme

Allows you to join other tables. Only INNER JOIN supported. Keys in all joined tables must exist and be unique

HIDE CODE
?
1
2
3
4
5
6
<?php
    $xcrud = Xcrud::get_instance();
    $xcrud->table('employees');
    $xcrud->join('officeCode','offices','officeCode'); // ... INNER JOIN offices ON employees.officeCode = offices.officeCode ...
    echo $xcrud->render();  
?>

Employees

refresh Print Export into CSV
Add
#LastnameFirstnameExtensionEmailOfficecodeReportstoJobtitleCityPhoneAddressline1Addressline2StateCountryPostalcodeTerritoryOrdering
Actions
1PattersonWilliamx48711wpatterson@classicmodelcars.com21056Sales Manager (APAC)Boston+1 215 837 08251550 Court PlaceSuite 102MAUSA02107NA3 View Edit Remove
2BondurGerardx5408gbondur@classicmodelcars.com41056Sale Manager (EMEA)Paris+33 14 723 440443 Rue Jouffroy D'abbansFrance75017EMEA0 View Edit Remove
3BowAnthonyx5428abow@classicmodelcars.com11056Sales Manager (NA)San Francisco+1 650 219 4782100 Market StreetSuite 300CAUSA94080NA1 View Edit Remove
4JenningsLesliex3291ljennings@classicmodelcars.com11143Sales RepSan Francisco+1 650 219 4782100 Market StreetSuite 300CAUSA94080NA1 View Edit Remove
5ThompsonLesliex4065lthompson@classicmodelcars.com11143Sales RepSan Francisco+1 650 219 4782100 Market StreetSuite 300CAUSA94080NA1 View Edit Remove
6FirrelliJuliex2173jfirrelli@classicmodelcars.com21143Sales RepBoston+1 215 837 08251550 Court PlaceSuite 102MAUSA02107NA3 View Edit Remove
7PattersonStevex4334spatterson@classicmodelcars.com21143Sales RepBoston+1 215 837 08251550 Court PlaceSuite 102MAUSA02107NA3 View Edit Remove
8TsengchuFoon Yueo224ftseng@classicmodelcars.com31143Sales RepNYC+1 212 555 3000523 East 53rd Streetapt. 5ANYUSA10022NA2 View Edit Remove
9VanaufGeorgex4102gvanauf@classicmodelcars.com31143Sales RepNYC+1 212 555 3000523 East 53rd Streetapt. 5ANYUSA10022NA2 View Edit Remove
10BondurLouix6493lbondur@classicmodelcars.com41102Sales RepParis+33 14 723 440443 Rue Jouffroy D'abbansFrance75017EMEA0 View Edit Remove
Search
 
slot thailand
slot thailand slot gacor
slot gacor