PHP membangunkan halaman pengubahsuaian sistem siaran berita ringkas
Terdahulu kami memperkenalkan pelaksanaan halaman senarai berita dan beberapa modul berfungsi
Apabila kami mengklik "Ubah suai" dalam pilihan penyuntingan berita halaman senarai, Lompat terus ke halaman pengubahsuaian berita,
<body> <a href="edit.php?id=<?php echo $arr['id']?>"><font color="red">修改</font></a> </body>
Halaman pengubahsuaian berita di sini ialah edit.php, apabila anda mengklik "Edit", lompat ke halaman pengubahsuaian berita melalui nilai id berita ini ,
Gunakan $_GET untuk mendapatkan id pada halaman pengubahsuaian berita dan paparkan kandungan dalam <borang> penyata pilih pangkalan data untuk pengubahsuaian.
<?php $id = isset($_GET["id"])?$_GET["id"]:""; ?>
Pernyataan SQL adalah seperti berikut:
<?php $sql="select id,title,author,content from new where id = '$id'"; $rel = mysqli_query($link,$sql);//执行sql语句 $arr= mysqli_fetch_array($rel); //获取一条新闻的所有信息 ?>
Dapatkan tajuk, pengarang dan kandungan melalui POST
<?php $title = isset($_POST['title'])?$_POST['title']:""; //获取标题 $author = isset($_POST['author'])?$_POST['author']:""; //获取作者 $content = isset($_POST['content'])?$_POST['content']:""; //获取内容 ?>
Letakkan kandungan yang diperolehi Paparan dalam halaman HTML
<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>
Dengan cara ini, anda boleh mengklik "Ubah suai" untuk melompat ke halaman penyuntingan berita dan memaparkan halaman HTML kandungan berita.
Kod penuh:
<!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><!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>
