PHP source code method to implement single entry MVC structure

This article mainly introduces the method of implementing single-entry MVC structure in PHP source code. It has certain reference value. Now I share it with you. Friends in need can refer to it.

Main:

1. MVC directory structure

2. Database tool class production

3. Create public model classes and public controller classes

--------------：-------------------------------------- blog ├─index.php 入口文件 ├─Model 模型 │ └─UserModel.class.php 用户模型类 ├─View 视图 │ └─login.html 登录表单页面 ├─Controller 控制器 │ └─UserController.class.php 用户控制器 ├─Frame 公共使用的类 │ ├─BaseModel.class.php 数据库连接类 │ ├─BaseController.class.php 控制器公共操作（设置编码，信息跳转） │ └─Db.class.php 数据库操作工具类 └─Public 静态公共文件（js,css,images） ├─js/ js文件 ├─css/ css样式文件 └─images img图片 -----------------------------------------------------------------

MVC directory structure

1) Preparation: Create branch

1 $ git checkout master2 $ git checkout -b "mvc-dbtools-base"

2) Create directory structure:

MVC Directory: Model/ Controller/ View/

Static resource directory: Public/

3) Create the project entry file [index.php]

Copy the encoding of the original login.php header(...)

　　Introducing the created controller UserController and model UserModel

1  $a();

　4) Create controller UserController 【Controller/UserController.class.php】

1 checkLoginInfo($data); 29 30 //结果提示信息 31 if($result){ 32 exit('登录成功'); 33 } else { 34 echo "用户名或密码不正确!"; 35 header('refresh:3; url=?'); 36 } 37 } 38 }

5) Create user model class UserModel [Model/UserModel.class.php]

Implementation method: checkLoginInfo() Check user name and password

      
View user model class
      
6) Login view: [view/login.html]
      
Modification of the introduction path,
      
Modification of the form submission action: action=?a=dlogin
      
1  2  3  4  5  6  7  8 
 9  10 
 11 
 12 
 13 
 14 
登录
 15 
 16 17 
 18 用户名: 19 
 20  21 
22 
23 24 
25 密 码: 26 
27  28 
29 
30 31 
 32 
 33 登录 34 重置 35 
36 
37 
38 
39 
40 41 46 47 
      


      
Click to view the login view source code
      
Database connection operations are all in the model and can be extracted to create database operation tool classes
      
Database tool class production
      
Database connection, set encoding, select database
      
Implement singleton
      
Get one row of data getOneRow, get a single array getOneData, get multiple rows getAllRows, add, delete, modify exec
      
Automatically generate insert or update statements autoExecute()
      
[Frame/Db.class.php]
      
