SQLSTATE[HY093]: Invalid parameter number: mixed named and positional parameters

Please format your code blocks properly and provide more information.

Which of your two queries is causing the problem?

this queries

$d= $data['som'];

$data['impot']=DB::table('baremes')->where('revenubrut','=',$d)->select('trimf')->get();

What does $data['som'] contain ?

@SNAPEY - it contain that : $data['som']=salaries::selectRaw('(salairebase + sursalaire) as total')->where('salaries.id', $request->id)->get();

So it contains a collection (assuming that query is executed)?

and you are trying to use this array in a where statement

->where('revenubrut','=',$d)

That will be a problem.

If you want a single string value, try

data['som']=salaries::selectRaw('(salairebase + sursalaire) as total')
              ->where('salaries.id', $request->id)->first()->total();

@SNAPEY - hi! i do that but have this error Call to undefined method Illuminate\Database\Query\Builder::total()

sorry, remove last brackets after total

@SNAPEY - thank's very match it's ok

@SNAPEY - can you help me fix the query?

    $d=salaries::selectRaw('(salairebase + sursalaire) as total ->where('salaries.id', $request->id)->first()->total;

  $im=salaries::selectRaw('(nombreparts) as  total')->where('salaries.id', $request->id)->first()->total;

    $data['impot']= DB::table('baremes')
       ->where(" ('revenubrut','=',$d){
           if($im='2.5') -> {select('deuxs')}
           or if($im =1') { ->select('un')}
           or if($im='1.5') { ->select('uns')}
            or if($im='2') { ->select('deux')}
           or if($im='3') { ->select('trois')}
           or  if($im='3.5') { ->select('troisplus')}


          }")->get();