create a variable name for existing variable in php

Question

Hi i have a variables that names are

$variable1='content1' , $variable2='content2' , $variable3='content3';

and i need to loop for using that contents and index for that; example;

$index=3;
for($i=0;$i<=$index;$i++){

  $sql="insert into table values("'variable'.$i,$i")on duplicate key update variable=values(variable),controlValueThatIs$i=values(controlValueThatIs$i)";
  $mysqli_query($con,$sql);
}

Is that work?

INSERT has no WHERE clause. Perhaps you want UPDATE instead? — jarlh
– jarlh, Commented Nov 23, 2015 at 10:03
for the sake of god don't use mysql_ anymore, it's deprecated and not safe, use mysqli_ instead. Here's a LINK, if you want to change — Lino
– Lino, Commented Nov 23, 2015 at 10:05
actually im using insert or update and mysqli_query in my original code but im trying to explain my problem in easy way so there is some code mistakes — Furkan
– Furkan, Commented Nov 23, 2015 at 10:08

rain · Accepted Answer · 2015-11-23 10:10:43Z

2

you can try this

$str = 'variable'.$i;

echo $$str;

answered Nov 23, 2015 at 10:10

rain

2431 silver badge8 bronze badges

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

1 Comment

Furkan Over a year ago

It inserts to database like '$variable1' not content of variable1 :(

Manoj Salvi · Accepted Answer · 2015-11-23 10:14:48Z

2

the problem is quote (') you should use it along with whole variable name like this -

values("'variable".$i."')

answered Nov 23, 2015 at 10:14

Manoj Salvi

2,7991 gold badge19 silver badges21 bronze badges

Collectives™ on Stack Overflow

create a variable name for existing variable in php

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related