PHP SQL insert prepared statements doesn't insert properly

Question

When executing the following code, no Errors occur but the data isn't put into the database!

$zero = 0;
    $connection = new mysqli("localhost", "andrewle_me", "*****", "andrewle_velocity");
    $stmt = $connection->prepare("INSERT INTO accounts Values(?, ?, ?, ?, ?, ?, ?, ?)");
    $stmt->bind_param("issssssi", $zero, $_POST["username"], password_hash($_POST["password"], PASSWORD_DEFAULT), $_POST["Email"], $_POST["firstname"], $_POST["lastname"], $_POST["nationality"], $zero);
    $stmt->execute();
    $stmt->close();
    $connection->close();
    echo "Success";

d.abyss · Accepted Answer · 2014-03-05 16:22:33Z

1

Define your posts and password hash outside of the param binding. Set the fields in the table that your values are going to be entered into.

answered Mar 5, 2014 at 16:22

d.abyss

2121 gold badge5 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP SQL insert prepared statements doesn't insert properly

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related