PHP variable variable names with concatenated string

Question

Lets say I have a mysql query:

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

This makes sense and works fine. It gives me variables such as:

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

Let's say now I want to do another query that may have fields that overlap. I want to prepend a "t_" to the variable name given the same format.

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

How can i have it so this query's results give me varaible names with an prepended "t_";

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

$kk in your first example must be $$k, same in third code block — Hamboy75
– Hamboy75, Commented Feb 4, 2017 at 8:43

bart2puck · Accepted Answer · 2017-02-04 08:41:34Z

2

 $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;
    }
 }

answered Feb 4, 2017 at 8:41

bart2puck

2,5203 gold badges33 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hamboy75 · Accepted Answer · 2017-02-04 08:45:30Z

0

just change

$$k = $v;

for

$$("t_".$k) = $v;

It will work.

answered Feb 4, 2017 at 8:45

Hamboy75

1,1241 gold badge13 silver badges28 bronze badges

Collectives™ on Stack Overflow

PHP variable variable names with concatenated string

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related