I'm quite new to Laravel so I don't quite understand the eloquent and it's query syntaxes. I want to get the name field in table products from ProposalController, but the table relationships are like this: I read that I can…
When I send a query with Postman, the response looks like this: I'm pulling data like this from my 'series' table: { "id": 9770, "name": "Name of serie", "type": null, "release_date": "2021-09-30 00:00:00", "year": 2021, "genre": "4,600,2815", } I want…
I've my migrations at two different default location (database/migrations/tables/) and (database/migrations/foreign/) and i want to use the RefreshDatabase trait, however it uses the default migration location. How can i specify or override at setUp or somewhere the "path" option for…
My response looks like this: "links": { "first": "http://localhost:8000/api/tasks?page=1", "last": "http://localhost:8000/api/tasks?page=200", "prev": null, "next": "http://localhost:8000/api/tasks?page=2" }, "meta": { "current_page": 1, "from": 1, "last_page": 200, "links": [ { "url": null, "label": "« Previous", "active": false }, { "url": "http://localhost:8000/api/tasks?page=1", "label": "1",…
I'm encountering an issue while trying to connect to a SQL Server database using PHP Laravel on macOS with Brew. I'm receiving the following error message: [Microsoft][ODBC Driver 17 for SQL Server] SSL Provider: [error:0A000102:SSL routines::unsupported protocol] Checked this GitHub…
I have two tables, one is products and the other is varients. In product table I store product basic data such as name, image, brand, etc. In varients table I store variants of product such as 1kg, 2kg, 5kg, etc…
I'm encountering an issue with PhpSpreadsheet where I'm getting an "Invalid cell coordinate" error while trying to export an excel report from laravel project, Specifically with coordinates like '01'. I've checked my code and ensured that I'm using integer column…
I have two tables in my db. Table Permit ID Permit_type Max_allowed 1 Full 24 2 Half 12 3 Quarter 6 Table Entry ID User_ID User_Name Permit_type Duration Status Date 1 1 John Smith Full 6 Approved 2023-12-08 2 2…
I am new in Laravel, so maybe this is a dumb question. $param = $req->input('param'); $param = $req->param; Both of them show the same result. The first one is what i learn from most site in internet. Is there any…
When Laravel Eloquent calls a relation property that indicates the original model of the relation destination from a certain model, it issues a re-query and returns the original model. Is there a way to return the original model without issuing…