Community Learn Tools Library Leisure
search
English

News classification list of PHP native development news station

In the previous lesson, we have completed the preparation of the news classification list. Including creating a database and inserting data. So today we will explain to you how to make a news category list display page. Then find our category management page in the background template~, and then delete the unnecessary and redundant code. !

After we have set up and modified the template, we start writing our program. First connect to the database: 

<?php
error_reporting(E_ALL & ~E_NOTICE  );
// 连接mysql数据库
$link = mysqli_connect('localhost', 'root', 'root');
if (!$link) {
    echo "connect mysql error!";
    exit();
}
// 选中数据库 news为数据库的名字
$db_selected = mysqli_select_db($link, 'news');
if (!$db_selected) {
    echo "<br>selected db error!";
    exit();
}

Then query the database and execute the SQL statement: 

$sql = "select * from new_category where 1 "; // 查询语句
$result = mysqli_query($link, $sql);
$arr_news_category = mysqli_fetch_all($result, MYSQL_ASSOC);

here We have fetched all the contents of the database, and now we need to traverse the fetched data and then display it: 

<table class="table table-hover text-center">
    <tr>
        <th width="5%">ID</th>
        <th width="15%">分类名</th>
        <th width="10%">操作</th>
    </tr>
       <?php
       if (count($arr_news_category) > 0) {
           foreach ($arr_news_category as $val) {
               echo "<tr>";
               echo "<td>{$val['id']}</td>";
               echo "<td>{$val['name']}</td>";
               ?>
               <td>
                   <div class='button-group'>
                       <a class='button border-main' href='category_edit.php?id=<?php echo $val['id'];?>'>
                           <span class='icon-edit'></span> 修改</a>
                       <a class='button border-red' href='javascript:;' onclick='return del(<?php echo $val['id']?>)'>
                           <span class='icon-trash-o'></span> 删除</a>
                   </div>
               </td>
               <?
               echo " </tr>";
           }
       } else {
           echo "<tr><td colspan='3' align='center'>暂无记录！</td></tr>";
       }
       ?>

OK! The news classification list is complete, oh yes! There is also pagination here. The pagination here is the same as the news pagination. I won’t repeat it here. You can refer to the news pagination!

1746.png


Continuing Learning
||
<?php header("Content-type: text/html; charset=utf-8"); include_once "../common/category_page.php"; //添加分类 if(count($_POST)>0){ $sql = "insert into new_category (name) values ('{$_POST['name']}')"; $result = mysqli_query($link,$sql); if ($result){ echo "添加成功！"; header("Location:category_list.php"); }else{ echo "添加失败~"; echo mysqli_error($link); exit; } } ?> <!DOCTYPE html> <html lang="zh-cn"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no" /> <meta name="renderer" content="webkit"> <title></title> <link rel="stylesheet" href="../css/pintuer.css"> <link rel="stylesheet" href="../css/admin.css"> <script src="../js/jquery.js"></script> <script src="../js/pintuer.js"></script> </head> <body> <div class="panel admin-panel"> <div class="panel-head"><strong class="icon-reorder">分类列表</strong></div> <div class="padding border-bottom"> <button type="button" class="button border-yellow" onclick="window.location.href='#add'"> <span class="icon-plus-square-o"></span> 添加分类</button> </div> <table class="table table-hover text-center"> <tr> <th width="5%">ID</th> <th width="15%">分类名</th> <th width="10%">操作</th> </tr> <?php if (count($arr_news_category) > 0) { foreach ($arr_news_category as $val) { echo "<tr>"; echo "<td>{$val['id']}</td>"; echo "<td>{$val['name']}</td>"; ?> <td> <div class='button-group'> <a class='button border-main' href='category_edit.php?id=<?php echo $val['id'];?>'> <span class='icon-edit'></span> 修改</a> <a class='button border-red' href='javascript:;' onclick='return del(<?php echo $val['id']?>)'> <span class='icon-trash-o'></span> 删除</a> </div> </td> <? echo " </tr>"; } } else { echo "<tr><td colspan='3' align='center'>暂无记录！</td></tr>"; } ?> <tr> <td colspan="8"> <div class="pagelist"> <a href="category_list.php">首页</a> <?php if( $page > 1 ){ ?> <a href="category_list.php?page=<?php echo $pre_page;?>">上一页</a> <? } if( $page < $max_page ){ ?> <a href="category_list.php?page=<?php echo $next_page;?>">下一页</a> <? } ?> <a href="category_list.php?page=<?php echo $max_page;?>">末页</a> / 总页码 <font color="red"><?php echo $max_page;?></font>页 当前页码 <font color="red"><?php echo $page;?></font>页 </div> </td> </tr> </table> </div> <script type="text/javascript"> function del(id,mid){ if(confirm("您确定要删除吗?")){ } } </script> <div class="panel admin-panel margin-top"> <div class="panel-head" id="add"><strong><span class="icon-pencil-square-o"></span>添加内容</strong></div> <div class="body-content"> <form method="post" class="form-x" action=""> <div class="form-group"> <div class="label"> <label>分类名：</label> </div> <div class="field"> <input type="text" class="input w50" name="name" /> <div class="tips"></div> </div> <div class="field"> <button class="button bg-main icon-check-square-o" type="submit"> 提交</button> </div> </div> </form> </div> </div> <script> function del(id){ if( confirm("请确认删除吗?")){ document.location.href = "category_delete.php?id=" + id ; } } </script> </body> </html>
submitReset Code
Previous section None
Tutorial List
get help
  • Course Recommendations
  • Courseware download
The courseware is not available for download at the moment. The staff is currently organizing it. Please pay more attention to this course in the future~

Students who have watched this course are also learning

The latest ThinkPHP 5.1 world premiere video tutorial (60 days to become a PHP expert online training course)  492407 plays