UC知道PHP随机从数据库读取N条数据
来源：百度知道 编辑：UC知道 时间：2024/05/17 01:34:13
以下代码怎么做出读出 30条随机数据，谢谢了
<?php
include_once('e/class/config.php');
foreach ($_REQUEST['id'] as $val) {
$musicarray[] = $val;
}
$musicnum = sizeof($musicarray);
?>
<?php
echo 'var urlht="';
if(sizeof($musicarray)>0) {
$conn = mysql_connect($phome_db_server, $phome_db_username, $phome_db_password);
mysql_select_db($phome_db_dbname);
foreach ($musicarray as $key=>$val) {
$sql = 'SELECT * FROM phome_ecms_wma WHERE id='.intval($val);
mysql_query("set names gbk"); $result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
if ($row) {
echo ''.$row['playpath'].'';
}
}
mysql_close($conn);
}
echo '";';
?>
<?php
include_once('e/class/config.php');
foreach ($_REQUEST['id'] as $val) {
$musicarray[] = $val;
}
$musicnum = sizeof($musicarray);
?>
<?php
echo 'var urlht="';
if(sizeof($musicarray)>0) {
$conn = mysql_connect($phome_db_server, $phome_db_username, $phome_db_password);
mysql_select_db($phome_db_dbname);
foreach ($musicarray as $key=>$val) {
$sql = 'SELECT * FROM phome_ecms_wma WHERE id='.intval($val);
mysql_query("set names gbk"); $result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
if ($row) {
echo ''.$row['playpath'].'';
}
}
mysql_close($conn);
}
echo '";';
?>
不用从页面取id
去掉foreach
$sql="select * from phome_ecms_wma order by rand() limit 30"
就行了
$sql='SELECT * FROM phome_ecms_wma ORDER BY rand() LIMIT 30 '
$sql="select * from phome_ecms_wma order by rand() limit 30"
同意：hemu780924
$sql="select * from phome_ecms_wma order by rand() limit 30"
但是数据量大的话速度就慢了。