php保存数据到数据库到后台显示删除编辑，到前台展示

Posted on 2015-06-03 17:05  小蕊同学  阅读(514)  评论(0)  编辑  收藏  举报
1.编写html页面
  1. <!doctype html>
  2. <html>
  3. <head>
  4. <meta charset="utf-8">
  5. <title>无标题文档</title>
  6. </head>
  8. <body>
  9. <form action="jobaddsave.php" method="post">
  10. 招聘标题:<input type="text" name="title"><br>
  11. 招聘要求：<textarea cols="10" rows="5" name="content">
  13. </textarea><br>
  14. <input type="submit" value="提交">
  16. </form>
  17. </body>
  18. </html>

2.编写jobaddsave.php页面，通过html页面把数据保存到数据库中
  1. <?php
  2. include '../inc/db_mysqli.php';
  3. $_POST['utime']=time();
  4. save('hnsc_job',$_POST);
  5. header('location:jobadmin.php');
  6. ?>
3.数据库中创建数据库表格hnsc_job  
  1. create table hnsc_job(
  2. 	id int unsigned auto_increment,
  3. 	title varchar(30),
  4. 	content text,
  5. 	utime int,
  6. 	primary key(id)
  7. )engine=myisam default charset=utf8;
4.查询数据库
select * from hnsc_job

5.实现网站前台，显示添加的内容加入如下代码
  1.      <?php
  2. 		$rows = query('hnsc_job');
  3. 		$i = 0;
  4. 		foreach($rows as $v){
  5. 		   echo '<h1>'.++$i.'、'.$v[1].'</h1>';	
  6. 		   echo nl2br($v[2]).'<br>';
  7. 		}
  8. 		?>

nl2br — 在字符串所有新行之前插入 HTML 换行标记
后台显示修改jobadmin.php
  1. <?php
  2. include '../inc/db_mysqli.php';
  4. //删除友情链接信息
  5. if(isset($_GET['del'])){
  6. 	$stmt=$m->prepare('delete from hnsc_job where id=?');
  7. 	$dd=$_GET['del'];
  8. 	$stmt->bind_param('i',$dd);
  9. 	$stmt->execute();
  10. 	$stmt->free_result();
  11. 	$stmt->close();
  12. }
  13. //预处理语句查询数据
  14. $stmt=$m->prepare('select * from hnsc_job order by id desc');
  15. $stmt->execute();
  16. $result=$stmt->get_result();
  17. $rows=$result->fetch_all(2);
  18. $stmt->free_result();
  19. $stmt->close();
  20. $m->close();
  21. ?>
  22. <!DOCTYPE html>
  23. <html>
  24.     <head>
  25.     <meta charset="utf-8">
  26.     <title></title>
  27.     <meta name="keywords" content="关键字">
  28.     <meta name="description" content="简介">
  29.     <script src=""></script>
  30.     <style>
  31. th {
  32. 	font-size: 14px;
  33. 	letter-spacing: 2px;
  34. 	background-color: #efefef;
  35. 	padding: 15px;
  36. }
  37. tr {
  38. 	background-color: #FFFFFF;
  39. }
  40. td {
  41. 	padding: 10px;
  42. 	text-align:center;
  43. 	font-size:12px;
  44. }
  45. </style>
  46.     </head>
  47.     <body>
  48. <table cellspacing="1" border="0" width="80%" bgcolor="#BFBFBF" align="center">
  49.       <tr bgcolor="#FFFFFF">
  50.     <th>标题</th>
  51.     <th>招聘内容</th>
  52.     <th>加入时间</th>
  53.     <th>操作</th>
  54.   </tr>
  55. <?php
  56. foreach($rows as $v){
  57. 	?>
  58.   <tr>
  60.   <td><?=$v[1]?></td>
  61.   <td><?=$v[2]?></td>
  62.  <td><?=date('Y-m-d H:i:s',$v[3])?></td>
  63.    <td>
  64.     <a href="?del=<?=$v[0]?>" onClick="return confirm('是否要删除?')">删除</a>
  65.    
  66.    </td>
  67.   </tr>
  68.   <?php
  69. }
  70.   ?>
  72. </table>
  73. <a href="jobaddd.html">添加新的招聘信息</a>
  74. </body>
  75. </html>












Copyright © 2024 小蕊同学
Powered by .NET 8.0 on Kubernetes