<!DOCTYPE html PUBLIC
"-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"
>
<html xmlns=
"http://www.w3.org/1999/xhtml"
>
<head>
<meta http-equiv=
"Content-Type"
content=
"text/html; charset=utf-8"
/>
<title>无标题文档</title>
<style type=
"text/css"
>
<!--
.STYLE1 {
font-family:
"新宋体"
;
font-weight: bold;
font-size: 24px;
color: #000000;
}
-->
</style>
</head>
<body>
<p align=
"center"
><span
class
=
"STYLE1"
><a href=
"数据搜集.html"
>返回</a></span>
<?php
$name
=
$_POST
[
"姓名"
];
$sex
=
$_POST
[
"性别"
];
$number
=
$_POST
[
"学号"
];
$专业 =
$_POST
[
"专业"
];
$年级 =
$_POST
[
"年级"
].
"届"
.
$_POST
[
"班级"
];
$省份 =
$_POST
[
"省份"
];
?>
</p>
<div align=
"center"
>
<table width=
"80%"
border=
"1"
>
<caption>
信息统计
</caption>
<tr bgcolor=
"#00FF00"
>
<td>姓名</td>
<td>性别</td>
<td>专业</td>
<td>学号</td>
<td>班级</td>
<td>省份</td>
</tr>
<tr>
<td><?php
echo
$name
?></td>
<td><?php
echo
$sex
?></td>
<td><?php
echo
$专业 ?></td>
<td><?php
echo
$number
?></td>
<td><?php
echo
$年级 ?></td>
<td><?php
echo
$省份 ?></td>
</tr>
</table>
<img src=
"image/搞笑.gif"
longdesc=
"image/搞笑.gif"
/>
<p></p>
<p> </p>
<?php
$server
=
"localhost"
;
$user
=
"root"
;
$password
=
"root"
;
$db
=
"chenmo"
;
$conn
=
new
mysqli(
$server
,
$user
,
$password
,
$db
);
$conn
->query(
'SET NAMES UTF8'
);
if
(
$conn
->connect_error)
echo
"连接失败"
;
else
echo
"连接成功"
;
$code
= "
INSERT INTO php_stu ( name,sex,number,major,province,
class
)
VALUES (
'$name'
,
'$sex'
,
'$number'
,
'$专业'
,
'$省份'
,
'$年级'
);
";
if
(
$conn
->query(
$code
) === TRUE )
echo
"插入成功!"
;
else
echo
"插入失败"
.
$conn
->error;
$conn
->close();
?>
</div>
<p align=
"center"
>
<label></label>
</p>
</body>
</html>