I have Product and Booking entity and I’m trying to select products that aren’t already booked in a given period. In other words, to select available products during a given period. To make myself understandable, see the schema below. I only want to select product that have a booking like #1 or #5 since it is available. If a product
Tag: doctrine
SQL : get number of user but order date [closed]
I trying to get how many user i got in a precise day compared to the first order for exemple : “2020-02” = 20, “2020-03” = 20 … etc… I did an sql query like that : SELECT o….
Can someone suggest a way to do this query using Doctrine (QueryBuilder) with multiple “where” clause?
I’m new to the QueryBuilder and I’m trying to do a POST request (with a JSON) to retrieve some informations in my database. I’m using array because each property can have several values. Here’s the JSON I’m currently sending : Here’s my database : The request I would like to have : And what I have currently done in Symfony,
How do I get Id in the URL to display comments with Symfony 5?
I’m coding a blog with Symfony 5 and I have issues getting the Id from the URL to display comments from my Database. To sum up : – I have a view “/fiche/{id}” wish displays specific game informations. – People can leave a comment below, the comment goes in Database with a foreign Key named “jeu_id” wish is the game
Syntax message in sql
I have a problem i don’t realy know how to fix, I took this sql when i exported my database in localhost, but when i try to create the User Table for my site in Production i get this Error message. I thought it was because je ‘Json’ format for the ‘role’ but when i change it to ‘array’ i
SQL How do I query a many-to-many relationship
How do I select posts that contain a specific tag if there is a many-to-many relationship between posts and tags? The problem I am having is that because of the where tag.name = ‘xxx’, only that tag is selected. I want to select all posts that have the tag specified, together with all of their tags, e.g., Currently what I