Krishna | Developer

Home Bio-Data Educations 4 Skills 64 Experiences Certificates 14 Programs 222 Projects 45 Accounts 5 Documents Personal Profile Interests Aspirations Images 58 Videos 3 Contact Others Declaration End

Font Settings

Select Font Size

Select Font Family

Select Text Color

Select BG Color

Get Employee Details from Multiple Tables

Program Info

Program Code

Download
Program

Get Employee Details from Multiple Tables

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class Query_Controller extends Controller
{
    public function index()
    {
        $data = DB::table('employee')
        ->join('users','employee.emp_id','=','users.emp_id')
        ->join('contact','employee.emp_id','=','contact.emp_id')
        ->select('employee.email','employee.address','users.displayName','users.username','contact.mobile')
        ->get();
        echo "<pre>";
        print_r($data->toArray());

    }
}

Get Employee Details with User and Contact Information

Program Info

Program Code

Download
Program

Get Employee Details with User and Contact Information

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class Query_Controller extends Controller
{
    public function index()
    {
        $data = DB::table('employee')
        ->join('users','employee.emp_id','=','users.emp_id')
        ->join('contact','employee.emp_id','=','contact.emp_id')
        ->select('employee.*','employee.address','users.displayName','users.username','contact.mobile')
        ->get();
        echo "<pre>";
        print_r($data->toArray());

    }
}

Get Employee Name by Address and Gender

Program Info

Program Code

Download
Program

Get Employee Name by Address and Gender

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class Query_Controller extends Controller
{
    public function index()
    {
        $data = DB::table('employee')->where(['address'=>'india','gender'=>'O'])->value('name');
        echo "<pre>";
        print_r($data);


    }
}

Get Employee Names by Email

Program Info

Program Code

Download
Program

Get Employee Names by Email

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class Query_Controller extends Controller
{
    public function index()
    {
        $data = DB::table('employee')->pluck('name','email');
        echo "<pre>";
        print_r($data->toArray());


    }
}

Get Employee Names by Email As Key

Program Info

Program Code

Download
Program

Get Employee Names by Email As Key

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class Query_Controller extends Controller
{
    public function index()
    {
        $data = DB::table('employee')->pluck('name','email');
        foreach($data as $email => $name)
        {
            echo "<pre>";
            echo $email.' '.$name;
        }


    }
}

Get Employees Created in a Specific Year

Program Info

Program Code

Download
Program

Get Employees Created in a Specific Year

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class Query_Controller extends Controller
{
    public function index()
    {
        $data = DB::table('employee')->whereYear('created_at','2024')->get();
        echo "<pre>";
        print_r($data->toArray());
    }
}

Get Employees Created in October

Program Info

Program Code

Download
Program

Get Employees Created in October

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class Query_Controller extends Controller
{
    public function index()
    {
        $data = DB::table('employee')->whereMonth('created_at','10')->get();
        echo "<pre>";
        print_r($data->toArray());
    }
}

Get Employees Created on a Specific Date

Program Info

Program Code

Download
Program

Get Employees Created on a Specific Date

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class Query_Controller extends Controller
{
    public function index()
    {
        $data = DB::table('employee')->whereDate('created_at','2024-10-09')->get();
        echo "<pre>";
        print_r($data->toArray());
    }
}

Get Employees Created on a Specific Day

Program Info

Program Code

Download
Program

Get Employees Created on a Specific Day

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class Query_Controller extends Controller
{
    public function index()
    {
        $data = DB::table('employee')->whereDay('created_at','31')->get();
        echo "<pre>";
        print_r($data->toArray());
    }
}

Get Employees Outside an ID Range

Program Info

Program Code

Download
Program

Get Employees Outside an ID Range

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class Query_Controller extends Controller
{
    public function index()
    {
        $data = DB::table('employee')->whereNotBetween('id',[10,90])->get();
        echo "<pre>";
        print_r($data->toArray());
    }
}

Showing page 5 of 8 (Total 77 records)

« Prev 1 ... 3 4 5 6 7 8 Next »