windows下安装nginx、php及Postgresql的步骤

1、下载nginx、php、postgresql。

2、解压nginx、php到各自的目录下。

3、安装postgresql，有一点要注意，在安装过程中，要选择明确的国家或地区，否则可能会安装不成功。

4、将php.ini-production拷贝一份，改名为php.ini。

5、配置php.ini文件：

     1）取消extension_dir目录前的';'注释符号，并设置为php目录下的ext目录。

     2）取消extension＝php_pdo.dll目录前的';'注释符号，以打开pdo功能。

     3）取消extension＝php_pgsql_pdo.dll目录前的';'注释符号，以打开pgsql功能。

6、为保证不产生版本冲突，将postgresql/bin下所有dll文件全部拷贝到php目录下。

7、设置nginx/conf目录下的nginx.conf文件：

     #user nobody; worker_processes 1; #error_log logs/error.log; #error_log logs/error.log notice; #error_log logs/error.log info; #pid logs/nginx.pid; events { # if it's used for internet , it would be 1024, but it's for development, so to set it to be 64. worker_connections 64; } http { include mime.types; default_type application/octet-stream; #log_format main '$remote_addr - $remote_user [$time_local] "$request" ' # '$status $body_bytes_sent "$http_referer" ' # '"$http_user_agent" "$http_x_forwarded_for"'; #access_log logs/access.log main; sendfile on; #tcp_nopush on; #keepalive_timeout 0; keepalive_timeout 65; #gzip on; server { listen 80; server_name localhost; #charset koi8-r; #access_log logs/host.access.log main; location / { root html; index index.php index.html index.htm; } #error_page 404 /404.html; # redirect server error pages to the static page /50x.html # error_page 500 502 503 504 /50x.html; location = /50x.html { root html; } # proxy the PHP scripts to Apache listening on 127.0.0.1:80 # #location ~ /.php$ { # proxy_pass http://127.0.0.1; #} # pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000 # location ~ /.php$ { root html; fastcgi_pass 127.0.0.1:9000; fastcgi_index index.php; fastcgi_param SCRIPT_FILENAME D:/nginx-0.9.1/php/$fastcgi_script_name; include fastcgi_params; } # deny access to .htaccess files, if Apache's document root # concurs with nginx's one # #location ~ //.ht { # deny all; #} } # another virtual host using mix of IP-, name-, and port-based configuration # #server { # listen 8000; # listen somename:8080; # server_name somename alias another.alias; # location / { # root html; # index index.html index.htm; # } #} # HTTPS server # #server { # listen 443; # server_name localhost; # ssl on; # ssl_certificate cert.pem; # ssl_certificate_key cert.key; # ssl_session_timeout 5m; # ssl_protocols SSLv2 SSLv3 TLSv1; # ssl_ciphers ALL:!ADH:!EXPORT56:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP; # ssl_prefer_server_ciphers on; # location / { # root html; # index index.php index.html index.htm; # } #} }  

其中用到一个自建的php.conf文件，如下：

# 连接到本机 9000 端口，这里的端口是指 PHP FastCGI Server 开启的端口， # 请与 php-cgi.exe 开启的端口保持一致 # 当 Nginx 收到 php 文件的请求时，会自动转发到 PHP FastCGI Server fastcgi_pass 127.0.0.1:9000; fastcgi_index index.php; include fastcgi_params; 

8、建立启动批处理文件start_nginx_php.bat，我的如下：

@echo off echo Starting PHP FastCGI... RunHiddenConsole D:/nginx-0.9.1/php/php-cgi.exe -b 127.0.0.1:9000 -c D:/nginx-0.9.1/php/php.ini echo Starting nginx... RunHiddenConsole D:/nginx-0.9.1/nginx.exe

9、建立结束stop_nginx.bat批处理文件：

@echo off echo Stopping nginx... taskkill /F /IM nginx.exe > nul echo Stopping PHP FastCGI... taskkill /F /IM php-cgi.exe > nul exit  

10、测试代码：

<?php // 连接，选择数据库 $dbconn = pg_connect( "host=192.168.0.7 port=5432 dbname=db_test user=user_yavobo password=123456") or die( 'Could not connect :'.pg_last_error()); // 执行 SQL 查询 $query = 'SELECT * FROM tbl_test '; $result = pg_query($query) or die('Query failed:'.pg_last_error()); // 用 HTML 显示结果 echo " <table> /n"; while($line = pg_fetch_array($result, null, PGSQL_ASSOC)){ echo "/t <tr> /n "; foreach($line as $col_value){ echo "/t/t <td> $col_value </td> /n "; } echo "/t </tr> /n "; } echo " </table> /n "; // 释放结果集 pg_free_result($result); // 关闭连接 pg_close($dbconn); ?> 

11、OK！