Skip to content

Instantly share code, notes, and snippets.

@gorlovka

gorlovka/random-record-from-model.php

Forked from vyspiansky/random-record-from-model.php
Created November 10, 2016 06:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save gorlovka/e729adf2abfd0d7ef63694e937afcf08 to your computer and use it in GitHub Desktop.
Save gorlovka/e729adf2abfd0d7ef63694e937afcf08 to your computer and use it in GitHub Desktop.
Download ZIP
Yii: how can I get random values from model
Raw
random-record-from-model.php
<?php
// Source: http://goo.gl/NOCJKM
$max = Table::model()->count(array(
'condition' => 'status<:status',
'params' => array('status' => Table::STATUS_A)
));
// Should query min value too
$offset = rand(0, $max);
$object = Table::model()->find(array(
'condition' => 'status<:status',
'params' => array('status' => Table::STATUS_A),
'offset' => $offset,
'limit' => 1
));
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment