增删改查操作小练习，大家练练手吧
一、查看新闻页面-----主页面
|
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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
|
<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8" /><title>查看新闻</title></head> <body><h1>查看新闻</h1><table width="100%" border="1" cellpadding="0" cellspacing="0"><tr> <td>id</td> <td>title</td> <td>author</td> <td>source</td> <td>content</td> <td>date</td> <td>update</td> <td>delete</td></tr><?php$db=new mysqli("localhost","root","","mydb");!mysqli_connect_error() or die("连接失败！");$sql="select * from news";$result=$db->query($sql);$arr=$result->fetch_all();foreach ($arr as $v){ echo "<tr> <td>{$v[0]}</td> <td>{$v[1]}</td> <td>{$v[2]}</td> <td>{$v[3]}</td> <td>{$v[4]}</td> <td>{$v[5]}</td> <td><a href='update.php?newsid={$v[0]}'>update</a></td> <td><a href='delete.php?newsid={$v[0]}'>delete</a></td> </tr>"; } ?></table><br><br /><div class="xw"><a href="xinwen.php">发布新闻</a></div> </body></html> |
二、发布新闻页面-----添加内容
|
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
34
35
36
37
38
39
40
|
<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8" /><title>发布新闻</title><style>.xw{ margin-top:10px; margin-left:400px; border:thick; }.a{ float:left; } </style> </head> <body><h1><center>发布新闻</center></h1> <form action="addchu.php" method="post"><div class="xw">标题：<input type="text" name="title" style="width:400px"></div><div class="xw">作者：<input type="text" name="author"></div><div class="xw">来源：<input type="text" name="source"></div><div class="xw">内容:<textarea rows="10" cols="80" name="content"></textarea></div> <div class="a"><input type="submit" value="提交" style="margin-left:600px;"></div><div class="a"><a href="chakan.php"><input type="button" value="查看" style="margin-left:6px;"></a></div> </form> </body></html> |
提交内容后的处理：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
<?php$newsid=$_post["newsid"];$title=$_post["title"];$author=$_post["author"];$source=$_post["source"];$content=$_post["content"];$time=date("y-m-d",time()); $db=new mysqli("localhost","root","","mydb");!mysqli_connect_error() or die("联系失败!");$sql="insert into news values('{$newsid}','{$title}','{$author}','{$source}','{$content}','{$time}')";$result=$db->query($sql);if($result){ header ("location:xinwen.php"); }else{ echo "添加新闻失败！"; } |
三、删除内容处理
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
<?php$newsid=$_get["newsid"];$db=new mysqli("localhost","root","","mydb");!mysqli_connect_error() or die("连接失败!");$sql="delete from news where newsid='{$newsid}'";$result=$db->query($sql);if($result){ header ("location:chakan.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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8" /><title>修改新闻</title><style>.xw{ margin-top:10px; margin-left:400px; border:thick; } .a{ float:left; } </style></head> <body><h1><center>修改新闻</center></h1><?php$newsid = $_get["newsid"];$db = new mysqli("localhost","root","","mydb");$sinfo = "select * from news where newsid='{$newsid}'";$r = $db->query($sinfo);$arr = $r->fetch_row(); //这个人的所有信息?> <form action="updatechu.php" method="post"><div class="xw"><input type="hidden" name="newsid" value="<?php echo $arr[0] ?>"></div><div class="xw">标题：<input type="text" name="title" style="width:400px" value="<?php echo $arr[1] ?>"></div><div class="xw">作者：<input type="text" name="author" value="<?php echo $arr[2] ?>"></div><div class="xw">来源：<input type="text" name="source" value="<?php echo $arr[3] ?>"></div><div class="xw">内容:<textarea rows="10" cols="80" name="content"><?php echo $arr[4] ?></textarea></div> <div class="a"><input type="submit" value="修改" style="margin-left:600px;"></div><div class="a"><a href="chakan.php"><input type="button" value="查看" style="margin-left:6px;"></a></div> </form> </body></html> |
提交修改内容后进行处理：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
<?php$newsid=$_post["newsid"];$title=$_post["title"];$author=$_post["author"];$source=$_post["source"];$content=$_post["content"];$time=date("y-m-d",time());$db=new mysqli("localhost","root","","mydb");!mysqli_connect_error() or die("联系失败!");$sql="update news set title='{$title}',author='{$author}',source='{$source}',content='{$content}',time='{$time}' where newsid='{$newsid}'";$result=$db->query($sql);if($result){ header ("location:update.php"); }else{ echo "修改数据失败!"; } |
以上就是本文的全部内容，希望对大家学习php程序设计有所帮助。
