ci框架（二），ci框架_PHP教程-tutorial php-php.cn

ci框架（二），ci框架

自定义SQL语句

当提供的API满足不了我们对SQL语句的要求的时候，我们通常是自己来写SQL语句，CI也提供了比较强大了，能够满足我们需求的一般的sql的API。

<span>$res</span>=<span>$this</span>->db->select('id,name'<span>)
    </span>->from('表名'<span>)
    </span>->whrer('id >=',5)<span>//</span><span>注意id后面要有个空格</span>
    ->limit(3,2<span>)<span>//这里与sql的limit是顺序是反的</span>
    </span>->order_by('id desc '<span>)
    </span>->get();<span>//</span><span>翻译成sql语句</span>
<span>var_dump</span>(<span>$res</span>-><span>result());
</span><span>echo</span> <span>$this</span>->db->last_query();<span>//</span><span>先是最近一条SQL</span>

Salin selepas log masuk

自定义扩展控制器

在application/core中新建MY_Controller.php

<span>class</span> MY_Controller <span>extends</span><span> CI_Controller
{
    </span><span>public</span> <span>function</span><span> __construct()
    {
        parent</span>::<span>__construct();
        </span><span>//</span><span>一定呀先调用父类的构造方法
        //登录验证、权限验证、其他操作。。。</span>
<span>    }
}</span>

Salin selepas log masuk

同时需要在application/config/config.php中配置一下：

<span>$config</span>['subclass_prefix'] = 'MY_';

Salin selepas log masuk

自定义扩展模型

在application/models中创建user_model.php

<span>class</span> User_model <span>extends</span><span> CI_Model
{
    </span><span>public</span> <span>function</span><span> getAll()
    {
        </span><span>$res</span> = <span>$this</span>->db->get('表名'<span>);
        </span><span>return</span> <span>$res</span>-><span>result();
    }
}</span>

Salin selepas log masuk

在控制器中调用自定义模型

application/controllers:

<span>class</span> User <span>extends</span><span> MY_Controller
{
    </span><span>public</span> <span>function</span><span> index()
    {
        </span><span>$this</span>->load->model('User_model');<span>//</span><span>调用以类名为主，而不是文件名</span>

Salin selepas log masuk

<span>$list</span> = <span>$this</span>->User_model->getAll();<span>//</span><span>调用模型获取数据</span>

Salin selepas log masuk

<span>$this</span>->load->view('user/index',<span>array</span>('list'=><span>$list</span>));<span>//</span><span>加载视图</span><span>  
    }   
}</span>

Salin selepas log masuk

加载模型的时候可以给模型取一个名字：

<span>$this</span>->load->model('User_model','user');<span>//</span><span>调用以类名为主，而不是文件名        </span>
<span>$list</span> = <span>$this</span>->user->getAll();<span>//</span><span>调用模型获取数据</span>

Salin selepas log masuk

Url相关函数

在表单验证的时候，需要把数据传给控制器，怎么准确的而且可扩展的写action呢，调用API：

<span>public</span> <span>function</span><span> addView()
{
    </span><span>$this</span>->load->helper('url');<span>//</span><span>为了不把表单传递的地址写死，用url函数</span>
    <span>$this</span>->load->view('user/add'<span>);
}</span>

Salin selepas log masuk

在user/add.php视图当中：

<span><</span><span>form </span><span>action</span><span>="<?php echo site_url('user/insert'); ?>"</span><span> method</span><span>="post"</span><span>></span>
<span><!--</span><span> ........</span><span>--></span>
<span></</span><span>form</span><span>></span>

Salin selepas log masuk

如果是index.php目录的话，用：

base_url();

Salin selepas log masuk

这个API。

同时，每次加载url很麻烦，也可是设置成自动加载，在config/config.php中修改：

<span>$config</span>['helper'] = <span>array</span>('url');

Salin selepas log masuk

可能在后面的版本中就没有这个自动加载了。

路由

ci框架（二），ci框架_PHP教程 $route['rouxx/showxx/([\d]+)\.html'] = 'rou/show/$1';//插入这句话

ci框架（二），ci框架_PHP教程分页

必须知道的一些参数

总共有多少条记录

一页要有多少条记录

总共多少页

当前页前后要显示多少个分页链接

设置一些CI分页类基本参数

