innstory

PDO連接Mysql方式 MVC上應用

function connect()

{

$dbhost=DB_SERVER;

$dbuser=DB_USERNAME;

$dbpass=DB_PASSWORD;

$dbname=DB_DATABASE;

try {

$dbConnection = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass);

$dbConnection->exec("set names utf8");

$dbConnection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

return $dbConnection;

}

catch (PDOException $e) {

echo 'Connection failed: ' . $e->getMessage();

}



}

$pdo = connect();