The simplest way to implement MVC development in PHP, thinking about the model

The simplest way to implement MVC development in PHP, thinking about the model_PHP tutorial

WBOY

Release： 2016-07-13 09:58:43

Original

778 people have browsed it

The simplest way to implement MVC development in PHP, thinking about the model

Yesterday someone in the group said that using MVC adds a lot of database operations to the program, resulting in a decrease in performance. This is really disappointing. I was taken aback. MVC is just a framework and has nothing to do with database operations. MVC only provides a clear programming development model. As long as you handle it well, it is impossible to do a lot of unnecessary database operations. If an MVC allows a programmer to perform many more database operations without knowing it, it is definitely not a good MVC architecture. I think MVC only needs to provide a simple development framework. There is no need to integrate many library classes. It is best for programmers to choose to use library classes.
The purpose of my own MVC framework is just to implement a simple MVC process, and others will be added in detail based on your specific situation. Be truly compact, flexible and efficient!
I wrote two articles in the past few weeks, "The Simplest Way to Implement MVC Development in PHP - View and Template Technology" and "The Simplest Way to Implement MVC Development in PHP - Single Point of Entry". Today I will talk specifically about how to implement the MVC model.
I have not studied the theory of MVC in depth. For me personally, the model is a database encapsulation. By calling the model method, you can get the corresponding data, but the programmer does not need to care about the implementation details. In actual development, it is likely that a database table corresponds to a model. For example, a user information table userinfo corresponds to a model user. By calling the add() method of the model user, you can add a piece of data to the database, you can query it through select(), and you can update it through update. At the same time, the model should be independent of the specific database type, whether you use mysql, oracle or sql server. At the same time, I do not recommend using ROR in WEB development. It is so convenient and fast to use SQL language for complex multi-table queries, and the performance is better. If a programmer doesn't even have knowledge of SQL, I don't think he is a qualified programmer. Therefore, I provide a query method in my model to implement direct SQL query.
Below is an approximate result of the model. This is not the complete code. Please see the demo package for the complete code.

<? 
class module{ 

var $mysql;//数据库操作类，可以是mysql,oracle,sql等等 

var $tbname;//模型对应的表名称 

var $debug=false;//是否是调试模式 

function module($tbname,$db=''){}//构造函数 

function _setDebug($debug=true){}//开启或者关闭调试模式 

function add($row,$tbname=''){}//新增加一条记录 

function query($strsql){}//直接查询sql语句 

function count($where='',$tbname=''){ }//计数统计 

function select($where='',$tbname=''){}//查询 

function delete($where='',$tbname=''){}//删除满足条件的一个记录 

function update($set,$where,$tbname=''){}//更新指定记录 

function detail($where,$tbname=''){}//详细显示一条记录 
} 
?>

Copy after login

In this model, I use arrays and database fields to correspond. In the early PHPBEAN, objects were used to correspond. But later I felt that this method was not good in PHP and added a lot of unnecessary classes. It is more convenient and better to use arrays (arrays in PHP are indeed a good thing, much better than JAVA).

In the demo below, I used the mysql database for demonstration, in which the database operation class was changed to one of my original library classes. For details, please see "Modify the previous library class, php5->php4".

Below, the use of demo will be explained in detail. ^_^
Add

to the index.php of the original package

<? 
require_once(SITE_PATH.'/libs/phpbean.class.php'); 
require_once(SITE_PATH.'/libs/mysql.class.php'); 
$phpbean=new phpbean(); 
global $phpbean; 

$mysql=new mysql("localhost","****","****","52site"); 
$phpbean->register('db',$mysql); 
unset($mysql); 
?>

Copy after login

This code mainly registers MYSQL into the registrar. For the principles of using the registrar, you can read the two articles I translated.
Then create a new mysqlController.class.php file with the following code:

<? 
/** 
* MVC演示demo 
* 仅仅实现最基本的MVC功能，不包含安全处理，数据过滤，及其他优化措施。 
* @author:feifengxlq 
* @since:2007-1-24 
* @copyright http://www.phpobject.net/blog/ 
*/ 
class mysqlController 
{ 
var $module; 

function mysqlController(){ 
require_once(SITE_PATH.'/libs/module.class.php'); 
$this->module=new module('52site_siteinfo');//52site_siteinfo为表名称 
$this->module->query("set names 'gb2312'");//如果是MYSQL5请加上这句 
} 

function indexAction(){ 
print_r($this->module->select());//这样实现了读取数据 
} 
} 
?>

Copy after login

The above is first to add a model to the constructor of the controller. Then call the model method in indexAction to display the data. This implements the simplest query list. You can view your results via this address http://path/to/yoursite/mv...
In the future, I will write a specific demo to explain how to use other methods of the model, such as query, update, add, paging list, multi-table query, etc.

Articles you may be interested in

php creates a simple case of your own MVC framework, providing ideas, for reference only
php obtains web content through socket Simple example
Some development experience on MVC in PHP
PHP gets the week and the first and last day of the month of the specified date
Use the PHP function memory_get_usage to get the current PHP memory consumption to optimize program performance
Summary of thinkphp development skills
The reason why PHP adds a backslash before quotation marks and how to remove the backslash in PHP, three ways to close php Magic quotes
PHP Get date list 30 days before current date