Laravel / Eloquent - Column name as variable

Question

Eloquent offers a handy way of passing stuff to the database

$table_name = new TableName;
$table_name->column_name = "some data";
$table_name->save();

I've got quite a lot of data from a form that needs to be validated, so I was wondering if it was possible to replace the column name with a variable, so I can put it in some loop, and get the names and data from arrays.

$table_name->$columns[$i] = $data[$i];

(though I suppose not written in that way)

Update

In the end I've gone with the following:

$table_name = new TableName;
$nameArray=[
  1 => 'form-name-1',
  ...
];
$columnArray=[
  1 => 'column_name_1',
  ...
];

for($i=1;$i<=count($nameArray);$i++){
  if(logic logic logic) $table_name->{$columnArray[$i]} = $_POST[$nameArray[$i]];
  else $table_name->{$columnArray[$i]} = NULL;
}
$table_name->save();

If it's validation you need done then check Laravel Validation which may save you lots of ifs — apokryfos
– apokryfos, Commented Sep 15, 2017 at 9:52

apokryfos · Accepted Answer · 2017-09-15 08:12:22Z

5

You can do one these:

1) Create with values

   $table_name = new TableName([
       "column_name" => "column_value"
   ]);

2) Fill

$table_name = new TableName();
$table_name->fill([
    "column_name" => "column_value"
]);

3) The way you suggested originally:

$valuesMap = [
    "column_name" => "column_value"
];
$table_name = new TableName();
foreach ($valuesMap as $column => $value) {
       $table_name->{$column} = $value; //The {} are optional in this case
}

Note that to do 1 or 2 all fields you put in the array must be fillable and not guarded.

answered Sep 15, 2017 at 8:12

apokryfos

40.9k11 gold badges85 silver badges128 bronze badges

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

1 Comment

MrEvers Over a year ago

Thx! I've gone for a variation of the 3rd option, since I needed to add some more logic before setting the value (the logic was always the same, that's why i asked the question.

aaron0207 · Accepted Answer · 2017-09-15 08:11:32Z

1

You can use it like an associative array:

$table_name['column_name'] 
$column_name = 'column_name';
$table_name[$column_name];

Or you can loop their attributes

    foreach($table_name->getAttributes() as $value => $key){
     echo "The attr ".$key." has this value: ".$value;
    }

answered Sep 15, 2017 at 8:11

aaron0207

2,3531 gold badge20 silver badges25 bronze badges

Collectives™ on Stack Overflow

Laravel / Eloquent - Column name as variable

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related