PHP string as array key for mysqli_fetch_array

Question

I am trying to use a variable (string) as array key for a mysql select query in PHP script.

Here is the PHP code:

$newskill="'".$skill."_!skill'";
//$newskill="'Working_!skill'"; //Will be written into the var in the line above

$skill = array();
$time = array();

while($row = mysqli_fetch_array($getSkills))
{
   $skill[] = $row[$newskill];
   $time[] = $row['updated_at'];
}

I am getting this error:

Notice: Undefined index: 'Working_!skill' in ....\htdocs\skill\skilldiagram.php on line 71

But it works this way: Nothing changed but the content of the variable is printed hardcoded into the source code. This way it works perfectly fine.

$skill = array();
$time = array();

while($row = mysqli_fetch_array($getSkills))
{
   $skill[] = $row['Working_!skill'];
   $time[] = $row['updated_at'];
}

Barmar · Accepted Answer · 2015-01-31 13:15:56Z

2

You don't need the literal quotes in $newskill. It should be:

$newskill=$skill."_!skill";

answered Jan 31, 2015 at 13:15

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

1 Comment

JustRandom Over a year ago

Works ty. That was fast and I feel like an idiot now :)

Collectives™ on Stack Overflow

PHP string as array key for mysqli_fetch_array

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