将Mysqli更改为sqlsrv

Question

我是PHP新手，需要修改一些代码才能使用我的进行编译。原来的代码是这样的。我从usercake下载的

<?php
/*
UserCake Version: 2.0.2
http://usercake.com
*/

//Database Information
$db_host = "localhost"; //Host address (most likely localhost)
$db_name = "202"; //Name of Database
$db_user = "202"; //Name of database user
$db_pass = "password"; //Password for database user
$db_table_prefix = "uc_";

GLOBAL $errors;
GLOBAL $successes;

$errors = array();
$successes = array();

/* Create a new mysqli object with database connection parameters */
 $mysqli = new mysqli($db_host, $db_user, $db_pass, $db_name); 
GLOBAL $mysqli;

if(mysqli_connect_errno()) {
echo "Connection Failed: " . mysqli_connect_errno();
exit();
}

//Direct to install directory, if it exists
if(is_dir("install/"))
{
header("Location: install/");
die();

}

?>

我已经安装了sqlsrv并测试了链接。它适用于我的数据库。然后，我将代码更改为：

<?php

//Database Information
$server = "servername";
$connectionInfo = array("Database"=>"databasename","UID"=>"xxxxxx", "PWD"=>"xxxxxx" );
$db_table_prefix = "uc_";

GLOBAL $errors;
GLOBAL $successes;

$errors = array();
$successes = array();

/* Create a new sqlsrv object with database connection parameters */

$mssqlsrv = new sqlsrv($server, $connectionInfo);
GLOBAL $mssqlsrv;

if(sqlsrv_connect_errno()) {
  echo "Connection Failed: " . sqlsrv_connect_errno();
  exit();
}

//Direct to install directory, if it exists
if(is_dir("install/"))
{
  header("Location: install/");
  die();
}

?>

我收到以下错误消息：

致命错误:未在

我认为这句话的问题是：

$mssqlsrv =新的sqlsrv($server，$connectionInfo)；

但我不知道怎么解决这个问题。

Answer 1

在本例中，我将使用PDO：http://www.php.net/manual/en/pdo.construct.php

可以创建到Server的DSN连接

$dsn = "sqlsrv:Server=servername;Database=databasename"

$user = 'dbuser';
$password = 'dbpass';

try {
   $dbh = new PDO($dsn, $user, $password);
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}

要连接到SQL server的信息可以在这里获得：http://www.php.net/manual/en/ref.pdo-sqlsrv.connection.php。