Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function eksempel(/* Parameter område */){
- /*
- TEST OMRÅDE TIL ACTIVE RECORDS
- Denne kaldes via frontend/eksempel
- */
- // Listevisning
- $sqlQuery = $this->db->get('ci_pages');
- foreach($sqlQuery->result() as $row){
- echo $row->page_id." -> ".$row->page_title."<br />";
- }
- // Enkeltvisning
- #eksempel 1
- $sqlQuery = $this->db->get_where('ci_pages','page_id = 1');
- $row = $sqlQuery->row();
- echo $row->page_title;
- #eksempel 2
- $arr = array(
- 'page_id' => 1
- );
- $sqlQuery = $this->db->get_where('ci_pages',$arr);
- $row = $sqlQuery->row();
- echo $row->page_title;
- #eksempel 3
- $this->db->where('page_id',1);
- $sqlQuery = $this->db->get('ci_pages');
- $row = $sqlQuery->row();
- echo $row->page_title;
- // Oprette
- $arr = array(
- 'page_title' => 'eksempelside',
- 'page_slug' => 'slawk',
- 'page_author' => 0,
- 'page_frontpage' => 0,
- 'page_level' => 0,
- 'page_parent' => 0,
- 'page_visible' => 1,
- 'page_core' => 0
- );
- #$this->db->insert('ci_pages',$arr);
- // Redigere
- $arr = array(
- 'page_title' => 'Forside',
- 'page_slug' => 'frontpage',
- 'page_author' => 0,
- 'page_frontpage' => 1,
- 'page_level' => 0,
- 'page_parent' => 0,
- 'page_visible' => 1,
- 'page_core' => 1
- );
- $this->db->where('page_id',1);
- $this->db->update('ci_pages',$arr);
- // Slette
- $this->db->where('page_title','eksempel');
- $this->db->delete('ci_pages');
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement