PHP development corporate website tutorial - modify news information

Click the modify page to jump to the modifnew.php page

Let’s take a look at the modifynew.php page

<?php
    require_once('conn.php');
    $id = $_GET['id'];
    $sql = "SELECT * from news where id='$id'";
    $res = mysql_query($sql);
    $row = mysql_fetch_array($res);
?>
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>修改新闻资讯</title>
    <style type="text/css">
        .ipt{width:180px;height:30px;border-radius:5px;
            outline:none;border:1px solid #eee;box-sizing:border-box;padding-left:15px;}
        .sub{width:50px;height:20px;border:1px solid #eee;background:#eee;color:#ff7575;}
    </style>
</head>
<body>
    <form method="post" action="modifynews.php?id=<?php echo $id;?>">
        标题：<input type="text" name="title" class="ipt" value="<?php echo $row['title'];?>">
        </br></br>
        内容：<textarea cols="80" rows="10" name="content" class="txt"><?php echo $row['content'];?></textarea></br></br>
        类型：<select name="type">
                <option value="0">公司公告</option>
                <option value="1">公司新闻</option>
              </select></br></br>
        <input type="submit" value="修改" class="sub">
    </form>
</body>
</html>

The form is submitted to the modifynews.php page, and also has a parameter id

Let’s take a look at the following modifynews.php page

The code is as follows:

<?php
    require_once('conn.php');
    $id = $_GET['id'];
    $title = $_POST['title'];
    $type = $_POST['type'];
    $content = $_POST['content'];
    $newtime = time();

    $sql = "UPDATE news SET title='$title',content='$content',type='$type',newtime='$newtime' where id='$id'";
    $res = mysql_query($sql);
    if($res){
        echo "<script>alert('修改新闻资讯成功');location.href='news.php'</script>";
    }else{
        echo "<script>alert('修改新闻资讯失败');history.go(-1);</script>";
    }
?>

With the above code, we have completed the function of modifying news

Continuing Learning

new file

<?php require_once('conn.php'); $id = $_GET['id']; $sql = "SELECT * from news where id='$id'"; $res = mysql_query($sql); $row = mysql_fetch_array($res); ?> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>修改新闻资讯</title> <style type="text/css"> .ipt{width:180px;height:30px;border-radius:5px; outline:none;border:1px solid #eee;box-sizing:border-box;padding-left:15px;} .sub{width:50px;height:20px;border:1px solid #eee;background:#eee;color:#ff7575;} </style> </head> <body> <form method="post" action="modifynews.php?id=<?php echo $id;?>"> 标题：<input type="text" name="title" class="ipt" value="<?php echo $row['title'];?>"> </br></br> 内容：<textarea cols="80" rows="10" name="content" class="txt"><?php echo $row['content'];?></textarea></br></br> 类型：<select name="type"> <option value="0">公司公告</option> <option value="1">公司新闻</option> </select></br></br> <input type="submit" value="修改" class="sub"> </form> </body> </html>

submit Reset Code

Automatic operation

PHP development corporate website tutorial - modify news information

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]