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 Link to comment https://forums.phpfreaks.com/topic/238109-parse-error/ 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')"; Link to comment https://forums.phpfreaks.com/topic/238109-parse-error/#findComment-1223535 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 Link to comment https://forums.phpfreaks.com/topic/238109-parse-error/#findComment-1223540 Share on other sites More sharing options...
fugix Posted June 1, 2011 Share Posted June 1, 2011 fix your problem? Link to comment https://forums.phpfreaks.com/topic/238109-parse-error/#findComment-1223541 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.