CI框架（5）-数据读取

1，数据库参数设置

2，创建Model

3，控制器获得数据，并且传递参数给视图

4，视图显示数据

---

1，数据库参数设置

在[application]->[config]->[database.php]设置数据库的IP地址、用户名、密码、数据。

'hostname' => '数据库地址',    'username' => '用户名',    'password' => '密码',    'database' => '数据',

2，创建Model

在application/models创建SingerModels.php文件，在文件里面创建SingerModels类并且继承CI_Model

<?phpclass SingerModel extends CI_Model{    function SingerModel()    {        $this->load->database();    }    function getSinger()    {        $sql = 'SELECT * from singer';        // 查询数据库        $query = $this->db->query($sql);        // $query=$this->db->get('singer');        // 以数组形式返回查询结果        return $query->result_array();    }    function insertSinger()    {        $sql = "insert into singer(name,introduce)values('king','123')";        $query = $this->db->query($sql);        echo $query;    }    function insertSinger2()    {        $data = array(            'name' => "wwesdd",            'introduce' => "33535y4erth"        );        $query = $this->db->insert('singer', $data);        echo $query;    }    function updataSinger1()    {        $sql = "update singer set name = 'kinggg' where id=30";        $query = $this->db->query($sql);        echo $query;    }    function updataSinger2()    {        $this->db->set('name', 'field+1');        $this->db->where('id', 30);        $query=$this->db->update('singer');        echo $query;    }    function deleteSinger1(){        $sql = "delete from singer where id =30 ";        $query = $this->db->query($sql);        echo $query;    }    function deleteSinger2(){       $this->db->where('id', 31);       $query =$this->db->delete('singer');        echo $query;    }}?>

3，控制器获得数据，并且传递参数给视图

在application/controllers/添加相关的代码

<?php class Singer extends CI_Controller{       function Singer(){        parent::__construct();        $this->load->helper('url');        $this->load->model('SingerModel');    }     function index(){         //$this->SingerModel->deleteSinger2();         $singers = $this->SingerModel->getSinger();         $data['singers'] = $singers;         $this->load->view('singer',$data);    }}?>

4，视图显示数据

 <?php         $imageUrl = base_url()."images/";        foreach ($singers as $singer){            //echo "<p>".$singer['name']."的介绍是</p>";            $url = $imageUrl.$singer['singer_icon_url'];            $name = $singer['name'];            $introduce = $singer['introduce'];            echo "<tr><td><img id='image' src='".$url."'></td><td><div id='infor'>".$singer['name']."</div></td></tr>";        }        ?>