I have created a PHP function that calculates how old a WordPress/WooCommerce order is. If the order is older than 90 days it should be canceled. The function used to work perfectly. However, since the new year 2020, it has…
I have a column of dates written as strings with "am" and "pm" at the end, for example: 1/1/2016 12:00:00.000 AM The type of the column is currently varchar, I want to change the type to datetime format. Attempt 1…
I have this simple code, which used to work correctly before: <?php $dateFormatted = MessageFormatter::formatMessage( 'en_US', "{0, date, d MMMM YYYY}", [new DateTime()] ); var_dump($dateFormatted); // 28 December 2019 But from Dec 29th, 2019 it shows next year's date: var_dump($dateFormatted);…
I'm looking for a way to give free shipping on all orders based on weekday of the order. So if someone places an order (let's say on Monday) it will give him free shipping no matter what type of order…
I have faced a problem. I need to get a specific product purchase date using the user id and product id. Using "Checking if customer has already bought something in WooCommerce" answer code, it checks all product in the following:…
I have a MySQL table which has a column called "created_at" which is a TIMESTAMP field. Whenever I try to insert datetime bigger than 2037 I get the following error: #1292 - Incorrect datetime value: '2039-06-18 16:54:35' for column 'created_at'…
I'm looking to run a query that gets all rows that occur on a specific date. For example, the query should return both of these entries, if I want all entries that occured on 2019-03-21. Any ideas on how to…
I have a table of records of wildlife sightings for different animals. Each row in the table is a record card containing columns for the different animals that it is possible to see, plus an ID column and a DateSeen…
We had a lot of price changes recently, and I just changed the prices on our basic 1.9 magento store. Now I wish to be able to sort out products based on: latest price change/ latest changed by date/time. So…
The issue is the cPanel Error message. I have a PHP script that auto shows (Sara Smile Is * Years of Age), and I have in (.htaccess) the line (AddType application/x-httpd-php .html), and that runs properly, however cPanel is giving…