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(); } }
效果图