Shulou(Shulou.com)06/01 Report--

The third phase (May 21-June 20, 2017): the focus of the main development content is shifted to the user business management, and the business logic is to use PHP programs to call database tables to meet the needs of business management. In addition to installing the PDO driver in the database, you also need to install the corresponding ODBC driver to facilitate the use of the ODBC data source interface in the future. Download the 32-bit installation of mysql-connector-odbc stable version 5.3 on the MySQL official website, and then add the corresponding mysql driver to the startup-> windows file management-> ODBC data resource management program. Subject development can refer to fastphp, ppphp lightweight development framework, H-ui front-end framework, agile framework, Medoo database framework to define and build the project skeleton, sort out the main line of project development, and formally start to develop and complete the main content of the project step by step, laying a solid foundation for later online testing.

Development content:

What is stored in ① cookie is the user number and salt salt encrypted with aes. When verifying cookies, aes decrypts the cookie and takes out the user number to query the user table to compare the content of the user's salt field with the salt in cookie. If it is consistent, the cookie is valid. Through verification, the user information is extracted and stored as the backend transmission parameters to provide the page in the system for use.

② system initialization configuration and internal page invocation mechanism code writing.

③ loads the common function library and splits the header, footer and main menu of the front-end frame static page with the corresponding function. Integrate the utility or solution into the function library or function.php file, directly refer to the functional modules of the project when needed, let the tools come and go freely, and quickly solve the problems in each functional module.

④ uses data tables to store or customize constants to generate system menus.

⑤ chooses the appropriate front-end development framework and writes the core code of the control layer to ensure the realization of daily business functions such as organizational maintenance, employee natural condition maintenance, salary and personnel data maintenance, report query and data export and import.

⑥ data processing and graphic query and save as web page or spreadsheet format file.

⑦ ODBC data source interface generates reports, making full use of the company's original VFP database resources.

Combined with PHP installation and running environment, ⑧ uses the appropriate version of medoo database framework to quickly solve the diversified operation of medel layer database under the guidance of official documents.

Development skills:

① naming convention. Because the remote virtual host Linux running environment is strictly case-sensitive for setting paths and file names, for the sake of safe and stable operation, project folders, database names, data table names, table prefixes and field names are named in lowercase letters or underscores, and attention should be paid to strict case distinction in the program.

② security operation. Considering the security operation problems such as preventing SQL injection, it is necessary to write a complete user registration login encryption authentication system to use with a single entry file.

③ has a deep understanding of MVC and structured programming. In MVC mode, Controller controller is the intermediary of the interaction between Model and View. It is responsible for routing and parsing URL submission, Model model layer is responsible for reading and writing data, and view layer is responsible for view processing and output. It is said that MVC is not only a kind of technology, but also a kind of art. The idea of MVC comes from work and life, and serves work and life. MVC is not the patent of which development language, nor is it limited to which project. MVC ideas are widely used in all kinds of project development of all development languages. To develop MIS with PHP is to use structured programming ideas to realize business logic processing closely around the three-level relationship of MVC. Structured programs are easier to write and test because complex programming problems are divided into smaller, simpler tasks. Each task is accomplished by a piece of code or a function, and the code and variables in the function are independent of the rest of the program. By dealing with one simple task at a time, programming targets will be faster, more accurate, and easier to maintain.

④ multiple browsers debug alternately. In order to improve the speed of browsing pages, the browser cache is becoming more and more powerful. In the process of programming, you should be especially careful to fall into the cache pit and be blinded by the cache. You must debug the program alternately with more than two browsers, and set breakpoints where you clearly know whether the code is true or false, deliberately changing variables or file names to repeatedly test whether the program is running true or false, bypassing the cache illusion.

In order to prevent mass piracy of site content, ⑤ uses a custom constant ROOT to introduce or include files in any subdirectory using an absolute path. In the remote virtual host Lninux, "." Represents the current directory, ".." To represent the previous directory. "-" indicates the last directory, "~" represents the home directory of the current user, or you can use "pwd" to view the current absolute path. From the point of view of convenient coding and stable operation of page jump, the relative path is commonly used to go to include/require file or jump, but it is modified to absolute path in online security test to reduce the pressure on server to search for files and improve product performance and application efficiency.

