Laravel Eloquent: inserting data

Question

I am sending a bunch of data through post method. For now I am using a fully working solution:

$dataClient = new Client;
$dataClient->name    = $post['client']['name'];
$dataClient->address = $post['client']['address'];
...
$dataClient->save();

I am wondering if there is a shorter solution? Like posting an array and Laravel could map keys to db fields?

What if you would add something more, like calculated value upon?

Example:

$dataClient = new Client;
Then map array keys to db keys
$dataClient->someField = someCalculatedValue 
$dataClient->save();

Thank you in advance.

I would prefer Eloquent. This way I can keep relations and e.g. date created. — be-codified, Jul 01 '15 at 18:35

score 20 · Accepted Answer · answered Jul 01 '15 at 20:41

You have quite a few options when it comes to creating models from a data array. If you want to directly insert it into the database, the easiest way is create()

Client::create($post['client']);

If you want to change some things afterwards or just not save it right away, just pass your data to the constructor.

$client = new Client($post['client']);
$client->someField = 'some value';
$client->save();

And finally, the last option, calling fill() manually. This method is used internally for create() as well as in the constructor.

$client = new Client();
$client->fill($post['client']);
$client->save();

Note: for all methods above you'll need to set up the fillable attributes in your model. This is to protect against malicious user input (request data).

protected $fillable = ['name', 'address', 'etc'];

More information about Mass Assignment

lukasgeiter thank you for your answer. Can you give me another example for mass assignment vulnerability? — be-codified, Jul 02 '15 at 08:52
Here's a simple one: let's say you have a field `is_admin`. Now you would pass the request data right to the model and it would just save all the values anybody could make themselves admin just by manipulating the request data and adding `is_admin=1` — lukasgeiter, Jul 02 '15 at 08:58

score 8 · Answer 2 · answered Jul 01 '15 at 18:06

8

Eloquent has create and update methods which will insert massive data. For example :

inputs = ['name' => 'value','address' => 'value'];
Client::create(inputs)

It will automatically map fields in Eloquent.

answered Jul 01 '15 at 18:06

Phi Nguyen

3,046
14
26

2

You need to watch out for guarded/fillable – Sean Routledge Jul 02 '15 at 04:46

Poncho · Answer 3 · 2015-07-01T18:33:28.230

2

Have you tried something like this?

$dataClient = new Client;
$dataClient->fill($client);
$dataClient->save();

Depending on how you set up your Client model and what fields you set as guarded/fillable, the fill method will automatically map the data with their respective fields.

edited Jul 01 '15 at 18:33

answered Jul 01 '15 at 18:15

Poncho

746
1
6
12

score 1 · Answer 4 · edited Apr 25 '23 at 17:29

1

DB::table('nodes')->insertGetId(
  [
    'name' => $name,
    'walletaddress' => $wallet,
    'datecreated' => '11'
  ]
);

edited Apr 25 '23 at 17:29

Tyler2P

2,324
26
22
31

answered Apr 25 '23 at 10:40

Emmanuel Iyen-Mediatrees

159
8

1

Your answer could be improved by adding more information on what the code does and how it helps the OP. – Tyler2P Apr 25 '23 at 17:28
The above code helps to insert data into database using the DB library...it inserts and gets the id as response..thank you – Emmanuel Iyen-Mediatrees Aug 06 '23 at 09:31

Laravel Eloquent: inserting data

4 Answers4

Linked