mvc

mvc{

M：模型用来操作表的

V : 模版用来显示页面

C:控制器调度操作那个表产生数据调用哪个模版显示数据

}

match_list_v.html 代码

<!-- 利用HTML代码展示数据 -->
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>比赛列表</title>
</head>
<body>
 
<table>
<tr>
<th>球队一</th><th>比分</th><th>球队二</th><th>时间</th>
</tr>
<?php foreach($match_list as $row) : ?>
    <tr>
    <td><?php echo $row['t1_name'];?></td>
    <td><?php echo $row['t1_score'];?>:<?php echo $row['t2_score'];?></td>
    <td><?php echo $row['t2_name'];?></td>
    <td><?php echo date('Y-m-d H:i', $row['m_time']);?></td>
    </tr>
<?php endForeach;?>
</table> 
</body>
</html>

　　match_list_c.php 代码(引入)

<?php
require "match_list_m.php";
 
require "template/match_list_v.html";

　　match_list_m.php 代码

<?php
 
include "mysql.class.php";
 
$config=[
    "host"=>"localhost",
    "name"=>"root",
    "pwd"=>"",
    "DbName"=>"z_075mvc"
];
$db= mysqlDb::getInstance($config);
//获得比赛列表数据
$sql = "select t1.t_name as t1_name, m.t1_score, m.t2_score, t2.t_name as t2_name, m.m_time from `match` as m left join `team` as t1 ON m.t1_id = t1.t_id  left join `team` as t2 ON m.t2_id=t2.t_id";
$match_list = $db->getAssoc($sql);

　　mysql.class.php 代码

<?php
class mysqlDb{
    public $host; //服务器地址
    public $post=3306; //端口
    public $name; //用户名
    public $pwd; //m密码
    public $DbName; //数据库名称
    public $charset;//默认编码
     
    public $link;//数据库连接对象
    public $res; //资源   返回结果集
     
    //三私一公
    private static $obj;//用来存newdb对象
    //构造方法 私有的
    private function __construct($config=array()){
        /*初始化参数*/
        $this->host = $config["host"] ? $config["host"] : "localhost";
        $this->name = $config["name"] ? $config["name"] : "root";   
        $this->pwd = $config["pwd"] ? $config["pwd"]  : "";
        $this->DbName = $config["DbName"] ?  $config["DbName"] : "mysql";
        $this->charset = $config["charset"] ?$config["charset"] : "utf8" ;
         
        /*连接数据库  设置字符集*/
        $this->connectMysql();
        $this->setCharSet();
    }
    //私有化clone方法
    private  function __clone(){}
    //提供公共的返回对象方法
    static function getInstance($config=array()){
        if(!isset(self::$obj)){
            self::$obj=new self($config);
        }
        return self::$obj;
    }
     
     
    /*连接数据库*/
    function connectMysql(){
        $this->link = new MySQLi($this->host,$this->name,$this->pwd,$this->DbName);
        !mysqli_connect_error() or die("连接数据库失败");
    }
     
    /*设置字符集*/
    function setCharSet(){
        $this->link->query("set names ".$this->charset );
    }
     
    /*执行sql语句的方法*/
    function DbQuery($sql){
        $this->res = $this->link->query($sql);
        if(!$this->res){
            echo ("<br />执行失败。");
            echo "<br />失败的sql语句为：" . $sql;
            echo "<br />出错信息为：" . mysqli_error($this->link);
            echo "<br />错误代号为：" . mysqli_errno($this->link);
            die;
        }
        return $this->res;
    }
   //返回字符串
    function getStr($sql){
        $zhi = $this->DbQuery($sql);
        //将结果集转为字符串
        $arr = $zhi->fetch_all();
        $brr = array();
        foreach($arr as $v){
            $brr[] = implode(",",$v);
        }
        return implode("^",$brr);
    }
 
    //返回json
    function getJson($sql){
        $zhi = $this->DbQuery($sql);
        $brr = array();
        while($row = $zhi->fetch_assoc()){
            $brr[] = $row;
        }
        return json_encode($brr);
    }
    /*返回关联数组*/
    function getAssoc($sql){
        $zhi = $this->DbQuery($sql);
        $brr = array();
        while($row = $zhi->fetch_assoc()){
            $brr[] = $row;
        }
        return $brr;
    }
    //返回索引数组
    function getAttr($sql){
        $zhi = $this->DbQuery($sql);
        return $zhi->fetch_all();
    }
 
}

　　展示效果图