Can i add multiple column from db at one table?

uTrx

I have some users fetching from db and shown on datatables. So far so good, every user have their name on db column called first_name. What i am asking, can i do anything to write user and first_name in one table column <th> for example

101 -> Username

kthorngren

Yes. Depending on when / where you are getting the user's name you can use columns.title or jQuery to set the th. You can use the jQuery statement in initComplete.

Kevin

uTrx

I get first name from another db like this.

Laravel Controller

$data = Student::select('user_id') ->distinct() ->get();

$aName = \DB::connection('mysql2') ->table('users') ->select('full_name', 'user') ->get();

columns:
 [
    { data: 'user_id', className: 'font-weight-bold' },
 ],

How can i use one of this options to make what i am looking for. Can you do an example with my code?

kthorngren

Here is an example:
http://live.datatables.net/savecude/1/edit

The initComplete function passes in the JSON from the Ajax response. You can get the name from one of the rows or you can add an additional object to the response with the data you want.

Kevin

uTrx

But how can i return 2 variable on json data. For now i am using this method but i can return just one variable with this

return Datatables::of($data)
            ->make(true);

And i have do return and $aName

allan

I don't know Laravel very well I'm afraid, so I suspect that you'll need to ask in a Laravel forum or Stackoverflow, but it looks to me like your JSON should contain both full_name and user properties from the above.

Can you use the debugger to give me a trace please - click the Upload button and then let me know what the debug code is.

Thanks,
Allan