我使用PDO_ODBC方法:
1-在具有wamp的服务器上安装ODBC,并在wamp上启用PHP_PDO_ODBC扩展
try{
$hostname = "IP";
$dbname = "database";
$username = "username";
$pw = "password";
$pdo = new PDO ("odbc:Driver={sql Server Native Client 10.0};Server=$hostname;Database=$dbname; Uid=$username;Pwd=$pw;");
} catch (PDOException $e) {
echo "Failed : " . $e->getMessage() . "\n";
exit;
}
$query = $pdo->prepare("select field_name from table");
$query->execute();
for($i=0; $row = $query->fetch(); $i++){
echo iconv("CP1256","UTF-8", $row['field_name'])."<br>";
}
3-用您的物品替换这些物品:
4-有时您需要使用“ sql SERVER”代替“ sql Server Native Client 10.0”,有时需要使用“ IP,port”代替“ IP”,有时需要使用“ ISO-8859-6”代替“ CP1256” ”。