Web Database Application Under Linux

On the basis of research on Web database on the platform of Linux, the article designs and implements a database management tool based on Web, called phpMiniAdmin. The tool was a result of the application of some software technology and with it the Internet user can manage mSQL, a mini DBMS, through Web browser, such as Internet Explorer.Web database technology is a combination of Web technology with database. Currently, there's some main development technology of dynamic Web database application, such as ASP, JSP, PHP, CGI. The article emphatically applied PHP and the methods of object orientation to design phpMiniAdmin. The methods and technology of object orientation have become a core one for developing software. It can simplify the analysis, design and implement of the application and help to reusage of the system. On the whole course of design, phpMiniAdmin applied the technology of object orientation.The database management tool based on Web not only can enhance the permissions management over the users of mSQL, but also extend the database management and application to the side of Web client. The users can operate phpMiniAdmin conveniently with the tool of Graphic User Interface (GUI), the Web browser. The article put forward a grading control based on object technology over the permissions of mSQL system. The method divides the permissions of the whole mSQL into three grades including system grade, database grade and table grade. It encapsulates each grade permission into a class and designs a flexible algorithm, which is based on the calculation of bits and is for the assignment and checkage of permissions.Besides, phpMiniAdmin also realizes the statistic of session, the record of user operation and the encryption of user password during transfer and in database, etc.