Capsule::table problem

[Davor]

Hello,

I want to get the orderId from the database based on the invoiceId directly from database using Capsule.

I don't get anything, also with try catch I don't get any errors.

Here is the code that I'm using:

use WHMCS\Database\Capsule;

$orderId = Capsule::table('tblorders')->select('id')
->where('invoiceid', $invoiceId)
->first();

 

The $invoiceId is for example 74 and there is a record in the database table tblorders that contains this invoiceId.

Can anyone see what I'm doing wrong?

 

Thanks,

Davor

 

Edited September 16, 2021 by Davor

[Davor]

Found what it was.

If anyone also is having this problem (or for my future me). My solution was to ditch the Select and get the whole row and then get the id. Here is the working code:

$orderId = Capsule::table('tblorders')
->where('invoiceid', $invoiceId)
->first();


//in the code use this to get the id
$myID = $invoiceId->id

 

[pRieStaKos]

use WHMCS\Database\Capsule;

$order = Capsule::table('tblorders')->where('invoiceid', $invoiceId) ->first();

$orderId = $order->id;

https://laravel.com/docs/5.2/queries#where-clauses

Edited September 17, 2021 by pRieStaKos

[developer _WHM_CS]

On 9/16/2021 at 2:39 PM, Davor said:

Found what it was.

If anyone also is having this problem (or for my future me). My solution was to ditch the Select and get the whole row and then get the id. Here is the working code:

$orderId = Capsule::table('tblorders')
->where('invoiceid', $invoiceId)
->first();


//in the code use this to get the id
$myID = $invoiceId->id

 

hi @Davor
You can use following Query

$orderId = Capsule::table('tblorders')
->where('invoiceid', $invoiceId)
->first()->id;

[UgurBurak]

$orderId = Capsule::table('tblorders')
->where('invoiceid', $invoiceId)
->value('id');
 

just use this. It will return directly value.