程式設計@筆記

//------------------------
// 資料庫主機設定
//------------------------
$DB_SERVER = "localhost";
$DB_LOGIN = "帳號";
$DB_PASSWORD = "密碼";
$DB = "資料庫";
//------------------------
// 連結資料庫
//------------------------
try{
$dsn = 'mysql:host='.$DB_SERVER.';dbname='.$DB;
$username = $DB_LOGIN;
$password = $DB_PASSWORD;
$options = array(
PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
);
$db = new PDO($dsn, $username, $password, $options);

//echo '連線成功';
$db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION); //錯誤訊息提醒

}catch(PDOException $e){
echo $e->getMessage();
}

function my_real_escape_string($value, $connection) {
return substr($connection->quote($value), 1, -1);
}