How to be a Senior Junior Software Engineer?

Wat a bullshit

thanks :))

i am trying to return data from two tables -same database but getting the error attached, any solutions..using laravel 5.4 because i am plugging into an old db with data from php 5.6

public function index()
{
//

$trustee = DB::table(‘trustee’);
$ltd = DB::table(‘limited_company’);
$posts = $ltd->merge($trustee)->paginate(10);

//$posts = DB::table(‘limited_company’)->paginate(10);
return view(‘index’, [‘posts’ => $posts]);

}

so how do i fix it

I just want to select all data from the tables then pass them to a variable that i can sort which data to return in my view …in SQL this is how the query looks like ::::::::::

SELECT * FROM trustee,limited_company ;

no

i am creating a search page that searchs sigle entries from both tables

i am just displaying the data

so i want to display the data from both tables no JOIN… just select from both tables

any way i can do that? select from both tables and return to view?

help me rearrange this code

public function index()
{
//

$trustee = DB::table(‘trustee’);
$ltd = DB::table(‘limited_company’);
$posts = $ltd->merge($trustee)->paginate(10);

//$posts = DB::table(‘limited_company’)->paginate(10);
return view(‘index’, [‘posts’ => $posts]);

}

please put in the code i see how it looks?

this did not work

failed

thats the error

#ask i upload laravel to hosting i got no found on my site but when i reload again i got found, the process i looping like that

419 page expired how to redirect a page

I want the group link please

failed

i have entry_id unique field

How to delete files on the server in Laravel summernote

this works but only returns 1 value to the front end yet both tables have about 20 records

view only returning 1 record

but i am not joining the two tables they have different data that is why i just want to list them on a page

they have different names but i want them to be listed on one page

Show me code pls

I know this one so where do I put in laravel

Ok

SELECT entry_id,name FROM limited_company
UNION
SELECT entry_id,name FROM trustee;

SELECT entry_id,name FROM limited_company
UNION
SELECT entry_id,name FROM trustee;

that is the sql statement returning the result i want to return

that sql is the correct one

sorry the other one was trying to explain the table

i explained the problem and what i wanted to do in the beginning

recall i said no to join

please lets do the sql query

SQL:::::::::::::

SELECT entry_id,name FROM limited_company
UNION
SELECT entry_id,name FROM trustee;

done the union

getting this error