I use the official woocommerce booking plugin and I try do get the quantity of all persons that have booked a product. for a single order that's no problem with: if ( is_callable( 'WC_booking_Data_Store::get_booking_ids_from_order_id') ) { $booking_data = new WC_booking_Data_Store();…
I have a list of different channels that could potentially bring users to a website (organic, SEO, online marketing, etc.). I would like to find an efficient way to count daily active user that comes from the combination of these…
I'm trying to get the posts count inside my product category page loop (Woocommerce), but it just doesn't work. Does anyone knows why? Woocommerce uses the same file archive-product.php for displaying both Shop Page and Product Category Page. In my…
This query lists out the distinct order numbers in Woocommerce that have order either of two products, where the orders are in a status called 'wc-on-hold'. The query does work, but if I comment back in the AND COUNT(t1.ID)=2 it…
I just upgraded my PHP Version from 5.6 to 7.4. I used count() function in my page, example: $watch_server_count = count($watch_server); if ($watch_server_count > 0) { foreach ($watch_server->table as $key=> $watch_server_rows) { } } Warning: count(): Parameter must be an…
I have the following array with sub arrays [0] through [9]. I want to test the array and see if there is One sub array or more than one. Why? Because sometimes I get one record back from some tables…
I've copied the W3 schools code for performing a mysqli row count function, but when I input my variables, the returned result is always '1'. I have checked my SQL code by entering it directly into phpMyAdmin, which returns the…
I have the following JSON that comes back from an API: { "Statement": [{ "Sid": "Group1", "Resource": "arn:aws:ecs:*:777744445555:task-rendition/${aws:PrincipalTag/Service}-*:*", "Effect": "Allow" }, { "Sid": "Group2", "Resource": [ "arn:aws:ecs:*:777744445555:task-definition/${aws:PrincipalTag/Service}-*:*", "arn:aws:ecs:*:777744445555:task-petition/${aws:PrincipalTag/Service}-*:*", "arn:aws:ecs:*:777744445555:task-fruition/${aws:PrincipalTag/Service}-*:*" ], "Effect": "Allow" } ]} When I apply these commands I…
I have the next query to get the 15 most sold plates in a place: This query is taking 12 seconds to execute over 100,000 rows. I think this execution takes too long, so I am searching a way to…
I'm trying to gather "followers" for a specific user (#1 in this code). I'm doing my primary select from followers as the column following will have user #1 and followers.userid will have the userid of the person doing the following.…