Store only integer value from sql select

Question

I am trying to get only integer value (serial id) without a column name, which makes it a string. I am working in Laravel so I can use Laravel functions for SQL queries if necessary.

$idcko = DB::table('repairs')
         ->select('id')
         ->latest();

So when I print idcko I get something like {"column name": 2} Where I want only number 2.

UPDATE:

With help of answers, I came up with this idea:

$idcko = DB::table('repairs')
                                ->select('id')
                                ->orderBy('id','desc')
                                ->first()
                                ->id;

Because I was getting error that I don't have a timestamp column and I wanted to get the newest / highest id, I could do a little trick and order it by id and select only first row.

Don't Panic · Accepted Answer · 2017-04-27 19:57:36Z

1

latest() just adds an order by clause and returns the builder instance. (See the API reference.) You still need to use some fetch method to actually get any records to pull values from. Since you're trying to get a single value, you can use first() and then get the property you want from that record.

$id = DB::table('repairs')->select('id')->latest()->first()->id;

answered Apr 27, 2017 at 19:57

Don't Panic

41.9k11 gold badges70 silver badges87 bronze badges

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

5 Comments

Ady96 Over a year ago

For both answers (Samsquanch), I am getting this error:

Undefined column: 7 ERROR: column "created_at" does not exist LINE 1: select "id" from "repairs" order by "created_at" desc limit ... ^ (SQL: select "id" from "repairs" order by "created_at" desc limit 1)

Don't Panic Over a year ago

Yeah, latest() depends on you having a timestamp column. It uses created_at by default, but you can pass a different one if your timestamp column is differently named.

Ady96 Over a year ago

But I did not change name of it. Is there another way how to get the newest id if its serial type?

Don't Panic Over a year ago

I think I may have misunderstood what you're trying to do. Can you edit the question to add more context/details regarding your overall goal?

Ady96 Over a year ago

I have updated my question where I posted my solution with your help guys.

Samsquanch · Accepted Answer · 2017-04-27 20:06:24Z

1

You're just wanting to retrieve the value of the column, so use value():

$idcko = DB::table('repairs')
             ->select('id')
             ->latest()
             // ->first()      // get the first result -- may not be needed?
             ->value('id'); // or any other column name here

edited Apr 27, 2017 at 20:06

answered Apr 27, 2017 at 19:56

Samsquanch

9,17612 gold badges55 silver badges90 bronze badges

7 Comments

Don't Panic Over a year ago

Oh yeah, forgot about value(). That's better.

Samsquanch Over a year ago

@Don'tPanic Thanks for the tip on first(), I thought latest() returned a single result.

Don't Panic Over a year ago

I think you were right at first. I believe ->value('id') is a shortcut equivalent to ->first()->id

Ady96 Over a year ago

Guys, for both of your's answers, I get same error as I mentioned in comment in @Don'tPanic answer.

Samsquanch Over a year ago

@Ady96 are you sure the column you're trying to select is in the repairs table?

|

Collectives™ on Stack Overflow

Store only integer value from sql select

2 Answers 2

5 Comments

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related