Home >Backend Development >PHP7 >Introducing PHP7.3.5 encapsulation class to access mysql database
Recommended (free): PHP7
PHP7.3.5 encapsulation class Access mysql database
Model.class.php
<?php class Model{ // 表名属性 public $table; public $connect; //构造方法以及表名赋值 public function __construct($t){ $this->table=$t; } private function conn(){ $servername = "localhost"; $username = "root"; $password = "133"; $dbname = "myweb"; // 创建连接 if($conn=mysqli_connect($servername, $username, $password, $dbname)){ return $this->connect=$conn; } } //select查询 public function select(){ $this->conn(); $sql="SELECT * FROM {$this->table}"; $rst=mysqli_query($this->connect,$sql); while($row=mysqli_fetch_assoc($rst)){ $rows[]=$row; } return $rows; } } ?>
function.inc.php
<?php function M($name){ return new Model($name); } ?>
index.php
<?php include "Model.class.php"; include 'function.inc.php'; $rows=M('user')->select(); echo '<pre class="brush:php;toolbar:false">'; print_r($rows); echo ''; ?>
Related free learning recommendations: mysql video tutorial
The above is the detailed content of Introducing PHP7.3.5 encapsulation class to access mysql database. For more information, please follow other related articles on the PHP Chinese website!