duandai7601 2017-07-28 14:29
浏览 37
已采纳

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

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!

  • 写回答

1条回答 默认 最新

  • drqyxkzbs21968684 2017-07-28 14:40
    关注

    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.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 labview程序设计
  • ¥15 为什么在配置Linux系统的时候执行脚本总是出现E: Failed to fetch http:L/cn.archive.ubuntu.com
  • ¥15 Cloudreve保存用户组存储空间大小时报错
  • ¥15 伪标签为什么不能作为弱监督语义分割的结果?
  • ¥15 编一个判断一个区间范围内的数字的个位数的立方和是否等于其本身的程序在输入第1组数据后卡住了(语言-c语言)
  • ¥15 游戏盾如何溯源服务器真实ip?
  • ¥15 Mac版Fiddler Everywhere4.0.1提示强制更新
  • ¥15 android 集成sentry上报时报错。
  • ¥50 win10链接MySQL
  • ¥15 抖音看过的视频,缓存在哪个文件