PHP Variable in a string in a string

Question

I am attempting to echo a sting containing a variable already stored in a variable. Essentially I am building a class that can dynamically build tables based on a changing number of columns. I need get my db field names into the foreach loop before the foreach loop that has my db results, and then iterate over them in the loop. The problem is I have to store them in a loop prior to the db results loop; which is not recognizing it as a variable and just giving me a plain text '$row['myVar']'.

How can I get this to recognize the variable in the second loop?

$sqlVarNames = explode(', ', $sqlVar);
foreach ($sqlVarNames as $columnVar) {
    $finalColumnVars .= '<td>\'. $row[\''.$columnVar.'\'] .\'</td>';
}

and then into my second loop

foreach ($sqlResult as $row) {
    echo '<tr>';
    echo $finalColumnVars;
    echo '</tr>';
}

I tried all sorts of escape sequences on my $finalColumnVars and can't seem to get it to output the variable instead on plain text.

Here is what I get with the above code

<td>'. $row['client_name'] .'</td>

Is this possible?

This returns '<td></td>'. I'm guessing because $row isn't anything in the first loop. — Milksnake12
– Milksnake12, Commented Aug 27, 2014 at 4:01
seems like you want to parse/execute/substitute php code from a string. perhaps some string substitution can help you here. — pushpraj
– pushpraj, Commented Aug 27, 2014 at 4:03
'<td>'. $columnVar.'</td>' will be ok here. Because $row is defined nowhere. — arunrc
– arunrc, Commented Aug 27, 2014 at 4:05
$columnVar is the db field name that needs to go in $row['$columnVar']. '<td>'. $columnVar.'</td>' would just output the field name and not it's contents. — Milksnake12
– Milksnake12, Commented Aug 27, 2014 at 4:07

Rasclatt · Accepted Answer · 2014-08-27 03:58:27Z

4

$sqlVarNames = explode(', ', $sqlVar);
foreach ($sqlVarNames as $columnVar) {
    $finalColumnVars .= '<td>'.$row[$columnVar].'</td>';
}

answered Aug 27, 2014 at 3:58

Rasclatt

12.5k3 gold badges28 silver badges33 bronze badges

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

2 Comments

Milksnake12 Over a year ago

This returns '<td></td>'. I'm guessing because $row isn't anything in the first loop.

Rasclatt Over a year ago

Ya you have to wrap the one foreach inside the other foreach

pushpraj · Accepted Answer · 2014-08-27 04:05:26Z

1

here is how you can merge these two loop and get the desired.

$sqlVarNames = explode(', ', $sqlVar);
foreach ($sqlResult as $row) {
    echo '<tr>';
    foreach ($sqlVarNames as $columnVar) {
        echo '<td>'. $row[$columnVar] .'</td>';
    }
    echo '</tr>';
}

answered Aug 27, 2014 at 4:05

pushpraj

13.7k3 gold badges38 silver badges52 bronze badges

Collectives™ on Stack Overflow

PHP Variable in a string in a string

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related