Home / Questions / 125520
Accepted
lucho
Asked: 2020-12-19 04:29:20 +0800 CST 2020-12-19 04:29:20 +0800 CST

Why is formatting with brackets saved in my database when querying text from a combobox in Laravel?

  • 772

I try to obtain the text of a combobox from the controller, so I make a query to the database with the value of the combobox obtained, but when saving it does so with the following format ["Plant I"] (I don't know why it saves me with brackets and quotes I just want the text). The controller code is as follows

$idpiso=$request->get('pisoroom');
      $nombrepiso=DB::table('levels')->where('id',$idpiso)
      ->pluck('nombre');
$rooms=Room::create([
         'ubicacion'=>$nombrepiso
        ]);
laravel

1 Answers

  1. Best Answer

    The problem is given because the where function returns an array, so it saves it with the format [value] since you indicate that you are going to leave only the name of all the fields, when you call pluck ('name')

    If you do the following you will realize what I mean:

    $nombrepiso = (string)DB::table('levels')->where('id',$piso)->pluck('nombre');
dd($nombrepiso);

    So in order for you to get what you want, you only have to call the first function since it is understood that you only want 1 and if you search for the id, this being almost always the primary key, you will only find 1. Therefore, when doing this:

    $idpiso=$request->get('pisoroom');
$nombrepiso = (string)DB::table('levels')->where('id',$piso)->pluck('name')->first();
$rooms=Room::create([ 'ubicacion'=>$nombrepiso ]);

    You can now save the name as expected. I hope you resolve this.

    • 3