Php 如何在codeigniter中将order_by RAND与下面的代码一起使用

发布于10月07日

我有这样的代码:

$select = ['account_access_token','account_config_id'];

$where = ['where'=>['enable_marketing' => '1', 'account_config_id.id!=' => $account_table_id]];

$join
=['account_user_info'=>'account_config_id.account_user_info_id=account_user_info.id,left'];

$pages_info = $this->basic->get_data('account_config_id',$where,$select,$join);

如您所见，我希望将一个帐户加载到我的目标页面

我的问题是: 如何随机加载$Pages_INFO结果？

i tried to add : RAND(), $order_by='RAND()' but its dosen't work
every time the account id=$id is loaded with no change thanks a lot in Advanced

在搜索方面没有运气

推荐答案

Codeigniter的查询构建器的orderBy接受RANDOM作为排序方向，然后将忽略第一个参数(通常是字段名)，除非第一个参数是数字，在这种情况下，它将用于种子RAND().

$builder->orderBy('account_config_id', 'DESC');
// Produces: ORDER BY `account_config_id` DESC

$builder->orderBy('account_config_id', 'ASC');
// Produces: ORDER BY `account_config_id` ASC

$builder->orderBy('account_config_id', 'RANDOM');
// Produces: ORDER BY RAND()

$builder->orderBy(12, 'RANDOM');
// Produces: ORDER BY RAND(12)