I want to create a csv file from a SQL query that will fetch the information from the database of my Prestashop site. The creation works well, however an essential need for the creation of my file takes me well the head. The purpose of my file is to save the orders of the customers of the day, each line
Tag: sql
Postgres- delete record not existing in array as value referenced in another table
I am trying to write an SQL query with PostgreSQL where I want to DELETE team_member_tag table record no longer presented in the array of $tags. The parameter is found in the tag table. tag table: id slug 3742 first-tag 3743 second-tag team_member_tag table: id team_member_id tag_id 89263 68893 3742 89264 68893 3743 The catch is that I should be
Why I can’t Pass values to the database using php
I have built an ISBN generator using PHP. However, Once ISBN Number is generated it’s not stored in the database. Here is the index.php Here is the isbn.php Here is the generate-isbn.php Why the values are not passing? Save the book to the database code in the generate-isbn.php. Values are generated but only one value is stored in the database.
SQLSTATE[42000]: Syntax or access violation: 1064 you have an error in your SQL syntax
hi am trying to run a sql query but it gives this error, i have reservations column in stores table and a reservations table which has firstname,lastname or email: code: Answer remove the “,” and that will solve your problem
How to use PHP’s ” .date(‘Y-m-d’). ” in a MySQL query in Where clause?
I have cloned a movie theatre project where the movie_carousel.php uses a query to fetch movies from the MySQL database. However it doesn’t fetch any data when I run it, only when I remove the entire Where clause from the query – then it fetches the movies. I believe it has something to do with the .date(‘Y-m-d’). in the script.
Should you use prepared statments on LIMIT
One day I was googling to understand when a prepared statment should be used. As I searched online many claimed that you should use always prepared statments. Now the question I have is… does this also count for LIMIT? I mean it is possible (I tried) but is it really that rational? Same question on ORDER BY too. Answer When
how to simplify this complex query
This is an extract of one of my php functions. I’m struggling to get this optimized as is super slow, as I need to load all interview records, and then check if the current user is either assigned as user_id on the interview record, or if the user->id is in the interviews shared_user_ids which is json I’m also using PostgreSQL
Laravel Eloquent where statement returns no attributes
So from my previous post, I was advised to start using Eloquent models, which I did. My end goal, is to print out specific gifts, that belongs to that specific box. Migrations: gift_items: gift_campaigns: Pivot table: Controller: Error that I receive using this way: Seems like the updated version is trying to call the gift_campaigns table id, instead of the
Date range loop into bbdd
I want to make different tables from 2 variables: start date and end date. Example: input start= 05/07/2022 input end= 07/07/2022 so, when I submit the form I want this result: ddbb: id:01 05/07/2022 id:02 06/07/2022 id:03 07/07/2022 I tried this but I got the dates displace, like this: id:01 06/07/2022 id:02 07/07/2022 id:03 08/07/2022 This is the code: Answer
showing contents of a table using PHP in HTML
I have this code snippet: and both inside submit.php, however, while the feedback table inside judges database is not empty, I don’t see any of the rows shown in the HTML page only the column name shows up in the Response tab of Network tab in Firefox Inspect tool. What do you suggest to populate the existing database into the