Getting Service ID from Order Number

[Jordan0361]

Hi there, I'm trying to get the service ID from the hook ShoppingCartCheckoutCompletePage

add_hook('ShoppingCartCheckoutCompletePage', 1, function(array $params) {
    $orderNumber = $params['ordernumber'];
    $serviceId = Capsule::select("
        SELECT tblorders.ordernum, tblhosting.orderid, tblinvoiceitems.relid
        FROM tblorders
        RIGHT JOIN tblhosting
        ON tblorders.id = tblhosting.orderid
        RIGHT JOIN tblinvoiceitems
        ON tblorders.id = tblinvoiceitems.relid
        WHERE tblorders.ordernum = $orderNumber
    ");

What am I doing wrong? Any help would be appreciated 🙂

[Jordan0361]

I've returned the data $serviceId as a var_dump and I get this:

 

array(2) { [0]=> object(stdClass)#940 (3) { ["ordernum"]=> int(4508992543) ["orderid"]=> int(25) ["relid"]=> int(25) } [1]=> object(stdClass)#937 (3) { ["ordernum"]=> int(4508992543) ["orderid"]=> int(25) ["relid"]=> int(25) } }