Why the SQL query not perform in database? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Why the SQL query not perform in database?

When I run this on PC browser(WAMPP server), I enter values and press register button, that display "Registration successfully". But the values are not stored in database. Why?. Any mistakes in my files?. Connection also successful. Please check out these files. https://code.sololearn.com/WR9y8mQBOTXP/?ref=app https://code.sololearn.com/w1RpmVi49Rmp/?ref=app https://code.sololearn.com/wdlQ0tQsBcjN/?ref=app

25th Jan 2021, 12:32 PM
Vadivelan
3 Answers
+ 2
No new record added in the table? Check return value from mysqli_stmt_execute maybe? Vadivelan Initialize the statement using mysqli_stmt_init() first, then prepare the statement using mysqli_stmt_prepare() https://www.php.net/manual/en/mysqli-stmt.prepare.php
25th Jan 2021, 2:41 PM
Ipang
+ 1
In file register.php; Values for variable $name, $email and $password is not yet initialized when they are bound as arguments for the statement (at line 8). $name, $email, and $password are initialized at line 9, 10 and 11, respectively.
25th Jan 2021, 12:36 PM
Ipang
+ 1
@Ipang Now I changed the lines. Even this code not working. The browser doesn't show any errors, warnings.
25th Jan 2021, 2:34 PM
Vadivelan