php - sql insert into query -


Please help!

What's wrong with this INSERT query ?!

This is before the query on the newUser.php page

  $ result2 = mysqli_query ($ con, "counting from boards in the form of selection number (*)"); While ($ row2 = mysqli_fetch_array ($ result2)) {$ post number = $ line 2 ["count"]; } Echo $ postNumber; Echo $ _POST ['bday'];   

This is the query

  mysqli_query ($ con, "user (userID, profPicLoc, age, username, real name , '', ''. $ '_POST [' name ']. ",' '$' ',' $ ' $ _POST ['password2']. '', '. $ Post number + 2.', ''. $ _POST ['email']. '' '') " ;   

The connection is created correctly, the UserID is automatically incremented, and the database in the database is DATE type

This receives information from someone Other pages & Form ...

new form action = "newUser.php" method = "post" & gt; & lt; / br & gt; name: & lt; input type = "Text" name = "name"> Input> User name: @ & gt; Password: & lt; input type = "password" name = "password2" & gt; & lt; / input & gt; & lt; / br & gt; Email: & lt; input type = "Text" name = "email" & gt; & Lt; / Input & gt; & Lt; / Br & gt; Birthday: & lt; Input type = "date" name = "birthday" & gt; & Lt; / Br & gt; & Lt; Input type = "submit" & gt; & Lt; / Input & gt; & Lt; / Form & gt;

mysqli_query () closing the bracket is inaccurate Another closing bracket is required

  mysqli_query ($ con, "Add user (profPicLoc, age, user name, real name, birthday, password, meBoardID, etc.) Remove  user_id  from inserting the value ('A', 17, ''. $ _POST ['username2']. '', '". $ _POST [' name ']." $ '_POST [' bday ']. "', '". $ _POST [' password2 '].' ',' $ PostNumber + 2. ',' ". $ _POST ['email']. "')");    

Comments

Popular posts from this blog

ios - Adding an SKSpriteNode to SKScene from a child SKSpriteNode -

Matlab transpose a table vector -

c# - Textbox not clickable but editable -