带连接字符串的 PHP 变量变量名

Question

假设我有一个 mysql 查询:

$qry = "SELECT name,date,id,size from table";
$stmt = $db->query($qry);
while($r = $stmt->fetch()){
      foreach ($r as $k => $v){
          $$k = $v;
      }
}

这是有道理的并且工作得很好。它给了我变量，例如:

    $name = 'someVal';
    $date = 'someOtherVal';

假设现在我想做另一个可能有重叠字段的查询。我想在给定相同格式的变量名称前面添加一个“t_”。

$qry = "SELECT name,occupation,date from otherTable";
$stmt = $db->query($qry);
while($r = $stmt->fetch()){
      foreach ($r as $k => $v){
          $$k = $v;
      }
}

我怎样才能拥有它，以便此查询的结果为我提供带有前缀“t_”的变量名称；

 $t_name = 'someVal';
 $t_occupation = 'someOtherVal';

Answer 1

 $qry = "SELECT name,occupation,date from otherTable";
 $stmt = $db->query($qry);
 while($r = $stmt->fetch()){
    foreach ($r as $k => $v){
        $varname = "t_".$k;
        $$varname = $v;
    }
 }