Php function returns with no value

Question

I have this table (wp_woocommerce_order_itemmeta):

And this table (wp_woocommerce_order_items):

I'm using a function (functions.php) which returns these item id's in an array:

function retrieve_orders_ids_from_a_product_id( $product_id, $order_date ) {
global $wpdb;

$table_posts = $wpdb->prefix . "posts";
$table_items = $wpdb->prefix . "woocommerce_order_items";
$table_itemmeta = $wpdb->prefix . "woocommerce_order_itemmeta";

// Define HERE the orders status to include in  <==  <==  <==  <==  <==  <==  <==
$orders_statuses = "'wc-processing'";

# Requesting All defined statuses Orders IDs for a defined product ID
$orders_ids = $wpdb->get_col( "
    SELECT DISTINCT $table_items.order_id
    FROM $table_itemmeta, $table_items, $table_posts
    WHERE  $table_items.order_item_id = $table_itemmeta.order_item_id
    AND $table_items.order_id = $table_posts.ID
    AND $table_posts.post_status IN ( $orders_statuses )
    AND $table_itemmeta.meta_key LIKE '_product_id'
    AND $table_itemmeta.meta_value LIKE '$product_id'
    AND $table_itemmeta.meta_key LIKE 'order_date'
    AND $table_itemmeta.meta_value LIKE '$order_date'
    ORDER BY $table_items.order_item_id DESC"
);
// return an array of Orders IDs for the given product ID
return $orders_ids;
}

And I call it inside my page:

<?php $orders_ids_array = retrieve_orders_ids_from_a_product_id($getid, $order_date); ?>

I'm 100% sure that $getid ($getid = product_id) and $order_date has the exact value which I from my db.

But if I print_r the array it returns with:

Array ( )

instead of any value.

Finally I need to count these id-s, but if doesn't return anything it looks impossible to me.

Can you run your sql statement inside phpmyadmin or Sequel Pro or something? To troubleshoot it. — JakeParis
– JakeParis, Commented Jan 11, 2018 at 18:39
Okay, without the order_date it works and gives back the id's. And I think I know what was my problem. — MysticUnicorn
– MysticUnicorn, Commented Jan 11, 2018 at 19:03

JakeParis · Accepted Answer · 2018-01-11 18:41:00Z

1

It looks like

 AND $table_itemmeta.meta_value LIKE 'order_date'

should be

 AND $table_itemmeta.meta_key LIKE 'order_date'

answered Jan 11, 2018 at 18:41

JakeParis

11.2k6 gold badges44 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

MysticUnicorn Over a year ago

Yeah I fixed it, but still didn't gives me back any value

MysticUnicorn · Accepted Answer · 2018-01-11 19:08:40Z

0

Okay, it has 2 problems. First:

 AND $table_itemmeta.meta_value LIKE 'order_date'

should be

 AND $table_itemmeta.meta_key LIKE 'order_date'

and the second is the $order_date is always refreshed because my foreach() loop.

answered Jan 11, 2018 at 19:08

MysticUnicorn

12814 bronze badges

Collectives™ on Stack Overflow

Php function returns with no value

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related