Getting array keys instead of the value with Laravel

Question

I'm getting a problem while I want to loop through an array and display it with Laravel blade engine

My controllers code is like this

    $table =  DB::table('tables')->select('id')->where('name', strtolower($name))->first();

    $columns =  Column::where('table_id', $table->id)->get();

    foreach ($columns as $col) {
        $data[] = $col->col_name;
    };

    $content = DB::table($name)->select(...$data)->get();


    return view('back.group.view-table', compact('content', 'columns', 'data'));

And my blade view code is like this

<table class="table table-striped">
            <thead>
                <tr>
                    @foreach($columns as $column)
                        <th>{{ $column->dis_name }}</th>
                    @endforeach
                </tr>
            </thead>
            <tbody>
                @foreach ($content as  $value)
                    <tr>
                        
                        @for ($i = 0; $i < count($columns); $i++)
                            <td>{{ $value->key = $data[$i] }}</td>
                        @endfor
                        
                    </tr>
                @endforeach
                
            </tbody>
        </table>

This is the result which I get with the following code:

The result I want to have:

$content as $value then {{ put here your array index name }} — Aman Kumar
– Aman Kumar, Commented Mar 2, 2017 at 9:52

Nicolas · Accepted Answer · 2017-03-02 09:52:48Z

4

php has a function called array_keys();

so it looks something like this I think

$results = DB::table($name)->select(...$data)->get();
$content = $results->first();
$keys = array_keys($content->toArray());

this will get you the keys. If you need the keys from each result just loop over $results and for each $result get the keys, using the array_keys syntax.

answered Mar 2, 2017 at 9:52

Nicolas

4,78621 gold badges55 silver badges87 bronze badges

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

1 Comment

Jeff Puckett Over a year ago

There's now also a laravel collection method simply called keys

online Thomas · Accepted Answer · 2017-03-02 09:53:59Z

1

Another solution would be using array_flip() it will flip the keys and values around.

answered Mar 2, 2017 at 9:53

online Thomas

9,4887 gold badges52 silver badges94 bronze badges

Comments

Aman Kumar · Accepted Answer · 2017-03-02 09:51:13Z

0

Change like this

<table class="table table-striped">
     <thead>
       <tr>
        @foreach($columns as $column)
          <th>{{ $column->dis_name }}</th>
        @endforeach
        </tr>
      </thead>
      <tbody>
      @foreach ($content as  $value)
      <tr>
         <td>{{ $value->name }}</td>
      </tr>
      @endforeach

     </tbody>
</table>

answered Mar 2, 2017 at 9:51

Aman Kumar

4,5573 gold badges21 silver badges40 bronze badges

6 Comments

Eth0 Over a year ago

I know that and i alredy did it but i want the users to get automatically the columns wich are coming from a table selected by the user if u understand

Aman Kumar Over a year ago

here foreach loop already do same thing what you want ... once check this

Eth0 Over a year ago

what i mean is if the table user has columns id username email etc etc i want to be displayed dynamiclly because he will select another table after with different columns ex. products id name price etc etc thats why i want that to be dynamic

Aman Kumar Over a year ago

first check $content array value by print_r if loop have more than one value then loop automatically repeat printing tr with its value ...

Eth0 Over a year ago

Collection {#196 ▼   #items: array:2 [▼     0 => {#194 ▼       +"onomateponimo": "Mukja Eluert"       +"email": "[email protected]"       +"kinito": "123456789"     }     1 => {#190 ▼       +"onomateponimo": "Eluert "       +"email": "[email protected]"       +"kinito": "123456789"     }   ] }

|

LF-DevJourney · Accepted Answer · 2017-03-02 09:56:19Z

0

use array_keys() to get all the keys from an array, you also can use foreach($arr as $key => $value)

answered Mar 2, 2017 at 9:56

LF-DevJourney

28.7k30 gold badges170 silver badges321 bronze badges

Comments

Eth0 · Accepted Answer · 2017-03-02 10:25:46Z

I Found the answer i just change my view from this

<table class="table table-striped">
        <thead>
            <tr>
                @foreach($columns as $column)
                    <th>{{ $column->dis_name }}</th>
                @endforeach
            </tr>
        </thead>
        <tbody>
            @foreach ($content as  $value)
                <tr>

                    @for ($i = 0; $i < count($columns); $i++)
                        <td>{{ $value->key = $data[$i] }}</td>
                    @endfor

                </tr>
            @endforeach

        </tbody>
    </table>

To this

<table class="table table-striped">
            <thead>
                <tr>
                    @foreach($columns as $column)
                        <th>{{ $column->dis_name }}</th>
                    @endforeach
                </tr>
            </thead>
            <tbody>
                @foreach ($content as  $value)
                    <tr>

                        @foreach ($data as $key)
                            <td>{{ $value->$key }}</td>
                        @endforeach

                    </tr>
                @endforeach

            </tbody>
        </table>

Jayant Pingua · Accepted Answer · 2021-05-07 13:08:15Z

-1

$hayStack = ['name' => 'John', 'age' => 30, 'sex' => 'm'];
$searchValue = 30;
$keyName = array_keys($hayStack, $searchValue)[0];

array_keys() will search all possible keys containing search value. Considering $hayStack to be an array, there won't be any duplicate key, so our result will be at index 0.
For search value is 30, result will be 'age'. Here array_keys is an inbuilt function https://www.php.net/manual/en/function.array-keys.php

edited May 7, 2021 at 13:08

answered Apr 17, 2021 at 21:47

Jayant Pingua

11 bronze badge

1 Comment

santamanno Over a year ago

Hey welcome to SO! Please explain your solution and ideally add references to the docs. I don't think the poster can understand it as you wrote it.

Collectives™ on Stack Overflow

Getting array keys instead of the value with Laravel

6 Answers 6

1 Comment

Comments

6 Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

Comments

6 Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related