Jump to content

Help with PDO connection


Renlok

Recommended Posts

I am creating a PDO database handler class, I've never used it before and its very slow going

 

so far it mostly works but i have a problem

 

 

 
public function connect($DbHost, $DbUser, $DbPassword, $DbDatabase, $DBPrefix, $CHARSET)
    {
        $this->DBPrefix = $DBPrefix;
        $this->CHARSET = $CHARSET;
try {
// MySQL with PDO_MYSQL
echo "SET NAMES $CHARSET";
$this->pdo = new PDO("mysql:host=$DbHost;dbname=$DbDatabase", $DbUser, $DbPassword, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES $CHARSET"));
// set error reporting up
$this->pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// actually use prepared statements
$this->pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
}
catch(PDOException $e) {
$this->error_handler($e->getMessage());
}
    }

doesn't work unless i remove 

, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES $CHARSET")
and I have no idea why it isn't throwing any errors its just not working :(
Link to comment
https://forums.phpfreaks.com/topic/276354-help-with-pdo-connection/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.