我試圖從 mysql 數(shù)據(jù)庫中獲取隨機(jī)數(shù)據(jù)，但它只在頁面刷新時(shí)獲取同一行我嘗試運(yùn)行查詢以從 mysql 獲取隨機(jī)單行數(shù)據(jù)并使用 php 在網(wǎng)頁上顯示，但它每次只檢索同一行 $sql = "SELECT * FROM identity_explorer_demographics ORDER BY RAND() LIMIT 1<?php$link = mysqli_connect("host", "username", "password", "db_name");if($link === false){ die("ERROR: Could not connect. " . mysqli_connect_error());}$sql = "SELECT * FROM identity_explorer_demographics ORDER BY RAND() LIMIT 1";if($result = mysqli_query($link, $sql)){ if(mysqli_num_rows($result) > 0){ echo "<table>"; echo "<tr>"; echo "<th>email_md5</th>"; echo "<th>age_group </th>"; echo "<th>age</th>"; echo "<th>income</th>"; echo "<th>Income_group </th>"; echo "<th>gender</th>"; echo "</tr>"; while($row = mysqli_fetch_array($result)){ echo "<tr>"; echo "<td>" . $row['email_md5'] . "</td>"; echo "<td>" . $row['age_group'] . "</td>"; echo "<td>" . $row['age'] . "</td>"; echo "<td>" . $row['income'] . "</td>"; echo "<td>" . $row['Income_group'] . "</td>"; echo "<td>" . $row['gender'] . "</td>"; echo "</tr>"; } echo "</table>"; // Free result set mysqli_free_result($result); } else{ echo "No records matching your query were found."; }} else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);}// Close connectionmysqli_close($link);?>每次刷新頁面時(shí)，我都需要顯示隨機(jī)行數(shù)據(jù)。如果有人可以建議是最佳解決方案，那真的會很有幫助。
2 回答
白衣染霜花
TA貢獻(xiàn)1796條經(jīng)驗(yàn) 獲得超10個(gè)贊
你把它和 PHP 混在一起
$sql = 'SELECT * FROM `identity_explorer_demographics`';
//Perform query and parse result, E.G $sql = db::query($sql);
function getRandomRow($sql) {
$random_row = count(0, count($sql));
foreach($sql as $row => $result) {
if ($row == $random_row) {
return $row;
}
}
}
吃雞游戲
TA貢獻(xiàn)1829條經(jīng)驗(yàn) 獲得超7個(gè)贊
$sql = "SELECT * FROM identity_explorer_demographics ORDER BY RAND() LIMIT 1";
將行更改為
$ randomv = rand (min, max);
$sql = "SELECT * FROM identity_explorer_demographics ORDER BY $randomv LIMIT 1";
這是我在另一種情況下的實(shí)現(xiàn)，我必須從可用的隨機(jī) id 中進(jìn)行選擇 - Yii 2 Framework
$prodcutids= \app\models\TblProduct::find()->all();
$targetproduct= ArrayHelper::map($prodcutids, 'id','id');
$productdetails= \app\models\TblProduct::findOne(['id'=>array_rand($targetproduct)]);
$productseriesname= \app\models\TblSeries::findOne(['id'=>$productdetails['Serie']]);
或者，如果您有一個(gè) id 列
$sql = "SELECT * FROM identity_explorer_demographics WHERE id=$randomv LIMIT 1";
rand(min,max) min 指定將返回的最小值。max 指定要返回的最大值。
- 2 回答
- 0 關(guān)注
- 187 瀏覽
添加回答
舉報(bào)
0/150
提交
取消