| Server IP : 5.161.254.237 / Your IP : 216.73.216.252 Web Server : Apache System : Linux diamond.sialwebvps.com 4.18.0-553.8.1.el8_10.x86_64 #1 SMP Tue Jul 2 07:26:33 EDT 2024 x86_64 User : stellasp ( 1131) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/stellasp/public_html/application/models/ |
Upload File : |
<?php
Class Page_model extends CI_Model
{
function __construct()
{
parent::__construct();
}
/********************************************************************
Page functions
********************************************************************/
function get_pages($parent = 0)
{
$this->db->order_by('sequence', 'ASC');
$this->db->where('parent_id', $parent);
$result = $this->db->get('pages')->result();
$return = array();
foreach($result as $page)
{
$return[$page->id] = $page;
$return[$page->id]->children = $this->get_pages($page->id);
}
return $return;
}
function get_page($id)
{
$this->db->where('id', $id);
$result = $this->db->get('pages')->row();
return $result;
}
function get_slug($id)
{
$page = $this->get_page($id);
if($page)
{
return $page->slug;
}
}
function save($data)
{
if($data['id'])
{
$this->db->where('id', $data['id']);
$this->db->update('pages', $data);
return $data['id'];
}
else
{
$this->db->insert('pages', $data);
return $this->db->insert_id();
}
}
function delete_page($id)
{
//delete the page
$this->db->where('id', $id);
$this->db->delete('pages');
}
function get_page_by_slug($slug)
{
$this->db->where('slug', $slug);
$result = $this->db->get('pages')->row();
return $result;
}
}