Random value from database column but only one time in Laravel

Question

My database query return random row from database. Is there any way when page load and return this random string when user refresh the page to not change the string?

So this is my controller

public function view() {

    $view = View::orderByRaw("RAND()")->limit('1')->get();          

    return View::make('site.view', [
            'view' => $view
        ]);
}

And in my blade I have

@foreach($view as $rand) 
  {{ Form::open() }}
      {{ $rand['my_view'] }} 

       // bunch of form fealds
       <button type="submit" class="btn btn-primary">Submit</button>
  {{ Form::clode() }}
@endforeach

So here user got random string and need to fill the form and add also this string. Then I save all information in database. Everything is saved perfectly in database. The problem is that user can refresh multiple time table after he submit form and can get confused when he see another random string...

Dekel · Accepted Answer · 2016-10-05 15:07:27Z

1

~~Option #1 - save the data you got from the View::make to a session and return it~~:

public function view() {
    $rand_view = Session::get('rand_view');
    if (!$rand_view) {
        $view = View::orderByRaw("RAND()")->limit('1')->get();

        $rand_view = View::make('site.view', [
            'view' => $view
        ]);

        Session::put('rand_view', $rand_view);
    }
    return $rand_view;
}

Option #2 - for a specific user - always generate the same "random":

public function view() {
    // To make sure we generate the same RAND() we generate a random seed for each user and we save that seed in the session for that user.
    $rand_seed = Session::get('rand_seed');
    if (!$rand_seed) {
        $rand_seed = mt_rand();
        Session::put('rand_seed', $rand_seed);
    };

    $view = View::orderByRaw("RAND({$rand_seed})")->limit('1')->get();          

    return View::make('site.view', [
        'view' => $view
    ]);
}

Update

After some debugging it seems like option #1 will not work because View::make returns an object that can't be serialized. If you need this solution use option #2

edited Oct 5, 2016 at 15:07

answered Oct 5, 2016 at 12:59

Dekel

62.9k12 gold badges109 silver badges130 bronze badges

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

8 Comments

S.I. Over a year ago

Thanks for the answer. I certainly need Option #1 and tried it but I've got Exception: Serialization of 'Closure' is not allowed

S.I. Over a year ago

Do I need to change foreach loop in my view? @foreach($view as $rand) ...

S.I. Over a year ago

Sorry, in option #1

S.I. Over a year ago

There is nothing in app/storage/logs/laravel.log nothing like empty.. I've deleted current log and reloaded the page -> this error 500 doesn't generate error log

S.I. Over a year ago

Also I have in app/config/app.php: 'debug' => true,

|

Shadow · Accepted Answer · 2016-10-05 10:34:59Z

0

Just save the random data into a session variable a display the contents of the session variable if it is present. Just do not forget to unset the variable when it is no longer needed.

answered Oct 5, 2016 at 10:34

Shadow

34.5k10 gold badges67 silver badges76 bronze badges

Collectives™ on Stack Overflow

Random value from database column but only one time in Laravel

2 Answers 2

Update

8 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Update

8 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related