
How to return a column with different name in Laravel
How to return a column with different name in Laravel
In this session, we will try our hand at solving the "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.-
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.
If you like what you are reading, please consider buying us a coffee ( or 2 ) as a token of appreciation.
Don't forget to share this article! Help us spread the word by clicking the share button below.
We appreciate your support and are committed to providing you valuable and informative content.
We are thankful for your never ending support.
Random Code Snippet Queries: Laravel
- How to call Laravel route in jQuery
- Pagination in laravel
- Create a record if not exist in laravel
- How to avoid duplicate entries in pivot table in Laravel
- Call to undefined relationship [user] on model [App\Models\Post]
- Class 'App\Rules\Hash' not found in Laravel
- Laravel create default admin user
- Display option of select as selected with blade directive Laravel
- Retain selected value of select box in Laravel
- The openssl extension is required for SSL/TLS protection but is not available
- Add a subselect based on relationship using withAggregate method
- Use of undefined constant laravel
- Php artisan make model, factory, migration and controller in single command
- Declaration of App\Models\Post::sluggable() must be compatible with Cviebrock\EloquentSluggable\Sluggable
- How to get CSRF token in laravel controller
- SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'posts_user_id_foreign'; check that column/key exists
- How to decrypt laravel password
- Submit form without CSRF token in Laravel
- How to increment column value of table in Laravel
- Automatically remove records using Prunable trait in Laravel
- Always load the relationship data with eager loading in Laravel
- Laravel create multiple records in Pivot table
- How to customize or Change validation error messages
- How to pass external link in laravel blade to anchor tag
- Get id of last inserted record in laravel