The Design And Realization Of Office's Website Based On PHP And MySQL

Along with the development of modern science and technology, human society has gradually entered the information society. With digitization of information technology, intelligence and information networks, the globalization have become the main feature of the information society. The rapid development of information technology, and its wide range applications in all areas of the national economic and social life, have brought about great changes to the people's production and lifestyle, and have brought great promotion to social productive forces rapidly. The extent of the application of information technology and intelligent technology has become an important embodiment of a country's comprehensive national strength .The most important sign of the Information age is the network has become an important channel for people to access information. People through the network to understand the international and domestic event and the latest hot issues in a real time, various organizations and enterprises through the network distribute information. The convenience and promptness of the network in facilitating people's access to information greatly saves enterprises operating costs and improve efficiency. Thus, almost all companies, social institutions, government departments, research institutions have their own Web sites, especially in universities, almost every department maintains its own departmental websites. To Jilin University, for example, in addition each college has its own home page, the administrative bodies such as the Finance Office, Student Office, Library, Security Department, etc. also have their own independent website.The principal's office in JiLin University as an administrative body whose purpose is to service for all students and teachers in school. In order to let all teachers and students know some of the school's decision-making more easily and allow teachers and students to understand the principal's office responsibilities and the services provided, it is very important for the office to has its own separate home page. Through the principal's office home page, staff and students can obtain information about the principal's office staff, job responsibilities, rules and regulations, work procedures, service guides, and so all aspects of information, and can not only do a comprehensive in-depth understanding to the principal's office, but also can obtain a number of comprehensive information.The normal network programming, mostly use the client - server mode, but to access the database on the network is the inevitable trend of development, that is, the browser - server mode. For the user concerned, the demand for the client application is increasing, not only requires the operating convenience as the maintenance of existing client, but also requires a Web interface style. Although in a sense, a number of developers in the client program embedded the IE interface, but the client program processing performance become weaker than the original C / S structure, and still not solve the problem that IE interface handle the business clumsily, also it do not have the flexibility and user-friendly. This paper will use the B / S model to develop the system. After a comprehensive analysis and comparison decided to adopt Apache+PHP +MySQL on windows operating system platform for development. Apache is a free, stable and fast web server. Apache is developed and maintained by Apache Group a group of non-profit organizations. As the world's number one web server, the combination of apache and PHP has been hailed as the classic configuration. As the visit amount to the principle office network is small, the pressure on Web Server would not be significant, taking into account the cost will increase while use the IIS, select the open source Apache server which is sufficient to handle data traffic. The biggest advantage of PHP is the open-source and cross-platform nature. The combination of PHP with the Apache configuration has been hailed as classics. PHP is completely free open-source products. With the use of PHP and Apache, we can quickly build dynamic Web sites system. MySQL is a lightweight open-source projects which is more suitable for small and medium sized applications.According to the entire site's function the system can be divided into two separate sub-modules: basic information dissemination module, and admin module include keepsakes management module.The Basic information dissemination module that is the principal's office external website, is used to introduce the principal's office staff, job responsibilities, rules and regulations, workflow, and publishing a number of important announcements and comprehensive information .It is the important channel for all staff and students to understand the situation and access information. The following is the settings of Basic information dissemination module:1. Stuff Information: Describes all staff's positions, job duties, and contact in the principal's office, and other information which will be needed by teachers or students;2. Duty of Job: Describes the consists of the principal's office responsibilities of various departments, job responsibilities, duties and other personal information, a clear division of labor;3. Rules and regulations: Introduce the principal's office management system and management methods;4. Work Order: Describes the principal's office's all the work carried out by the workflow;5.Comprehensive information: Platform for internal information releaseing;6. Service Guide: Describes the principal's office's service available for the external;7. Internal Work: The regular meeting in the principal's office, branch building, and the activities of the organization of work;8. Service Information: Providing some of the services links provided by other departments;9. Notice: Release the school inform;10. Related Links: Links to related sites.Background management module is used for the background data management and maintenance. These mainly include: news, keepsakes, user, IP restrictions. The main task of background management module is operating the data stored in the database through increasing, deleting, changing, checking the relevant databases on the background to achieve the maintenance of the data stored in the database.The following is background management module feature setting:1. Adding News: Add news which is going to be release on the principal's office web site and will be displayed on the home page of the General Information section;2. Management of News: Manage the news that have been released;3. Adding Keepsakes: Add keepsakes available for purchasing;4. Management Keepsakes: Manage keepsakes that have been added;5. Adding Information of Keepsakes: Add related keepsakes information to notify all staff and students; 6. Management of Keepsake Information: Manage the keepsakes information which has been added;7. Viewing User Comments: View User feedback inorder to improve their work;8. Management of the News categories: Manage the type of the news;9. Managing the User: Management of the staffs;10. Managing IP restriction: Add or remove network segment information , the visit of the network segment which has been deleted will be rejected.In this paper, the development process is in full compliance with software engineering thought, has gone through requirement analysis, outline design, detailed design to coding to achieve the final test and post-maintenance optimization, top-down stepwise refinement, which effectively guarantee the quality of the site. Information technology completely changed people's way of life. It has become the most important means to obtain information, and establishing web site has become the first choice for enterprises and institutions to publish information. Jilin University Principle's Office needs to develop their own independent website for making timely delivery of the school decision to all teachers and students which will be a great convenience for the teachers and students to have a better understanding of school-run. This paper draws the key technology of HTML, CSS used during the developing of web site .By analysing the current commonly used model in Web development, as well as Web servers, scripting languages, databases and Combining with the specific functions of the principal's office Web site, decides to select the appropriate development languages and development tools, with a lower cost to develop the principal Office web site.This article is completed under the guidance of my instructor Professor Zhao Hongwei, not only he gave me invaluable help but also his rigorous academic attitude and spirit of tireless research deeply influenced me. Through this thesis work, I deeply feel the collective power and sincere feelings among classmates, friends, and teachers. Often in times of difficulties, people surrounded who will always not hesitate to lend a helping hand, so I also deeply feel the concern which collective has given to me. So here I would like to express my deep appreciation to all of you.