PHP develops simple news release system news modification page

Earlier we introduced the implementation of the news list page and some of its functional modules

When we click "Modify" in the editing option of the news list page, Jump directly to the news modification page,

<body>
<a href="edit.php?id=<?php echo $arr['id']?>"><font color="red">修改</font></a>
</body>

The news modification page here is edit.php, when you click "Modify", jump to the news modification page through the id value of this news ,

Use $_GET on the news modification page to obtain the id, and display the content in the <form> form of the modification page through the database select statement for modification.

<?php
$id = isset($_GET["id"])?$_GET["id"]:"";
?>

The SQL statement is as follows:

<?php
$sql="select id,title,author,content from new where id = '$id'";

$rel = mysqli_query($link,$sql);//执行sql语句

$arr= mysqli_fetch_array($rel); //获取一条新闻的所有信息
?>

Get the title, author and content through POST method

<?php
$title = isset($_POST['title'])?$_POST['title']:"";    //获取标题

$author = isset($_POST['author'])?$_POST['author']:"";    //获取作者

$content = isset($_POST['content'])?$_POST['content']:"";    //获取内容
?>

Put the obtained content Display in HTML page

<body>
<form name="article" method="post" action="update.php" style="margin:5px;">
  <h1>新闻修改页</h1>
  <input type="hidden" name="id" value="<?php echo $arr['id']?>"/><br/>
  标 题:<input type="text" name="title" value="<?php echo $arr['title']?>"/><br/><br/>
  作 者:<input type="text" name="author" value="<?php echo $arr['title']?>"/><br/><br/>
  <span>内 容:</span>
  <textarea cols=30 rows=5 name="content"><?php echo $arr['content']?></textarea><br/><br/>
  <input type="submit" value="修改新闻"/>
</form>
</body>

This way, you can click "Modify" to jump to the news editing page and display the HTML page of the news content.

Full code:

<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <title>新闻修改页面</title>
  <style type="text/css">
    span{display:inline-block; float: left; width: 50px;}
    input[type="submit"]{margin-left: 10%;}
  </style>
</head>
<body bgcolor="#ccc">
  <?php
  
  $link = mysqli_connect('localhost','username','password','test');
          mysqli_set_charset($link, "utf8");
  if (!$link) {
    die("连接失败:".mysqli_connect_error());
  }
  
  $id = isset($_GET["id"])?$_GET["id"]:"";
  $title = isset($_POST['title'])?$_POST['title']:"";
  $author = isset($_POST['author'])?$_POST['author']:"";
  $content = isset($_POST['content'])?$_POST['content']:"";
  
  $sql="select id,title,author,content from new where id = '$id'";
  //echo $sql;
  $rel = mysqli_query($link,$sql);//执行sql语句
  $arr= mysqli_fetch_array($rel);
  ?>
  
  <form name="article" method="post" action="update.php" style="margin:5px;">
    <h1>新闻修改页</h1>
    <input type="hidden" name="id" value="<?php echo $arr['id']?>"/><br/>
    标 题:<input type="text" name="title" value="<?php echo $arr['title']?>"/><br/><br/>
    作 者:<input type="text" name="author" value="<?php echo $arr['title']?>"/><br/><br/>
    <span>内 容:</span>
    <textarea cols=30 rows=5 name="content"><?php echo $arr['content']?></textarea><br/><br/>
    <input type="submit" value="修改新闻"/>
  </form>
</body>
</html>

Continuing Learning

new file

<!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>新闻修改页面</title> <style type="text/css"> span{display:inline-block; float: left; width: 50px;} input[type="submit"]{margin-left: 10%;} </style> </head> <body bgcolor="#ccc"> <?php $link = mysqli_connect('localhost','username','password','test'); mysqli_set_charset($link, "utf8"); if (!$link) { die("连接失败:".mysqli_connect_error()); } $id = isset($_GET["id"])?$_GET["id"]:""; $title = isset($_POST['title'])?$_POST['title']:""; $author = isset($_POST['author'])?$_POST['author']:""; $content = isset($_POST['content'])?$_POST['content']:""; $sql="select id,title,author,content from new where id = '$id'"; //echo $sql; $rel = mysqli_query($link,$sql);//执行sql语句 $arr= mysqli_fetch_array($rel); ?> <form name="article" method="post" action="update.php" style="margin:5px 500px;"> <h1>新闻修改页</h1> <input type="hidden" name="id" value="<?php echo $arr['id']?>"/><br/> 标题:<input type="text" name="title" value="<?php echo $arr['title']?>"/><br/><br/> 作者:<input type="text" name="author" value="<?php echo $arr['title']?>"/><br/><br/> <span>内容:</span> <textarea cols=30 rows=5 name="content"><?php echo $arr['content']?></textarea><br/><br/> <input type="submit" value="修改新闻"/> </form> </body> </html>

submit Reset Code

Automatic operation

PHP develops simple news release system news modification page

ElementaryImperial CMS enterprise imitation website tutorial

ElementaryNewbies with zero foundation in WordPress build personal blogs and corporate websites

ElementaryUltimate CMS zero-based website building instruction video

ElementaryFront-end project-Shangyou [HTML/CSS/JS technology comprehensive practice]

IntermediateVue3.0 from 0 to build a universal backend management system project practice

ElementaryZero-based front-end course [Vue advanced learning and practical application]

ElementaryWEB front-end tutorial [HTML5+CSS3+JS]

ElementaryQuick introduction to apipost

IntermediateVue3+TypeScript practical tutorial-enterprise-level project practice

ElementaryLet's briefly talk about starting a business in PHP

IntermediateVUE e-commerce project (front-end & back-end dual project actual combat)

ElementaryApipost practical application [api, interface, automated testing, mock]