How do i fix this

Question

I want to know how to fix this error on this page :
https://naijalife.000webhostapp.com/good.php
I used this code :

https://code.sololearn.com/ww724T97Rsz2/?ref=app

Answer 1

Joseph,
<$result> is a mysqli_result instance (an object in short), so we can't just go and concatenate strings with it. Try to change line 24 to not to mix <$result> with string for output.

echo "Error in query:<br>".$mysqli->error;

Answer 2

you just posted database credentials online. I would quickly change them if your db is accessible by the internet

Answer 3

well the script doesn‘t output anything, and if i go to your page I indeed only see a white page

Answer 4

Joseph,
Can you tell what error message you got when running that code on your side? without this information, it is rather hard to isolate the problem.

Answer 5

Thanks

Answer 6

Not a problem 👌
Did it work though Joseph?

Answer 7

the if else statement on line 20 and 23 doesn‘t make much sense.
The if statement checks if the username already exists, so far so good. However, if it doesn‘t exist it proceeds to print the error message that there is an error in the query?? why?
Can‘t you get rid of the else statement?

Answer 8

Also you don‘t need to fetch the last id in the table. you can set the id column to primary and autoincrement and then just leave the id out of the INSERT statement.

Answer 9

So do know what's wrong

Answer 10

It was something like, fatal error: uncaught object of class mysqli_result not converted to string on line 24

Answer 11

Be aware to read up on something called sql injection and prepared statements in the future.
if someone would have their username as "; DELETE FROM accounts; —
They could for instance delete your whole accounts table

Answer 12

never mind, I see you‘re using real_escape_string. That also works

Answer 13

https://code.sololearn.com/WQ332eQGvsut/?ref=app