如何获取数组中的随机元素以及如何从mysql中获取随机行？(how to get a random element in an array and how to get a random row fr

如何获取数组中的随机元素以及如何从mysql中获取随机行？(how to get a random element in an array and how to get a random row from mysql?)

我被要求获得用户在其物品中的相关内容

所以，就数据库创建而言，这个items表存储了类别名称，所以，我想获取类别名称并将其保存到数组中

然后执行for循环并从中获取一个随机值

之后从mysql数据库中获取一个随机行，这样任何人都知道如何做到这一点

换句话说，我想知道如何从数组和mysql中的随机行获取随机值

提前致谢。

I have been asked to get related stuff to what the user has in his items

so as far as the database was created this items table stores the category name so, i thought to get the category name and save it into an array

and then do a for loop and get one random value from it

and after that get a random row from mysql database so anyone has an idea how to do this

in other words i want to know how to get a random value from an array and a random row from mysql

Thanks in advance.

最满意答案

使用

$rand_keys = array_rand($input, 1);

有关php和mysql的示例http://php.net/manual/en/function.array-rand.php

SELECT * FROM tbl_name ORDER BY RAND() LIMIT 1

用这个

use

$rand_keys = array_rand($input, 1);

see example http://php.net/manual/en/function.array-rand.php for php and for mysql

SELECT * FROM tbl_name ORDER BY RAND() LIMIT 1

use this