PDO Class problem

newwarrior · 05-22-2011, 01:52 PM

Hello,

I have a little problem with a class that I used for my website, where the user could register.

This is the part for DB Connection:

PHP Code:


			
$dbh = new PDO("mysql:host=$DB_DATA_HOST;dbname=$DB_DATA_DATABASE", $DB_DATA_USER, $DB_DATA_PASSWORD);

This is the call for my class:

PHP Code:


			
//CREATE NEW CREATE OBJ

$create_user = new user($dbh);

$create_user->USERNAME = $_POST['username'];

$create_user->PASSWORD = md5($_POST['password']);

$create_user->EMAIL = $_POST['email'];

$create_user->REGISTER_DATE = time();



if($create_user->createUser())

    $content_var .= $MESSAGE_SUCCESS['register'];

This is my class (part of):

PHP Code:


			
public function __construct($dbh)

{

$this->dbh = $dbh;

}



public function createUser()

{

$ZERO = 0;

$this->OPERATION = true;

$this->ACTIVATE_KEY = $this->createRandomKey(25);



$sth = $this->dbh->prepare('INSERT INTO user(username, password, email, active, activate_key, register_date) VALUES(?,?,?,?,?,?)');

$sth->bindParam(1, $this->USERNAME, PDO::PARAM_STR);

$sth->bindParam(2, $this->PASSWORD, PDO::PARAM_STR);

$sth->bindParam(3, $this->EMAIL, PDO::PARAM_STR);

$sth->bindParam(4, $this->ZERO, PDO::PARAM_INT);

$sth->bindParam(5, $this->ACTIVATE_KEY, PDO::PARAM_STR);

$sth->bindParam(6, $this->REGISTER_DATE, PDO::PARAM_INT);

$sth->execute();

The problem is, that there is no DB entry.
I get no error message or notice message.
I don't find the problem.

Could you maybe help me?

wGEric · 05-26-2011, 05:23 PM

Check to see if $sth->execute() is returning true or false. If it is false then there was an error and you should use PDOStatement->errorInfo() to get the error message.