Multiple where laravel in Codefunda

 <?php 

// Multiple where laravel in Codefunda

// laravel where multiple conditions

$query->where([

    ['column_1', '=', 'value_1'],

    ['column_2', '<>', 'value_2'],

    [COLUMN, OPERATOR, VALUE],

    ...

])

laravel where multiple conditions on single colmn

// here, i have used two different where condition on a single column

$data = Users::where('type',1)

        ->where(function($query) {

            return $query->whereDate('updated_at','!=', Carbon::today())

            ->orWhere('updated_at',null);

         })

         ->get();

         

www.Codefunda.tk

?>

Read More

Multiple where laravel in Codefunda

 <?php 

// Multiple where laravel in Codefunda

// laravel where multiple conditions

$query->where([

    ['column_1', '=', 'value_1'],

    ['column_2', '<>', 'value_2'],

    [COLUMN, OPERATOR, VALUE],

    ...

])

laravel where multiple conditions on single colmn

// here, i have used two different where condition on a single column

$data = Users::where('type',1)

        ->where(function($query) {

            return $query->whereDate('updated_at','!=', Carbon::today())

            ->orWhere('updated_at',null);

         })

         ->get();

         

www.Codefunda.tk

?>

Read More

Multiple orwhere condition in laravel in Codefunda

 <?php 

// Multiple orwhere condition in laravel in Codefunda

// multiple orwhere condition in laravel

public function index()

    {

        $search = "Har";

  

        $users = User::select("*")->where('status', 1)

                  ->where(function($query) use ($search){

                   $query->where('first_name', 'LIKE', '%'.$search.'%')

                   ->orWhere('last_name', 'LIKE', '%'.$search.'%')

                   ->orWhere('email', 'LIKE', '%'.$search.'%');

                    })->get();

  

        dd($users);

    }

# With Join

  public function index()

    {

        $search = "Har";

  

        $users = User::select("*")->where('status', 1)

                  ->where(function($query) use ($search){

                   $query->where('first_name', 'LIKE', '%'.$search.'%')

                   ->orWhere('last_name', 'LIKE', '%'.$search.'%')

                   ->orWhere('email', 'LIKE', '%'.$search.'%');

                    })

          ->join('users_roles', 'users.id', '=', 'users_roles.user_id')

          ->where('users_roles.role_id', '=', Role::USER_PARTICIPANT)->get();

  

        dd($users);

    }

    // laravel where multiple conditions

    $query->where([

        ['column_1', '=', 'value_1'],

        ['column_2', '<>', 'value_2'],

        [COLUMN, OPERATOR, VALUE],

        ...

    ])

www.Codefunda.tk

?>

Read More

Multiple orwhere condition in laravel in Codefunda

 <?php 

// Multiple orwhere condition in laravel in Codefunda

// multiple orwhere condition in laravel

public function index()

    {

        $search = "Har";

  

        $users = User::select("*")->where('status', 1)

                  ->where(function($query) use ($search){

                   $query->where('first_name', 'LIKE', '%'.$search.'%')

                   ->orWhere('last_name', 'LIKE', '%'.$search.'%')

                   ->orWhere('email', 'LIKE', '%'.$search.'%');

                    })->get();

  

        dd($users);

    }

# With Join

  public function index()

    {

        $search = "Har";

  

        $users = User::select("*")->where('status', 1)

                  ->where(function($query) use ($search){

                   $query->where('first_name', 'LIKE', '%'.$search.'%')

                   ->orWhere('last_name', 'LIKE', '%'.$search.'%')

                   ->orWhere('email', 'LIKE', '%'.$search.'%');

                    })

          ->join('users_roles', 'users.id', '=', 'users_roles.user_id')

          ->where('users_roles.role_id', '=', Role::USER_PARTICIPANT)->get();

  

        dd($users);

    }

    // laravel where multiple conditions

    $query->where([

        ['column_1', '=', 'value_1'],

        ['column_2', '<>', 'value_2'],

        [COLUMN, OPERATOR, VALUE],

        ...

    ])

www.Codefunda.tk

?>

Read More

Multiple logical condition in laravel query in Codefunda

 <?php 

// Multiple logical condition in laravel query in Codefunda

// multiple logical condition in laravel query

// ...

$q->where(function ($query) {

    $query->where('gender', 'Male')

        ->where('age', '>=', 18);

})->orWhere(function($query) {

    $query->where('gender', 'Female')

        ->where('age', '>=', 65);   

})

