PHP development corporate website tutorial to display news information (1)

We have already introduced how to display information in the previous content, look at the code:

<?php
    require_once('conn.php'); //连接数据库
    require_once('functions.php');
    $sql = "SELECT * FROM news order by id desc";
    $info = mysql_query($sql);    
?>
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>展示新闻资讯</title>
    <style type="text/css">
        .top{height:30px;line-height:30px;float:right;margin-right:15px;}
        .top a{color:red;text-decoration:none;}
        .cont{width:100%;height:300px;float:left;}
        .cont_ct{float:left;}
        table{width:100%;border:1px solid #eee;text-align:center;}
        th{background:#eee;}
        td{width:200px;height:30px;}
    </style>
</head>
<body>
    <div class="top"><a href="addne.php">添加新闻资讯</a></div>

    <div class="cont">
        <table cellspacing="0" cellpadding="0" border="1">
            <tr>
                <th>ID</th>
                <th>类别</th>
                <th>标题</th>
                <th>内容</th>
                <th>操作</th>
            </tr>
            <?php
                //获取表中的数据
                while($row=mysql_fetch_array($info)){
            ?>
            <tr>
                <td><?php echo $row['id'];?></td>
                <?php
                    if($row['type']==1){
                ?>
                <td>公司新闻</td>
                <?php
                    }else{
                ?>
                <td>公司公告</td>
                <?php
                    }
                ?>
                <td><?php echo $row['title'];?></td>
                <td><?php echo msubstr($row['content'],0,15);?></td>
                <td>
                    <a href="modifnew.php?id=<?php echo $row['id'];?>">修改</a>
                    <a href="delnews.php?id=<?php echo $row['id'];?>">删除</a>
                </td>
            </tr>
            <?php
                }
            ?>
        </table>
    </div>
</body>
</html>

The above code has already displayed the news information

Continuing Learning

new file

<?php require_once('conn.php'); //连接数据库 require_once('functions.php'); $sql = "SELECT * FROM news order by id desc"; $info = mysql_query($sql); ?> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>展示新闻资讯</title> <style type="text/css"> .top{height:30px;line-height:30px;float:right;margin-right:15px;} .top a{color:red;text-decoration:none;} .cont{width:100%;height:300px;float:left;} .cont_ct{float:left;} table{width:100%;border:1px solid #eee;text-align:center;} th{background:#eee;} td{width:200px;height:30px;} </style> </head> <body> <div class="top"><a href="addne.php">添加新闻资讯</a></div> <div class="cont"> <table cellspacing="0" cellpadding="0" border="1"> <tr> <th>ID</th> <th>类别</th> <th>标题</th> <th>内容</th> <th>操作</th> </tr> <?php //获取表中的数据 while($row=mysql_fetch_array($info)){ ?> <tr> <td><?php echo $row['id'];?></td> <?php if($row['type']==1){ ?> <td>公司新闻</td> <?php }else{ ?> <td>公司公告</td> <?php } ?> <td><?php echo $row['title'];?></td> <td><?php echo msubstr($row['content'],0,15);?></td> <td> <a href="modifnew.php?id=<?php echo $row['id'];?>">修改</a> <a href="delnews.php?id=<?php echo $row['id'];?>">删除</a> </td> </tr> <?php } ?> </table> </div> </body> </html>

submit Reset Code

Automatic operation

PHP development corporate website tutorial to display news information (1)

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]