codeigniter 查看、添加、更新和删除

我是 codeigniter 的新手，仍在学习。任何人都可以在基本视图、添加、更新、删除操作和 Codeigniter 中的查询方面提供示例帮助，我们将不胜感激。

只是一个简单的事情，比如为新手创建地址簿。

thanks,

此致

Codeigniter 中的一些示例查询

class Names extends Model {
  function addRecord($yourname) {
    $this->db->set("name", $yourname);
    $this->db->insert("names");
    return $this->db->_error_number(); // return the error occurred in last query
  }
  function updateRecord($yourname) {
    $this->db->set("name", $yourname);
    $this->db->update("names");
  }
  function deleteRecord($yourname) {
    $this->db->where("name", $yourname);
    $this->db->delete("names");
  }
  function selectRecord($yourname) {
    $this->db->select("name, name_id");
    $this->db->from("names");
    $this->db->where("name", $yourname);
    $query = $this->db->get();
    return $this->db->result();
  }
  function selectAll() {
     $this->db->select("name");
     $this->db->from("names");
     return $this->db->get();
  }
}

有关 CRUD 的更多信息和更多方法Codeigniter 活动记录文档 http://codeigniter.com/user_guide/database/active_record.html有关错误号的更多信息here http://codeigniter.com/forums/viewthread/61557/

控制器示例

class names_controller extends Controller {
   function addPerson() {
      $this->load->Model("Names");
      $name = $this->input->post("name"); // get the data from a form submit
      $name = $this->xss->clean();
      $error = $this->Names->addRecord($name);
      if(!$error) {
         $results = $this->Names->selectAll();
         $data['names'] = $results->result();
         $this->load->view("show_names", $data);
      } else {
         $this->load->view("error");
      }
   }
}

有关控制器的更多信息here http://codeigniter.com/user_guide/general/controllers.html

示例视图 - show_names.php

<table>
  <tr>
    <td>Name</td>
  </tr>
  <?php foreach($names as $row): ?>
  <tr><td><?ph echo $row->name; ?></td></tr>
  <?php endforeach; ?>
</table>

有关 codeigniter 视图的更多信息here http://codeigniter.com/user_guide/general/views.html