使用数组从MySql收集数据并创建变量

Question

I am collecting a lot of data-strings from a MySql database. The data has to be used on various different places on my website. So I would like for each string collected from my database to be assigned to its own variable. I don't want to write the same piece of code over and over again. Therefore, I want to use an array in order to collect all the strings and create specific variables in the process. Below is what I have.

    $tableName = "fruits";
    $variablesArray = array(
                    "Apple",            
                    "Banana",   
                    "Coconut",          
    );

    foreach($variablesArray as $val) {
      $query = "SELECT * FROM {$tableName} WHERE ID = '{$val}'";
      $result = mysqli_query($conn, $query) or die('error');
      while($data = mysqli_fetch_array($result)) {
        For ($n = 0; $n < 1; $n++){
          ${'$val'} = $data["COLORS"];
        }
      }
      echo ${'$val'};
      echo "</br>";
    }        

In the above, I am using the ID's of the database in the array to collects the data from my database. This echoes "Green", "Yellow", "Brown".

What I would like however, is to make three variables:

• $Apple = "Green"
• $Banana = "Yellow"
• $Coconut = "Brown"

The above code doesn't create these. I am unsure of how to use the ${'$val'} in order to achieve this. I have tried creating associative arrays as well, but I was not able to get what I wanted. I was hoping someone here could point me in the right direction. Thanks!

Answer 1

Your problem (not necessarily the only one) lies in ${'$val'};

Single quote strings will not parse variables, so your variable is quite literally called '$val'

Use $$val

${"$val"}; would also be valid as double quote strings do parse variables. In simple cases like this however, it is unnecessary to use the quotes, as $val is already a string, and unnecessary to use the curly braces, as there are no other parts of the string you want to separate the variable from.