StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
12226745
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-09-01T09:55:11.727
FavoriteCount
0
LastActivityDate
2015-02-27T23:35:02.490
LastEditDate
2015-02-27T23:35:02.490
LastEditorUserId
1709587
OwnerUserId
2013164
ParentId
12082021
PostTypeId
2
Score
11
ViewCount
0
LastEditorDisplayName
text
Body
I shall explain step by step how to get this working. Step 1 - Create an Yii web app Navigate to your Yii framework path in your console and create a new webapp. In my case I used this in my console: <pre><code>cd c:\zeus\yii-1.1.10.r3566\framework yiic webapp c:\zeus\www\yiiblog </code></pre> where c:\zeus\yii-1.1.10.r3566\framework is my path to Yii php framework and c:\zeus\www\yiiblog is the path to my Yii webapp test folder Stept 2 - fake my domain to dev.yiiblog.com Go to C:\Windows\System32\drivers\etc and edit your hosts file by adding this line: <pre><code>127.0.0.1 dev.yiiblog.com </code></pre> Step 3 - alter apache httpd.conf file <pre><code><VirtualHost *:80> DocumentRoot "c:/zeus/www/yiiblog" ServerName dev.yiiblog.com ErrorLog "logs/dev.yiiblog.com-error.log" CustomLog "logs/dev.yiiblog.com-access.log" common </VirtualHost> </code></pre> and restart apache service. I used in my windows console: <pre><code>net stop apache net start apache </code></pre> where my Apache 2 service is named "apache" not "apache2.2" like the default one. Step 4 - create a database and configure a database connection into Yii I've created a database yiitest and a user yiitest. Then I opened my Yii configuration file located ad /protected/config/main.php and edited the connection to MySQL: <pre><code>'db'=>array( 'connectionString' => 'mysql:host=localhost;dbname=yiitest', 'emulatePrepare' => true, 'username' => 'yiitest', 'password' => 'password', 'charset' => 'utf8', ), </code></pre> Step 5 - download dburlmanager Yii extension Go to Yii dburlmanager, download the Yii dburlmanager extension <a href="http://www.yiiframework.com/extension/dburlmanager/" rel="nofollow noreferrer">http://www.yiiframework.com/extension/dburlmanager/</a> and extract it to your /protected/extensions folder Step 6 - Create MySQL database tables and add dummy data <pre><code>CREATE TABLE IF NOT EXISTS `articles` ( `seoURL` varchar(100) NOT NULL ) ENGINE=InnoDB; INSERT INTO `articles` (`seoURL`) VALUES ('first-post'), ('another-post'), ('post/value'), ('website/page1'); CREATE TABLE IF NOT EXISTS `pages` ( `seoURL` varchar(100) NOT NULL ) ENGINE=InnoDB; INSERT INTO `pages` (`seoURL`) VALUES ('page-first-post'), ('page-another-post'), ('page/post/value.html'), ('page-website/page1'); </code></pre> Step 7 - Create your Yii custom Controllers Create under /protected/controllers folder two php files named ArticleController.php and PageController.php: ArticleController.php content: <pre><code><?php /** * @filename ArticleController.php */ class ArticleController extends CController { public function actionView() { $this->render('view', array( 'article' => isset($_GET['article'])?$_GET['article']:'', )); } } </code></pre> PageController.php content: <pre><code><?php /** * @filename PageController.php */ class PageController extends CController { public function actionView() { $this->render('view', array( 'page' => isset($_GET['page'])?$_GET['page']:'', )); } } </code></pre> Step 8 - create your custom Yii views Create your view files corresponding to those controllers above with the path /protected/views/article/view.php and /protected/views/page/view.php: Article view content: <pre><code><h1>Article View Test</h1> <?php if (isset ($article)) echo "article: $article"; ?> </code></pre> Page view content: <pre><code><h1>Page View Test</h1> <?php if (isset ($page)) echo "page: $page"; ?> </code></pre> Step 9 - add custom Yii url rules Open again your main.php Yii config file and set your urlManager to something similar to: <pre><code>'urlManager'=>array( 'urlFormat'=>'path', 'class'=>'ext.DbUrlManager.EDbUrlManager', 'connectionID'=>'db', 'rules'=>array( '<article:[\w\/.-]+>'=>array( 'article/view', 'type'=>'db', 'fields'=>array( 'article'=>array( 'table'=>'articles', 'field'=>'seoURL' ), ), ), '<page:[\w\/.-]+>'=>array( 'page/view', 'type'=>'db', 'fields'=>array( 'page'=>array( 'table'=>'pages', 'field'=>'seoURL' ), ), ), '<controller:\w+>/<id:\d+>' => '<controller>/view', '<controller:\w+>/<action:\w+>/<id:\d+>' => '<controller>/<action>', '<controller:\w+>/<action:\w+>' => '<controller>/<action>', ), 'showScriptName'=>false, ), </code></pre> Step 10 - create .htaccess file Create a .htaccess file under your web app root and etid its content to: <pre><code>Options +FollowSymLinks IndexIgnore */* RewriteEngine on # if a directory or a file exists, use it directly RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d # otherwise forward it to index.php RewriteRule . index.php </code></pre> Step 11 - test your SEO Friendly URLs <pre><code>dev.yiiblog.com/first-post dev.yiiblog.com/page-first-post </code></pre> etc Have fun creating awesome blogs or other web apps with complete url managing power.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POYii advanced url rewrite
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USMark Amery
UserOwnerUserId
1. USMarian Zburlea
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POYii advanced url rewrite
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.