Form to input to sql database not working

Question

I am trying to make a website that will take data from a html form and add it to a sql database

post.html:

<form action="send_post.php" method="post">
<h3>ID:</h3>
<input type="text" name="id">
<h3>Name:</h3>
<input type="text" name="name">
<h3>Surname:</h3>
<input type="text" name="surname">
<input type="submit">

send_post.php

<?php  
$connect = mysqli_connect("myhost","myusername","mypassword","myDB");
mysqli_query($connect,"INSERT INTO test_table (id, name, surname)
VALUES ('$_POST[id]', '$_POST[name]', '$_POST[surname]')"
?>

I have hosted it here

However when I try it says that there is a unexpected semicolon in a line where there is not a semi colon. How do I fix this?

It says the error is on line 7, however you only posted 5 lines of code? — Thijs Riezebeek
– Thijs Riezebeek, Commented Feb 8, 2015 at 17:57
Check once again on what line, in what file and what the exact error. And post relevant code. — u_mulder
– u_mulder, Commented Feb 8, 2015 at 17:59
I had some comments in which I deleted, I have updated it, it now says line 5 — samrobbins
– samrobbins, Commented Feb 8, 2015 at 17:59

Moid · Accepted Answer · 2015-02-08 18:01:48Z

3

Missing ); Use this...

mysqli_query($connect,"INSERT INTO test_table (id, name, surname) VALUES ('$_POST[id]', '$_POST[name]', '$_POST[surname]')");

answered Feb 8, 2015 at 18:01

Moid

1,4471 gold badge13 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

Form to input to sql database not working

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related