How to display static pages in Yii with database content?

You are viewing revision #12 of this wiki article.
This version may not be up to date with the latest version.
You may want to view the differences to the latest version.

next (#15) »

To extend further static pages as shown by Qiang here're the steps to take:

  1. Create a table spage (static page) in the databse with fields (id, url, title, content)
  2. Create model and CRUD for it via Gii
  3. Add method in the model Spage.php
public function getSpageByUrl($url) {
	return $this->find('url=:url',array(':url'=>$url));

4.. In protected/components/SiteController.php add

public function actionPage() {
	$model = Spage::model()->getSpageByUrl($_GET['view']);
	if ($model === NULL)
		$this->render('pages/spage', array('model'=>$model));

5.. Create a view file: protected/views/site/spages/spage.php with content

<h1><?php echo $model->title?></h1>
<?php echo $model->content?>

6.. Create a page via the admin, e.g. with a url = "test" and sample data for title and content and navigate to it - assuming that friendly URLs are turned on and index.php is hidden with config urlManager(array('urlFormat'=>'path','showScriptName'=>false,))

Hint: To remove "page" from the URL a line could be added at the start of the URL rules array:

'<view:\w+>' => 'site/page', 

so the address could simply be

That's about it. Hope it's clear enough. Will update the article further to make it better. Happy coding.

3 0
Viewed: 41 854 times
Version: Unknown (update)
Category: Tutorials
Written by: yasen
Last updated by: yasen
Created on: Oct 11, 2012
Last updated: 11 years ago
Update Article


View all history

Related Articles