this is the result of a Foreach loop get method using dd$($value),
Questions: how do i convert this inside my controller into an array and store it into my database
Example: [Lead_id1=Subjectid1 , Lead_id2=Subjectid1, Lead_id3=Subjectid1] so on and so fort..
Note: Lead_id and Subject_id are both FK there for the value must be integer Not String
Controller:
public function store(Request $request)
{
$value=$request->all();
$subjects = $value['Subject_id'] ?? [];
$leads = $value['Lead_id'] ?? [];
$data = [];
foreach ($subjects as $subject) {
$data[] = array_combine($leads, array_fill(0, count($leads), $subject));
$scores=new Score;
$scores->Subject_id=$request->input('Subject_id');
$scores->Lead_id=$request->input('Lead_id');
dd($scores);
$scores->save();
}
Score Model
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class Score extends Model
{
protected $guarded = [
'id',
'Year_id',
'Term_id',
'Level_id',
'Classes_id',
'Subject_id',
'Lead_id',
];
}
You said Lead_id and Subject_id
both are foreign key then you can simply use ManyToMany relation in laravel and save the data accordingly
Subject Model
class Subject extends Model{
public function leads(){
return $this->belongsToMany(Lead::class, 'scores', 'Subject_id', 'Lead_id');
}
}
Lead Model
class Lead extends Model{
public function subjects(){
return $this->belongsToMany(Subject::class, 'scores', 'Lead_id', 'Subject_id');
}
}
Questions: how do i convert this inside my controller into an array and store it into my database
foreach($data['Subject_id'] as $subjectId){
$subject = Subject::find($subjectId);
$leadids = $data['Lead_id'];
$subject->leads()->attach($leadids);
}
For details check this https://laravel.com/docs/5.6/eloquent-relationships#many-to-many
You can try -
$temp = [];
$subject = !empty($value['Subject_id'][0]) ? $value['Subject_id'][0] : null; // extract the subject id
// Loop through lead ids
foreach($value['Lead_id'] as $lead) {
$temp[$lead] = $subject; // store subject id fro lead ids
}
You may try following :
public function store(Request $request)
{
$value=$request->all();
$subjects = $value['Subject_id'] ?? [];
$leads = $value['Lead_id'] ?? [];
$data = [];
foreach ($subjects as $subject) {
$data[] = array_combine($leads, array_fill(0, count($leads), $subject));
}
foreach ($data as $load => $subject) {
$scores = new Score;
$scores->Subject_id = $subject;
$scores->Lead_id = $load;
$scores->save();
dd($scores);
}
}
convert the array first into a json string
json_encode($array);
before store it to the database