Pluck id (integer) cast to string Laravel

Question

While plucking from a database, I get id as strings.

$alphabets = new Alphabet();
return $alphabets->pluck('name', 'id');

Output

{
    "1": "Apple",
    "2": "Ball",
    "3": "Cat"
}

Expected

{
    1: "Apple",
    2: "Ball",
    3: "Cat"
}

But, when I reverse ID and name,

return $alphabets->pluck('id', 'name');

I get id as integer.

{
    "Apple": 1,
    "Ball": 2,
    "Cat": 3
}

I'm not sure what's happening behind the scene. But how can I get ID in integer ? Actually, old flash session doesn't set value because of 1 vs "1" in Form Collective.

{!! Form::select('alphabet', $alphabets, null, ['class' => 'form-control', 'multiple' => true]) !!}

Dharmesh Rakholia · Answer 1 · 2017-06-28T11:33:56.107

7

Try this code

$alphabets = new Alphabet();
return $alphabets->all()->pluck('name', 'id');

Alphabet.php

You should cast your columns like this.

  protected $casts = [
    'id' => 'integer',
    'name' => 'string' 
  ];

edited Jun 28 '17 at 11:33

answered Jun 28 '17 at 11:11

Dharmesh Rakholia

1,210
9
22

Sagar Chamling · Accepted Answer · 2017-09-14T07:36:11.003

3

I think I found the answer here.

https://laracasts.com/discuss/channels/laravel/pluck-id-integer-cast-to-string

Here I found JSON only allows key names to be strings.

Using number as "index" (JSON)

{
    "1": "Apple",
    "2": "Ball",
    "3": "Cat"
}

Actually, I want to achieve it for Form Collective. It was a bug and it's PR has been merged now.

https://github.com/LaravelCollective/html/pull/368#pullrequestreview-46820423

edited Sep 14 '17 at 07:36

answered Jun 28 '17 at 12:37

Sagar Chamling

1,038
1
12
26

1

How can we do it when pluck values from a pivot table where the values come always as int? – JS_LnMstr Sep 16 '21 at 10:27

score 1 · Answer 3 · answered Jun 28 '17 at 11:22

1

you also convert key into int

 $alphabets = new Alphabet();
    $alphaArr =$alphabets->pluck('name', 'id');
    foreach($array as $key => $value) {
       $newArray[(int) $key] = $value;
    }

answered Jun 28 '17 at 11:22

Shailesh Ladumor

7,052
5
42
55

I've tried that too but the result is the same. Txs – Sagar Chamling Jun 28 '17 at 12:09

Sagar Gautam · Answer 4 · 2017-06-28T11:32:03.993

0

Usually, pluck() method gives you associative array of values in string values.

So, try using select statements like this:

$data = Alphabet::select('id','name')->get()->toArray();

This will give you following result:

array:3 [▼
  0 => array:2 [▼
    "id" => 1
    "name" => "Apple"
  ]
  1 => array:2 [▼
    "id" => 2
    "name" => "Ball"
  ]
  2 => array:2 [▼
    "id" => 3
    "name" => "Cat"
  ]
]

Now, using simple loop you can get your expected array.

$expected = array();

foreach($data as $d){
    $expected[$d['name']] = $d['id'];
}

dd($expected);

edited Jun 28 '17 at 11:32

answered Jun 28 '17 at 11:19

Sagar Gautam

9,049
6
53
84

1

that's the second case of my question this works but it is not expected result. – Sagar Chamling Jun 28 '17 at 12:14

score 0 · Answer 5 · answered Jun 30 '17 at 18:02

Adding this line fix the old session issue of LaravelCollective/Html.

|| in_array((string) $value, $selected, true)

/**
 * Determine if the value is selected.
 *
 * @param  string $value
 * @param  string $selected
 *
 * @return null|string
 */
protected function getSelectedValue($value, $selected)
{
    if (is_array($selected)) {
        return in_array($value, $selected, true) || in_array((string) $value, $selected, true) ? 'selected' : null;
    } elseif ($selected instanceof Collection) {
        return $selected->contains($value) ? 'selected' : null;
    }
    return ((string) $value == (string) $selected) ? 'selected' : null;
}

Pluck id (integer) cast to string Laravel

5 Answers5

Linked