Laravel-5 how to populate select box from database with id value and name value

Question

I want to create a select box like the one below using illuminate html     lt select gt       lt option value   item- gt id  gt  item- gt name lt  option gt       lt option value   item- gt id  gt  item- gt name lt  option gt   lt  select gt    In my controller I tried this   public function create          items   Items  all   id    name          return view  prices create   compact  id    items         And in my view this    lt div class  form-group  gt          Form  Label  item    Item                Form  select  item id    items  null    class    gt   form-control         lt  div gt    The issue is that instead of  item- gt name is displaying all the info of the entity

User · Answer

Laravel 5 3  use pluck  value   key     value is displayed in your drop list and  key is id  controller   products   Product  pluck  name    id     return view  main index   compact  products       view     Form  select  id    products  null    class    gt   form-control

User · Answer

I was trying to do the same thing in Laravel 5 8 and got an error about calling pluck statically  For my solution I used the following  The collection clearly was called todoStatuses    lt div class  row mb-2  gt       lt label for  status  class  mr-2  gt Status  lt  label gt         Form  select  status                     todoStatuses- gt pluck  status    id                     null                     placeholder    gt   Status        lt  div gt

User · Answer

Laravel use array for Form  select  So I passed array like below    datas   Items  lists  name    id     items   array     foreach   datas as  data         items  data- gt id     data- gt name     return  View  make  your view   compact  items   items      In your view    lt div class  form-group  gt          Form  label  item    Item                Form  select  item id    items  null    class    gt   form-control         lt  div gt

User · Answer

Controller    campaignStatus   Campaign  lists  status    id      compact  campaignStatus   will result in   id  status     example  1     pending    return view  management campaign index   compact  campaignStatus       View      Form  select  status    campaignStatus  array  class    gt   form-control

User · Answer

For Laravel 5     items   Items  lists  name    id      Push an item onto the beginning of the collection    items- gt prepend  value   key   null

User · Answer

Sorry for the late reply   Obviously lists method has been deprecated in Laravel  but you can use the pluck method    For Eg   Laravel 5 7  public function create          countries    Country  pluck  country name   id        return View  make  test new  - gt with  countries    countries       and in the view if you are FORM components just pass as      Form  select  testname   countries null   class    gt   required form-control select2   id   gt  testname         if will generate the dropdown  but i have a situation to show that select country as the first option and as null value   lt option value    selected  selected  gt --Select  Country-- lt  option gt    so I have referred to   https   stackoverflow com a 51324218 8487424   and fixed this  but in later times if I want to change this I hate being changing it in the view  So have created the helper function  based on https   stackoverflow com a 51324218 8487424  and placed in the  Country Model  public static  function toDropDown  tableName     nameField     idField     defaultNullText  --Select--         if   idField    null                 idField  id               listFiledValues   DB  table  tableName - gt select  idField  nameField - gt get                  selectArray                  selectArray null     defaultNullText              foreach   listFiledValues as  listFiledValue                                  selectArray  listFiledValue- gt  idField     listFiledValue- gt  nameField                            return  selectArray              and in controller  public function create                countries   Country  toDropDown  countries   name   id   --Select  Country--          return View  make  test new  - gt with  countries    countries           and finally in the view       Form  select  testname   countries null   class    gt   required form-control select2   id   gt  testname         and the result is as expected  but I strongly recommend to use pluck   method

User · Answer

Laravel provides a Query Builder with lists   function  In your case  you can replace your code   items   Items  all   id    name       with   items   Items  lists  name    id      Also  you can chain it with other Query Builder as well    items   Items  where  active   true - gt orderBy  name  - gt lists  name    id      source  http   laravel com docs 5 0 queries selects    Update for Laravel 5 2   Thank you very much  jarry  As you mentioned  the function for Laravel 5 2 should be   items   Items  pluck  name    id      or   items   Items  where  active   true - gt orderBy  name  - gt pluck  name    id      ref  https   laravel com docs 5 2 upgrade upgrade-5 2 0  -- look at Deprecations lists

User · Answer

To populate the drop-down select box in laravel we have to follow the below steps   From controller we have to get the value like this    public function addCustomerLoyaltyCardDetails             loyalityCardMaster   DB  table  loyality cards  - gt pluck  loyality card id    loyalityCardNumber            return view  admin AddCustomerLoyaltyCardScreen  - gt with  loyalityCardMaster   loyalityCardMaster           And the same we can display in view     lt select class  form-control  id  loyalityCardNumber  name  loyalityCardNumber   gt          foreach   loyalityCardMaster as  id   gt   name                                                    lt option value     name    gt    id   lt  option gt          endforeach   lt  select gt    This key value in drop down you can use as per your requirement  Hope it may help someone

User · Answer

I have added toArray   after pluck   items   Item  get  - gt pluck  name    id  - gt toArray        Form  select  item id    null  gt  Please Select      items

User · Answer

Many has been said already but keep in mind that there are a times where u don t want to output all the records from the database into your select input field       Key example I have been working on this school management site where I have to output all the noticeboard categories in a select statement  From my controller this is the code I wrote   Noticeboard   groupBy  - pluck  category  - get      This way u get distinct record as they have been grouped so no repetition of records

User · Answer

Just change your controller to the following   public function create          items   Subject  all   id    name         return View  make  your view   compact  items   items        And your view to    lt div class  form-group  gt        Form  Label  item    Item           lt select class  form-control  name  item id  gt       foreach  items as  item         lt option value     item- gt item id    gt    item- gt id   lt  option gt       endforeach    lt  select gt   lt  div gt    Hope this will solve your problem

User · Answer

In your controller  add   public function create          items   array           itemlist    gt   DB  table  itemtable  - gt get                 return view  prices create    items       And in your view  use   lt select name  categories  id  categories  class  form-control  gt     foreach  itemlist as  item       lt option value      item- gt id     gt     item- gt name    lt  option gt     endforeach  lt  select gt    In select box  it will be like this    lt select gt    lt option value  1  gt item1 lt  option gt    lt option value  2  gt item2 lt  option gt    lt option value  3  gt item3 lt  option gt        lt  select gt

User · Answer

Try this one  Without using controller     Form  select  apartment id    App Apartment  all  - gt pluck  apartment name    apartment id  - gt toArray    null   class   gt  select2 form-control    multiple   gt  multiple   required   id    gt   apartment id

User · Answer

Laravel  gt   5 3 method lists   is deprecated use pluck    items   Items  pluck  name    id         Form  select  items    items  null    class    gt   some css class         This will give you a select box with same select options as id numbers in DB for example if you have this in your DB table  id name 1  item1 2  item2 3  item3 4  item4  in select box it will be like this  lt select gt   lt option value  quot 1 quot  gt item1 lt  option gt   lt option value  quot 2 quot  gt item2 lt  option gt   lt option value  quot 3 quot  gt item3 lt  option gt   lt option value  quot 4 quot  gt item4 lt  option gt   lt  select gt   I found out that pluck now returns a collection  and you need to add - gt toArray   at the end of pluck   so like this  pluck  name    id  - gt toArray

User · Answer

Laravel 5    In your controller    items  Items  pluck  name    id  - gt toArray    return view  your view   compact  items    items      In your view      Form  select  organization id    items  null

[php] Laravel-5 how to populate select box from database with id value and name value

Examples related to php

Examples related to laravel

Examples related to laravel-5

Examples related to blade