Practical experience: simple connection to the PHPMySQL database Forum

Campus forums are an indispensable part of campus networks. Although the forum application based on ASP + ACCESS is simple and easy to install, MySQL database has become the preferred database for many sites with its advantages such as short, convenient, fast, and free.

Campus forums are an indispensable part of campus networks. Although the forum application based on asp access is simple and easy to install, MySQL database has become the preferred database for many sites because it is short, convenient, fast, and free, the PHP language is also highly portable, secure, reliable, fast, and efficient. Therefore, many popular forum programs are developed using PHP and MySQL. However, for Cainiao, installing the PHP MySQL forum on the server is not as simple as asp access. you only need to directly put it under the site directory to run it. Most PHP MySQL forums require installation before applications.

If you want to purchase a virtual space to run the PHP MySQL Forum program, you must first purchase a space to support PHP MySQL. generally, it is suitable to run a small forum (about 200 people are online at the same time) the minimum annual cost of a program's virtual space is generally about 300 yuan. In addition, you must create a MySQL database, user name, and password to successfully install the PHP MySQL Forum. Some virtual space providers directly provide this information to you, so you do not need to set it yourself. For example, after a database named itlm is created in the background for the K300 VM of Shanghai EIP, you have created three users, itlm_f, itlm_r, and itlm_w (their own passwords ). In this way, you can directly apply the application during installation.

If the school has its own server (Windows system), follow the steps below to set up the server runtime environment so that the server can support PHP MySQL.

Server software installation

In most cases, PHP MySQL Forum programs run on Linux, UNIX, and other systems, however, installing Linux and UNIX systems and configuring PHP MySQL is not something I can do for Cainiao! Here I recommend a Web Server software on the Win32 Platform: EasyAPM-Server. EasyAPM-Server is Win2000/XP /.

2003 quickly integrate the installation package in the Apache PHP MySQL running environment in the system. Once installed, the following programs are automatically included: Apache v2.0.54 (Win32), PHP v4.4.0 (Win32), Zend Optimizer v2.5.10a (Win32), MySQL v4.0.25 (Win32), and phpMyAdmin v2.6.3-pl1, users do not need to modify any configuration files. it is the most convenient and fast WEB server platform for beginners!

Step 2: Download the EasyAPM-Server2 from the following address:

Http://www.byshell.net/Software/Catalog143/4075.html

Step 2: decompress the downloaded file to the server d: \ usr;

Step 2: Run d: \ usr \ install on the server. install the Apache PHP MySQL integration kit in bat. in this way, your server (or personal computer) will immediately become a server supporting PHP MySQL within a few minutes.