CodeIgniter框架学习札记

CodeIgniter框架学习笔记
??
1.安装所需库: gcc    openssl-devel    zlib-devel    pcre-devel

   编译安装方式：
   解压**.tar.gz包
   cd  **目录下
   ./configure
   make
   make install

   注： /opt/nginx/sbin/nginx -V 查看安装nginx时的编译选项，

     从而查看安装的模块

2.下载 安装nginx
   http://nginx.org/

3.配置nginx
   /opt/nginx/conf/nginx.conf


user  webuser webuser;
worker_processes  8;
error_log  logs/error.log;
pid        logs/nginx.pid;
worker_rlimit_nofile 51200;
events {
    use epoll;
    worker_connections  51200;
}
   
http {
        include mime.types;
        default_type application/octet-stream;
        charset utf-8;
        underscores_in_headers on;
   
        server_names_hash_bucket_size 128;
        client_header_buffer_size 32k;
        large_client_header_buffers 4 32k;
        client_max_body_size 8m;
   
        sendfile on;
        tcp_nopush on;
   
        Gkeepalive_timeout 60;
   
        tcp_nodelay on;
   
        fastcgi_connect_timeout 300;
        fastcgi_send_timeout 300;
        fastcgi_read_timeout 300;
        fastcgi_buffer_size 128k;
        fastcgi_buffers 2 256k;
        fastcgi_busy_buffers_size 256k;
        fastcgi_temp_file_write_size 256k;
   
        gzip on;
        gzip_min_length 1k;
        gzip_buffers 4 16k;
        gzip_http_version 1.0;
        gzip_comp_level 2;
        gzip_types text/plain application/x-javascript text/css application/xml;
        gzip_vary on;
   
        server {
                listen 80;
                server_name localhost;
                root /app/workspace_lxm_php;
                index index.html index.htm index.php;
                access_log off;
   
                if (-d $request_filename) {
                rewrite ^/(.*)([^/])$ http://$host/$1$2/ permanent;
                }
   
                if (-f $request_filename.php) {
                rewrite ^(.*)/([^/.]+)$ $1/$2.php last;
                }
  
                location / {
                if (!-e $request_filename) {
                rewrite ^/(.*)$ /index.php/$1 last;
                }
   
                location ~ /index.php {
                set $path_info "";
                set $real_script_name $fastcgi_script_name;
                if ($fastcgi_script_name ~ "^(.+?.php)(/.+)$") {
                set $real_script_name $1;
                set $path_info $2;
                }
                fastcgi_pass unix:/tmp/php-cgi.sock;
                fastcgi_index index.php;
                include fastcgi_params;
                fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
                fastcgi_param PATH_INFO $path_info;
                fastcgi_param SCRIPT_NAME $real_script_name;
                }
                }
   
                location ~ \.php$ {
                fastcgi_pass unix:/tmp/php-cgi.sock;
                fastcgi_index index.php;
                fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
                include fastcgi_params;
                }
            }
   
    server {
                listen 80;
                server_name local.cn;
                root /app/workspace_lxm_php/market;
                index index.html index.htm index.php;
                access_log off;
   
                if (-d $request_filename) {
                rewrite ^/(.*)([^/])$ http://$host/$1$2/ permanent;
                }
   
                if (-f $request_filename.php) {
                rewrite ^(.*)/([^/.]+)$ $1/$2.php last;
                }
   
                location / {
                if (!-e $request_filename) {
                rewrite ^/(.*)$ /index.php/$1 last;
                }
   
                location ~ /index.php {
                set $path_info "";
                set $real_script_name $fastcgi_script_name;
                if ($fastcgi_script_name ~ "^(.+?.php)(/.+)$") {
                set $real_script_name $1;
                set $path_info $2;
                }
                fastcgi_pass unix:/tmp/php-cgi.sock;
                fastcgi_index index.php;
                include fastcgi_params;
                fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
                fastcgi_param PATH_INFO $path_info;
                fastcgi_param SCRIPT_NAME $real_script_name;
                }
                }
   
                location ~ \.php$ {
                fastcgi_pass unix:/tmp/php-cgi.sock;
                fastcgi_index index.php;
                fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
                include fastcgi_params;
                }
            }
        }
修改conf重启nginx  /opt/nginx/sbin/nginx -s reload
local.cn 模拟域名设置
vi /etc/hosts加入
127.0.0.1 localhost local.cn


使用SQLite

1.安装SQLite

a.http://www.sqlite.org 下载编译安装

b.sqlite数据库管理

    参看http://www.cnblogs.com/frankliiu-java/archive/2010/05/18/1738144.html

  
  c.PHP / PDO / SQLite3 Example
    参看http://www.if-not-true-then-false.com/2012/php-pdo-sqlite3-example/


2.CodeIgniter中数据库配置

  a.查看所用CI sytem/croe下是否有pdo的driver

  b.config/database.php进行数据库配置 参看http://codeigniter.org.cn

3.