How to set up php mysql environment

How to build a php mysql environment

Install Apache

1. Download Apache, address: http://www.apachelounge.com/download/, as shown below:

##2. Unzip the compressed package, It is best to put it in the root directory of the disk, otherwise it is easy to report a path error during configuration. I have changed the folder name here to facilitate future configuration, as shown below:

Installation PHP

1. Download the PHP compressed package at: https://windows.php.net/download. I downloaded the PHP7.0 Thread Safe version, as shown below:

2. Unzip the compressed package. I unzipped it as follows:

Install MySQL

1. The MySQL55 version I installed. I will not introduce the installation method of MySQL here. You can search it online by yourself

2. MySQL official download address:
https://dev.mysql.com/downloads/installer/3. The default installation directory of MySQL is as follows:

Configuring MySQL

1. Check-in environment variable page

The specific operations are as follows: My Computer-right-click-Properties-Advanced System Settings-Environment Variables
2. Create a new MYSQL_HOME variable, the value is the installation path of MySQL, as shown below:

3. Edit the path system variable and add %MYSQL_HOME%\bin to the end of the path variable.

4. Start MySQL and enter: start mysqld on the command line, as shown below:

Configuring PHP

1. Open the PHP installation directory and copy php.ini-development first, then change php.ini-development to php.ini and save it.

2. Open php.ini to modify the configuration, search; extension_dir = “ext”, change to extension_dir = “ext directory”, for example extension_dir = “D:\Software\php7\ext”, as shown below:

3. Open several commonly used extensions, for example: find extension=php_mysqli.dll and remove the preceding semicolon. Open the libraries in the picture below:

Configuring Apache

1. Open the Apache installation directory and find the conf file folder and open the httpd.conf file

2. Find the "Define SRVROOT" item and change the value in the following quotation marks to the Apache installation directory, as shown below:

3. Add support for PHP and PHP installation path at the end of the file, as shown below:

##The code is as follows:

# php7 support
LoadModule php7_module "D:/软件/php7/php7apache2_4.dll"
AddType application/x-httpd-php .php .html .htm

# configure the path to php.ini
PHPIniDir "D:/软件/php7"

Start Apache service

1. Set environment variables

Right-click My Computer, Properties->Advanced, find the environment variables button at the bottom, and select the current user's PATH variable. Edit and create the following entries:

D:\Apache24\bin

D:\Software\php7

D:\Software\php7\ext

2 , Install the apache service

Open the command line as an administrator, execute httpd.exe -k install

3. Start the service

Find the bin file in the installation directory of apache folder, double-click ApacheMonitor.exe, and apache will start after double-clicking.

You can select the icon below in the taskbar, right-click to open the Apache Service Monitor window, and manage the Apache service

4. At this time, go to the browser address Enter localhost in the field and press Enter, the apache interface will appear, as shown below:

5、接下来在 Apache安装目录/htdocs的目录下新建一个phpinfo.php文件，内容为：

<?php
phpinfo();
?>

保存后，在浏览器输入127.0.0.1/phpinfo.php，回车，出现关于PHP的版本信息，如下图：

至此php环境搭建完成，可以将php文件放入htdocs文件夹中运行了

踩到的坑

1、浏览器输入对应PHP地址后，无法解析php
解决：在命令行输入httpd -t，可以查看是不是Apache的启动问题，如下图：

可以看到，报错信息是说找不到PHP安装目录下的php7apache2_4.dll文件，通过网上查后我下载的PHP版本不对，应该下载Thread safe 版本。

推荐教程： 《php教程》

The above is the detailed content of How to set up php mysql environment. For more information, please follow other related articles on the PHP Chinese website!