Send form values to db error

Question

When I try to send data from an html form to a database using php, I keep getting error unexpected ; in line 6. I cant seem to find the exact cause.

This is the code of send.php:

<?php
//Connecting to sql db.
$connect = mysqli_connect("host","user","password","database");
//Sending form data to sql db.
mysqli_query($connect,"INSERT INTO sw5_green (firstname_r, lastname_r, vid, occupation, address, firstname_s, lastname_s, country, amount, currency) 
VALUES ('$_POST[post_firstname_r]', '$_POST[post_lastname_r]', '$_POST[post_vid]', '$_POST[post_occupation]', '$_POST[post_address]', '$_POST[post_firstname_s]', '$_POST[post_lastname_s]', '$_POST[post_country]', '$_POST[post_amount]', '$_POST[post_currency]')";
?>

Thanks :) It worked

Haf833
– Haf833

2016-07-19 11:41:51 +00:00
Commented Jul 19, 2016 at 11:41 — Haf833
– Haf833, Commented Jul 19, 2016 at 11:41

Vinod VT · Accepted Answer · 2016-07-19 11:42:50Z

1

You are missing ) at the end of the statement. put ) this before last ;.

Try it,

    mysqli_query($connect,"INSERT INTO sw5_green (firstname_r, lastname_r, vid, occupation, address, firstname_s, lastname_s, country, amount, currency) 
VALUES ('$_POST[post_firstname_r]', '$_POST[post_lastname_r]', '$_POST[post_vid]', '$_POST[post_occupation]', '$_POST[post_address]', '$_POST[post_firstname_s]', '$_POST[post_lastname_s]', '$_POST[post_country]', '$_POST[post_amount]', '$_POST[post_currency]')");

edited Jul 19, 2016 at 11:42

answered Jul 19, 2016 at 11:40

Vinod VT

7,18912 gold badges54 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Simon Shirley Over a year ago

That's not quite in the right place. Your explanation is right but the code example is wrong.

Devsi Odedra · Accepted Answer · 2016-07-19 11:41:43Z

0

You are missing )

Replace your code with query with this

mysqli_query($connect,"INSERT INTO sw5_green (firstname_r, lastname_r, vid, occupation, address, firstname_s, lastname_s, country, amount, currency) 
VALUES ('$_POST[post_firstname_r]', '$_POST[post_lastname_r]', '$_POST[post_vid]', '$_POST[post_occupation]', '$_POST[post_address]', '$_POST[post_firstname_s]', '$_POST[post_lastname_s]', '$_POST[post_country]', '$_POST[post_amount]', '$_POST[post_currency]'))";

answered Jul 19, 2016 at 11:41

Devsi Odedra

5,3421 gold badge25 silver badges38 bronze badges

5 Comments

Simon Shirley Over a year ago

You've copied the same mistake from Vinod VT 's answer. (which he has since corrected).

Devsi Odedra Over a year ago

please just check the time, i just typing the answer and some one given it before few second than its not mean that it copy @SimonShirley

Simon Shirley Over a year ago

Granted, that may have been the case. The answers and comments were in rapid succession, but it did seem odd that it was exactly the same typo.

Devsi Odedra Over a year ago

if i want to copy than i can just change the description, but when i typing the answer at that time there is no any answers, so i have given that ans .

Simon Shirley Over a year ago

I'm not going to get into a debate over when things were posted as it's counter-productive. However, I will leave you with one final thought - your code example still contains the typo and therefore will not solve the OP's problem.

Deepak Saini · Accepted Answer · 2016-07-19 11:44:34Z

0

wrong syntax

'$_POST[post_firstname_r]' should be $_POST['post_firstname_r']

Always escape your data before saving.

answered Jul 19, 2016 at 11:44

Deepak Saini

2494 silver badges8 bronze badges

Collectives™ on Stack Overflow

Send form values to db error

3 Answers 3

1 Comment

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related