Home >Backend Development >PHP Tutorial >Detailed explanation of operating MySQL database with PHP (2)
Detailed explanation of operating MySQL database with PHP (2)
- 黄舟Original
- 2017-03-25 09:45:102116browse
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['id']."</td>\n";
$str .= " <td>".$arr['title']."</td>\n";
$str .= " <td>".$arr['author']."</td>\n";
$str .= " <td>".$arr['source']."</td>\n";
$str .= " <td>".$arr['orderby']."</td>\n";
$str .= " <td>".$arr['hits']."</td>\n";
$str .= " <td>".date("Y-m-d H:i", $arr['addate'])."</td>\n";
$str .= " <td><a href='javascript:void(0)'>修改</a>
<a href='javascript:void(0)' onClick='confirmDel(".$arr['id'].")'>删除</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['id']."</td>\n";
$str .= " <td>".$arr['title']."</td>\n";
$str .= " <td>".$arr['author']."</td>\n";
$str .= " <td>".$arr['source']."</td>\n";
$str .= " <td>".$arr['orderby']."</td>\n";
$str .= " <td>".$arr['hits']."</td>\n";
$str .= " <td>".date("Y-m-d H:i", $arr['addate'])."</td>\n";
$str .= " <td><a href='javascript:void(0)'>修改</a>
<a href='javascript:void(0)' onClick='confirmDel(".$arr['id'].")'>删除</a></td>\n";
$str .= "</tr>\n";
}
echo $str;
?>
</table>
</body>
</html>
The running effect is displayed
Business process for deleting news records
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!