Quotation Marks on Session Variables

[Larry101]

Hi all... once again I am trying to re-educate my self into PHP after a long gap.

 

I do not have a problem as such just a question... here is part of my script that doesnot work;

 

<?

       $sql= "INSERT INTO member (

        username,
        email
    )
VALUES (
        \"$_SESSION['nm_username']\",
        \"$_SESSION['nm_email']\"


)";

?>

 

The above errors because there are single quotation marks in the session variables. When I remove them the script works and the values of the variables seem to be correct!

 

My question is - do I NEED the quotation marks in the variable and if so how should I write the query?

 

Regards

[Muddy_Funster]

Yes, you need the quotes around the SESSION[] elements.  You should also only use single quotes around sql strings.  your query should look like:

 $sql= "INSERT INTO member (
        username,
        email
    )
VALUES (
        '".$_SESSION['nm_username']."',
        '".$_SESSION['nm_email']."'
)";

 

using . to concatenate the string values with the variable contents.

[Larry101]

Yes, you need the quotes around the SESSION[] elements.  You should also only use single quotes around sql strings.  your query should look like:

 $sql= "INSERT INTO member (
        username,
        email
    )
VALUES (
        '".$_SESSION['nm_username']."',
        '".$_SESSION['nm_email']."'
)";

 

using . to concatenate the string values with the variable contents.

 

Thank you very much Muddy_Funster. I didn't feel comfortable leaving off the quotations.

[Muddy_Funster]

no worries

[KevinM1]

For interpolating array values, you can also use curly braces around the array value while within in the string.  Like so:

 

echo "Look, I'm an unbroken string!  Here's my data: {$_SESSION['someData']}";