CI Database Operations

1. First find: C:\AppServ\www\ci\application\config under the database.php file to modify the parameters of the connection database

2. Locate the corresponding file in the controller C:\AppServ\www\ci\application\controllers

650) this.width=650; "Src=" http://img.blog.csdn.net/20150424001535007?watermark/2/text/ ahr0cdovl2jsb2cuy3nkbi5uzxqveglhb21vz2c=/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/ Center "style=" border:none; "/>

Code:

class user extends ci_controller{    public  function  Showusers ()     {        //loading database operation class           $this->load->database ();        After the  //load succeeds, it is placed into the properties of the Super object, the default property name db         $sql = ' select *  From qq ';         $res = $this->db->query ($sql);//Return is an object           $users = $res->result ();//Returns an array of   objects         //  $users = $res->result_array ();//Returns a two-dimensional array with associative arrays         //  $users = $res->row ();//Returns the first data, directly an object        //  Var_dump ($users);         //mysql_fetch_assoc ()//associative array          //mysql_fetch_object ()//Return object          $data [' user_list ']= $users;          $this->load->view ("User/showusers", $data);//In view output      }

}

3. View File: C:\AppServ\www\ci\application\views\user

Code:

<?phpvar_dump ($user _list);

CI Database Operations