php - 将 mysql 结果存储在数组中(不回显)，然后使用该数组设置另一个变量

Question

我已经尝试在之前提出的其他问题中寻找解决方案(一如既往)，但我似乎无法解决这个问题。

看，我想从一个表中获取一些唯一 ID(以随机顺序)并将它们存储在一个数组中而不回显它们。然后我想在循环中使用该数组变量，这样我就可以在每次传递时递增 key ，并将另一个变量设置为该数组变量。令人困惑？我认为查看代码会更清楚。

问题是我似乎无法将查询到的值存储到数组中供以后在代码中使用。我粘贴了代码的相关部分，并用注释/* */标记指出了我的问题点。

感谢任何帮助。

<?php

include ('parse_functions.php');

if ($fetch['use_rand']=='yes')

{ $loop = 5;    
$concept = $fetch['concept'];
$countRandom = "SELECT exID FROM examples WHERE concept='$concept' ORDER BY RAND()";
$askForRandom = mysql_query($countRandom) or die(mysql_error());
/* HERE I NEED TO STORE RANDOM KEYS (exID) INTO AN ARRAY */ }

else

{  if (!empty($fetch['ex5'])) { $loop = 5; }
 elseif (!empty($fetch['ex4'])) { $loop = 4; }
 elseif (!empty($fetch['ex3'])) { $loop = 3; }
 elseif (!empty($fetch['ex2'])) { $loop = 2; }
 elseif (!empty($fetch['ex1'])) { $loop = 1; }
 else { $loop = 0; }

    }

     if ($loop!==0)

      {

         echo '<div id="examples">' . "\n";
         echo '<table class="showExample" cellspacing="0" cellpadding="0" border="0" align="center">' . "\n";

         $turns = 1;

             do {

             if ($fetch['use_rand']=='no')

              { $exID = $fetch['ex'.$turns.'']; }

             else

              { $exID = /* THIS IS WHERE I WILL USE "RANDOM VARIABLE" */; }

             $askExamples = "SELECT * FROM examples WHERE exID='$exID'";
             $getExamples = mysql_query($askExamples) or die(mysql_error());
             $sortExamples = mysql_fetch_assoc($getExamples);

             echo '<tr>' . "\n";

// ...and so on

Answer 1

如果您需要做的只是将信息存储在一个数组中，这里有一个简单的方法。

/* code 
to open
db here
*/

/* assuming you have a value for $concept */

$countRandom = "SELECT exID FROM examples WHERE concept='$concept' ORDER BY RAND()";
$askForRandom = mysql_query($countRandom) or die(mysql_error());

$Element = 0; //Array elements start at ZERO. So this is to intialise it.
while ($Fields = mysql_fetch_array($askforRandom)) //As long as there are records, get them.
    {
    //Records are retrieved one at a time. So store each one's exID in the array element
    $Data[$Element] = $Fields["exID"];
    //Soon after storing one, increment the value of the $Element variable so it is ready for the next one.
    $Element++
    }

/* now you have the data in the array. So you can do what you like with it. */

希望对你有帮助

注意:读取数组时，请确保放置条件以检查计数器是否小于 $Element。这是因为在读取最后一条记录后，$Element 增加了 1。希望这是清楚的。