<span>//</span><span>总条数</span>
<span>$config</span>['total_rows'<span>]
</span><span>//</span><span>一页显示几条</span>
<span>$config</span>['per_page'<span>]
</span><span>//</span><span>定义当前页的前后各有几个数字链接</span>
<span>$config</span>['num_links'<span>]
</span><span>//</span><span>定义没有分页参数,主URL</span>
<span>$config</span>['base_url']

Salin selepas log masuk

调用CI的分页类

<span>$this</span>->load->library('pagination');

Salin selepas log masuk

执行分页方法

<span>$this</span>->pagination->initialize(<span>$config</span>);

Salin selepas log masuk

输出分页链接

<span>echo</span> <span>$this</span>->pagination->create_links();

Salin selepas log masuk

查询部分数据(limit)

<span>echo</span> <span>$this</span>->db->limit(<span>$num</span>,<span>$start</span>);  <span>//</span><span>从$start查$num条</span>

Salin selepas log masuk

<?<span>php 
</span><span>if</span> ( ! <span>defined</span>('BASEPATH')) <span>exit</span>('No direct script access allowed'<span>);

</span><span>class</span> Page <span>extends</span><span> CI_Controller {

    </span><span>public</span> <span>function</span><span> user_add(){
        </span><span>$this</span>->load->model('test_m'<span>);

        </span><span>for</span> (<span>$i</span> = 1;<span>$i</span> <= 100;<span>$i</span>++<span>){
            </span><span>$name</span> = 'u'.<span>$i</span><span>;
            </span><span>$arr</span> = <span>array</span>("usid"=><span>$i</span>,"uname"=><span>$name</span>,"upass"=>123456<span>);
            </span><span>$this</span>->test_m->user_insert(<span>$arr</span><span>);

        }
    }

    </span><span>public</span> <span>function</span><span> pagelist(){
        </span><span>$this</span>->load->model('test_m'<span>);
        </span><span>$user</span> = <span>$this</span>->test_m-><span>user_select_all();
        </span><span>$allnum</span> = <span>count</span>(<span>$user</span><span>);
        </span><span>$pagenum</span> = 20<span>;

        </span><span>$config</span>['total_rows'] = <span>$allnum</span><span>;
        </span><span>$config</span>['per_page'] = <span>$pagenum</span><span>;
        </span><span>$config</span>['num_links'] = 3<span>;
        </span><span>$config</span>['base_url'] = "/CI/index.php/page/pagelist"<span>;
        </span><span>$config</span>['use_page_numbers'] = <span>true</span><span>;

        </span><span>$this</span>->load->library('pagination'<span>);
        </span><span>$this</span>->pagination->initialize(<span>$config</span><span>);

        </span><span>var_dump</span>(<span>$this</span>->pagination-><span>create_links());
        </span><span>echo</span> <span>$this</span>->pagination-><span>create_links();

        </span><span>echo</span> "<br />"<span>;
        </span><span>$id</span> = <span>$this</span>->uri->segment(3);  <span>//</span><span>获得url第三段字符</span>
        <span>$id</span> =<span>$id</span> ? <span>$id</span>:1<span>;
        </span><span>$start</span> = (<span>$id</span> - 1) * <span>$pagenum</span><span>;
        </span><span>$list</span> = <span>$this</span>->test_m->user_select_limit(<span>$start</span>,<span>$pagenum</span><span>);
        </span><span>var_dump</span>(<span>$list</span><span>);
    }
}</span>

Salin selepas log masuk

上传文件

视图 /views/up.php：

<span><</span><span>html</span><span>></span>
    <span><</span><span>form </span><span>action</span><span>="ci/CodeIgniter_2.2.0/index.php/upload/up"</span><span> method</span><span>="post"</span><span> enctype</span><span>="multipart/form-data"</span><span>></span>
        <span><</span><span>input </span><span>type</span><span>="file"</span><span> name</span><span>="upfile"</span> <span>/></span>
        <span><</span><span>input </span><span>type</span><span>="submit"</span><span> name</span><span>="sub"</span><span> value</span><span>="提交"</span> <span>/></span>
    <span></</span><span>form</span><span>></span>
<span></</span><span>html</span><span>></span>

Salin selepas log masuk

控制器：

定义一个数组，设置一些与上传相关的参数

<span>$config</span>['upload_path'] = './uploads/'<span>;
</span><span>//</span><span>设置允许上传的类型</span>
<span>$config</span>['allowed_types'] = 'gif|jpg|png'<span>;
</span><span>$config</span>['max_size'] = '100'<span>;
</span><span>//</span><span>如果是图片还可以设置最大高度和宽度</span>
<span>$config</span>['max_height'] = 768<span>;
</span><span>$config</span>['max_width'] = 1024;

