sql insert into query

Question

Please help!

What is wrong with this INSERT INTO query?!

This is before the query on the newUser.php page

$result2=mysqli_query($con,"SELECT count(*) AS count FROM boards");
while($row2 = mysqli_fetch_array($result2)){
    $postNumber=$row2["count"];
}
echo $postNumber;
echo $_POST['bday'];

This is the query

mysqli_query($con,"INSERT INTO users (userID, profPicLoc, age, username, realName, birthday, password, meBoardID, email) VALUES (0, 'aa', 17, '" . $_POST['username2'] . "', '" . $_POST['name'] . "', '" . $_POST['bday'] . "', '" . $_POST['password2'] . "', " . $postNumber+2 . ", '" . $_POST['email'] . "')";

The connection is made to the database correctly, the userID is auto increment, and the birthday field in the database is DATE type

it recieves the information from this form on another page...

<form action="newUser.php" method="post">
</br>Name: <input type="text" name="name"></input></br>
Username: @<input type="text" name="username2"></input></br>
Password: <input type="password" name="password2"></input></br>
Email: <input type="text" name="email"></input></br>
Birthday: <input type="date" name="bday"></br>
<input type="submit"></input>
</form>

"the userID is auto increment" - Then get rid of userID in your query. — Funk Forty Niner
– Funk Forty Niner, Commented Jul 25, 2014 at 4:20
don't build SQL queries with strings; it lets people hack you pretty easily. use bound parameters. — Eevee
– Eevee, Commented Jul 25, 2014 at 4:21
Fred, I already tried removing the userID field, still didn't work... I think it it a small syntax error but I have no idea what is going wrong — sgrutman978
– sgrutman978, Commented Jul 25, 2014 at 4:23
WOOOOOOOOW I'm stupid, I forgot the parentheses before the semi colon — sgrutman978
– sgrutman978, Commented Jul 25, 2014 at 4:34
Yeah, you have syntax error. Missing ) at the end before semi colon. — TBI
– TBI, Commented Jul 25, 2014 at 4:36

simeg · Accepted Answer · 2014-07-25 04:53:36Z

2

mysqli_query() parenthesis closing is wrong. Need one more closing parenthesis at the end. remove the user_id from inserting if it is AI

mysqli_query($con,"INSERT INTO users (profPicLoc, age, username, realName, birthday, password, meBoardID, email) 
VALUES ('aa', 17, '" . $_POST['username2'] . "', '" . $_POST['name'] . "', '" . $_POST['bday'] . "', '" . $_POST['password2'] . "', " . $postNumber+2 . ", '" . $_POST['email'] . "')");

edited Jul 25, 2014 at 4:53

simeg

1,8792 gold badges27 silver badges34 bronze badges

answered Jul 25, 2014 at 4:36

Hari

3131 gold badge4 silver badges11 bronze badges

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

Comments

Teerath Kumar · Accepted Answer · 2014-07-25 04:48:02Z

1

Use it:

mysqli_query($con,"INSERT INTO users (profPicLoc, age, username, realName, birthday, password, meBoardID, email) VALUES ('aa', 17, '" . $_POST['username2'] . "', '" . $_POST['name'] . "', '" . $_POST['bday'] . "', '" . $_POST['password2'] . "', " . $postNumber+2 . ", '" . $_POST['email'] . "')";

never include primary key with auto incremented column while inserting.

answered Jul 25, 2014 at 4:48

Teerath Kumar

4985 silver badges15 bronze badges

Collectives™ on Stack Overflow

sql insert into query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related