Using one Array Value As Another Array Key PHP MySQL

Question

I want to use a value from one array as the key for another as part of a MySQL replace statement. I tried the code below but got a syntax error of

"Unexpected '[' expected ']'"

Can this be done and if so any help with the right syntax would bemuch appreciated.

$sql = "REPLACE INTO sections(IDENTIFIER, NAME, DESCRIPTION, SEQUENCE, INSTRUCTIONS, TIME_AVAILABLE, EXTERNAL_RESOURCE)
            VALUES ('$currentline[$flippedheaders['IDENTIFIER']]', '$currentline[flippedheaders['NAME']]', '$currentline[flippedheaders['DESCRIPTION']]', $currentline[flippedheaders['SEQUENCE']], '$currentline[flippedheaders['INSTRUCTION']]', $currentline[flippedheaders['TIME_AVAILABLE']], '$currentline[flippedheaders['EXTERNAL_RESOURCE']]')";

What database driver are you using? Doing string interpolation is extremely error prone because you need to properly escape all your values or you will have serious problems. — tadman
– tadman, Commented Jun 25, 2015 at 16:36

taxicala · Accepted Answer · 2015-06-25 16:37:40Z

1

I see you have a lot of typos there, mising quotes and not properly interpolating the string. Try as follows:

$sql = "REPLACE INTO sections(IDENTIFIER, NAME, DESCRIPTION, SEQUENCE, INSTRUCTIONS, TIME_AVAILABLE, EXTERNAL_RESOURCE)
        VALUES ('{$currentline[$flippedheaders['IDENTIFIER']]}', '{$currentline[$flippedheaders['NAME']]}', '{$currentline[$flippedheaders['DESCRIPTION']]}', '{$currentline[$flippedheaders['SEQUENCE']]}, '{$currentline[$flippedheaders['INSTRUCTION']]}', '{$currentline[$flippedheaders['TIME_AVAILABLE']]}', '{$currentline[$flippedheaders['EXTERNAL_RESOURCE']]}')";

answered Jun 25, 2015 at 16:37

taxicala

21.8k7 gold badges41 silver badges67 bronze badges

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

1 Comment

Jonny Over a year ago

Aside from the embarrassing typos, not interpolating the string was the main issue here. I knew that's what I needed to do but not what it was called or how to do it so this was a huge help, thanks :)

Collectives™ on Stack Overflow

Using one Array Value As Another Array Key PHP MySQL

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