PHP development news release system news modification page

Create new_ed.php file

The picture above is the effect of our news list page, you can go to Seeing the modification and deletion links above, in this chapter we will tell you how to modify

The process is roughly as shown below

To modify, we need to fill in the previous The data is read out and then modified, so the first step is to read the data from the database

The code is as follows

<?php
header("content-type:text/html;charset=utf8");
$id=$_GET['id'];
$conn=mysqli_connect("localhost","root","root","News");
mysqli_set_charset($conn,"utf8");
if($conn){
    $sql="select * from new where id='$id'";
    $que=mysqli_query($conn,$sql);
    $row=mysqli_fetch_assoc($que);
}
?>

The above code can help us read the data from the database Take it out, but after reading it out, we also need to put the data where it should be displayed. For example, the title must be placed in the title input box, and the content must be placed in the content input box. Only in this way can we see that we The data filled in before can only be completed by using our HTML and PHP language. The code is as follows

## new_ed .php file complete code

<!doctype html>
<html>
<head>
    <meta charset="utf-8">
    <title>PHP中文网</title>
    <style>
        body{
            background-color: rgba(128, 128, 128, 0.3);
        }
    </style>
    <script>
        function foo(){
            if(myform.title.value==""){
                alert('请填写你的新闻标题');
                myform.title.focus();
                return false;
            }
            if(myform.content.value==""){
                alert('新闻内容不能为空哦');
                myform.content.focus();
                return false;
            }
        }
    </script>
</head>
<body>
<?php
header("content-type:text/html;charset=utf8");
$id=$_GET['id'];
$conn=mysqli_connect("localhost","root","root","News");
mysqli_set_charset($conn,"utf8");
if($conn){
    $sql="select * from new where id='$id'";
    $que=mysqli_query($conn,$sql);
    $row=mysqli_fetch_assoc($que);
}
?>
<form  method="post" action="new_upd.php?id=<?php echo $row['id'] ?>" onsubmit=" return foo();" name="myform">
    <h1>修改新闻</h1><span><a href="new_list.php">返回</a></span>
    <p>标题：<input type="text" name="title" value="<?php echo $row['title']?>"></p>
    <p>内容：<textarea cols=30 rows=5 name="content"><?php echo $row['content']?></textarea></p>
    <p><button>修改</button></p>
</form>
</body>
</html>

The next step is to submit our data to the new_upd.php page, and store the new data in the database on the new_upd.php page

Continuing Learning

new file

<!doctype html> <html> <head> <meta charset="utf-8"> <title>PHP中文网</title> <style> body{ background-color: rgba(128, 128, 128, 0.3); } </style> <script> function foo(){ if(myform.title.value==""){ alert('请填写你的新闻标题'); myform.title.focus(); return false; } if(myform.content.value==""){ alert('新闻内容不能为空哦'); myform.content.focus(); return false; } } </script> </head> <body> <?php header("content-type:text/html;charset=utf8"); $id=$_GET['id']; $conn=mysqli_connect("localhost","root","root","News"); mysqli_set_charset($conn,"utf8"); if($conn){ $sql="select * from new where id='$id'"; $que=mysqli_query($conn,$sql); $row=mysqli_fetch_assoc($que); } ?> <form method="post" action="new_upd.php?id=<?php echo $row['id'] ?>" onsubmit=" return foo();" name="myform"> <h1>修改新闻</h1><span><a href="new_list.php">返回</a></span> <p>标题：<input type="text" name="title" value="<?php echo $row['title']?>"></p> <p>内容：<textarea cols=30 rows=5 name="content"><?php echo $row['content']?></textarea></p> <p><button>修改</button></p> </form> </body> </html>

submit Reset Code

Automatic operation

PHP development 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]