Download Files
This includes codeigniter, BackendPro, messages module, calendar module, categories module, menu module and pages module.
You can find db in sql folder.
Pages module
Home of Page module shows ID, Name, Full Path, Status and Actions.
We use jquery dataTables to show our information. This will allow us to sort by each column, display different number of rows and seach.
If you click ‘active’ in a Status column, it will change to inactive. And vice versa for inactive.
There will be edit and delete button to do each action.
There will be Name, Keywords, Description, Path/FURL, content fields and Status drop-down in ‘Create Page’.
Keywords can be set up to show keywords in each meta tag.
And description as well.
You need to set Path which will be used in URL. You need to use one word or use under score _ for this purpose.
We use TinyMCE for the content area.
And active and inactive will be in Status drop-down.
Edit Page will have the same field as the Create Page.
Module structure
You can see the page structure in this image. Please click to enlarge the image.
Database
CREATE TABLE IF NOT EXISTS `omc_page` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`keywords` varchar(255) NOT NULL DEFAULT '',
`description` varchar(255) NOT NULL DEFAULT '',
`path` varchar(255) NOT NULL DEFAULT '',
`content` text NOT NULL,
`status` enum('active','inactive') NOT NULL DEFAULT 'active',
`category_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;
admin controller
Please read the comments in the following code. modules/pages/controllers/admin.php
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Admin extends Admin_Controller {
function Admin(){
parent::Admin_Controller();
// Check for access permission
check('Pages');
// Load modules/menus/models/MMenus
$this->load->module_model('menus','MMenus');
// Load pages model
$this->load->model('MPages');
// Set breadcrumb
$this->bep_site->set_crumb($this->lang->line('backendpro_pages'),'pages/admin');
}
function index(){
// we use the following variables in the view
$data['title'] = "Manage Pages";
$data['pages'] = $this->MPages->getAllPages();
$data['header'] = $this->lang->line('backendpro_access_control');
// This how Bep load views
$data['page'] = $this->config->item('backendpro_template_admin') . "admin_pages_home";
$data['module'] = 'pages';
$this->load->view($this->_container,$data);
}
function create(){
// We need TinyMCE, so load it
$this->bep_assets->load_asset_group('TINYMCE');
if ($this->input->post('name')){
// if info is filled in then do this
$this->MPages->addPage();
// This is CI way to show flashdata
// $this->session->set_flashdata('message','Page created');
// But here we use Bep way to display flash msg
flashMsg('success','Page created');
// and redirect to this index page
redirect('pages/admin/index','refresh');
}else{
// this must be first visit to the creat page
$data['title'] = "Create Page";
$data['menus'] = $this->MMenus->getAllMenusDisplay();
// Set breadcrumb
$this->bep_site->set_crumb($this->lang->line('userlib_page_create'),'pages/admin/create');
$data['header'] = $this->lang->line('backendpro_access_control');
// Setting up page and telling which module
$data['page'] = $this->config->item('backendpro_template_admin') . "admin_pages_create";
$data['module'] = 'pages';
$this->load->view($this->_container,$data);
}
}
function edit($id=0){
// we are using TinyMCE here, so load it.
$this->bep_assets->load_asset_group('TINYMCE');
if ($this->input->post('name')){
// info is filled out, so the followings
$this->MPages->updatePage();
// This is CI way to show flashdata
// $this->session->set_flashdata('message','Page updated');
// But here we use Bep way to display flash msg
flashMsg('success','Page updated');
redirect('pages/admin/index','refresh');
}else{
// set variables here
$data['title'] = "Edit Page";
$data['page'] = $this->config->item('backendpro_template_admin') . "admin_pages_edit";
$data['pagecontent'] = $this->MPages->getPage($id);
if (!count($data['page'])){
// if page is not specified redirect to index
redirect('pages/admin/index','refresh');
}
$data['menus'] = $this->MMenus->getAllMenusDisplay();
// Set breadcrumb
$this->bep_site->set_crumb($this->lang->line('userlib_page_edit'),'pages/admin/edit');
$data['header'] = $this->lang->line('backendpro_access_control');
$data['module'] = 'pages';
$this->load->view($this->_container,$data);
}
}
function delete($id){
$this->MPages->deletePage($id);
// CI way
// $this->session->set_flashdata('message','Page deleted');
flashMsg('success','Page deleted');
redirect('pages/admin/index','refresh');
}
function changePageStatus($id){
$this->MPages->changePageStatus($id);
// CI way
// $this->session->set_flashdata('message','Page status changed');
flashMsg('success','Page status changed');
redirect('pages/admin/index','refresh');
}
}//end class
?>
mpages model
modules/pages/models/mpages.php
<?php
class MPages extends Model{
function MPages(){
parent::Model();
}
function getPage($id){
$data = array();
$this->db->where('id',id_clean($id));
$this->db->limit(1);
$Q = $this->db->get('omc_page');
if ($Q->num_rows() > 0){
$data = $Q->row_array();
}
$Q->free_result();
return $data;
}
function getPagePath($path){
$data = array();
$this->db->where('path',db_clean($path));
$this->db->where('status', 'active');
$this->db->limit(1);
$Q = $this->db->get('omc_page');
if ($Q->num_rows() > 0){
$data = $Q->row_array();
}else{
$data = array();// this prevent visiting unexistent page
}
$Q->free_result();
return $data;
}
function getAllPages(){
$data = array();
$Q = $this->db->get('omc_page');
if ($Q->num_rows() > 0){
foreach ($Q->result_array() as $row){
$data[] = $row;
}
}
$Q->free_result();
return $data;
}
function getAllPageswithnone(){
$data[0] = 'none';
$Q = $this->db->get('omc_page');
if ($Q->num_rows() > 0){
foreach ($Q->result_array() as $row){
$data[$row['id']] = $row['name'];
}
}
$Q->free_result();
return $data;
}
function getAllPathwithnone(){
$data[0] = 'none';
$Q = $this->db->get('omc_page');
if ($Q->num_rows() > 0){
foreach ($Q->result_array() as $row){
$data[$row['path']] = $row['path'];
}
}
$Q->free_result();
return $data;
}
function addPage(){
$data = array(
'name' => db_clean($_POST['name']),
'keywords' => db_clean($_POST['keywords']),
'description' => db_clean($_POST['description']),
'status' => db_clean($_POST['status'],8),
'path' => db_clean($_POST['path']),
'content' => $_POST['content'],
);
$this->db->insert('omc_page', $data);
}
function updatePage(){
$data = array(
'name' => db_clean($_POST['name']),
'keywords' => db_clean($_POST['keywords']),
'description' => db_clean($_POST['description']),
'status' => db_clean($_POST['status'],8),
'path' => db_clean($_POST['path']),
'content' => $_POST['content'],
);
$this->db->where('id', id_clean($_POST['id']));
$this->db->update('omc_page', $data);
}
function deletePage($id){
$this->db->where('id', id_clean($id));
$this->db->delete('omc_page');
}
function changePageStatus($id){
// getting status of page
$pageinfo = array();
$pageinfo = $this->getPage($id);
$status = $pageinfo['status'];
if($status =='active'){
$data = array('status' => 'inactive');
$this->db->where('id', id_clean($id));
$this->db->update('omc_page', $data);
}else{
$data = array('status' => 'active');
$this->db->where('id', id_clean($id));
$this->db->update('omc_page', $data);
}
}
}
?>
Views
admin_pages_create
modules/pages/views/admin/admin_pages_create.php
<h2><?php echo $title;?></h2>
<div id="create_edit">
<?php
echo form_open('pages/admin/create');
echo "\n<p><label for='pname'>Name</label><br/>\n";
$data = array('name'=>'name','id'=>'pname','size'=>25);
echo form_input($data) ."</p>\n";
echo "<p><label for='short'>Keywords</label><br/>\n";
$data = array('name'=>'keywords','id'=>'short','size'=>40);
echo form_input($data) ."</p>\n";
echo "<p><label for='desc'>Description</label><br/>\n";
$data = array('name'=>'description','id'=>'desc','size'=>40);
echo form_input($data) ."</p>\n";
echo "<p><label for='fpath'>Path/FURL Use one word or with under line _ .</label><br/>\n";
$data = array('name'=>'path','id'=>'fpath','size'=>50);
echo form_input($data) ."</p>\n";
echo "<p><label for='long'>Content</label><br/>\n";
$data = array('name'=>'content','id'=>'long','rows'=>5, 'cols'=>'40');
echo form_textarea($data) ."</p>\n";
echo "<p><label for='status'>Status</label><br/>\n";
$options = array('active' => 'active', 'inactive' => 'inactive');
echo form_dropdown('status',$options) ."</p>\n";
echo form_submit('submit','create page');
echo form_close();
?>
</div>
admin_pages_edit
modules/pages/views/admin/admin_pages_create.php
<h2><?php echo $title;?></h2>
<div id="create_edit">
<?php
echo form_open('pages/admin/edit');
echo "<p><label for='pname'>Name</label><br/>";
$data = array('name'=>'name','id'=>'pname','size'=>25, 'value' => $pagecontent['name']);
echo form_input($data) ."</p>";
echo "<p><label for='short'>Keywords</label><br/>";
$data = array('name'=>'keywords','id'=>'short','size'=>40, 'value' => $pagecontent['keywords']);
echo form_input($data) ."</p>";
echo "<p><label for='desc'>Description</label><br/>";
$data = array('name'=>'description','id'=>'desc','size'=>40, 'value' => $pagecontent['description']);
echo form_input($data) ."</p>";
echo "<p><label for='fpath'>Path/FURL</label><br/>";
$data = array('name'=>'path','id'=>'fpath','size'=>50, 'value' => $pagecontent['path']);
echo form_input($data) ."</p>";
echo "<p><label for='long'>Content</label><br/>";
$data = array('name'=>'content','id'=>'long','rows'=>5, 'cols'=>'40', 'value' => $pagecontent['content']);
echo form_textarea($data) ."</p>";
echo "<p><label for='status'>Status</label><br/>";
$options = array('active' => 'active', 'inactive' => 'inactive');
echo form_dropdown('status',$options,$pagecontent['status']) ."</p>";
echo form_hidden('id',$pagecontent['id']);
echo form_submit('submit','update page');
echo form_close();
?>
</div>
admin_pages_home
modules/pages/views/admin/admin_pages_home.php
<?php print displayStatus();?>
<h2><?php echo $title;?></h2>
<p>
<?php
echo anchor("pages/admin/create", "Create new page");
?>
</p>
<?php
/*
This is how CI display flash data. but we don't use it.
if ($this->session->flashdata('message')){
echo "<div class='status_box'>".$this->session->flashdata('message')."</div>";
}
*/
if (count($pages)){
echo "<table id='tablesorter' class='tablesorter' border='1' cellspacing='0' cellpadding='3' width='100%'>\n";
echo "<thead>\n<tr valign='top'>\n";
echo "<th>ID</th>\n<th>Name</th><th>Full Path</th><th>Status</th><th>Actions</th>\n";
echo "</tr>\n</thead>\n<tbody>\n";
foreach ($pages as $key => $list){
echo "<tr valign='top'>\n";
echo "<td align='center'>".$list['id']."</td>\n";
echo "<td>".$list['name']."</td>\n";
echo "<td>";
if (!preg_match("/\.html$/",$list['path'])){
$list['path'] .= ".html";
}
if ($list['category_id'] == 0){
echo "/". $list['path'];
}else{
echo "/". $cats[$list['category_id']]. "/". $list['path'];
}
echo "</td>";
echo "<td align='center'>";
echo anchor('pages/admin/changePageStatus/'.$list['id'],$list['status'], array('class' => $list['status']));
echo "</td>\n";
echo "<td align='center'>";
echo anchor('pages/admin/edit/'.$list['id'],'edit');
echo " | ";
echo anchor('pages/admin/delete/'.$list['id'],'delete');
echo "</td>\n";
echo "</tr>\n";
}
echo "</tbody>\n</table>";
}
?>
Popular Posts