Laravel 4: custom select query

Question

I use Laravel DB::select to return specific data from DB,

the problem is only one row return when use print_r($result)

    $questions = DB::select('
            select text
            from question 
            where id in (?) 
            order by field(id,?)',
            array($question_ids_list_str,$question_ids_list_str));


    print_r($questions);

how to return the rest of results? thanks,

There is no rest of results apparently. This method returns array of stdObjects representing each row. Btw why do you use this instead of query builder, that's easier to use? — Jarek Tkaczyk
– Jarek Tkaczyk, Commented Aug 31, 2014 at 10:06
You should make sure what $question_ids_list_str contains. If it contains only one id or one existing id in database, select won't return more rows — Marcin Nabiałek
– Marcin Nabiałek, Commented Aug 31, 2014 at 10:08
@MarcinNabiałek $question_ids_list_str contains list of ids , tested — Ted
– Ted, Commented Aug 31, 2014 at 10:15
@JarekTkaczyk_deczo_ I use this way cause I work on DB with too many tables :( — Ted
– Ted, Commented Aug 31, 2014 at 10:16
@mwafi I have no idea what you mean by that. I wasn't talking about Eloquent, but query builder: DB::table('question')->whereIn('id', $ids)->orderBy(DB::raw('field(id,'.implode(',',$ids).')'))->get(); — Jarek Tkaczyk
– Jarek Tkaczyk, Commented Aug 31, 2014 at 11:49

The Alpha · Accepted Answer · 2014-09-01 00:29:20Z

2

You may try something like this:

$ids = array(1, 2, 3); // Pass the ids in whereIn clause
$questions = DB::table('question')
               ->whereIn('id', $ids) 
               ->orderBy('id')
               ->get(array('text')); // Only get text field

answered Sep 1, 2014 at 0:29

The Alpha

147k30 gold badges294 silver badges313 bronze badges

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

1 Comment

Ted Over a year ago

this is working fine, but what is the wrong in DB::select, force it to retrieve only 1 row?

score 0 · Accepted Answer · 2014-09-01 10:47:43Z

0

Try this:

$questions = DB::select('
        select text
        from question 
        where id in (?) 
        order by field(id,?)',
        array($question_ids_list_str,$question_ids_list_str));
foreach($questions as $question) {
    echo $question;
}

edited Sep 1, 2014 at 10:47

answered Aug 31, 2014 at 13:29

user3900721

Collectives™ on Stack Overflow

Laravel 4: custom select query

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