How to fetch data from database with 3 parameters Laravel

Question

I'm still new to this laravel, for now I'm facing a trouble for fetching data from the database. What i want to get is when there are only one data available, the second parameters won't be executed, but if there are some data available on the second parameters, then all the data from first parameter and the second parameter will be called.

    $detail = Barang_Keluar_Detail::findOrFail($id); //15
    $cariid = $detail->pluck('barang_keluar_id');
    $instansiquery = Barang_Keluar::where('id',$cariid)->first(); //21
    $instansiid = $instansiquery->pluck('instansi_id');
    $tanggal = $instansiquery->pluck('tanggal')->first();//2019-12-31

and the parameter are here

    $cariinstasama = Barang_Keluar::where('id', $cariid)
        ->orWhere(function ($query) use($instansiid, $tanggal) {
            $query->where('tanggal', "'$tanggal'")
            ->where('instansi_id', $instansiid);
        });

Please any help will be appreciated, thank you.

Your question is not clear actually or else you'd have definitely got an answer — Khalid Khan
– Khalid Khan, Commented Dec 16, 2019 at 7:12

R.K.Saini · Accepted Answer · 2019-12-17 18:17:11Z

6

+25

Laravel query builder provides elegant way to put conditional clause using when() . You can put conditional clause on your query like this:

$cariinstasama = Barang_Keluar::where('id', $cariid)
    ->when($instansiid, function ($query, $instansiid) {
        return $query->where('instansi_id', $instansiid);
    })
    ->when($tanggal, function ($query, $tanggal) {
        return $query->where('tanggal', $tanggal);
    })->get();

For more info see https://laravel.com/docs/5.8/queries#conditional-clauses

answered Dec 17, 2019 at 18:17

R.K.Saini

2,6981 gold badge20 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Prashant Deshmukh..... · Accepted Answer · 2019-12-17 11:53:33Z

3

You can try this as well.

$cariinstasama = Barang_Keluar::where('id', $cariid);

if($instansiid !== null)
{
   $cariinstasama->where('instansi_id', $instansiid); 
}

if($tanggal !== null) 
{
   $cariinstasama->where('instansi_id', $instansiid);
}

$result = $cariinstasama->get();

answered Dec 17, 2019 at 11:53

Prashant Deshmukh.....

2,2921 gold badge11 silver badges11 bronze badges

Comments

Samuel Bié · Accepted Answer · 2019-12-21 06:43:31Z

0

Its not clear what exactly you want.

Are you applying more than one parameter on the query if the first parameter result gives you more than one row in the database? If yes check out my approach :

$query = new Model(); // the model you want to query
if($query->where('col1', $param1)->count() > 1) // checks if the query from the 1st parameter produces more than one row in the database
     $query = $query->where( // if yes apply more parameters to the query
        [
           ['col1', $param1],
           ['col2', $param2]
        ]
     );
else
    $query = $query->where('col1', $param1);
$results = $query->get();

Hope it helps....

answered Dec 21, 2019 at 6:43

Samuel Bié

9219 silver badges11 bronze badges

Collectives™ on Stack Overflow

How to fetch data from database with 3 parameters Laravel

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related