Configuration of Php+mysql running environment

Installation steps:

1. Extract the compressed package into the C:\PHP directory.

2. Copy all the files in the "C:\php\dlls" directory to the "C:\WinNT\System32 (Winodws98 system C:\Windows\System)" directory and overwrite it with the presence of an old file.

3. Rename the C:\PHP\php.ini-dist file to php.ini, copy it to the "C:\WinNT (Winodws98 system C:\Windows)" directory and modify the contents, as follows:
Find "Extension_dir =" instead of "extension_dir=c:/php/extensions"
Look a little further down and change to this:
; Windows Extensions
; Note that MySQL and ODBC support are now built in, so no DLL are needed for it.
;
Extension=php_bz2.dll
Extension=php_ctype.dll
Extension=php_cpdf.dll
Extension=php_curl.dll
Extension=php_cybercash.dll
Extension=php_db.dll
Extension=php_dba.dll
Extension=php_dbase.dll
Extension=php_domxml.dll
Extension=php_dotnet.dll
Extension=php_exif.dll
Extension=php_fdf.dll
Extension=php_filepro.dll
Extension=php_gd.dll
Extension=php_gettext.dll
; Extension=php_ifx.dll
Extension=php_iisfunc.dll
Extension=php_imap.dll
Extension=php_interbase.dll
Extension=php_java.dll
Extension=php_ldap.dll
Extension=php_mhash.dll
; Extension=php_mssql65.dll
Extension=php_mssql70.dll
; Extension=php_oci8.dll
Extension=php_openssl.dll
; Extension=php_oracle.dll
Extension=php_pdf.dll
Extension=php_pgsql.dll
Extension=php_printer.dll
Extension=php_sablot.dll
; Extension=php_snmp.dll
; Extension=php_sybase_ct.dll
Extension=php_yaz.dll
Extension=php_zlib.dll

If the library is not normal at run time, add the semicolon ";" at the beginning of the line.

4. Repair the registration form. (You need to restart your computer to take effect)
In the Hkey_local_machine\system\currentcontrolset\services\w3svc\parameters\script Map
Add the following key values:
Key name: ". PHP "Key value:" C:\php\php.exe%s%s "

5. Click the "Start-> program-> Administrative Tools->internet Service Manager" to open Internet Services Manager, right-click the default Web site-> properties to open the Default Web Site Properties window, under the ISAPI filter Configuration page, Add a new filter named PHP, the executable file is the full path to the Php4isapi.dll file, such as C:\php\sapi\php4isapi.dll; under the Home Directory Configuration page, press the Configure button to open the Application Configuration window. Add an application mapping entry, executable file as Php.exe, full path to file
such as C:\PHP\php.exe, the extension is. PHP (of course, you can also change to something else, but note that your PHP program to use it as a suffix OH), the "script engine" tick, restart the computer and WWW service.

Test PHP running Environment

In the site directory to write a test program test.php, the content of


Installation and configuration of MySQL database system

First, download the MySQL database (ODBC) driver and MySQL database system program

1.MySQL Database (ODBC) driver download address: http://mysql.com/Downloads/MyODBC/myodbc-2.50.36-nt.zip, http:// Download.sourceforge.net/pub...-2.50.36-nt.zip or Http://www.fykx.net/download/php/myodbc-2.50.36-nt.zip (1457KB)

2.MySQL Database System program Download address: Http://www.mysql.com/Downloads/MySQ ... 0-gamma-win.zip (9632KB) or http://www.fykx.net/download/php/my ... 0-gamma-win.zip

Second, the installation of the program

1. Install MySQL database (ODBC) driver (must be installed under Windows System)

2. Install MySQL database System program, generally installed in the system default location "C:\MySQL", but to consider whether your server as a network database server, if you want to set up hundreds of database users on this server, it should be installed in the space compared to large hard drive, To avoid unnecessary trouble and cumbersome settings in the future.

Third, the commencement of the program

Execute the "[System Installation Letter]:\mysql\bin\winmysqladmin.exe" This program to start the MySQL database system and manager, the first time you start, the system will appear "Quick Settings" window, the request to establish the first database user account, the following figure. Enter the username of the first MySQL database account in User name, enter the password of the first MySQL database account in password, preferably you remember the value entered, and then enter the MySQL database Management window, after a while the program automatically minimizes the window to the system tray ( There is a "traffic light" icon on the right side of the taskbar, and the system is starting normally (Windows2000 also checks the "MySQL Component Services" in Component Services Manager for startup). At this point, the program also added a shortcut in the Startup group, the next time you start the computer will automatically start the MySQL database system.


Iv. Establishment of the database

The first time the database is started, the system automatically creates two databases called MySQL and test, and you can create a database of other names in the following ways:

Right-click the system Bay Traffic light icon =>> Click Show me to open the MySQL Database Management window =>> Select the Databases tab =>> Select Database Server =>> right-click => > select the "CREATE DATABASE" menu item =>> in the Pop-up Add Database dialog box, type the database name =>> Click Create the Datebase (create this database). A new database is set up. The following figure


V. Database user account Management

The first time you start a database to create a database user account, if your server to allow multiple users to use, you have to set up a number of database user accounts, the following steps:

Start ODBC Data Source Administrator (ODBC Data Source Administrator under the WindowsNT System) in Administrative Tools, WINDOWS98 or me system ODBC data Source Administrator in Control Panel =>> Click in the first label User DSN in the ". Add button =>> Select "MySQL" in the data source driver list =>> Click Finish to =>> the "Dynamic Education Network" in the Database Driver Configuration dialog box "Windows DSN name" ( For the dynamic Education Network Open account, in the MySQL host (name or IP) fill in the server's hostname or IP address, in the MySQL database name, fill in the names of databases in the user, fill in the username of the database account number, In password, fill in the password of the database account number, others for the default settings =>> click OK. A new database account is set up.


Vi. Debugging procedures (vbulletin version 1.1.5 Chinese Standard Edition after the layout style is used as the proxy example)

1. Modify the admin/config.php document as follows:


Only MySQL is currently supported
$dbservertype = "MySQL";
hostname or server IP
$servername = "localhost";
User name and password for login to the database
$dbusername = "Xiaozhang";
$dbpassword = "123456";
Database name
$dbname = "MySQL";
Allow viewing/editing of passwords in Control Panel
0 = not visible or edited
1 = not visible, but can be edited
2 = visible and can be edited
$PWDINCP = 2;

?>