How to get an element in each row from a complete array in Laravel?

Question

I'm inserting a group of elements in database, I'm trying to get one element for each row but I'm obtaining all elements in one row and every row from the database is repeated like this

I would like to get one element for row in the column.. I'm using this query

$data = DB::table('incidencias')
   ->join('clientes_incid', 'clientes_incid.rif', '=', 'incidencias.rif')
   ->select('incidencias.rif')
   ->distinct()
   ->get();

    foreach ($data as $val) { 
    DB::table('clientes_view')->insert(['resultado' => $data]);

How could I fix it?

TsaiKoga · Accepted Answer · 2020-01-14 02:32:55Z

2

Because you are inserting the $data instead of $val,

You can get all $data, and insert them at once, like this:

$data = DB::table('incidencias')
   ->join('clientes_incid', 'clientes_incid.rif', '=', 'incidencias.rif')
   ->select('incidencias.rif AS resultado')
   ->distinct()
   ->get();
// If you are using Eloquent, you can just use ->toarray();
// For query builder, you need to change stdClass to array, so I use json_decode()
$data = json_decode(json_encode($data, true), true);

DB::table('clientes_view')->insert($data);

updateOrInsert only supports one record, so if you want to use this method:

$data = DB::table('incidencias')
   ->join('clientes_incid', 'clientes_incid.rif', '=', 'incidencias.rif')
   ->select('incidencias.rif AS resultado')
   ->distinct()
   ->get();
$data = json_decode(json_encode($data, true), true);
forEach($data as $val) {
    DB::table('clientes_view')->updateOrInsert($val, $val);
}

edited Jan 14, 2020 at 2:32

answered Jan 14, 2020 at 1:50

TsaiKoga

13.4k2 gold badges23 silver badges31 bronze badges

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

7 Comments

Laravel Oscar Over a year ago

Im getting this error Object of class stdClass could not be converted to string

Laravel Oscar Over a year ago

I think that I have to invoke the class because I got this error Call to undefined function App\Http\Controllers\ATC\json_ecode() Which class do I have to invoke?

TsaiKoga Over a year ago

@LaravelOscar sorry, that's my mistake, It's json_encode()...

TsaiKoga Over a year ago

@LaravelOscar u'r welcome, updateOrInsert only support to one record, if you want to use this method, you need to loop it, like foreach ($data as $val) { Model::updateOrInsert($val, $val)

TsaiKoga Over a year ago

@LaravelOscar I have post it.

|

Collectives™ on Stack Overflow

How to get an element in each row from a complete array in Laravel?

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related