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 "修改失败" ;
}
?> |
点击修改其中一条数据: