nginx连接php测试

1 nginx连接php

[root@web01 /application/nginx/conf/conf.d]# cat docs.conf
server {
        server_name docs.oldboy.com;
        listen 80;
        root /code;
        index index.php index.html;
        
        location / {

        }

        location ~ \.php$ {
            root /code;
            fastcgi_pass   127.0.0.1:9000;                                      # 请求被location匹配到 ,通过fastcgi_pass(php服务端)交给本地9000端口
            fastcgi_index  index.php;                                           # 默认的php文件
            fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
            include        fastcgi_params;
        }
}

2 测试php与mysql的连接(使用浏览器测试是否连接成功)

php5.6版本测试命令是mysql_connect

$conn = mysql_connect($servername, $username, $password)

php7版本测试命令是mysqli_conncet

$conn = mysqli_connect($servername, $username, $password)

测试时候选则对应的命令否则报错

[root@web01 /application/nginx/conf/conf.d]# tail -f ../../logs/error.log 
2018/12/23 22:55:05 [error] 7040#0: *13 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Call to undefined function mysqli_connect() in /code/mysql.php on line 7" wh
ile reading response header from upstream, client: 10.0.0.1, server: docs.oldboy.com, request: "GET /mysql.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "docs.oldboy.com"

[root@web02 ~]# cat /code/wordpress/mysql.php
         <?php
        $servername = "localhost";
        $username = "root";
        $password = "Bgx123.com";

        // 创建连接
        $conn = mysqli_connect($servername, $username, $password);

        // 检测连接
        if (!$conn) {
            die("Connection failed: " . mysqli_connect_error());
        }
        echo "连接成功";
        ?>