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

<?php

class 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>";
        }

        ?>