www.Codefunda.tk

?>

Read More

Multiple logical condition in laravel query in Codefunda

 <?php 

// Multiple logical condition in laravel query in Codefunda

// multiple logical condition in laravel query

// ...

$q->where(function ($query) {

    $query->where('gender', 'Male')

        ->where('age', '>=', 18);

})->orWhere(function($query) {

    $query->where('gender', 'Female')

        ->where('age', '>=', 65);   

})

www.Codefunda.tk

?>

Read More

Laravel where condition with if in Codefunda

 <?php 

// laravel where condition with if

// laravel where condition with if

$query = DB::table('user_ads')

            ->join('ads', 'users_ads.ad_id', '=', 'ads.id')

            ->orderBy($column, $method);

if ($input['search']) {

    $query->where('short_description', $input['search']);

}

if ($input['category']) {

    $query->where('category', $input['category']);

}

$query->join('users', 'users_ads.user_id', '=', 'users.id')

    ->select('ads.id', 'ads.img1', 'ads.short_description', 'ads.category', 'ads.product', 'ads.price', 'users.city')

$result= $query->get();

return $result;

www.Codefunda.tk

?>

Read More

Laravel where condition with if in Codefunda

 <?php 

// laravel where condition with if

// laravel where condition with if

$query = DB::table('user_ads')

            ->join('ads', 'users_ads.ad_id', '=', 'ads.id')

            ->orderBy($column, $method);

if ($input['search']) {

    $query->where('short_description', $input['search']);

}

if ($input['category']) {

    $query->where('category', $input['category']);

}

$query->join('users', 'users_ads.user_id', '=', 'users.id')

    ->select('ads.id', 'ads.img1', 'ads.short_description', 'ads.category', 'ads.product', 'ads.price', 'users.city')

$result= $query->get();

return $result;

www.Codefunda.tk

?>

Read More

Laravel where condition on relationship in Coderfunda.tk

 <?php 

// laravel adding condition to relation

class Game extends Eloquent {

    // many more stuff here

    // relation without any constraints ...works fine 

    public function videos() {

        return $this->hasMany('Video');

    }

    // results in a "problem", se examples below

    public function available_videos() {

        return $this->videos()->where('available','=', 1)->get();

    }

}

// laravel where condition on relationship

App\Request::where('id',4)

    ->whereHas('quotes', function ($query) {

        $query->where('status','=','3');

    })

    ->with('quotes','sourceTable','destinationTable')

    ->get(); 

?>

Read More

Laravel where condition on relationship in Coderfunda.tk

 <?php 

// laravel adding condition to relation

class Game extends Eloquent {

    // many more stuff here

    // relation without any constraints ...works fine 

    public function videos() {

        return $this->hasMany('Video');

    }

    // results in a "problem", se examples below

    public function available_videos() {

        return $this->videos()->where('available','=', 1)->get();

    }

}

// laravel where condition on relationship

App\Request::where('id',4)

    ->whereHas('quotes', function ($query) {

        $query->where('status','=','3');

    })

    ->with('quotes','sourceTable','destinationTable')

    ->get(); 

?>

Read More

Laravel multiple group by Coderfunda.tk

 <?php 

// “laravel multiple group by” Coderfunda.tk

//laravel multiple group by

$routes = DB::table('route')

->groupBy('rte_origin', 'rte_destination')

->get();

?>

Read More

Laravel multiple group by Coderfunda.tk

 <?php 

// “laravel multiple group by” Coderfunda.tk

//laravel multiple group by

$routes = DB::table('route')

->groupBy('rte_origin', 'rte_destination')

->get();

?>

Read More

Laravel if else condition in query in Coderfunda

 <?php 

// laravel if else condition in query

$query = SocialMediaFeed::where('location_id', $location_id);

if(!$filters) {

    $query = $query->where('self', '<>', true);

} else {

    $query = $query->orWhere('self', true);

}

?>

Read More

Laravel if else condition in query in Coderfunda

 <?php 

// laravel if else condition in query

$query = SocialMediaFeed::where('location_id', $location_id);

if(!$filters) {

    $query = $query->where('self', '<>', true);

} else {

    $query = $query->orWhere('self', true);

}

?>

Read More

Laravel eloquent where two conditions in Coderfunda

 <?php 

// laravel where multiple conditions

$query->where([

    ['column_1', '=', 'value_1'],

    ['column_2', '<>', 'value_2'],

    [COLUMN, OPERATOR, VALUE],

    ...

])

