Posts by Matheus Hahn • 57 points
4 posts
-
1
votes1
answer696
viewsQ: Search records referencing the same table
I own a table that she owns an fk for herself. The point of this is to assemble a history of the previous records, so I have the id and id_previous column, and the previous id_fk for the id column.…
postgresqlasked Matheus Hahn 57 -
1
votes1
answer467
viewsQ: How to create a relationship between 3 Laravel tables?
I own 3 tables that it is necessary to make Join’s to access the information. By the relationship of the Laravel I can create simple relationships, like belongsTo. I’m trying to access the…
-
1
votes1
answer587
viewsQ: Laravel paging with search filter?
I have on my home screen a search filter, when I perform the search is sent by POST the filter data and I can’t get the pagination link redirected with the search filters. Every time I have filtered…
laravelasked Matheus Hahn 57 -
2
votes1
answer463
viewsQ: Optimize queries with leftJoin Laravel?
I have linked tables and when I need to access the information I recreate the query: DB::table('paciente AS pac') ->leftJoin('pessoa AS p', 'p.id', '=', 'pac.id_pessoa') ->select('p.nome,…