PHP + MySQL: Get result from fetch array and convert to variables automatically?

Question

I was wondering. I always do fetch and then create variables when I do loop. Is there a way to do this more efficient? Like as in automatically?

Maybe something like convert_to_variable("name","description","etc") and it'll automatically set variables for me without having to do each manually? Or maybe a single command like convert_to_variable($rows) and it'll do the rest for me.

Here is what I am doing now.

$sql = "SELECT * from projects";
$rows = $db->fetch_all_array($sql);
 foreach($rows as $row) {
  $name = $row['name'];
  $description = $row['description'];
}

Something easier would be

$sql = "SELECT * from projects";
$rows = $db->fetch_all_array($sql);
 foreach($rows as $row) {
  convert_to_variable($row);
  echo $name, $description;
}

Emil Vikström · Accepted Answer · 2010-10-19 05:28:15Z

6

extract can do that for you.

answered Oct 19, 2010 at 5:28

Emil Vikström

92.3k17 gold badges144 silver badges178 bronze badges

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

Collectives™ on Stack Overflow

PHP + MySQL: Get result from fetch array and convert to variables automatically?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related