how to create variable dynamically and pass into php built in function

Question

I have a string like this: $shortName = 'DATE,FB,DS,AK,GB,AJ,GL';

Now I want to create variables like $DATE $FB $DS $AK $GB $AJ $GL dynamically for passing these variables into bind_result() function.

here is my code

$gameQuery  = "SELECT `SHORT` FROM `game` WHERE `STATUS` = 1"
$gameStmt   =  $this->game->prepare($gameQuery);
$gameStmt   -> execute();
$gameStmt   -> bind_result($short);

$shortName = 'DATE';

while ($gameStmt->fetch()) {
   $shortName = $shortName.','.$short; 
}

echo $shortName; #output : DATE,FB,DS,AK,GB,AJ,GL

$chartQuery = "SELECT $shortName FROM `chart` WHERE MONTH(`date`) = ?";
$chartStmt  =  $this->chart->prepare($chartQuery);
$chartStmt  -> bind_param("s",$month);
$chartStmt  -> execute();
$chartStmt  -> bind_result();

Does anybody have a solution or an alternative for this ?

sorry but how ? $shortName store every $short and after while loop end i am using in other query .. — Rakesh
– Rakesh, Commented Apr 11, 2015 at 17:39
any solution ? See the answers below maybe they answer your question — Rizier123
– Rizier123, Commented Apr 11, 2015 at 17:53

Rizier123 · Accepted Answer · 2015-04-11 17:45:37Z

3

You can use extract() with explode() and array_combine() to do this:

$vars = explode(',', $shortName);
$array = array_combine($vars, $vars);
extract($vars);

Demo

explode() turn that string in an array using the comma as a separator. array_combine() creates an associative array with keys (needed for the next step). Then extract() turns each array element into a variable.

This feels convoluted but it is what you asked for.

edited Apr 11, 2015 at 17:45

Rizier123

59.8k17 gold badges106 silver badges167 bronze badges

answered Apr 11, 2015 at 17:31

John Conde

220k100 gold badges464 silver badges504 bronze badges

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

1 Comment

Rakesh Over a year ago

Sorry but how can i use this variables in bind_result() function ?

Collectives™ on Stack Overflow

how to create variable dynamically and pass into php built in function

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related