?>

Read More

Laravel eloquent where two conditions in Coderfunda

 <?php 

// laravel where multiple conditions

$query->where([

    ['column_1', '=', 'value_1'],

    ['column_2', '<>', 'value_2'],

    [COLUMN, OPERATOR, VALUE],

    ...

])

?>

Read More

How to use multiple where condition in codeigniter in Coderfunda

 

 <?php

// How to use multiple where condition in codeigniter ;

$data = array('name' => 'Rockky');

        $multiClause = array('id' => $ids, 'name' => $name, 'status' => 1 );

        $this->db->where($multiClause);     

        $query = $this->db->get('table-name', $data);   

        return $query->result();

        

?>

Read More

How to use multiple where condition in codeigniter in Coderfunda

 

 <?php

// How to use multiple where condition in codeigniter ;

$data = array('name' => 'Rockky');

        $multiClause = array('id' => $ids, 'name' => $name, 'status' => 1 );

        $this->db->where($multiClause);     

        $query = $this->db->get('table-name', $data);   

        return $query->result();

        

?>

Read More

Count with condition laravel in coderfunda

 <?php 

count with condition laravel

$user = User::where('user_id' , 10);

$user->count();

?>

Read More

Count with condition laravel in coderfunda

 <?php 

count with condition laravel

$user = User::where('user_id' , 10);

$user->count();

?>

Read More

Laravel where with multiple conditions query

 

 i have used two different where condition on a single column

$data = Users::where('type',1)

        ->where(function($query) {

            return $query->whereDate('updated_at','!=', Carbon::today())

            ->orWhere('updated_at',null);

         })

         ->get();

 Laravel where multiple conditions

         $query->where([

            ['column_1', '=', 'value_1'],

            ['column_2', '<>', 'value_2'],

            [COLUMN, OPERATOR, VALUE],

            ...

        ])

Read More

Laravel where with multiple conditions query

 

 i have used two different where condition on a single column

$data = Users::where('type',1)

        ->where(function($query) {

            return $query->whereDate('updated_at','!=', Carbon::today())

            ->orWhere('updated_at',null);

         })

         ->get();

 Laravel where multiple conditions

         $query->where([

            ['column_1', '=', 'value_1'],

            ['column_2', '<>', 'value_2'],

            [COLUMN, OPERATOR, VALUE],

            ...

        ])

Read More

WordPress Cheat Sheet (For Beginners & Developers)

 

Read More

WordPress Cheat Sheet (For Beginners & Developers)

 

Read More

How to partition a hard drive in Windows 10, and keep your most important files separate from the rest

 1. Press the Windows key + R on your keyboard to open the Run utility, or search for it in the Start menu.

2. Type "diskmgmt.msc" and press "OK." You can also copy and paste that from this article into the Run utility's text field.

3. A menu will appear with a list of all your hard drives. Right-click on the drive you want to partition and select "Shrink Volume."

4. You'll be asked how much you want the drive to shrink. The amount you enter will be the amount of space left for your new partition. The "total size after shrink" will be the space left in the original partition.

5. Still in the disk management utility, right-click the new box that appears at the bottom of the window — it should say much data you shrunk, and the word "Unallocated." In the right-click menu, select "New Simple Volume."

6. Follow the instructions in the New Simple Volume wizard to create the partition. This will allow you to set the partition's size, and to select the letter it will be assigned.

7. You may be asked which format you want the partition to be in. In nearly all cases, you should select "NTFS." In some other cases, like if you're trying to partition a USB flash drive, you'll want to pick "FAT32." 

Read More

How to partition a hard drive in Windows 10, and keep your most important files separate from the rest

 1. Press the Windows key + R on your keyboard to open the Run utility, or search for it in the Start menu.

2. Type "diskmgmt.msc" and press "OK." You can also copy and paste that from this article into the Run utility's text field.

3. A menu will appear with a list of all your hard drives. Right-click on the drive you want to partition and select "Shrink Volume."

4. You'll be asked how much you want the drive to shrink. The amount you enter will be the amount of space left for your new partition. The "total size after shrink" will be the space left in the original partition.

5. Still in the disk management utility, right-click the new box that appears at the bottom of the window — it should say much data you shrunk, and the word "Unallocated." In the right-click menu, select "New Simple Volume."

6. Follow the instructions in the New Simple Volume wizard to create the partition. This will allow you to set the partition's size, and to select the letter it will be assigned.

