Read and delete news list

Implementation code

1. First write a separate PHP file (conn.php) to connect MySQL database

//*******************PHP连接MySQL数据库********************
<?php
//声明PHP输出数据的字符集
header("content-type:text/html;charset=utf-8");

//0.数据库配置信息
$db_host = "localhost:3306";
$db_user = "root";
$db_pwd = "yeoman";
$db_name = "yeoman92";

//1.PHP连接MySQL服务器
$link = @mysql_connect($db_host, $db_user, $db_pwd);
if(!$link){
    echo "MySQL服务器连接失败！".mysql_error();
    exit();
}

//2.选择数据库
if(!mysql_select_db($db_name, $link)){
    echo "选择{$db_name}数据库失败！".mysql_error();
    exit();
}

//3.设置MySQL返回的数据字符集
mysql_query("set names utf8");

?>

Function Explanation:
header()

Description: Send a custom http message, in other words: the format of the data returned by PHP or character set.
Syntax: void header (string $string)
Example:

header(“content-type:text/html;charset=utf-8”) //Set the character set of data returned by PHP
header(“location:http:www .sina.com.cn”); //Web page jump

2. Write the main file (index.php)

<?php

//包含连接MySQL的文件，即文件引入
include "conn.php";

//执行查询的语句
$sql = "SELECT * FROM 007_news ORDER BY id DESC";
$result = mysql_query($sql); //返回的是结果集

?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8" />
<title>新闻列表</title>
<script type="text/javascript">function confirmDel(id){
    //询问是否删除记录
    if(window.confirm("你确定要删除吗？")){        
    //跳转到PHP的删除页面 del.php
        location.href = "del.php?id="+id;
    }
}
</script>
</head>
<body>
<table width="70%" border="1" bordercolor="#CCC" rules="all" align="center" cellpadding="5">
    <tr bgcolor="#efefef">
        <th>编号</th>
        <th>新闻标题</th>
        <th>作者</th>
        <th>来源</th>
        <th>排序</th>
        <th>点击率</th>
        <th>发布日期</th>
        <th>操作选项</th>
    </tr>
    <?php 
    $str = "";
    while($arr = mysql_fetch_array($result,MYSQL_ASSOC)){    //输出表格内容
        $str .= "<tr>\n";
        $str .= "	<td>".$arr[&#39;id&#39;]."</td>\n";
        $str .= "	<td>".$arr[&#39;title&#39;]."</td>\n";
        $str .= "   <td>".$arr[&#39;author&#39;]."</td>\n";
        $str .= "	<td>".$arr[&#39;source&#39;]."</td>\n";
        $str .= "	<td>".$arr[&#39;orderby&#39;]."</td>\n";
        $str .= "	<td>".$arr[&#39;hits&#39;]."</td>\n";
        $str .= "	<td>".date("Y-m-d  H:i", $arr[&#39;addate&#39;])."</td>\n";
        $str .= "	<td><a href=&#39;javascript:void(0)&#39;>修改</a> 
        <a href=&#39;javascript:void(0)&#39; onClick=&#39;confirmDel(".$arr[&#39;id&#39;].")&#39;>删除</a></td>\n";
        $str .= "</tr>\n";     
    }
    echo $str;
    ?></table></body></html>

Explanation of syntax structure

1. Include syntax structure, (not a function)

Description: Include and run the specified file.
Syntax: include $filename or include($filename)
Example: include “include/conn.php”

2. require syntax structure

If the included file does not exist, include will report a warning error and the script will continue to run below.
And require will report a fatal error and the script will terminate execution immediately.
Description: Include and run the specified file.
Syntax: require $filename or require($filename)
Example: require “include/conn.php”
Note: include and require both include and run files, but there is a difference.

For details on how to introduce files in PHP, please see: Four ways to introduce files in PHP and their differences

##3 . Write the file to delete the record (del.php)

<?php

//包含连接MySQL的文件，即文件引入
include "conn.php";

//执行查询的语句
$sql = "SELECT * FROM 007_news ORDER BY id DESC";
$result = mysql_query($sql); //返回的是结果集

?>

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8" />
<title>新闻列表</title>

<script type="text/javascript">
function confirmDel(id){
    //询问是否删除记录
    if(window.confirm("你确定要删除吗？")){
        //跳转到PHP的删除页面 del.php
        location.href = "del.php?id="+id;
    }
}
</script>

</head>

<body>
<table width="70%" border="1" bordercolor="#CCC" rules="all" align="center" cellpadding="5">
    <tr bgcolor="#efefef">
        <th>编号</th>
        <th>新闻标题</th>
        <th>作者</th>
        <th>来源</th>
        <th>排序</th>
        <th>点击率</th>
        <th>发布日期</th>
        <th>操作选项</th>
    </tr>
    <?php 
    $str = "";
    while($arr = mysql_fetch_array($result,MYSQL_ASSOC)){    //输出表格内容
        $str .= "<tr>\n";
        $str .= "	<td>".$arr[&#39;id&#39;]."</td>\n";
        $str .= "	<td>".$arr[&#39;title&#39;]."</td>\n";
        $str .= "   <td>".$arr[&#39;author&#39;]."</td>\n";
        $str .= "	<td>".$arr[&#39;source&#39;]."</td>\n";
        $str .= "	<td>".$arr[&#39;orderby&#39;]."</td>\n";
        $str .= "	<td>".$arr[&#39;hits&#39;]."</td>\n";
        $str .= "	<td>".date("Y-m-d  H:i", $arr[&#39;addate&#39;])."</td>\n";
        $str .= "	<td><a href=&#39;javascript:void(0)&#39;>修改</a> 
        <a href=&#39;javascript:void(0)&#39; onClick=&#39;confirmDel(".$arr[&#39;id&#39;].")&#39;>删除</a></td>\n";
        $str .= "</tr>\n";     
    }
    echo $str;
    ?>
</table>
</body>
</html>

The running effect is displayed

Detailed explanation of operating MySQL database with PHP (2)

Business process for deleting news records

Detailed explanation of operating MySQL database with PHP (2)

The above is the detailed content of Detailed explanation of operating MySQL database with PHP (2). For more information, please follow other related articles on the PHP Chinese website!

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn