Download Laravel-xCRUD Integration Full Code that includes this full demo


<?php

namespace App\Http\Controllers;

use 
Illuminate\Http\Request;

class 
xJoinController extends Controller
{
    public function 
index()
    {
        
$xcrud Xcrud_get_instance();
        
$xcrud->table('employees');
        
$xcrud->join('officeCode','offices','officeCode'); // ... INNER JOIN offices ON employees.officeCode = offices.officeCode ...
        
$render $xcrud->render();
        return 
view('xcrud_simple', ['render' => $render]);
        
    }
}

Employees

#LastnameFirstnameExtensionEmailOfficecodeReportstoJobtitleCityPhoneAddressline1Addressline2StateCountryPostalcodeTerritoryOrdering 
1MurphysDiane234james@classicmodelcars.com31232PresidentNYC+1 212 555 3000523 East 53rd Streetapt. 5ANYUSA10022NA0 View Edit Remove
2PattersonMaryx324mpatterso@classicmodelcars.com710090VP SalesLondon+44 20 7877 204125 Old Broad StreetLevel 7UKEC2N 1HNEMEA0 View Edit Remove
3FirrelliJeffx9273gbondur@classicmodelcars.com71002VP MarketingLondon+44 20 7877 204125 Old Broad StreetLevel 7UKEC2N 1HNEMEA0 View Edit Remove
4Patterson123x4645wpatterson@classicmodelca.com71056Sales Manager (APAC)London+44 20 7877 204125 Old Broad StreetLevel 7UKEC2N 1HNEMEA0 View Edit Remove
5BondurGerard2x540ygbondur@classicmodelcars.com31050Sale Manager (EMEA)NYC+1 212 555 3000523 East 53rd Streetapt. 5ANYUSA10022NA0 View Edit Remove
6BowAnthony8x5428abow@classicmodelcars.com11056Sales Manager (NA)San Francisco+1 650 219 4782100 Market StreetSuite 300CAUSA94080NA0 View Edit Remove
7JenningsLesliex540ljennings@classicmodelcars.com51143Sales Rep 2Tokyo+81 33 224 50004-1 KioichoChiyoda-KuJapan102-8578Japan150 View Edit Remove
8ThompsonLesliex4065lthompson@classicmodelcars.com11143Sales Rep 3San Francisco+1 650 219 4782100 Market StreetSuite 300CAUSA94080NA0 View Edit Remove
9FirrelliJuliex2173jfirrelli@classicmodelcars.com21143Sales RepBoston+1 215 837 08251550 Court PlaceSuite 102MAUSA02107NA0 View Edit Remove
10PattersonStevex4334spatterson@classicmodelcars.com21143Sales RepBoston+1 215 837 08251550 Court PlaceSuite 102MAUSA02107NA0 View Edit Remove
Search