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

Search Employees Across Multiple Columns

Program Info

Program Code

Download
Program

Search Employees Across Multiple Columns

<?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')->whereAny(['address','name','email'],'like','%india%')->get();
        echo "<pre>";
        print_r($data->toArray());
    }
}

Search Multiple Columns with LIKE

Program Info

Program Code

Download
Program

Search Multiple Columns with LIKE

<?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')->whereAll(['address','name','email'],'like','%india%')->get();
        echo "<pre>";
        print_r($data->toArray());
    }
}

Skip First 5 Records and Get Next 10 Records

Program Info

Program Code

Download
Program

Skip First 5 Records and Get Next 10 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')->skip(5)->take(10)->get();
        echo "<pre>";
        print_r($data->toArray());
    }
}

Update Employee Details

Program Info

Program Code

Download
Program

Update Employee Details

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class Query_Controller extends Controller
{
    public function index()
    {
        DB::table('employee')->where('id',92558)->update(['name'=> 'kishna verma','address'=>'meerut']);  
    }
}

Update Employee Name by Employee ID

Program Info

Program Code

Download
Program

Update Employee Name by 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('employee')->where('id',92558)->update(['name'=> 'kishna verma']); 
    }
}

Update Employee Record by Employee ID

Program Info

Program Code

Download
Program

Update Employee Record by 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['name'] = 'krishna verma';
        $data['email'] = 'krishna@gmail.com';
        $data['address'] = 'meerut';
        DB::table('employee')->where('id',39418)->update($data);    
    }
}

Update Employee Record by ID

Program Info

Program Code

Download
Program

Update Employee Record by ID

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class Query_Controller extends Controller
{
    public function index()
    {
        $data = [
            'name'=> 'krishna verma',
            'address'=> 'meerut',
        ];
        DB::table('employee')->where('id',95299)->update($data);   
    }
}

Showing page 8 of 8 (Total 77 records)

« Prev 1 ... 6 7 8