Cloud Grading System Development Of Road Tunnel Surrounding Rock Based On PHP-MySQL

This paper mainly improves the traditional data management mode in the system by applying MySQL database technology to the road tunnel surrounding rock cloud grading system.Describing the basic information of the project,the classification index of the surrounding rock,the surrounding rock grade and the tunnel construction method,and the relationship between the four entities are described in detail through the use of ER model,realizing the functions of storing,modifying and deleting MySQL database in Wamp integrated development environment and through PHP technology establishing the dynamic interactive Web database system conveniently quickly to query results online.Applying MySQL database to the practice of surrounding rock classification in tunnel engineering,reflects the importance of data management for the road tunnel surrounding rock cloud grading system,and verifies the accuracy of querying the basic information,surrounding rock level and construction method quickly in the database by Web page.By using these technologies to research and developing the road tunnel surrounding rock cloud grading system,the following results are obtained:(1)Through the analysis of the user's needs and feasibility analysis,the system used e-r model and logical structure design to establish the Tunnel surrounding rock classification database.The MySQL database completes the replacement of the traditional database,improving the data management mode of the system as well as the data processing efficiency,and avoiding unnecessary data loss.(2)Based on Apache server,HTML5 language and PHP language,establishing a dynamic Web page database,realizing the search for existing data in the Web query interface by using the tunnel face number or a combination of various conditions.It not only allows users to query data information conveniently and quickly,but also lays a solid foundation for further improvement of the system in the future and development of mobile phone clients.(3)By comparing and analyzing the three interfaces of mysqli extension,PDO and PHP mysql extension,chose the PDO interface method and use PHP language programming to successfully connect to the MySQL database,making the access between the database and the Web page more smooth.(4)Creaing a MySQL database in the Wamp integrated development environment,the author successfully improves the function of the road tunnel surrounding rock cloud grading system and applys it to practical projects such as the Naqiu Tunnel and the June Field Tunnel,which proved that the MySQL database runs effectively in the system.