Home > Article > Backend Development > How to query the content of Mysql database in php language
How to query the content of Mysql database in php language
- coldplay.xixiOriginal
- 2020-08-27 09:53:442230browse
How to query the content of Mysql database in php language: First, the php page needs a php language execution environment when browsing; then create a php class file [mysql.php] for specific operations; then create a page file [ index.php] to receive data; finally access the path.
【Related learning recommendations: mysql tutorial】
How to query the content of Mysql database in php language:
1. When browsing the php page, you need a php language execution environment. I use WampServer software. Just copy the project to wampserver_php\wamp\www\The php language can be executed under this path.
2. Create a php class file (mysql.php) for specific operations
<?php
/*设置内容类型和编码样式*/
header("content-type:text/html;charset=utf-8");
/*对数据库操作*/
class dbMysqli{
private $conn = null;
public $message = "";
/*设置错误接受机制*/
function Message($mes,$flag=true){
if($flag){
$this->message .="<div style='color:green;font-size:12px;'>".$mes."</div>";
}else{
$this->message .="<div style='color:green;font-size:12px;'>".$mes."</div>";
}
}
/*连接数据库服务器，设置连接数据库编码*/
function __construct($host,$user,$pwd,$dbName,$charset){
//连接数据库服务器选择数据库
$this->conn = new mysqli($host,$user,$pwd,$dbName);
if($this->conn === false){
$this->Message("连接数据库失败",false);
return false;
}else{
$this->Message("连接数据库成功，选择数据库");
}
//设置连接编码
if($this->conn->set_charset($charset)){
$this->Message("设置编码成功");
}else{
$this->Message("设置编码失败",false);
}
}
/*查询数据库数据*/
public function MoreData($sql){
$sql = trim($sql);
/*检查sql语言是否正确*/
$result = preg_match('/^select/i',$sql);
if($result){
//执行sql语句
$rs = $this->conn->query($sql);
if($rs === false){
$this->Message("执行'".$sql."'失败，失败原因：".$this->conn->error,false);
return false;
}else{
$this->Message("执行'".$sql."'成功");
$RS = $rs->fetch_all(MYSQL_ASSOC);
$rs->free();
return $RS;
}
}else{
$this->Message("执行'".$sql."'失败",false);
return false;
}
}
}
/*链接数据库地址、用户名，密码，数据库名，编码方式*/
$db = new dbMysqli('localhost','root','cly8','user','utf-8');
3. Create a page file (index.php) to receive data
<?php
header("content-type:text/html;charset=utf-8");
error_reporting(E_ALL);
//引入一个数据库操作类
include_once 'mysql.php';
//查询数据
$rs = $db->MoreData("select * from student");
?>
<html>
<head>
<meta charset="utf-8" />
<title>css3实现多彩动态漩涡线条特效动画</title>
</head>
<style>
table{
font-family: verdana,arial,sans-serif;
font-size:11px;
color:#333333;
border-width: 1px;
border-color: #666666;
border-collapse: collapse;
}
table th {
border-width: 1px;
padding: 8px;
border-style: solid;
border-color: #666666;
background-color: #dedede;
}
table td {
border-width: 1px;
padding: 8px;
border-style: solid;
border-color: #666666;
background-color: #ffffff;
}
</style>
<body>
<table>
<tr>
<th>编号</th>
<th>姓名</th>
<th>密码</th>
</tr>
<?php foreach($rs as $val) {?>
<tr>
<td><?php echo $val['Sid'];?></td>
<td><?php echo $val['Sname'];?></td>
<td><?php echo $val['Password'];?></td>
</tr>
<?php }?>
</table>
</body>
</html>4. The last access path is http://localhost/folder name/index.php
If you want to learn more about it, please stay tuned. php training column!
The above is the detailed content of How to query the content of Mysql database in php language. For more information, please follow other related articles on the PHP Chinese website!