Home>

I am making a membership registration form, but I get an error when connecting to the database.
I would appreciate it if you could teach me what should not be done. ↓ Database column for registration
] (83982ddd482b1d941f617cf118c387d5.png)
Code

// Create SQL to register data
$sql = "INSERT INTO MEMBER (id, NAME, KANA, TEL, MAIL, YEAR, SEX, MAGAGINE, PASS_TMP, PASSWORD) VALUES (0, '$_ POST [your_name]', '$_ POST [your_kanaName]', '$_POST [your_number] ',' $_ POST [your_mail] ', $_ POST [birth_year], $_ POST [gender], $_ POST [agreement],' test ',' test ') ";

Error message
Cannot register with database

I have checked the contents of the database many times and should not be wrong.

  • Answer # 1

      

    I have checked the contents of the database many times and should not be wrong.

    If it is

    , it is not.

    However, it is impossible for others to judge from the current question content that even if "the contents of the database have been confirmed, it is not wrong".
    Please add and revise the question according to the indications you have already made.

    Also, when I answer this kind of question in various places, I write (Example: How to update DB information using ajax)
    Make sure to execute it directly before executing from the program.