Salin selepas log masuk

还可以设置其他的一些额外参数，详细看用户手册。

调用CI的上传通用类，并执行上传

<span>//</span><span>upload为调用的类名，全小写</span>
<span>$this</span>->load->library('upload',<span>$config</span><span>);
</span><span>//</span><span>如果上传框的name写的是userfile，那就不用传参数了，如果不是，把name的值传进去</span>
<span>$this</span>->upload->do_upload('上传框的name');

Salin selepas log masuk

接收出错信息或成功信息

<span>//</span><span>出错信息</span>
<span>$error</span> = <span>array</span>('error' => <span>$this</span>->upload-><span>display_error());
</span><span>//</span><span>成功信息</span>
<span>$data</span> = <span>array</span>('upload_data' => <span>$this</span>->upload->data());

Salin selepas log masuk

<?<span>php 
</span><span>if</span> ( ! <span>defined</span>('BASEPATH')) <span>exit</span>('No direct script access allowed'<span>);

</span><span>class</span> Upload <span>extends</span><span> CI_Controller {
    </span><span>//</span><span>显示带表单的视图</span>
    <span>public</span> <span>function</span><span> index(){
        </span><span>$this</span>->load->view('up'<span>);
    }
    </span><span>//</span><span>显示上传信息</span>
    <span>public</span> <span>function</span><span> up(){
        </span><span>$config</span>['upload_path'] = './uploads/'<span>;
        </span><span>$config</span>['allowed_types'] = 'gif|jpg|png'<span>;
        </span><span>$config</span>['max_size'] = "2000"<span>;
        </span><span>$this</span>->load->library('upload',<span>$config</span><span>);
        </span><span>//</span><span>打印成功或错误的信息</span>
        <span>if</span>(<span>$this</span>->upload->do_upload('upfile'<span>))
        {
            </span><span>$data</span> = <span>array</span>("upload_data" => <span>$this</span>->upload-><span>data());
            </span><span>var_dump</span>(<span>$data</span><span>);
        }
        </span><span>else</span><span>
        {
            </span><span>$error</span> = <span>array</span>("error" => <span>$this</span>->upload-><span>display_errors());
            </span><span>var_dump</span>(<span>$error</span><span>);
        }
    }
}</span>

Salin selepas log masuk

Session

利用CI类实现session登录

修改配置文件（config.php）

<span>//</span><span>生成一个随机不重复的字符串走位加密的key保存到config.php的encryption_key中</span>
<span>$config</span>['encryption_key']='adb8bf6d0ac4e17b42a80941582497a4';

Salin selepas log masuk

加载SESSION类

<span>$this</span>->load->library('session');

Salin selepas log masuk

创建SESSION

<span>$array</span> = <span>array</span>('id'=>3,'name'=>'jack'<span>);
</span><span>$this</span>->session->set_userdata(<span>$array</span>);

Salin selepas log masuk

查看SESSION

<span>$this</span>->session->userdata(session名);

Salin selepas log masuk

删除SESSION

<span>$this</span>->session->unset_userdata('SESSION名');

Salin selepas log masuk

ci框架（二），ci框架_PHP教程 $config['sess_cookie_name'] = 'ci_session'; $config['sess_expiration'] = 7200; $config['sess_expire_on_close'] = FALSE; $config['sess_encrypt_cookie'] = TRUE $config['sess_use_database'] = FALSE; $config['sess_table_name'] = 'ci_sessions'; $config['sess_match_ip'] = FALSE; $config['sess_match_useragent'] = TRUE; $config['sess_time_to_update'] = 300;

一次性数据，只能读取一次

<span>//</span><span>设置</span>
<span>$this</span>->session->set_flashdata('test','aaaaa'<span>);
</span><span>//</span><span>读取</span>
<span>$test</span> = <span>$this</span>->session->flashdata('test');

Salin selepas log masuk

php CI 框架怎从数据库中取值(一个二维数组)以表格的形式显示到view层

控制层
function test_func(){
//获取model页面需要的两个参数
$competition_id = $_GET["competition_id"];
$report_class = $_GET["report_class"];
$this->load->model("Action"); //引入model
$data["head"] = $this->Action->get_report_item($competition_id, $report_class); //引用model的函数
$this->load->view("test_result",$data); //将结果显示在test_result.php页面中
}
view层：