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 Employees Where Name Is Not Null

Program Info

Program Code

Download
Program

Get Employees Where Name Is Not Null

<?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')->whereNotNull('name')->get();
        echo "<pre>";
        print_r($data->toArray());
    }
}

Get Employees with a Null Name

Program Info

Program Code

Download
Program

Get Employees with a Null Name

<?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')->whereNull('name')->get();
        echo "<pre>";
        print_r($data->toArray());
    }
}

Get Employees with ID 50000 or Higher

Program Info

Program Code

Download
Program

Get Employees with ID 50000 or Higher

<?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('id','>=',50000)->get();
        echo "<pre>";
        print_r($data->toArray());

    }
}

Get Employees Within Multiple ID Ranges

Program Info

Program Code

Download
Program

Get Employees Within Multiple ID Ranges

<?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')->whereBetween('id',[13,14])->orwhereBetween('id',[10,90])->get();
        echo "<pre>";
        print_r($data->toArray());
    }
}

Get Maximum Employee ID

Program Info

Program Code

Download
Program

Get Maximum Employee ID

<?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')->max('id');
        echo "<pre>";
        print_r($data);
    }
}

Get Selected Employee Details

Program Info

Program Code

Download
Program

Get Selected Employee Details

<?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')->select('name','email','address')->get();
        echo "<pre>";
        print_r($data->toArray());
    }
}

Get the First 10 Employees

Program Info

Program Code

Download
Program

Get the First 10 Employees

<?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')->limit(10)->get();
        echo "<pre>";
        print_r($data->toArray());
    }
}

Get the Latest Employee Record

Program Info

Program Code

Download
Program

Get the Latest Employee Record

<?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')->latest();
        echo "<pre>";
        print_r($data);


    }
}

Get Unique Employee Records

Program Info

Program Code

Download
Program

Get Unique Employee Records

<?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')->distinct()->get();
        echo "<pre>";
        print_r($data->toArray());

    }
}

Insert a New Contact Record with a Random Employee ID

Program Info

Program Code

Download
Program

Insert a New Contact Record with a Random Employee ID

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class Query_Controller extends Controller
{
    public function index()
    {
        DB::table('contact')->insert(['id'=> mt_rand(11111,99999),'mobile'=>1234567890]);

    }
}

Showing page 6 of 8 (Total 77 records)

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