Search by Queries/Bugs/Errors

How to return a column with different name in Laravel

Sometimes you have to get the column of the table with a different name. In that case you can use as in the select to get the column with a different column name.

Answers 1

Return a column with different name in Laravel using Eloquent Query Builder

$users = DB::table('users')->select('name', 'email as user_email')->get();
dd($users);

Output:

^ Illuminate\Support\Collection {#1437 ▼
  #items: array:15 [▼
    0 => {#1438 ▼
      +"name": "summer"
      +"user_email": "[email protected]"
    }
    1 => {#1441 ▶}
    2 => {#1442 ▶}
    3 => {#1443 ▶}
    4 => {#1444 ▶}
    5 => {#1445 ▶}
    6 => {#1446 ▶}
    7 => {#1447 ▶}
    8 => {#1448 ▶}
    9 => {#1449 ▶}
    10 => {#1450 ▶}
    11 => {#1451 ▶}
    12 => {#1452 ▶}
    13 => {#1453 ▶}
    14 => {#1454 ▶}
  ]
}

It will return the records from the users table with column email as user_email. Output may varies. In may case i have 15 records in my users table which return name and email as user_email after using this code snippet.

Back to code snippet queries related laravel

Bootstrap C C++ Cmd CodeIgniter Css Drupal Git Html Java Javascript Jquery Laravel Nodejs Php Python Sql Typescript Wordpress

How to return a column with different name in Laravel

Return a column with different name in Laravel using Eloquent Query Builder

Give answer to above query by entering the title (optional) and body

Random Code Snippet Queries: Laravel

How to return a column with different name in Laravel

Return a column with different name in Laravel using Eloquent Query Builder

Give answer to above query by entering the title (optional) and body

Random Code Snippet Queries: Laravel

Insert Link

Insert Image URL