Experience:

① uses plug-ins reasonably to give positive energy. The difficulty of the background mainly lies in that the chart display of the data may be involved in the secondary development, which needs to be completed by the JS plug-in. The table and form display of the data, and the data table that comes with the plug-in realizes the sorting and search of the form, and the integration and development of the external brain system greatly simplifies the workload of the project development.

② custom building is suitable for the development framework.

A framework is a basic conceptual structure used to solve or deal with systemic and complex problems. To put it bluntly, to use a frame is to use a wheel built by others. "it's easy to come, easy to go; if you come out, you'll have to pay it back sooner or later." If you use other people's wheels, you always have to pay too much for inexplicable things. In addition, large frameworks are repeatedly built on top of PHP with a pile of code, so in pursuit of extreme performance, it is not recommended to reuse too much code to build building blocks. In fact, the most elegant framework is PHP itself. Instead of using the framework, it is better to sort out the project development ideas and build the project architecture. More importantly, it is not necessarily the best to build your own MVC architecture that suits the needs of the project and integrate your ideas into the framework, but you can develop various practical functions in your own way, so that you can have an in-depth understanding of MVC development patterns. It also allows you to quickly improve your skills in the process of business project development, cultivate the ability to think independently, master the essence of the MVC framework and the object-oriented instantiation application of PHP, and be familiar with various code optimization methods of PHP, solutions to most PHP security problems, and basic PHP operating mechanism principles. Because PHP itself supports template functions, it is not necessary to use a third-party template engine, and because PDO+SQL can already be a good abstract database operation, you can easily store and operate query results with PHP array, and encapsulate project functional modules with custom functions. Functional structured programming is flexible and easy to maintain. Since it is difficult to make a choice in the face of a variety of frameworks, it is better to develop native structured development, which can not only reduce learning costs but also experience high-performance PHP services. With the rapid development of handheld devices, the rapid development of HTML5 industry standards has been driven. In order to meet the needs of highly flexible development of Web front-end to adapt to different browsers, tablets, smartphones and various handheld devices, it is necessary to use responsive strategy to develop frameworks, then use lightweight front-end frameworks such as H-ui or agile frameworks.

In short, using PHP native object-oriented to give MVC ideas to avoid the hustle and bustle of many frameworks, not to be kidnapped by the framework, in the simplest way to interpret efficiency is the king.

③ adheres to the core development concept from Avenue to simplicity. PHP has always been known for its simplicity, the development of PHP code must not be deliberately made unfathomable, as long as "the method is desirable, stable operation, to meet the needs", every link in programming should be as simple as possible, easy to use, easy to understand, all want to simple, the more simple and happy, the more simple and powerful.

It is easier for ④ to pick apples when standing on the shoulders of giants. Composer is an excellent PHP dependency manager, listing the project dependencies in the composer.json file, and then through some simple commands, Composer will automatically help you download these dependencies and configure the auto-load path. According to the needs of the project extension, using composer install/update to declare dependence, install and update automatically load third-party class libraries or plug-ins, greatly improve the efficiency and performance of developing Web applications.

⑤ Quick start to break through difficulties. The development of PHP+MySQL management information system has become a popular trend. Management information system pays attention to business practicality, but it is difficult in function realization and application promotion. Most of the reasons are that program development is out of touch with business requirements, programmers who understand technology do not understand business, and customers with business needs do not understand technology, which virtually increases the difficulty of communication and program maintenance. Endless business needs, looking forward to practical and easy-to-use management information system (MIS), Web Apps is irresistible, comply with the call of the times, the operation habits and application methods that are not suitable for the times will be gradually replaced by MIS, as long as the firm direction goes on calmly, I believe it will always break through all kinds of problems.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.