{"id":10076,"date":"2021-06-07T11:10:35","date_gmt":"2021-06-07T02:10:35","guid":{"rendered":"https:\/\/www.gigas-jp.com\/appnews\/?p=10076"},"modified":"2021-06-07T11:18:36","modified_gmt":"2021-06-07T02:18:36","slug":"laravel-adding-custom-data-to-eloquent-result","status":"publish","type":"post","link":"https:\/\/www.gigas-jp.com\/appnews\/archives\/10076","title":{"rendered":"[Laravel] Adding custom data to eloquent result"},"content":{"rendered":"\n

Sometimes, we want to add more custom data to our eloquent result before passing to blade or doing further logic improvements. Today we will be focusing how to add custom data to our eloquent result.<\/p>\n\n\n\n

I assume you already know laravel framework in this article as we will not covering from scratch of laravel framework. First let’s make a posts<\/strong> table. Here is the migration file.<\/p>\n\n\n\n

Schema::create('posts', function (Blueprint $table) {\n  $table->id();\n  $table->string('name');\n  $table->string('description');\n  $table->timestamps();\n});<\/code><\/pre>\n\n\n\n
In our post table, we will have these columns in above. And we gonna add a data record. You can add manually using database clients or you can of course make a seeder class to add dummy data like this<\/p>\n\n\n\n
DB::table('posts')->insert([\n  'name' => Str::random(10),\n  'description' => Str::random(100),\n  'created_at' => date('Y-m-d H:i:s'),\n]);<\/code><\/pre>\n\n\n\n
Lets go to our controller and select the data with all<\/strong> method and print the result with dd <\/strong>function.<\/p>\n\n\n\n
$data = Post::all();\ndd($data);<\/code><\/pre>\n\n\n\n
The output will be look like this.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Now , let’s try to add a new column called category_id<\/code> and user_id<\/code> to that eloquent results. We can achieve this using map<\/strong> function.<\/p>\n\n\n\n
$data = Post::all();\n\n$data->map(function ($result) {\n  $result->category_id = 1;\n  $result->user_id = 2;\n  return $result;\n});\n\ndd($data);<\/code><\/pre>\n\n\n\n
And the result will be look like this. Please remember there are two arrays called attributes<\/code> which is the one we customized and added the data. And there is also original<\/code> array which contains only original data from eloquent. <\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Anyhow, we can access our created data using map like always. For further more to customize the eloquent results , please check out here<\/a>.<\/p>\n\n\n\n
dd($data[0]->category_id.','.$data[0]->user_id);\n\/\/result -> 1,2<\/code><\/pre>\n\n\n\n
If you need to loop through many data, you can use loop functions but in this case I just added a 0 index to get data easily.<\/p>\n\n\n\n
By Yuuma<\/p>\n
\n            
<\/g:plusone><\/div>\n            
 \"\u3053\u306e\u30a8\u30f3\u30c8\u30ea\u30fc\u3092\u306f\u3066\u306a\u30d6\u30c3\u30af\u30de\u30fc\u30af\u306b\u8ffd\u52a0\"<\/a>