php连接SqlServer并实现增删改查⼀、配置环境
  3、在你的php.ini⽂件中加上
extension=php_pdo_sqlsrv_74_ts_x64.dll
extension=php_sqlsrv_74_ts_x64.dll
  4、重启Apache服务器。
  5、测试：
$serverName = "localhost"; //数据库服务器地址
$uid = "sa";    //数据库⽤户名
$pwd = "lxy208751"; //数据库密码
$connectionInfo = array("UID" => $uid, "PWD" => $pwd, "Database" => "Students");
$conn = sqlsrv_connect($serverName, $connectionInfo);
if ($conn == false) {
echo "连接失败！";
var_dump(sqlsrv_errors());
exit;
} else {
echo "链接成功";
}
⼆、编码设置
（注：由于sql server 不⽀持UTF8，当使⽤varchar保存汉字时，会出现乱码。需要转换。）
  1、从数据库查出来的数据编码“GBK”，⼀般我们有的是“UTF-8”，所以需要转换成“UTF-8”。
function toU8($str){
return iconv('GBK', 'UTF-8', $str);
}
  2、从程序代码中的变量插⼊的数据库时，需要将变量的编码改成“GBK”才能插⼊数据库。
function toGBK($str){
return iconv('UTF-8', 'GBK', $str);
}
三、学⽣信息管理系统
  1、index.php
<?php
include('./conn/conn.php');
$sql="select * from student";
$result = sqlsrv_query( $conn, $sql ) or die("数据查询失败！");
if(!empty($_GET)){
$delete=$_GET['delete'];
if($delete='1'){
echo "<script>alert('删除成功！');</script>";
}else{
echo "<script>alert('删除失败！');</script>";
}
}
function toU8($str){
return iconv('GBK', 'UTF-8', $str);
}
>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>学⽣管理系统</title>
<link rel="stylesheet" href="css/bootstrap.min.css" type="text/css" />
<script src="js/jquery-1.11.3.min.js" type="text/javascript"></script>
<script src="js/bootstrap.min.js" type="text/javascript"></script>
<style type="text/css">
/
*body {
background-repeat: no-repeat;
background-size:cover;
background-attachment: fixed;
background-image: url(image/c_b2.jpg);
background-position: 0px -80px;
}*/
table {
margin: auto;
width: 80%;
text-align: center;
background-color: #ffffff;
}
h1 {
font-family: 华⽂⾏楷;
}
</style>
<script type="text/javascript">
function deleteStudent(sno) {
if (confirm("您是否要删除该项？")) {
location.href = "delete.php?sno="+sno;
}
}
</script>
</head>
<body>
<div>
<h1 align="center">学⽣信息管理系统</h1>
<h3 align="center">
<a href="add.php">添加学⽣信息</a>
</h3>
</div>
<div >
<table class="table table-bordered" >
<thead>
<tr>
<th><p align="center">学号</p></th>
<th><p align="center">姓名</p></th>
<th><p align="center">性别</p></th>
<th><p align="center">年龄</p></th>
<th><p align="center">学院</p></th>
<th colspan="2"><p align="center">操作</p></th>
</tr>
</thead>
<tbody>
<?php
while($row = sqlsrv_fetch_array( $result, SQLSRV_FETCH_ASSOC)){            >
<tr>
<td><?php echo toU8($row['Sno']);?></td>
<td><?php echo toU8($row['Sname']);?></td>
<td><?php echo toU8($row['Ssex']);?></td>
<td><?php echo toU8($row['Sage']);?></td>
<td><?php echo toU8($row['Sdept']);?></td>
<td><a
href="update.php?sno=<?php echo toU8($row['Sno']);?>">修改</a></td>
<td><a href="javascript:;" onclick="deleteStudent(<?php echo toU8($row['Sno']);?>)">删除</a></td>            </tr>
<?php
}
>
</tbody>
</table>
</div>
<div>
<hr>
<h1 align="center" >⽯家庄铁道⼤学 @2018-2020</h1>
</div>
</body>
</html>
View Code
  2、add.php
<?php
include('./conn/conn.php');
function toGBK($str){
return iconv('UTF-8', 'GBK', $str);
}
if(!empty($_POST)){
$name=$_POST['name'];
$sex=$_POST['sex'];
$sno=$_POST['sno'];
$dept=$_POST['dept'];
$age=$_POST['age'];
$sno=toGBK($sno);
$name=toGBK($name);
$sex=toGBK($sex);
$dept=toGBK($dept);
$sql = "insert into Student(Sno,Sname,Ssex,Sage,Sdept) values('$sno','$name','$sex',$age,'$dept')"; echo$sql;
$result = sqlsrv_query($conn, $sql) or die("数据插⼊失败！");
header("location:index.php");
}
>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>添加学⽣信息</title>
<style type="text/css">
html {
font-size: 15px;
}
fieldset {
width: 450px;
margin: 0 auto;
}
legend {
font-weight: bold;
font-size: 18px;
}
label {
float: left;
width: 70px;
margin-left: 10px;
}
.left {
margin-left: 80px;
}
.input {
width: 200px;
border: 1px solid #ccc;
padding: 7px 0px;
border-radius: 3px; /*css3属性IE不⽀持*/
padding-left: 5px;
}
span {
color: #666666;
}
p{
margin-left: 30px;
}
</style>
</head>
<body>
<fieldset>
<legend>添加个⼈信息</legend>
<form name="addForm" method="post" action="#">
<p>
<label for="sno" class="label">学号:</label>
<input id="sno" name="sno" type="text" class="input" />
<p/>
<p>
<label for="name" class="label">姓名:</label>
<input id="name" name="name" type="text" class="input" />
<p/>
<p>
<label for="sex" class="label">性别:</label>
<input name="sex" type="radio" value="男" >男
<input name="sex" type="radio"value="⼥">⼥
<p/>
<p>
<label for="age" class="label">年龄:</label>
<input id="age" name="age" type="text" class="input" />
<p/>
<p>
<label for="dept" class="label">学院:</label>
<input id="dept" name="dept" type="text" class="input" />
<p/>
<p>
<input type="reset" value=" 重置 "/>
<input type="submit" name="submit" value="  提交  " class="left" />        </p>
</form>
</fieldset>
</body>
</html>
View Code
  3、undate.php
<?php
include('./conn/conn.php');
function toU8($str){
return iconv('GBK', 'UTF-8', $str);
}
function toGBK($str){
return iconv('UTF-8', 'GBK', $str);
}
if(!empty($_GET) ){
$sno=$_GET['sno'];
$sno=toGBK($sno);
$sql="select * from student where Sno='$sno'";
$result = sqlsrv_query($conn, $sql) or die("数据查询失败！"); $row=sqlsrv_fetch_array( $result, SQLSRV_FETCH_ASSOC); }
>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>修改学⽣信息</title>
<style type="text/css">
html {
font-size: 15px;
}
fieldset {
width: 450px;
margin: 0 auto;
}
legend {
font-weight: bold;
font-size: 18px;
}
label {
float: left;
width: 70px;
margin-left: 10px;
}
.left {
margin-left: 80px;
}
.input {
width: 200px;
border: 1px solid #ccc;
padding: 7px 0px;
border-radius: 3px; /*css3属性IE不⽀持*/
padding-left: 5px;
}
span {
color: #666666;
php修改数据库内容
}
p{
margin-left: 30px;
}
</style>
</head>
<body>
<fieldset>
<legend>修改学⽣信息</legend>
<form name="addForm" method="post" action="change.php">

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。