7. You may be asked which format you want the partition to be in. In nearly all cases, you should select "NTFS." In some other cases, like if you're trying to partition a USB flash drive, you'll want to pick "FAT32." 

Read More

How can we Create Multiple Where Clause Query Using Laravel Eloquent?

 I'm using the Laravel Eloquent query builder and I have a query where I want a WHERE clause on multiple conditions. It works, but it's not ingenious.

Example:

$results = User::where('this', '=', 1)
    ->where('that', '=', 1)
    ->where('this_too', '=', 1)
    ->where('that_too', '=', 1)
    ->where('this_as_well', '=', 1)
    ->where('that_as_well', '=', 1)
    ->where('this_one_too', '=', 1)
    ->where('that_one_too', '=', 1)
    ->where('this_one_as_well', '=', 1)
    ->where('that_one_as_well', '=', 1)
    ->get();

Is there a better way to do this, or should I stick with this method?

Thank you!!

You can use Conditions using Array:

$users = User::where([
       'column1' => value1,
       'column2' => value2,
       'column3' => value3
])->get();

That Will produce query like bellow:

SELECT * FROM TABLE WHERE column1=value1 and column2=value2 and column3=value3;

Conditions using Antonymous Function:

$users = User::where('column1', '=', value1)
               ->where(function($query) use ($variable1,$variable2){
                    $query->where('column2','=',$variable1)
                   ->orWhere('column3','=',$variable2);
               })
              ->where(function($query2) use ($variable1,$variable2){
                    $query2->where('column4','=',$variable1)
                   ->where('column5','=',$variable2);
              })->get();

That Will produce query like bellow:

SELECT * FROM TABLE WHERE column1=value1 and

 (column2=value2 or column3=value3) and (column4=value4 and column5=value5);

Read More

How can we Create Multiple Where Clause Query Using Laravel Eloquent?

 I'm using the Laravel Eloquent query builder and I have a query where I want a WHERE clause on multiple conditions. It works, but it's not ingenious.

Example:

$results = User::where('this', '=', 1)
    ->where('that', '=', 1)
    ->where('this_too', '=', 1)
    ->where('that_too', '=', 1)
    ->where('this_as_well', '=', 1)
    ->where('that_as_well', '=', 1)
    ->where('this_one_too', '=', 1)
    ->where('that_one_too', '=', 1)
    ->where('this_one_as_well', '=', 1)
    ->where('that_one_as_well', '=', 1)
    ->get();

Is there a better way to do this, or should I stick with this method?

Thank you!!

You can use Conditions using Array:

$users = User::where([
       'column1' => value1,
       'column2' => value2,
       'column3' => value3
])->get();

That Will produce query like bellow:

SELECT * FROM TABLE WHERE column1=value1 and column2=value2 and column3=value3;

Conditions using Antonymous Function:

$users = User::where('column1', '=', value1)
               ->where(function($query) use ($variable1,$variable2){
                    $query->where('column2','=',$variable1)
                   ->orWhere('column3','=',$variable2);
               })
              ->where(function($query2) use ($variable1,$variable2){
                    $query2->where('column4','=',$variable1)
                   ->where('column5','=',$variable2);
              })->get();

That Will produce query like bellow:

SELECT * FROM TABLE WHERE column1=value1 and

 (column2=value2 or column3=value3) and (column4=value4 and column5=value5);

Read More

Laravel Query Builder & Eloquent ORM

 An application always needs to interact with a database and Laravel makes this task hassle free. Few tools that make Laravel an awesome framework is the inclusion of “Query Builder and Eloquent ORM”. Through this blog I intend to share few quick pointers on these concepts.

 Query Builder:

In LaravelLaravel the database query builder provides an easy way to create and run database queries. It can be used to perform all the database operations in your application, from basic DB Connection, CRUD, Aggregates etc and it works on all supported database systems like a champ.

 The notable factor about query builder is that, since it uses the PHP Data Objects (PDO), we need not worry about SQL injection attacks (Make sure we don’t inadvertently remove this protection). We can avoid all those lines of code to sanitise the data before feeding it to the DB.

 So, how do we create a simple select query to fetch all values from the users table?

1	$users = DB::table('users')->get();

 DB::table is responsible to begin a fluent query against a database table. The table from which the value has to be selected is mentioned inside the brackets within quotes and finally the get() method gets the values. Similarly to fetch a single row we can modify the above code by adding a where clause

