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: 157

Filed under:
|

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

Related posts about php

Related posts about mysql