PHP script not writing data to mysql table

Solution:

Your main problem:

You declared$STH instead of$sql.

To fix this:

1. Change$STH = ... to$sql = ...

OR

2. Change$count = $DBH->exec($sql); to$count = $DBH->exec($STH);

I'd recommend the first one.

Also, you should really consider using prepared statements to prevent SQL injection.

Also:

$STH = "INSERT INTO 'users' ('name', 'password', 'email' )"
                . "VALUES ('$varName', '$varPass', '$varMail')";
Copy code

This results in:

INSERT INTO 'users' ('name', 'password', 'email' )VALUES ('$varName', '$varPass', '$varMail')
Copy code

There are a couple of other things wrong with this:

1. There's no space between) andVALUES
2. The column names have quotes around them instead of backticks
3. There's really no point in that string concatenation, just put it all in one string.

The fix: (edited)

$sql = "INSERT INTO users (name, password, email) VALUES ('$varName', '$varPass', '$varMail')";
Copy code

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.