Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function eksempel(){
- $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' => 'eksempel',
- 'page_author' => 0,
- 'page_frontpage' => 0,
- 'page_level' => 0,
- 'page_parent' => 0,
- 'page_visible' => 1,
- 'page_core' => 0
- );
- // Opret handling
- # $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
- );
- // Rediger handling
- # $this->db->where('page_id',22);
- # $this->db->update('ci_pages',$arr);
- // Slette
- // Slette hendling
- # $this->db->where('page_slug','eksempel');
- # $this->db->delete('ci_pages');
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement