php登录页面:
1
2
3
4
5
6
|
<h1>登录界面</h1>
<form action=
"dengluchuli.php"
method=
"post"
>
用户名:<input type=
"text"
name=
"uid"
/>
密码:<input type=
"text"
name=
"pwd"
/>
<input type=
"submit"
value=
"登录"
/>
</form>
|
其中 dengluchuli.php在规定路径下。
登录跳转页面:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
<?php
$yonghuming
=
$_POST
[
"uid"
];
$mima
=
$_POST
[
"pwd"
];
$db
=
new
mysqli(
"localhost"
,
"root"
,
""
,
"12345"
);
$sql
=
"select password from login where username='{$yonghuming}'"
;
$result
=
$db
->query(
$sql
);
$atter
=
$result
->fetch_row();
if
(
$atter
[0]==
$mima
&& !
empty
(
$mima
))
{
header(
"location:xinxi.php"
);
}
else
{
echo
"用户名或密码错误"
;
}
?>
|
此页面用于登录界面登录成功后通过用户名找到相应的数据。
登录主界面:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
|
<?php
$de
=
new
mysqli(
"localhost"
,
"root"
,
""
,
"12345"
);
$e
=
"select * from info"
;
$result
=
$de
->query(
$e
);
$atter
=
$result
->fetch_all();
echo
"<table border=1>"
;
echo
"<tr>
<td>代号</td>
<td>姓名</td>
<td>性别</td>
<td>民族</td>
<td>出生日期</td>
<td>操作</td>
</tr> ";
for
(
$i
=0;
$i
<
count
(
$atter
);
$i
++)
{
echo
"<tr>"
;
for
(
$j
=0;
$j
<
count
(
$atter
[
$i
]);
$j
++)
{
if
(
$j
==4)
{
echo
"<td>"
.
$atter
[
$i
][
$j
].
"</td> <td><a href='shanchu.php?code={$atter[$i][1]}' onclick=\"return confirm('确定删除?')\"> 删除</a></td>"
;
}
else
{
echo
"<td>"
.
$atter
[
$i
][
$j
].
"</td>"
;
}
}
echo
"</tr>"
;
}
echo
" </table>"
;
echo
"<a href='tianjia.php'>添加数据</a>"
?>
|
添加数据(tianji.php):
1
2
3
4
5
6
7
8
9
|
<h1>添加数据</h1>
<form action=
"zeng.php"
method=
"post"
>
代号:<input type=
"text"
name=
"daihao"
/> <br />
姓名:<input type=
"text"
name=
"xinming"
/><br />
性别:<input type=
"text"
name=
"xinbie"
/><br />
民族:<input type=
"text"
name=
"minzu"
/><br />
生日:<input type=
"text"
name=
"shengri"
/><br />
<input type=
"submit"
value=
"提交"
/>
</form>
|
zeng.php :
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
<?php
$code
=
$_POST
[
"daihao"
];
$name
=
$_POST
[
"xinming"
];
$sex
=
$_POST
[
"xinbie"
];
$nation
=
$_POST
[
"minzu"
];
$birthday
=
$_POST
[
"shengri"
];
$db
=
new
mysqli(
"localhost"
,
"root"
,
""
,
"12345"
);
$sql
=
"insert into info values('{$code}','{$name}','{$sex}','{$nation}','{$birthday}')"
;
$r
=
$db
->query(
$sql
);
if
(
$r
)
{
header(
"location:xinxi.php"
);
}
else
{
echo
"添加失败"
;
}
?>
|
添加成功:
shanchu.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
<?php
$name
=
$_GET
[
"code"
];
$db
=
new
mysqli(
"localhost"
,
"root"
,
""
,
"12345"
);
$sql
=
"delete from info where name='{$name}'"
;
$result
=
$db
->query(
$sql
);
if
(
$result
)
{
header(
"location:xinxi.php"
);
}
else
{
echo
"删除失败"
;
}
?>
|
修改数据:
在xinxi.php文件中插入代码:
1
|
<a href=
'xiugai.php?code={$atter[$i][1]}'
>修改</a>
|
相同路径下新建xiugai.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
<?php
$name
=
$_GET
[
"code"
];
$db
=
new
mysqli(
"localhost"
,
"root"
,
""
,
"12345"
);
$sql
=
"select * from info where name='{$name}'"
;
$r
=
$db
->query(
$sql
);
$atter
=
$r
->fetch_row();
?>
<h1>修改</h1>
<form action=
"xiugaichuli.php"
method=
"post"
>
<input type=
"hidden"
name=
"daihao"
value=
"<?php echo $atter[0]; ?>"
/> <br />
姓名: <input type=
"text"
name=
"xinming"
value=
"<?php echo $atter[1]; ?>"
/> <br />
性别: <input type=
"text"
name=
"xinbie"
value=
"<?php echo $atter[2]; ?>"
/> <br />
民族: <input type=
"text"
name=
"minzu"
value=
"<?php echo $atter[3]; ?>"
/> <br />
生日: <input type=
"text"
name=
"shengri"
value=
"<?php echo $atter[4]; ?>"
/> <br />
<input type=
"submit"
value=
"修改"
/>
</form>
|
相同路径下新建xiugaichuli.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
<?php
$code
=
$_POST
[
"daihao"
];
$name
=
$_POST
[
"xinming"
];
$sex
=
$_POST
[
"xinbie"
];
$nation
=
$_POST
[
"minzu"
];
$birthday
=
$_POST
[
"shengri"
];
$db
=
new
mysqli(
"localhost"
,
"root"
,
""
,
"12345"
);
$sql
=
"update info set name='{$name}',sex={$sex},nation='{$nation}',birthday='{$birthday}' where code='{$code}'"
;
$r
=
$db
->query(
$sql
);
if
(
$r
)
{
header(
"location:xinxi.php"
);
}
else
{
echo
"修改失败"
;
}
?>
|
点击修改其中一条数据: