PDO data entry, doesn’t it work?

Question

PDO data entry, doesn’t it work?

Asked 7 years, 5 months ago

Viewed 76 times

0

I am trying to create a registration page with PDO however, it does not perform the insertion and does not present error, which can be?

include "../pages/sqlconn.php";

$name  = $_POST["name"];
$email = $_POST["email"];
$pass  = $_POST["password"];

try {
    $sql = "INSERT INTO db_user(user_name, user_email, user_pass) VALUES (?,?,?)";
    $ins = $conn->prepare($sql);
    $ins->bindParam(1, $name, PDO::PARAM_STR);
    $ins->bindParam(2, $email, PDO::PARAM_STR);
    $ins->bindParam(3, $pass, PDO::PARAM_STR);
    $ins->execute();
    echo $ins->execute();       
} catch (PDOException $e) {
    echo "ERROR: ".$e->getMessage();
}

Gives a var_dump($e); and put here.

– Thiago

2017/05/29 at 18:00
The page has turned white yet, returned no results...

– Igor Donizete

2017/05/29 at 18:09
Why, so he’s not entering the Exception, give a var_dump($ins->execute()); and pole here.

– Thiago

2017/05/29 at 18:13
C: wamp64 www Mysqli-Learn action createAccount.php:25:Boolean false

– Igor Donizete

2017/05/29 at 18:14
In place of echo $ins->execute(), place print_r($conn->errorInfo());

– Woss

2017/05/29 at 18:26
Returned one, Array ( [0] => 00000 [1] => [2] => )

– Igor Donizete

2017/05/29 at 18:29
Gor, replace VALUES (?,??) with VALUES (:name, :email, :pass) and instead of 1, 2, and 3, in bindParam, replace with :name, :email, and :pass in their proper order and see if there is an error.

– Diego Andrade

2017/05/29 at 18:39
1

Add $conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION ); right after creating the object $conn that will probably appear the error message. I tested the code here and it worked perfectly. The table name is db_user same or would be db_users?

– Woss

2017/05/29 at 18:42
Anderson Carlos Woss, that’s right bro, they returned that it was missing a column to have insertion, then I set it in the database as NULL, now functional he entered correctly.

– Igor Donizete

2017/05/29 at 18:47

Show 4 more comments

1 answer

Browser other questions tagged php pdo

You are not signed in. Login or sign up in order to post.

by Thiago • **417** points · Answer 1 · 2017-05-29T18:19:28+00:00

Try it like this:

include "../pages/sqlconn.php";

$name  = $_POST["name"];
$email = $_POST["email"];
$pass  = $_POST["password"];

try {
    $sql = "INSERT INTO db_user (user_name, user_email, user_pass) VALUES ('$name','$email','$pass')";
    $conn->query($sql)->fetchAll();       
} catch (PDOException $e) {
    echo "ERROR: ".$e->getMessage();
}