输入中出现意外字符：'''（ASCII = 39）

Question

i have following code:

<?php
header( 'Content-type: text/xml' );
mysql_connect( 'domain', 'user', 'password' );
mysql_select_db( 'database' );

mysql_query("   INSERT INTO user(userName,password,email)
                VALUES(

                    '".$_POST['username']."',
                    '".md5($pass)."',
                    '".$_POST['email']."',          
 )" );
?>

When i try to load this in url:

http://xcode.domain.de/add.php?userName=test&password=test

I got this error on my server:

Warning: Unexpected character in input: ''' (ASCII=39) state=1 in /kunden//webseiten/xcode/add.php on line 15

Parse error: syntax error, unexpected '"' in /kunden/webseiten/xcode/add.php on line 15

can Somebody help on this?

thank you

Answer 1

ASCII 39 (decimal) is a single apostrophe.

The error that I see is an extra comma after the "email" line. Try this:

                '".$_POST['username']."',
                '".md5($pass)."',
                '".$_POST['email']."'