1	$user = DB::table('users')->where('name', 'shivam')->first();

Here, we are trying to fetch a row that has the value Shivam in its name column. The first() method will only return the first find. What if we need only the user id of Shivam. Instead of returning the entire result array we can simply pluck out that specific column?

1	$user_id = DB::table('users')->where('name', 'shivam')->pluck('id');

For specifying more than one column we can use the select clause

1	$users = DB::table('users')->select('name', 'email')->get();

I now believe you are getting the grip. Things get more interesting further down.

We often write queries against certain ‘where conditions’. So how do we fetch the list of users whose user_id is less than 10?

1	$users = DB::table('users')->where(id, '<', 10)->get();

Yes, we split up the operator and the operands as three parameters and feed it to the where conditions. Now we have a situation, we need to fetch all those users whose user_id falls between 10 and 20.

1	$users = DB::table('users')->whereBetween('id', array(10, 20))->get()

Laravel has the whereBetween(), whereNotBetween(), wherein() and whereNotIn() methods to which we can pass values as an array.

Why are we passing values as an array and not as comma separated parameters?

At the start of this blog I did mention about SQL injection attacks. Let’s say that the values 10 and 20 are taken as user inputs. As programmers we cannot trust what the user types into the input field. He can be a valid user who enters proper values or someone trying to enter false values and crash your DB.

1	$users = DB::table('users')->whereBetween('id', array($from, $to))->get()

Here $from and $to are user inputs. If we look in to the Laravel’s database connection class for the select() method this array is wrapped around PDO connection and it is responsible to sanitize the data before the query is executed. So you have clean queries!!

Using Query builder we can also write raw SQL queries

1	DB::select(DB::raw(“SELECT * FROM `users` WHERE name = ‘$name’ ”));

Here $name is obtained from user input. $name may contain malicious code therefore we need to alter the above code to make it SQL friendly.

1	DB::select(DB::raw("SELECT * FROM `users` WHERE `name` = :username"), array('username' => $name));

So the array value when passed through the PDO connection gets sanitized.

What is Eloquent in Laravel ?

Eloquent is object that is representative of your database and tables,in other words it’s act as controller between user and DBMS

For eg,

• DB raw query,

select * from post LIMIT 1

• Eloquent equivalent,

$post = Post::first();

$post->column_name;

What is ORM?

ORM or Object Relational Mapper is a technique to access objects without having to consider how those objects are related to their source.

What is Eloquent?

The ORM included in Laravel is called Eloquent and it enables us to work with the database objects and relationships using an expressive syntax. It is similar to working with objects in PHP. In Laravel, each database table has a corresponding “Model”. Eloquent ORM provides Active Record implementation which means that each model we create in our MVC structure corresponds to a table in our database.

Creating an Eloquent model is similar to creating a class. All the model files should be inside the app/models folder.

class Group extends Eloquent { }

All Eloquent models extends from the Eloquent class. The lower-case, plural name of the class will be used as the table name unless another name is explicitly specified. Eloquent will also assume that each table has a primary key column named “id” unless specified. We can specify a table as follows:

class Group extends Eloquent

1 2 3 4 5

{   protected $table = 'group_list';   // will point to group_list table if mentioned   }

Here, Group model will correspond to groups table (by default). We can access the data in the groups table using the basic CRUD operations.

By default Eloquent models will have auto-incrementing keys.

Create:

1 2 3 4 5 6 7 8 9 10 11

$new_group = new Group; $new_group->name = 'NewGroup'; $new_group->description = 'Awesome Group'; $new_group->save(); <read:< pre="">   <strong>// To get all groups</strong>   Group::all();   // To find a group by passing the group id etc.

1	Group::find($id);

// Try to retrieve a model by primary key else throw an exception

1 2	$model = User::findOrFail(1); $model = User::where('id', '>', 5)->firstOrFail();

Update:

// Retrieve and update

1 2 3

$group = Group::find(1); $group->name = ‘Group01’; $group->save();

// Using a WHERE clause

1	Group::where('name', '=', ‘Group01’)-date(array('name' => ‘Group1’));

// Delete one record

1 2	$group = Group::find(1); $group->delete();

// Delete several

1 2	Group::destroy(1, 2, 3); Group::where('id', '<', 10)->delete();

There are more topics to cover under Eloquent, hopefully in the next blog.

Conclusion:

It’s way of representing your database values with object you can easily use with

your application.

by: webkul.com

Read More