Setting a mysql column value to be the name of a php variable

Asked Sep 20 '18 at 12:51

Active Sep 20 '18 at 14:59

Viewed 26 times

I have a MySQL table named global_variables with three columns id, name, value. I'd like to loop through all rows and make the name column the name of the variable and the value column its value. Sample data row 1

`id`='1'
`name`='age'
`value`='35'

row 2

`id`='2'
`name`='gender'
`value`='Male'

Here is my code

$result = $db->query("SELECT `name`, `value` FROM `global_variables`");
while($row = $result->fetch_array()){
    $$row['variable_name'] = $row['variable_value'];
}
echo $age; //This should display 35
echo $gender; //This should display Male

The problem is in the while loop at $$row['variable_name']. How do implement naming a variable using the name column and assigning its value as the value column?

edited Sep 20 '18 at 14:59

Brian

3,850
3
21
37

asked Sep 20 '18 at 12:51

Slimfresh

Use `${$row['variable_name']}` – Madhur Bhaiya Sep 20 '18 at 12:54
2

Using variable variables is generally a bad idea. Consider using an array instead. – Patrick Q Sep 20 '18 at 12:54
1

'variable_name' and 'variable_value' are not defined/part of the SELECT – Jeff Sep 20 '18 at 12:55
Thanks guys the problem has been solved. I'll consider your advice – Slimfresh Sep 20 '18 at 13:15

Setting a mysql column value to be the name of a php variable

0 Answers0