我被要求获得用户在其物品中的相关内容
所以,就数据库创建而言,这个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 1use this
更多推荐
发布评论