(Mac os)CodeIgniter3.0部署

1. 下载3.0 http://codeigniter.org.cn/download
   下载MAMP(Mac+Apache+Mysql+PHP) https://www.mamp.info/en/downloads/

2. 部署
   1>CodeIgniter复制到htdocs目录
   2>Application的config里database配置
   $db[‘default’] = array(
   ‘dsn’ => ”,
   ‘hostname’ => ‘localhost’,
   ‘username’ => ‘root’,
   ‘password’ => ‘root’,
   ‘database’ => ‘avatar_mobile’,
   ‘dbdriver’ => ‘mysqli’,
   ‘dbprefix’ => ‘tbl_’,
   ‘pconnect’ => true,
   ‘db_debug’ => (ENVIRONMENT !== ‘production’),
   ‘cache_on’ => FALSE,
   ‘cachedir’ => ”,
   ‘char_set’ => ‘utf8’,
   ‘dbcollat’ => ‘utf8_general_ci’,
   ‘swap_pre’ => ”,
   ‘encrypt’ => FALSE,
   ‘compress’ => FALSE,
   ‘stricton’ => FALSE,
   ‘failover’ => array(),
   ‘port’ => ‘3389’,
   ‘save_queries’ => TRUE
   );

   3>创建数据库

     CREATE TABLE `tbl_advice` (
       `id` int(11) NOT NULL AUTO_INCREMENT,
       `userid` int(11) NOT NULL,
       `content` varchar(255) COLLATE utf8_bin DEFAULT NULL,
       `username` varchar(255) COLLATE utf8_bin DEFAULT NULL,
       `phone` varchar(255) COLLATE utf8_bin DEFAULT NULL,
       PRIMARY KEY (`id`)
     ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
   
   
     INSERT INTO `tbl_advice` VALUES ('1', '123', '哈打算开发少尽量发生来得及发上来的附近阿隆索f ', '王华', '1343673333'), ('2', '34  34', '嘿嘿楼上的罚款是浪费  拉伸的减肥拉伸', '梁潇', '1343673333');
   

   4>Controller

    <?php
          class Advice extends CA_Controller {

              function __construct()
              {/*{{{*/
                 parent::__construct();
              }/*}}}*/

              public function index()
              {/*{{{*/
                  $this->load->database();
                 $query = $this->db->query("SELECT id, content, username, phone FROM tbl_advice");
                 var_dump($query->result());

              }/*}}}*/
          }
    ?>

1. 浏览器访问：http://localhost:8888/bian/index.php/advice/index