$db->Execute Question

[Dave224]

Ran across the following code in the sales report plugin:

        $order_info = $db->Execute(
            "SELECT o.currency, o.currency_value, o.order_total
               FROM " . TABLE_ORDERS . " o
              WHERE o.orders_id = $oID
              LIMIT 1"
        );

Note that the php variable $oID is enclosed in the long double-quoted phrase. I always thought a query like this should be written as:

        $order_info = $db->Execute(
            "SELECT o.currency, o.currency_value, o.order_total
               FROM " . TABLE_ORDERS . " o
              WHERE o.orders_id = " . $oID . 
              " LIMIT 1"
        );

.

Does the Execute method really substitute the value of $oID for the text "$oID"?

Sorry, I can't follow the code in Execute to answer the above question.

[dbltoe]

You might want to post over on the thread for that mod.

https://www.zen-cart.com/showthread....es-report-2-0/

[carlwhat]

Ran across the following code in the sales report plugin:

        $order_info = $db->Execute(
            "SELECT o.currency, o.currency_value, o.order_total
               FROM " . TABLE_ORDERS . " o
              WHERE o.orders_id = $oID
              LIMIT 1"
        );

Note that the php variable $oID is enclosed in the long double-quoted phrase. I always thought a query like this should be written as:

        $order_info = $db->Execute(
            "SELECT o.currency, o.currency_value, o.order_total
               FROM " . TABLE_ORDERS . " o
              WHERE o.orders_id = " . $oID . 
              " LIMIT 1"
        );

.

Does the Execute method really substitute the value of $oID for the text "$oID"?

Sorry, I can't follow the code in Execute to answer the above question.

you have thought wrong. vars get evaluated in double quotes; they do not in single quotes.

if your sql statement has no vars in it, it is best to use single quotes. if there are vars in it, use double quotes as in the original code.

that would be the most efficient way to do it; although the results may not be noticeable.

best.

[swguy]

> Does the Execute method really substitute the value of $oID for the text "$oID"?

When a string is enclosed in double quotes (not single), PHP performs string interpolation.
Do a websearch on "php string interpolation" to learn more.

[Dave224]

Thank you all so much. I learn so much here. Donation on the way.
Dave