PHP variable name in mysql query

Question

$resultSystem = mysql_query("SELECT * FROM templates where templateId = 1");
while($row = mysql_fetch_assoc($resultSystem))
{
$Part1 = $row["Part1"];
}

$name = "Peter";
echo $Part1;

In my database $Part1 results in $name. I would like the code to print the name "Peter", however it prints $name. How do I make PHP print the value of the variable?

senK · Accepted Answer · 2014-02-13 12:31:47Z

2

if $Part1 = 'name';

$name ="Peter";

Then

echo $$Part1 will print "Peter"

answered Feb 13, 2014 at 12:31

senK

2,8021 gold badge30 silver badges38 bronze badges

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

2 Comments

winkbrace Over a year ago

I prefer for clarity ${$Part1}

TheOneWhoPrograms Over a year ago

woah, I've never thought this kind of thing was possible :o... yep... over 6 years of programming, and I didn't know this small trick... -.-

Andrius Naruševičius · Accepted Answer · 2014-02-13 12:31:44Z

0

Use function eval() like

eval("echo $Part1");

However, be very careful so the users don't launch malicious code.

answered Feb 13, 2014 at 12:31

Andrius Naruševičius

8,6289 gold badges53 silver badges83 bronze badges

Collectives™ on Stack Overflow

PHP variable name in mysql query

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