Skip to content

Laravel Relationship Getting All Children

I have a query which returns a table. I would like to also return a list of styles which relate to it from another table. I have tried many things but I can’t find one which works. Any advice? Query: YarnOrderLines: YarnOrderLineStyles (table with relating styles in I would like to pull in) Answer You&#…

Use explode on array?

What’s the easiest way to turn the array into Is there something built-in with laravel/collections that I can use? I know I can make a foreach loop and use explode and populate a new array, but I’m wondering if there is a built-in function in PHP or a laravel collections method I can use. Answer I…

PHP odbc_exec not returning all rows

This simple query when run in DBExplorer (a DB tool for executing raw SQL queries), returns 5 rows (contents of an invoice). Everything is setup in such a way that an invoice may contain multiple goods of the same ID (but with different prices and procurement prices, printing names – e.g. bucket-white, …

How to Install Swagger to Laravel 8 API for documentation?

Installing Swagger for the First Time in laravel 8 Getting Error like: Answer I’m guessing the URL you’re hitting might be incorrect. Change it to just docs/api-docs instead of docs/api-docs.json. In addition, if you haven’t ran the generate command already, you would have to do so to make i…

In laravel, how do I generate an array of counts?

For example, I have several orders, and each order is related to a zone(there are 10 zones). I want the number of orders for each zone so 10 rows. Something like this: Select count(*) as aggregate …