laravel/php getting object value from request

Question

I've got basic store function in my OffersController:

public function store(Request $request)
{     
    $offer = new Offer;
    $offer->title = $request->title;
    $offer->body = $request->body;
    $offer->region = $request->region;
    $offer->user_id = auth()->user()->id; 

    $offer->save();

    $offer->specialities()->sync($request->specialities, false); 

    return response()->json([
        'created' => true
    ], 201);
}

my api request is calling OffersController store function with an object as below:

{ "title": "offer title", "body": "offer body", 
"specialities": { "lang": "en", "id": "eu33", "icon": "0",
"name": "speciality name 33" }, "region": "region1" }

this gives me an error: Internal Server Error

"message": "SQLSTATE[HY000]: General error: 1366 Incorrect 
integer value: 'pl' for column 'speciality_id' at row 1 (SQL: 
insert into `offer_speciality` (`offer_id`, `speciality_id`) 
values (59, en))",

so it seems I'm doing obvious mistake, so I correct my request:

$offer->specialities()->sync($request->specialities->id, false);

and this gives me an error:

Internal Server Error, Trying to get property of non-object.

What am I doing wrong here?

edit: table schemas:

    Schema::create('offers', function (Blueprint $table) {
        $table->increments('id');
        $table->string('title');
        $table->string('region');
        $table->mediumText('body');
        $table->integer('user_id');
        $table->timestamps();
    });

    Schema::create('specialities', function (Blueprint $table) {
        $table->increments('id');
        $table->string('name');
        $table->timestamps();
    });

    Schema::create('offer_speciality', function (Blueprint $table) {
        $table->increments('id');
        $table->integer('offer_id')->unsigned();
        $table->integer('speciality_id')->unsigned();
    });

Hussein · Accepted Answer · 2018-04-08 16:22:10Z

1

$request->specialities is array, so to access the id you say $request->specialities['id']

answered Apr 8, 2018 at 16:22

Hussein

1,1431 gold badge9 silver badges16 bronze badges

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

18 Comments

gileneusz Over a year ago

this should be good solution, but when I write: $offer->specialities()->sync($request->specialities[0]->number, false); I've got an error: "Undefined offset: 0",

Hussein Over a year ago

it's $request->specialities['id'] NOT $request->specialities[0], you access all the properties of the json object just like accessing array elements, it's an associative array with object properties being keys to the array

Hussein Over a year ago

it's ok we all were beginners

Hussein Over a year ago

$int = (int)$data['specialities'][0]['id'];

gileneusz Over a year ago

thank you for this link! this is finally works I use simply: $id= $request->input('specialities.id'); and then $offer->specialities()->sync($id, false);

|

Brian Lee · Accepted Answer · 2018-04-08 16:59:58Z

1

specialities is not being automatically hydrated from a database record, model binding only occurs when you setup the route accordingly.

It appears you're not using an unsigned integer for the specialties table primary key, given "id": "eu33", is that correct?

Try using json_decode($request->get('specialties')); first then sync to offers.

Just taking a guess here, but also doing a query for the specialities record first like:

$offer->save();

$specialties = DB::table('specialties')->where('name', $request->get('specialties')['name'])
                                       ->first();

$offer->specialities()->sync($specialities->id, false);

Hard to say though without seeing your schema.

edited Apr 8, 2018 at 16:59

answered Apr 8, 2018 at 16:24

Brian Lee

18.3k3 gold badges45 silver badges55 bronze badges

12 Comments

gileneusz Over a year ago

I'm very beginner on laravel. Let me see

gileneusz Over a year ago

I've got basic offers and specialities table with id's. And offer_speciality table with offer_id and speciality_id columns. This code works fine previously, but I had to modify my speciality into an array of objects with an id inside each object. My id is now eu33 but I can convert it into digit only id. Hope this explained something

gileneusz Over a year ago

I tried: $offer->specialities()->sync(json_decode($request->get('specialties'))->id, false); with no luck

Brian Lee Over a year ago

If you can post your table schemas it would probably help get to the answer.

gileneusz Over a year ago

why? I just want to get the id value :)

|

Collectives™ on Stack Overflow

laravel/php getting object value from request

2 Answers 2

18 Comments

12 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

18 Comments

12 Comments

Your Answer

Sign up or log in

Post as a guest

Related