1 host = !empty($conf['host']) ? $conf['host'] : 'localhost'; 27 $this->user = !empty($conf['user']) ? $conf['user'] : 'root'; 28 $this->pwd = !empty($conf['pwd']) ? $conf['pwd'] : 'root'; 29 $this->port = !empty($conf['port']) ? $conf['port'] : '3306'; 30 $this->charset = !empty($conf['charset']) ? $conf['charset'] : 'utf8'; 31 $this->dbname = !empty($conf['dbname']) ? $conf['dbname'] : 'web'; 32 33 $this->connect(); 34 } 35 36 /** 37 * 连接数据库，设置编码，选库 38 * @access private 39 */ 40 private function connect() 41 { 42 $this->link = @ mysql_connect("{$this->host}:{$this->port}", "$this->user", "$this->pwd") or die('连接失败!'.mysql_error()); 43 $this->setCharset($this->charset); 44 $this->useDb($this->dbname); 45 } 46 /** 47 * 设置字符便 48 * @access public 49 * @param string $char 字符编码 50 */ 51 public function setCharset($char) 52 { 53 $this->query("set names $char"); 54 } 55 /** 56 * 选择数据库 57 * @access public 58 * @param string $dbname 数据库名称 59 */ 60 public function useDb($dbname) 61 { 62 $this->query("use $dbname"); 63 } 64 65 /** 66 * 执行sql语句 67 * @param string $sql sql语句 68 * @return mixed 69 */ 70 private function query($sql) 71 { 72 $result = mysql_query($sql, $this->link); 73 if(false === $result) { 74 echo "
sql执行失败!
"; 75 echo "
失败语句：".$sql; 76 echo "
错误代号".mysql_errno(); 77 echo "
错误提示: ".mysql_error()."
"; 78 exit(); 79 } 80 return $result; 81 } 82 83 /** 84 * 获取本类实例 85 * @access public 86 * @param array $conf 数据库连接信息 87 * @return object 本类的单例对象 88 */ 89 public static function getDb($conf) 90 { 91 if(false === (static::$instance instanceof static)){ 92 static::$instance = new static($conf); 93 } 94 return static::$instance; 95 } 96 /** 97 * 禁止克隆 98 */ 99 public function __clone() 100 { 101 102 } 103 /** 104 * 关闭数据库连接 105 * @access public 106 */ 107 public function closeDb() 108 { 109 mysql_close($this->link); 110 } 111 112 public function exec($sql) 113 { 114 $result = $this->query($sql); 115 return $this->affectedRows(); 116 117 } 118 /** 119 * 受影响的行数 120 * @return int 返回受影响的行数 121 */ 122 private function affectedRows() 123 { 124 return mysql_affected_rows($this->link); 125 } 126 127 /** 128 * 执行 “返回一行数据”的查询 129 * @param string $sql sql语句 130 * @return array 一维数组（一行） 131 */ 132 public function getOneRow($sql) 133 { 134 $result = $this->query($sql); 135 $data = mysql_fetch_assoc($result); 136 mysql_free_result($result); 137 return $data; 138 } 139 /** 140 * 执行 "返回多行数据" 的查询 141 * @param string $sql sql语句 142 * @return array 二维数组 143 */ 144 public function getAllRows($sql) 145 { 146 $result = $this->query($sql); 147 $data = array(); 148 while($row = mysql_fetch_assoc($result)){ 149 $data[] = $row; 150 } 151 mysql_free_result($result); 152 return $data; 153 } 154 /** 155 * 执行“获取一个数据”的查询 156 * @param string $sql sql语句 157 * @return mixed 标量数据值 158 */ 159 public function getOneData($sql) 160 { 161 $result = $this->query($sql); 162 $data = mysql_fetch_row($result); 163 mysql_free_result($result); 164 return $data[0]; 165 } 166 167 /** 168 * 上次insert时的自增长id值 169 * @return int insert时的id值 170 */ 171 public function getInsertId() 172 { 173 return mysql_insert_id($this->link); 174 } 175 176 /** 177 * 序列化时，对指定数据进行序列化 178 * @return array 指定进行序列化的数据 179 */ 180 public function __sleep() 181 { 182 return array('host', 'port', 'user', 'pass','charset', 'dbname'); 183 } 184 /** 185 * 反序列化时，使用相应数据连接数据库 186 */ 187 public function __wakeup() 188 { 189 $this->connect(); //连接数据库 190 } 191 /** 192 * 自动生成insert语句或update语句 193 * @param array $data insert或update的数据 194 * @param string $table 操作的数据表 195 * @param string $act 是update还是insert操作 196 * @param string $where where条件 如 id=2 如果是update必须加，否则不执行直接返回false 197 * @return bool 执行insert与update的结果 198 */ 199 public function autoExecute($data, $table, $act='insert', $where='') 200 { 201 if($act == 'insert') { 202 $sql = "insert into ".$table."("; 203 $sql .=implode(",", array_keys($data)); 204 $sql .= ") values ('"; 205 $sql .= implode("','", array_values($data)); 206 $sql .= "')"; 207 208 $res = $this->exec($sql); 209 return $this->getInsertId(); 210 211 } else if($act == 'update') { 212 if(!$where) { return false; } 213 $sql = 'update '.$table.' set '; 214 foreach ($data as $k => $v) { 215 $sql .= $k."='".$v."',"; 216 } 217 $sql = substr($sql, 0, -1); 218 $sql .= ' where '.$where; 219 220 return $this->exec($sql); 221 } else { 222 return false; 223 } 224 225 } 226 }
      
Click to view the tool class
      
Create public model classes and public controller classes
      
　1) Public model class [Frame/BaseModel.class.php] Get database operation tool class instance
      
1 'localhost', 19 'user'=>'root', 20 'pwd'=>'root', 21 'port'=>'3306', 22 'charset'=>'utf8', 23 'dbname'=>'web', 24 ); 25 $conf = empty($config)? $conf : array_merge($conf,$config); 26 $this->db = Db::getDb($conf); 27 } 28 }
      
　2) Public control Container class [Frame/BaseController]:
      
Unified coding
      
Prompt message jump
      
1 返回
页面将在{$time}秒之后跳转！！"; 28 header("refresh: $time; url=$url"); 29 exit("
$msg
"); 30 } 31 }
      
3) Introduce tool classes, basic models and basic controller classes into the entry file
      
　【index.php】
      
1  $a();
      
Click to view the entry file
      
　4) User model class optimization【Model/UserModel.class.php】
      
1 db->getOneRow($sql); 18 return $res['pwd'] == md5($data['pwd']) ? : false; 19 } 20 }
      
5) User controller login operation, jump prompt optimization
      
Use the public controller method msg()
      
1 。。。。。。。 2 /** 3 * 登录操作： 校验登录信息 4 */ 5 public function dlogin() 6 { 7 //接收登录信息 8 $data = array(); 9 $data['username'] = trim($_POST['username']); 10 $data['pwd'] = trim($_POST['pwd']); 11 12 //实例化模型，调用模型方法 13 $model = new UserModel(); 14 $result = $model->checkLoginInfo($data); 15 //跳转提示 16 if($result){ 17 $this->msg('登录成功！', '?a=index',3); 18 } else { 19 $this->msg('用户名或密码不正确！！'); 20 } 21 }
      
Merge, save and push to git
      
1 $ git add -A 2 $ git commit -m "MVC结构，数据库操作类，基础模型类和基础控制器类制作" 3 $ git checkout master 4 $ git merge mvc-dbtools-base 5 $ git push origin master
      
Summary: Optimize the directory structure, create database operation classes, use basic model classes and basic controller classes
      
Next step: Implement singletons in model classes, further optimize the directory structure, and differentiate platforms (such as frontend, backend)
      
The above is the entire content of this article. I hope it will be helpful to everyone's study. For more related content, please pay attention to the PHP Chinese website!
      
Related recommendations:
      
A brief discussion on PHP source code five: About the creation of array array
      
A brief discussion on PHP source code one: explode and implode function

      
The above is the detailed content of PHP source code method to implement single entry MVC structure. For more information, please follow other related articles on the PHP Chinese website!