How to assign Array to a String in PHP?

Question

I am trying to assign the contents of a 2D array to a string in PHP.

$sql="SELECT Order_Code FROM Order WHERE CUST_CODE = '$output['username']';";

I know the problem exists in how I'm writing the $output variable assignment.

The following line of code outputs the correct data from the variable:

echo $output['username'];  

The following error is being thrown:

Parse error: syntax error, unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING)

Answer 1

Parameters surrouned by curly brackets will work well in your case. Here is what i mean. {$array['key']}
And for your example:

$sql="SELECT Order_Code FROM Order WHERE CUST_CODE = '{$output['username']}';";

Answer 2

You need to concatenate this string as the multiple single quotes from accessing the array element are mixing up the string.

$sql="SELECT Order_Code FROM Order WHERE CUST_CODE = '" . $output['username'] ."';";

Answer 3

Try this:

 $sql="SELECT Order_Code FROM Order WHERE CUST_CODE = '".$output['username']."'";

Answer 4

You can also try this:

$user_name =  $output['username'];
$sql = "SELECT Order_Code FROM Order WHERE CUST_CODE = $user_name";