php怎么连接SqlServer并实现增删改查

这篇文章将为大家详细讲解有关php怎么连接SqlServer并实现增删改查，小编觉得挺实用的，因此分享给大家做个参考，希望大家阅读完这篇文章后可以有所收获。

连接 SQL Server

1. 使用 SQLSRV 扩展：

   $serverName = "your_server_name";
   $connectionInfo = array(
       "Database" => "your_database",
       "UID" => "your_username",
       "PWD" => "your_password"
   );
   $conn = sqlsrv_connect($serverName, $connectionInfo);

2. 使用 PDO：

   $host = "your_server_name";
   $dbName = "your_database";
   $dsn = "sqlsrv:Server=$host;Database=$dbName";
   $username = "your_username";
   $password = "your_password";
   $conn = new PDO($dsn, $username, $password);

增删改查操作

插入

1. 使用预处理语句 (SQLSRV 扩展)

   $stmt = sqlsrv_prepare($conn, "INSERT INTO your_table (name) VALUES (?)");
   sqlsrv_bind($stmt, 1, $_POST["name"]);
   sqlsrv_execute($stmt);

2. 使用 PDO

   $stmt = $conn->prepare("INSERT INTO your_table (name) VALUES (?)");
   $stmt->bindParam(1, $_POST["name"], PDO::PARAM_STR);
   $stmt->execute();

删除

1. 使用预处理语句 (SQLSRV 扩展)

   $stmt = sqlsrv_prepare($conn, "DELETE FROM your_table WHERE id = ?");
   sqlsrv_bind($stmt, 1, $_GET["id"]);
   sqlsrv_execute($stmt);

2. 使用 PDO

   $stmt = $conn->prepare("DELETE FROM your_table WHERE id = ?");
   $stmt->bindParam(1, $_GET["id"], PDO::PARAM_INT);
   $stmt->execute();

更新

1. 使用预处理语句 (SQLSRV 扩展)

   $stmt = sqlsrv_prepare($conn, "UPDATE your_table SET name = ? WHERE id = ?");
   sqlsrv_bind($stmt, 1, $_POST["name"]);
   sqlsrv_bind($stmt, 2, $_POST["id"]);
   sqlsrv_execute($stmt);

2. 使用 PDO

   $stmt = $conn->prepare("UPDATE your_table SET name = ? WHERE id = ?");
   $stmt->bindParam(1, $_POST["name"], PDO::PARAM_STR);
   $stmt->bindParam(2, $_POST["id"], PDO::PARAM_INT);
   $stmt->execute();

查询

1. 使用预处理语句 (SQLSRV 扩展)

   $stmt = sqlsrv_prepare($conn, "SELECT * FROM your_table WHERE name LIKE ?");
   sqlsrv_bind($stmt, 1, $_GET["name"]);
   sqlsrv_execute($stmt);
   while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
       // Process the row
   }

2. 使用 PDO

   $stmt = $conn->prepare("SELECT * FROM your_table WHERE name LIKE ?");
   $stmt->bindParam(1, $_GET["name"], PDO::PARAM_STR);
   $stmt->execute();
   while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
       // Process the row
   }

以上就是php怎么连接SqlServer并实现增删改查的详细内容，更多请关注编程学习网其它相关文章！