Error in inserting data into database
        Posted  
        
            by 
                Matthew
            
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Matthew
        
        
        
        Published on 2011-11-25T09:00:41Z
        Indexed on 
            2011/11/25
            9:50 UTC
        
        
        Read the original article
        Hit count: 213
        
When I try to run this code it will not insert the data into the database?
<?php
class Database {
private $dsn;
function __construct($dbname, $host, $user, $password, $enckey) {
    $this->dsn = "mysql:dbname=" . $dbname . ';host=' . $host;
    $this->user = $user;
    $this->password = $password;
}
private function createDSN() {
    return $this->dsn;
}
public function createConnection() {
    try {
        $dbh = new PDO(self::createDSN(), $this->user, $this->password);
    } 
    catch (PDOException $e) {
        echo 'Connection failed: ' . $e->getMessage();
    }
    return $dbh;
}
}
$db = new Database('mytest', 'localhost', 'root', 'hashedpassword', null);
$dbh = $db->createConnection();
$sql = $dbh->prepare("INSERT INTO contacts (firstname, lastname) VALUES (?,?)");
$sql->execute(array("abc", "xyz"));
?>
© Stack Overflow or respective owner