narendrav Posted June 1, 2011 Share Posted June 1, 2011 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Thanks For Your Feedback</title> </head> <body> <h2>Comments And Suggestions</h2> <?php $rate_us = $_POST['rating']; $your_name = $_POST['name']; $email = $_POST['email']; $your_comments = $_POST['comments']; $dbc = mysqli_connect('localhost','root','password','contactus') or die('Error connecting to MySQL server.'); $query = "INSERT INTO contact_us (rate_us,your_name,email,your_comments)"."VALUES ('$rate_us','$your_name','$email','$your_comments'); $result = mysqli_query($dbc,$query) or die('Error querying database'); mysqli_connect($dbc); echo 'Thanks for your suggestions and comments'.'<br />'.$your_name.'<br />'; echo 'And you rated us as'.'<br />'.$rate_us; ?> </body> </html> Hi.I am new to php. I have written this code for storing the data entered into form fields in mysql database It shows the following error Parse error: syntax error, unexpected $end in F:\xampp\htdocs\contactus.php on line 34 [code] Can anyone tell me the mistake is. BY the way i am using xampp. and the version of php is 5.3.5 Quote Link to comment Share on other sites More sharing options...
fugix Posted June 1, 2011 Share Posted June 1, 2011 this $query = "INSERT INTO contact_us (rate_us,your_name,email,your_comments)"."VALUES ('$rate_us','$your_name','$email','$your_comments'); should be $query = "INSERT INTO contact_us (rate_us,your_name,email,your_comments) VALUES ('$rate_us','$your_name','$email','$your_comments')"; Quote Link to comment Share on other sites More sharing options...
narendrav Posted June 1, 2011 Author Share Posted June 1, 2011 ya. i haven't used the double quotes in the end Quote Link to comment Share on other sites More sharing options...
fugix Posted June 1, 2011 Share Posted June 1, 2011 fix your problem? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.