MySQL + PHP+Nginx相连接

1、PHP安装

apt install php5-fpm -y  

 2、配置php-fpm

​
切换到/etc/php5/fpm/pool.d目录下，并编辑www.conf

cd /etc/php5/fpm/pool.d

gedit www.conf

将listen = /var/run/php5-fpm.sock

改为listen = 127.0.0.1:9000

​

 

3、启动php-fpm

  /etc/init.d/php5-fpm restart

  启动后查看php监听的端口号

  netstat -antp|grep php

  可知端口号正是我们上一步设置的9000这个端口号

 php平台安装及配置完成

Nginx配置

1、创建一个server，并让该服务监听8899端口

配置完记得重启nginx：/home/ubuntu/nginx/sbin/nginx -s reload

重启后，打开浏览器确认配置生效

 

 重启的前提应该先启动一下 

cd /home/ubuntu/nginx/sbin
sudo ./nginx
/home/ubuntu/nginx/sbin/nginx -s reload

 2、在8899该服务下添加php的相关配置

重新加载nginx配置：

/home/ubuntu/nginx/sbin/nginx -s reload

3、访问网页

浏览器中打开http://127.0.0.1:8899/index.php

和  http://127.0.0.1:8899/info.php

 发现网页是空白后

打开gedit fastcgi_params，在文章第一段添加

fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name; 

root@ubuntu:/home/xan/Desktop# cd /home/ubuntu/nginx/conf/
root@ubuntu:/home/ubuntu/nginx/conf# gedit fastcgi_params
root@ubuntu:/home/ubuntu/nginx/conf# cd /home/ubuntu/nginx/sbin
root@ubuntu:/home/ubuntu/nginx/sbin# sudo ./nginx
/home/ubuntu/nginx/sbin/nginx -s reload

 

 php访问mysql

1、安装三个依赖

apt install php5-mysql php5-pgsql php5-sqlite

将nginx  php-fmt  mysql全部启动 

/etc/init.d/mysql start

cd /home/ubuntu/nginx/sbin
sudo ./nginx

/etc/init.d/php5-fpm restart  

如果有apache2占用端口，用下面语句关闭

kill -9 $(ps -e | grep apache2 | awk '{print $1}')

2、在8899该服务下添加php的相关配置

cd /home/ubuntu/nginx/html/
gedit info.php

加入配置

<?php
$host = "127.0.0.1"; 
$port = "3306";  
$username = "root"; 
$password = "1";  #密码根据自己的修改
$dbname = "mysql"; 
$charset = "utf8"; 
$dsn = "mysql:dbname=$dbname;host=$host";
 try{
$pdo = new Pdo($dsn, $username, $password);
$pdo->setAttribute(PDO::ATTR_ERRMODE, 
PDO::ERRMODE_EXCEPTION); 
echo “接入mysql成功";
echo "hello world";
echo '<hr>';
$state = $pdo->query("select * from ruanjian "); 
$total_column = $state->columnCount();
var_dump($total_column);
echo '<hr>';
for ($counter = 0; $counter < $total_column; $counter ++) {
    $meta = $state->getColumnMeta($counter);
    $column[] = $meta['name'];
}
print_r($column);
set_exception_handler("cus_exception_handler");
} catch(PDOException $e){
echo “接入mysql失败";
die("连接失败: ".$e->getMessage());
}
?>

然后再启动重启nginx

cd /home/ubuntu/nginx/sbin
sudo ./nginx -s reload  #重启