CODEWITHSUNDEEP
phpsqlarrayslaravel
Ronan Ca
Ronan Ca

Reputation: 460

Laravel - Merge "phone" and "telephone" into the same field

I am trying to merge different column names like "phone" and "telephone" into one in Laravel.

I also want to do it for "first_name" and "firstname", etc

In my table I have rows with phone and others with telephone. Here is my line to get the data :

$landing_datas =  \App\LandingData::whereIn('landing_id', $landinds_ids)->orderBy('updated_at', 'desc');

How could I achieve what I want to do please ?

Upvotes: 0

Views: 200

Answers (1)

codedge
codedge

Reputation: 5174

If you want to merge them into one column in your database do it like described by M Khalid Junaid.

You can also define an accessor to join both numbers

public function getPhoneNumberAttribute(): string
{
    return "{$this->phone}, {$this->telephone}";
}

and then you can access it via $model->phone_number.

This, of course, is only applicable if you want to display them properly in Laravel and does not solve the issue with having them in multiple columns.

Upvotes: 2

Related Questions