I have a database that holds stock levels for certain items that are supplied by different suppliers. Each supplier sends me a daily CSV file with their current stock levels. I am trying to update the stock levels into my…
They are newbie to docker. Get phpmyadmin, php, home assistant working. But I can't configure the docker well to be able to connect from php to a database. Could you help me see what the problem is. I tried everything.…
Currently, I have a grid of employees photos on a webpage. Each employee has an IN and OUT photo. They are named firstname_here.jpg and firstname_away.jpg respectively. When I click on a photo it toggles between the two. This is just…
I designed a database model on MySQLWorkbench. Then, I export the model to generate a SQL script. Finally, when I import it in MariaDB PhpMyAdmin it raises errors like : #1067 - Invalid default value for 'created' MariaDB version :…
so I'm currently working on some Statistics. for that, I need 3 datetimes one between 7:50 and 8:10, one between 11:50 and 12:10, and one between 14:50 and 15:10. SELECT * FROM sensor WHERE zone = 5 and updated >='2020-08-12…
We are in the middle of refactoring a custom-built middleware/API from Python 2 to 3. The software is responsible for creating and updating categories, products, listings, orders, stock, etc. on many different platforms (like ebay, amazon, shopware) by data exported…
I want to change date format in my PHP MySQL but could not change. echo ($row->PasscreationDate);?> PasscreationDate is the date I want to change it appear default as YYYY-MM-DD HH-MM-SS, I want to change that date format as DD-MM-YYYY.
I have a MariaDB query that I am using in my Laravel application and I would like it to return 7 columns. When I dump the resultant array with PHP it seems to only be returning 4. However when I…
So to make my project GDPR friendly, I have to remove all customer data after 90 days. This is how the sales table looks like (the input is just for example), using phpMyAdmin: | ID | CUSTOMER | EMAIL |…
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html We can see that some functions do not like incomplete dates: Some date functions can be used with “zero” dates or incomplete dates such as '2001-11-00', whereas others cannot. I want to subtract two dates like this: SELECT DATEDIFF(CURRENT_DATE(),…